Microsoft
DP-300 · Question #51
Hotspot Question You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_
Sign in or unlock DP-300 to reveal the answer and full explanation for question #51. The question stem and answer options stay visible for context.
Submitted by ricky.ec· Mar 6, 2026Implement a secure environment
Question
Hotspot Question You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table. You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the following requirements: - The first six numerals of each customer's phone number must be masked. - The last four digits of each customer's phone number must be visible. - Hyphens must be preserved and displayed. How should you configure the dynamic data mask? To answer, select the appropriate options in the answer area. Answer:
Exhibits
Answer Area
- The dynamic data mask for the Customer_Phone column must be configured with an Exposed Prefix of 0.
- The dynamic data mask for the Customer_Phone column must be configured with a Padding String of 'xxx-xxxx'.
- The dynamic data mask for the Customer_Phone column must be configured with an Exposed Suffix of 5.
Unlock DP-300 to see the answer
You've previewed enough free DP-300 questions. Unlock DP-300 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#Dynamic Data Masking#Azure SQL Database#Data Security#Data Privacy

