BenchMark Quizzes by MDFT Pro

Prevent Users From Seeing Full Email Addresses

You work for MDFT Pro, a well-known training agency with a dedicated SQL pool in Azure Synapse Analytics that contains student information. Mark, the Privacy Officer, has raised a concern about protecting student email addresses in the dbo.Students table. The table is accessed by course coordinators and reporting staff who need to view most student information but should not see complete email addresses for privacy reasons. Mark has asked you to configure the system so that non-administrative users see email addresses in a masked format like aXXX@XXXX.com instead of the actual email addresses, while database administrators should still be able to view the full unmasked values.

What should you do?

Choose the correct answer from the options below.

Explanations for each answer:

From the Azure portal, set a mask on the Email column is correct. Dynamic data masking can be configured from the Azure portal to mask email addresses in the specified format (aXXX@XXXX.com) for non-administrative users.
From the Azure portal, set a sensitivity classification of Confidential for the Email column is incorrect. Sensitivity classification labels data for compliance and discovery purposes but does not mask or hide the actual data from users.
From Microsoft SQL Server Management Studio, set an email mask on the Email column is incorrect. While you can configure dynamic data masking via SSMS, the Azure portal is the recommended approach for Azure SQL Database, and this option is less specific than option A.
From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Students table except Email is incorrect. This would prevent users from seeing the Email column entirely, but the requirement is to show a masked version (aXXX@XXXX.com), not to hide the column completely.

Learn more about Dynamic Data Masking:

Dynamic Data Masking

Practice Exam

Prevent Users From Seeing Full Email Addresses

Discuss this question on social media: