Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-300 Exam - Topic 8 Question 49 Discussion

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?
B) From the Azure portal, set a sensitivity classification of Confidential for the Email column.
A) From the Azure portal, set a mask on the Email column.
C) From Microsoft SQL Server Management Studio, set an email mask on the Email column.
D) From Microsoft SQL Server Management Studio, grant the SELECT permission to the users for all the columns in the dbo.Customers table except Email.

Microsoft DP-300 Exam - Topic 8 Question 49 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 49
Topic #: 8
[All DP-300 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 aXXX@XXXX.com instead.

What should you do?

Show Suggested Answer Hide Answer
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


by Roslyn at May 09, 2022, 04:04 PM

Limited Time Offer

25%

Off

Get Premium DP-300 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Paris
10 months ago
Wait, can we really mask emails like that? Sounds too easy!
upvoted 0 times
...
Sue
10 months ago
D could work, but it feels a bit clunky.
upvoted 0 times
...
Deandrea
11 months ago
C sounds right, but I prefer using the portal for ease.
upvoted 0 times
...
Yong
11 months ago
I think B is more about data classification, not masking.
upvoted 0 times
...
Rene
11 months ago
Option A is the way to go! Masking is perfect for this.
upvoted 0 times
...
Teddy
11 months 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?
upvoted 0 times
...
Josefa
11 months 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.
upvoted 0 times
...
Sharan
11 months 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?
upvoted 0 times
...
Celia
11 months ago
I think option A sounds familiar; I remember something about setting a mask in the Azure portal during our practice sessions.
upvoted 0 times
...
Eveline
11 months ago
This seems like a tricky one. I'll need to draw on my knowledge of surveillance camera technology to make an informed decision.
upvoted 0 times
...
Suzi
11 months 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.
upvoted 0 times
...
Naomi
11 months ago
I feel like the answer is probably three tests to cover all possible paths, but I'm second-guessing myself on the specifics.
upvoted 0 times
...

Save Cancel