Implementing Dynamic Data Masking

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Security for Azure SQL

What you'll be asked

  1. What is the primary purpose of Dynamic Data Masking (DDM) in Azure SQL Database?
  2. Which of the following database roles is automatically excluded from Dynamic Data Masking by default?
  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., [email protected]). Which masking function should you use?
  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. 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?

Answers and explanations come after you submit.