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…

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…

Submitted by valeria.br· Mar 30, 2026Secure, monitor, and optimize data storage and data processing

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

How the community answered

(48 responses)

A
2% (1)
B
83% (40)
C
8% (4)
D
2% (1)
E
4% (2)

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

Topics

#dynamic data masking#column security#PII protection#Synapse SQL pool

Community Discussion

No community discussion yet for this question.

Full DP-203 Practice