Implementing Dynamic Data Masking

5 questions Pass: 70% +15 pts

Quiz covering Security for Azure SQL

Implementing Dynamic Data Masking

5 questions | Pass: 70% | Earn 15 points

Questions in this quiz

A preview of the 5 questions covered. Start the quiz above to answer them, check your score, and read the explanations.

  1. 1

    What is the primary purpose of Dynamic Data Masking (DDM) in Azure SQL Database?

  2. 2

    Which of the following database roles is automatically excluded from Dynamic Data Masking by default?

  3. 3

    You have a column containing email addresses. You want to mask the email so that only the first letter and the domain are visible (e.g., aXXX@hotmail.com). Which masking function should you use?

  4. 4

    A developer needs to see unmasked data for a specific testing scenario. What permission must you grant to the developer's user account to allow them to view the original data?

  5. 5

    You are implementing DDM on a column that is used in a WHERE clause for filtering. What is a critical security consideration regarding DDM and query execution?