DP-300 Certification Practice Question #74

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

To prevent salespeople from viewing or inferring credit card information while allowing them to view other customer entries, you must use Column-Level Security (D). Dynamic Data Masking (B) is not a security boundary and fails the "prevent inferring" requirement because users can still reference the masked column in a `WHERE` clause or join condition to guess or brute-force the actual data (e.g., executing a query to check if the credit card equals a specific number). By contrast, Column-Level Security blocks users from referencing the column altogether, preventing both viewing and inference.

More DP-300 practice questions