Microsoft
DP-203 · Question #71
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
Sign in or unlock DP-203 to reveal the answer and full explanation for question #71. The question stem and answer options stay visible for context.
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
Unlock DP-203 to see the answer
You've previewed enough free DP-203 questions. Unlock DP-203 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#dynamic data masking#column security#PII protection#Synapse SQL pool