New Year Sale 2026! 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

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
4 months ago
Wait, can we really mask emails like that? Sounds too easy!
upvoted 0 times
...
Sue
4 months ago
D could work, but it feels a bit clunky.
upvoted 0 times
...
Deandrea
4 months ago
C sounds right, but I prefer using the portal for ease.
upvoted 0 times
...
Yong
5 months ago
I think B is more about data classification, not masking.
upvoted 0 times
...
Rene
5 months ago
Option A is the way to go! Masking is perfect for this.
upvoted 0 times
...
Teddy
5 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
5 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
5 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
5 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
5 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
5 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
5 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