HOTSPOT

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

Correct Answer:

Explanation/Reference:
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.
Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver15