Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
You have a SQL pool in Azure Synapse Analytics containing a table named dbo.Customers with an Email column. You need to ensure non-administrative users cannot view full email addresses and instead see values formatted as aXXX@XXXX.com. 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.