Explanation:
The scenario requires implementing Dynamic Data Masking (DDM) on the Email column in an Azure Synapse Analytics dedicated SQL pool to display email addresses in the format aXXX@XXXX.com for non-administrative users.
✅ Option A: From Microsoft SQL Server Management Studio, set an email mask on the Email column
ALTER TABLE dbo.Customers
ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()');
ALTER TABLE dbo.Customers
ALTER COLUMN Email ADD MASKED WITH (FUNCTION = 'email()');
email() masking function specifically produces the required aXXX@XXXX.com format❌ Option B: From the Azure portal, set a mask on the Email column
❌ Option C: From Microsoft SQL Server Management Studio, grant SELECT permission excluding Email
❌ Option D: From the Azure portal, set a sensitivity classification
email() masking function in SQL Server/Azure SQL automatically produces the aXXX@XXXX.com formatOption A is the correct approach as it directly addresses the requirement using the appropriate tool (SSMS with T-SQL) and the built-in email masking function that produces the exact format specified in the requirement.
Ultimate access to all questions.
No comments yet.
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.