DP-203 · Question #190
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…
The correct answer is A. From Microsoft SQL Server Management Studio, set an email mask on the Email column. 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. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
Question
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 a [email protected] instead. What should you do?
Options
- 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 permission to the users for all
- DFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
How the community answered
(32 responses)- A78% (25)
- B3% (1)
- C13% (4)
- D6% (2)
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. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
Topics
Community Discussion
No community discussion yet for this question.