What should you do?

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?
A . From the Azure portal, set a mask on the Email column.
B . From the Azure portal, set a sensitivity classification of Confidential for the Email column.
C . From Microsoft SQL Server Management Studio, set an email mask on the Email column.
D . From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

View Answer

Answer: B

Explanation:

The Email masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address.

Example: [email protected]