Microsoft Certified Azure Database Administrator Associate · Free Practice Question Medium
Question 5
You are managing an SQL database in Azure. Which feature should you configure to obfuscate sensitive data in result sets of queries, without changing the actual data stored in the database?
- A Transparent Data Encryption (TDE).
- B Always Encrypted.
- C Dynamic Data Masking.
- D Row-level Security.
Reveal correct answer
Correct answer: C
Explanation
Dynamic Data Masking helps prevent unauthorized access to sensitive data by enabling you to specify how much of the sensitive data to reveal with minimal impact on the application layer. Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overviewDiscussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
