DP-203 Certification Practice Question #223

Question

You have an Azure Synapse Analytics dedicated SQL pool that contains a table named Contacts. Contacts contains a column named Phone.
You need to ensure that users in a specific role only see the last four digits of a phone number when querying the Phone column.
What should you include in the solution?

Accepted Answer

The scenario asks for a display-time transformation: users in a role should query the `Phone` column but see only the last four digits. That is exactly what dynamic data masking is designed for. It leaves the stored value intact and masks the returned value for non-privileged users. Row-level security is the wrong scope, and encryption is aimed at protecting stored data rather than selectively masking query results.

More DP-203 practice questions