ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam DP-200 All Questions

View all questions & answers for the DP-200 exam
Go to Exam

Exam DP-200 topic 3 question 4 discussion

Actual exam question from Microsoft's DP-200
Question #: 4
Topic #: 3
[All DP-200 Questions]

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?

  • A. From Microsoft SQL Server Management Studio, set an email mask on the Email column.
  • B. From the Azure portal, set a mask on the Email column.
  • C. From Microsoft SQL Server Management studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.
  • D. From the Azure portal, set a sensitivity classification of Confidential for the Email column.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
by cdanner at Nov. 5, 2020, 5:22 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
datachamp
Highly Voted 4 years, 5 months ago
Correct Answer: A. From Microsoft SQL Server Management Studio, set an email mask on the Email column. This is because "This feature cannot be set using portal for Azure Synapse (use PowerShell or REST API) or SQL Managed Instance." So use Create table statement with Masking e.g. CREATE TABLE Membership (MemberID int IDENTITY PRIMARY KEY, FirstName varchar(100) MASKED WITH (FUNCTION = 'partial(1,"XXXXXXX",0)') NULL, . . https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
upvoted 27 times
Mgb106
7 months, 4 weeks ago
Now the documentation only says "This feature can't be set using portal for SQL Managed Instance.". So maybe they added the option to do it in Azure Synapse, after this question was created.
upvoted 1 times
Mgb106
7 months, 4 weeks ago
But I think you can't do in from the portal, or at least you didn't use to be able to when this question was created.
upvoted 1 times
...
...
lingjun
4 years, 5 months ago
we can. I try it out from portal for Azure Synapse SQL pool
upvoted 7 times
dumpsm42
4 years, 4 months ago
https://docs.microsoft.com/pt-pt/azure/azure-sql/database/dynamic-data-masking-configure-portal see the initial note regards
upvoted 3 times
ramelas
3 years, 4 months ago
we are not using an MI
upvoted 2 times
...
...
...
...
cdanner
Highly Voted 4 years, 5 months ago
I would select A since B doesn't describe the type of mask. It needs to be email mask on the email column.
upvoted 11 times
Kalo
4 years, 2 months ago
agree with you. A and B can both work but in the option B, we don't have the type of mask. So the answer have to be A here.
upvoted 2 times
...
Internet_User
4 years ago
I also agree. I tested both, and A and B can both work. A is more specific, however.
upvoted 1 times
...
...
odavidrg
Most Recent 3 years, 5 months ago
What about D ? in dp-300 D is the correct
upvoted 2 times
...
massnonn
3 years, 5 months ago
for set mask on column is need one sql script or design of the table , A is correct
upvoted 1 times
...
Mist3
3 years, 10 months ago
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. I go for B - Azure portal
upvoted 4 times
...
GData23
3 years, 11 months ago
It's B. The test is teaching you Azure so don't " overthink" it. This test isn't designed to trick you. The answers are more straight-forward. In documentation it says: APPLIES TO: Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics
upvoted 3 times
...
davita8
4 years ago
Correct Answer: A
upvoted 2 times
...
KpKo
4 years ago
the answer is correct
upvoted 1 times
...
Wendy_DK
4 years ago
This feature cannot be set using portal for SQL Managed Instance (use PowerShell or REST API). The article was on 1/25/2021. It means A and B both can do the mask job.
upvoted 2 times
...
cjh1912
4 years, 3 months ago
Should be A cause if masking was not specified the "@" will also be converted to X which is not what the question is asking https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview
upvoted 3 times
KRV
4 years, 3 months ago
Even though your choice is correct , its is bcos it applies to both Azure SQLDatabase and Azure Synapse Analytics
upvoted 1 times
...
...
Navii
4 years, 4 months ago
Option Marked is correct. 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 (use PowerShell or REST API).
upvoted 4 times
Ab5381
4 years, 3 months ago
I agree. I tried in my existing dedicated SQL Pools (formerly DWH) and I can do it from portal as mentioned in https://docs.microsoft.com/pt-pt/azure/azure-sql/database/dynamic-data-masking-configure-portal
upvoted 1 times
KRV
4 years, 3 months ago
Hi , The link that you pasted only applies to Azure SQL Database. Please check the link at the top it clearly says : APPLIES TO: Azure SQL Database However if you see the https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15 It applies to Applies to: yesSQL Server 2016 (13.x) and later YesAzure SQL Database YesAzure SQL Managed Instance yesAzure Synapse Analytics So since the question asks for Synapse Pool , I would go with the option A of expliciltiy specifying during create table as Email varchar(100) MASKED WITH (FUNCTION = 'email()') NULL
upvoted 2 times
...
...
...
syu31svc
4 years, 5 months ago
Answer can only be A
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago