How should you configure the dynamic data mask?

HOTSPOT

You have an Azure SQL database that contains a table named Customer.

Customer contains 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 the customer phone numbers must be masked.

✑ The last four digits of the customer phone numbers 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. NOTE: Each correct selection is worth one point.

View Answer

Answer:

Explanation:

Exposed Prefix: 0

The first six digits must be masked. There is thus no exposed prefix.

Padding String: XXX-XXX

The first six digits must be masked and hyphens must be preserved.

Exposed Suffix: 5

The last 4 digits must be visible. There is not option for 4 but we can use 5 as it would include the hyphen before the last 4 digits.