Question 121 of 170 from exam DP-200: Implementing an Azure Data Solution

Prev Question Next Question

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:

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.

Prev Question Next Question