Exam DP-300 topic 1 question 23 discussion

correct answer is A: you need to mask the email.

The correct answer is A

answer A

reference: https://www.examtopics.com/discussions/microsoft/view/36123-exam-dp-200-topic-3-question-4-discussion/ The answer should be C. The key word is "a SQL pool in Azure Synapse". Dynamic data masking does not apply to it. (So we can't achieve this from the Azure portal.)

This is a DP-203 question. Azure Synapse Analytics is not part of the DP-300 curriculum.

The correct option is A. From the Azure portal, set a mask on the Email column. By setting a mask on the Email column, you can control the way sensitive data is displayed to non-administrative users. The mask allows you to show a modified version of the data while keeping the original data secure. In this case, you can configure the mask to display the email addresses in the format of [email protected] as required. Option B, setting a sensitivity classification of Confidential for the Email column, is not the most appropriate choice for this scenario. While sensitivity classifications can be used to label data and apply policies, they do not directly handle the masking of data for display purposes. Options C and D, setting an email mask from Microsoft SQL Server Management Studio or granting SELECT permission to users for all columns except Email, are not correct because they both involve implementing security measures at the database level, but they do not specifically address the data masking requirement for displaying the email addresses in the desired format.

according to this article you can do it in portal. so my take is A https://www.sqlshack.com/dynamic-data-masking-in-azure-synapse-analytics/

Dynamic Masking

A and B can both work, however, I would select C since A doesn't describe the type of mask. It needs to be email mask on the email column. If you apply dynamic data from Azure portal, and you don´t specify the type of mask, it will detect the type of the column to apply the mask, so in this case, it applies the default mask for a column type as varchar therefore it is not applying an email mask type

Dynamic Data Masking in the Azure portal is support for SQL DB and Synapse Analytics, just not for Managed Instance. https://www.sqlshack.com/dynamic-data-masking-in-azure-synapse-analytics/

C is not supported for Azure Synapse.

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.

A - set a mask

The question is on masking the data.

Correct answer is A. The question is on masking not classifying.

This question is play on words as they want to know HOW you will PREVENT NONADMINISTRATIVE USERS from SEEING the ENAIL COLOMB and not how to hide the email colomb data itself.

More specific than A