What should you do?

You have a SQL pool in Azure Synapse that contains a table named dbo.Customers. The table contains 9 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?
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.

View Answer

Answer: B

Explanation:

Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview