Implementing an Azure Data Solution (legacy) — Question 11

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?

Answer options

• A. From Microsoft SQL Server Management Studio, set an email mask on the Email column.
• B. From the Azure portal, set a mask on the Email column.
• C. From Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
• D. From the Azure portal, set a sensitivity classification of Confidential for the Email column.

Correct answer: B

Explanation

The correct answer is B because setting a mask on the Email column through the Azure portal allows for dynamic data masking, which renders the email addresses in the specified masked format. Option A is incorrect as SQL Server Management Studio does not have a direct feature for setting masks. Option C does not fulfill the requirement since it does not mask the email addresses, and option D only classifies the sensitivity without masking the data.