nerdexam
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

DP-300 question #51 exhibit 1
DP-300 question #51 exhibit 2

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
Full DP-300 Practice