Test Index
Administering Relational Databases on Microsoft Azure (DP-300) Test 2
© examsnet.com
Question : 12 of 40
Marks:
+1,
-0
HOTSPOT
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 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
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in the following table.
| Customer_ID | Customer_Name | Customer_Phone |
|---|---|---|
| 11001 | Contoso, Ltd. | |
| 11002 | Litware, Inc. | |
| 11003 | ADatum Corporation | |
▪ The first six numerals of each customer’s phone number must be masked.
▪ 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
- Exposed Prefix: ______
- Padding String: ______
- Exposed Suffix: ______
Go to Question: