DP-300 Certification Practice Question #67

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.
Hot Area:

Accepted Answer

The `partial(prefix, padding, suffix)` dynamic data masking function replaces the unexposed middle section of a string with the padding string. Since the first six digits must be masked, the prefix is set to `0`. The last four digits plus the hyphen (`-YYYY`) represent 5 characters from the end of the string, so the suffix parameter must be set to `5` (since `4` is not a dropdown option). Since the suffix exposures include the hyphen, the padding string must be `XXX-XXX` (representing the first six digits, without a trailing hyphen) to avoid displaying a double hyphen.

More DP-300 practice questions