DP-203 Certification Practice Question #209

Question

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?

Accepted Answer

The scenario is another masking-style question rather than a full authorization question. Microsoft Learn is clear that dynamic data masking is the feature that changes what non-privileged users see at query time, including email-style masks. The other options solve different security problems. The dump context is a bit messy, so I keep confidence slightly conservative, but the product behavior strongly favors dynamic data masking.

More DP-203 practice questions