DP-203 · Question #71
DP-203 Question #71: Real Exam Question with Answer & Explanation
The correct answer is B: dynamic data masking. Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It’s a policy-based security feature that hides the sensitive data in the result set
Question
You have an Azure Synapse Analystics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone. You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column. What should you include in the solution?
Options
- Aa default value
- Bdynamic data masking
- Crow-level security (RLS)
- Dcolumn encryption
- Etable partitions
Explanation
Dynamic data masking helps prevent unauthorized access to sensitive data by enabling customers to designate how much of the sensitive data to reveal with minimal impact on the application layer. It’s a policy-based security feature that hides the sensitive data in the result set of a query over designated database fields, while the data in the database is not changed. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
Community Discussion
No community discussion yet for this question.