Exam DP-203 topic 3 question 16 discussion

I think it's a terrible question, both A(using T-SQL) and B (via GUI) can do the job.

Go with A, reason for not B, if email column is string type ,default masking will make it as xxxxxxxx, so here I go with email mask on email column. https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql

To apply Dynamic Data Masking to a column, you typically use the Azure Portal. Here's how: Azure Portal: Navigate to the SQL pool in your Azure Synapse Analytics workspace. Under the Security section, select Dynamic Data Masking. Add a masking rule for the Email column in the dbo.Customers table. Save your changes. SQL Server Management Studio (SSMS): Alternatively, you can use T-SQL commands in SSMS to configure Dynamic Data Masking.

I'm going with A. I asked ChatGPT and it didn't provice documentation source, but explained this: You're right to ask for clarification. Unfortunately, Azure documentation does not always explicitly state which features are supported across different services, leading to confusion. However, based on current feature availability, here's the relevant context: Azure SQL Database supports dynamic data masking (DDM) through both the Azure portal UI and SQL commands. Azure Synapse Analytics dedicated SQL pools support DDM, but only through T-SQL commands like those executed via SQL Server Management Studio (SSMS) or other query tools. Azure Synapse Analytics documentation and features do not include portal-based support for dynamic data masking. Instead, the Synapse dedicated SQL pools only allow DDM configuration via T-SQL. You won’t find a corresponding section in the Synapse portal for dynamic data masking, as you would for Azure SQL Database.

In the provided documentation link, if you check the step-by-step guide at number 7, where the documentation instructs you to go to the Azure Portal, you'll see the email DDM format exactly as the question asks: '[email protected]'. So, I'll go with option B. You can view the guide here: https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-configure-portal?view=azuresql

A is better than B

A is correct

Its A ! B can work but not by default. Cgatgpt : Based solely on the information provided in the prompt and considering that any unspecified option would use a default value, the appropriate response would be: A. From Microsoft SQL Server Management Studio, set an email mask on the Email column. This is because option A specifically mentions setting an email mask, which is the type of masking required by the scenario. The other options do not mention configuring a custom masking format for email addresses.

Both A & B are correct capable of achieving the same. But let's go for A.

A or B

default masking will make it as xxxxxxxx,

B says just mask and not email mask

The link provided in the solution is correctly pointing to the solution: Dynamic Data Masking, that is done from the Azure Portal, so the correct answer is B! :)

email masking option via ssms

Vote for B becouse of "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." Source: https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql#:~:text=You%20set%20up%20a%20dynamic%20data%20masking%20policy%20in%20the%20Azure%20portal%20by%20selecting%20the%20Dynamic%20Data%20Masking%20blade%20under%20Security%20in%20your%20SQL%20Database%20configuration%20pane.

B correct

both A and B are correct