MicrosoftMicrosoft
DP-300 · Question #101
DP-300 Question #101: Real Exam Question with Answer & Explanation
Sign in or unlock DP-300 to reveal the answer and full explanation for question #101. The question stem and answer options stay visible for context.
Submitted by tarun92· Mar 6, 2026
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 [email protected] instead. What should you do?
Options
- AFrom the Azure portal, set a mask on the Email column.
- BFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
- CFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.
- DFrom Microsoft SQL Server Management Studio, grant the SELECT permission to the users for
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 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.