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 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: A

Explanation:

From Microsoft SQL Server Management Studio, set an email mask on the Email column. This is because "This feature cannot be set using portal for Azure Synapse (use PowerShell or REST API) or SQL Managed Instance." So use Create table statement with Masking e.g. CREATE TABLE Membership (MemberID int IDENTITY PRIMARY KEY, FirstName varchar(100) MASKED WITH (FUNCTION = ‘partial(1,"XXXXXXX",0)’) NULL, . . https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overviewupvoted 24 times