12 Questions
What is the primary purpose of Dynamic Data Masking (DDM)?
To grant or revoke permissions for accessing unmasked data
Which of the following is NOT a supported operation in the Dynamic Data Masking REST API?
Provision new database instances
Which of the following is a built-in role that can be used to configure Dynamic Data Masking?
There are no built-in roles for configuring Dynamic Data Masking
What is the purpose of the UNMASK permission in Dynamic Data Masking?
To grant or revoke access to view unmasked data
Which of the following steps is required to apply data masking to a database column using the Dynamic Data Masking portal?
Select the appropriate masking function
What is the primary benefit of using Dynamic Data Masking with Microsoft Entra authentication?
It provides a granular way to control access to unmasked data
What does dynamic data masking in Azure SQL Database help prevent?
Unauthorized access to sensitive data
How does dynamic data masking impact the application layer?
Minimal effect on the application layer
Where can a dynamic data masking policy be set up in Azure SQL Database?
Azure Portal under Security in SQL Database configuration pane
What is an example of how dynamic data masking can be used for confidentiality?
Masking all the email addresses in query results
Why might a service representative at a call center only see partial email addresses using dynamic data masking?
To identify a caller without revealing sensitive information
What feature helps hide sensitive data in the result set of a query over designated database fields?
Dynamic data masking
Learn about dynamic data masking in Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. Discover how dynamic data masking limits sensitive data exposure to nonprivileged users.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free