Microsoft
DP-203 · Question #190
You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses
Sign in or unlock DP-203 to reveal the answer and full explanation for question #190. The question stem and answer options stay visible for context.
Submitted by skyler.x· Mar 30, 2026Secure, monitor, and optimize data storage and data processing
Question
You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains a column name Email. You need to prevent nonadministrative users from seeing the full email addresses in the Email column. The users must see values in a format of a [email protected] instead. What should you do?
Options
- AFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.
- BFrom the Azure portal, set a mask on the Email column.
- CFrom Microsoft SQL Server Management Studio, grant the permission to the users for all
- DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
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#email mask#Azure Synapse Analytics#data obfuscation