Discuss Microsoft DP-300 Exam Topic 8 Question 49

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 aXXX@XXXX.com instead.

What should you do?

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 all the columns in the dbo.Customers table except Email.

Suggested Answer: B

The Email masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address.

Example: aXX@XXXX.com

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF Real Exam Format Detailed Explanations Instant Access Get Your Practice Test

12 comments · newest first

Paris 12 months ago

Wait, can we really mask emails like that? Sounds too easy!

Sue 12 months ago

D could work, but it feels a bit clunky.

Deandrea 12 months ago

C sounds right, but I prefer using the portal for ease.

Yong 1 year ago

I think B is more about data classification, not masking.

Rene 1 year ago

Option A is the way to go! Masking is perfect for this.

Teddy 1 year ago

I remember discussing permissions in class, and option D seems like it could work, but it doesn't really mask the email, does it?

Josefa 1 year ago

I practiced a similar question where we had to mask data in SQL Server Management Studio, so option C might be the answer, but I can't recall the exact steps.

Sharan 1 year ago

I'm not entirely sure, but I feel like sensitivity classifications are more about data governance than masking. So, maybe option B isn't the right choice?

Celia 1 year ago

I think option A sounds familiar; I remember something about setting a mask in the Azure portal during our practice sessions.

Eveline 1 year ago

This seems like a tricky one. I'll need to draw on my knowledge of surveillance camera technology to make an informed decision.

Suzi 1 year ago

Okay, I've got this. The key things to confirm are that the director has leadership support and that the project has a measurable goal. Those seem like the most important pieces of information to validate before moving forward.

Naomi 1 year ago

I feel like the answer is probably three tests to cover all possible paths, but I'm second-guessing myself on the specifics.

Microsoft DP-300 Exam - Topic 8 Question 49 Discussion