Question 217

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?

• 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 SELECT permission to the users for all the columns in the dbo.Customers table except Email.
• DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.