Discuss Microsoft DP-300 Exam Topic 4 Question 34

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?

Arow-level security

Bdata masking

CAlways Encrypted

Dcolumn-level security

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

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

Caren 12 months ago

Not sure if data masking is enough for credit card info.

Scarlet 1 year ago

Wait, can column-level security really prevent inference?

Lonna 1 year ago

Always Encrypted sounds like a solid choice!

Veronica 1 year ago

Row-level security is better for this scenario.

Eric 1 year ago

I think data masking is the way to go here.

Linwood 1 year 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.

Douglass 1 year ago

Always Encrypted sounds familiar, and I feel like it might be the right choice since it protects data at rest and in transit.

Lavonda 1 year 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.

Lonny 1 year ago

I think data masking could be a good option here, but I’m not completely clear on how it works with Azure Synapse.

Jani 1 year 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.

Dorsey 1 year 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.

Reita 1 year 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.

Microsoft DP-300 Exam - Topic 4 Question 34 Discussion