DP-200 Exam - Question 121

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

Examice · Accepted Answer

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.

NamishBansal · Answer

correct, nice question

Abouraa · Answer

the answer of padding string  , must be : XXX-XXX or  XXX-XXX- ?

DP-200 Exam - Question 121

Discussion