nerdexam
Microsoft

DP-300 · Question #101

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 the Azure portal, set a mask on the Email column. You set up a dynamic data masking policy in the Azure portal by selecting the Dynamic Data Masking blade under Security in your SQL Database configuration pane. This feature cannot be set using portal for SQL Managed Instance. For more information, see Dynamic Data Masking…

Submitted by tarun92· Mar 6, 2026Implement a secure environment

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 [email protected] instead. What should you do?

Options

  • AFrom the Azure portal, set a mask on the Email column.
  • BFrom the Azure portal, set a sensitivity classification of Confidential for the Email column.
  • CFrom Microsoft SQL Server Management Studio, set an email mask on the Email column.
  • DFrom Microsoft SQL Server Management Studio, grant the SELECT permission to the users for

How the community answered

(28 responses)
  • A
    71% (20)
  • B
    18% (5)
  • C
    7% (2)
  • D
    4% (1)

Explanation

You set up a dynamic data masking policy in the Azure portal by selecting the Dynamic Data Masking blade under Security in your SQL Database configuration pane. This feature cannot be set using portal for SQL Managed Instance. For more information, see Dynamic Data Masking. https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview

Topics

#dynamic data masking#email mask#Azure Synapse SQL pool#data protection

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full DP-300 Practice