DP-203 Certification Practice Question #236

Question

You have an Azure Synapse Analytics dedicated SQL pool that hosts a database named DB1.

You need to ensure that DB1 meets the following security requirements:

•	When credit card numbers show in applications, only the last four digits must be visible.
•	Tax numbers must be visible only to specific users.

What should you use for each requirement? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Accepted Answer

The first requirement is plainly a masking problem: users can see the value, but only its last four digits. Dynamic data masking is built for that. The second requirement is different: only certain users may see the tax-number column at all. That is column-level security, which grants or denies access to specific columns. Row-level security would hide rows, not the tax-number field itself, so it does not match the requirement as closely.

More DP-203 practice questions