DP-203 Certification Practice Question #211

Question

You are designing an Azure Synapse Analytics dedicated SQL pool.
You need to ensure that you can audit access to Personally Identifiable Information (PII).
What should you include in the solution?

Accepted Answer

The requirement is specifically to *audit access* to PII, not merely hide or filter it. Microsoft Learn states that Data Discovery & Classification (sensitivity classifications) adds sensitivity metadata to audit logs, which is exactly the capability needed to track access to sensitive data. Dynamic data masking, column-level security, and RLS are access-control or obfuscation features, but they do not answer the auditing requirement.

More DP-203 practice questions