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 4 Question 34 Discussion

Actual exam question for Microsoft's DP-300 exam
Question #: 34
Topic #: 4
[All DP-300 Questions]

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information.

You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers.

The solution must prevent all the salespeople from viewing or inferring the credit card information.

What should you include in the recommendation?

Show Suggested Answer Hide Answer
Suggested Answer: B

Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics support dynamic data masking. Dynamic data masking limits sensitive data exposure by masking it to non-privileged users.

The Credit card masking method exposes the last four digits of the designated fields and adds a constant string as a prefix in the form of a credit card.

Example:

XXXX-XXXX-XXXX-1234


by Heike at May 08, 2022, 11:54 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
Caren
5 months ago
Not sure if data masking is enough for credit card info.
upvoted 0 times
...
Scarlet
5 months ago
Wait, can column-level security really prevent inference?
upvoted 0 times
...
Lonna
5 months ago
Always Encrypted sounds like a solid choice!
upvoted 0 times
...
Veronica
5 months ago
Row-level security is better for this scenario.
upvoted 0 times
...
Eric
5 months ago
I think data masking is the way to go here.
upvoted 0 times
...
Linwood
5 months ago
Column-level security seems like it could help too, but I’m not confident if it’s enough to stop salespeople from inferring credit card details.
upvoted 0 times
...
Douglass
5 months ago
Always Encrypted sounds familiar, and I feel like it might be the right choice since it protects data at rest and in transit.
upvoted 0 times
...
Lavonda
5 months ago
I remember we discussed row-level security in class, but I'm not sure if it fully prevents access to sensitive data like credit card info.
upvoted 0 times
...
Lonny
6 months ago
I think data masking could be a good option here, but I’m not completely clear on how it works with Azure Synapse.
upvoted 0 times
...
Jani
6 months ago
Okay, let me think this through. I know HIPAA has titles related to things like administrative simplification and insurance portability, so I'll try to eliminate the options that sound like they fit those categories.
upvoted 0 times
...
Dorsey
6 months ago
This is a good one. I'm pretty confident I know the Citrix ADC features well enough to identify the right solution here. I'll carefully evaluate each choice and pick the one that best addresses a 503 error.
upvoted 0 times
...
Reita
6 months ago
I'm a bit confused on this one. Is DBCC SHRINKDATABASE the same as sp_clean_db_free_space? I know they're both related to freeing up space, but I'm not sure if they do the same thing. I'll have to double-check the documentation to make sure I understand the differences.
upvoted 0 times
...

Save Cancel