Administering Relational Databases on Microsoft Azure (DP-300) Test 2

© examsiri.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.
Customer_IDCustomer_NameCustomer_Phone
11001 Contoso, Ltd. 555−555−0173
11002 Litware, Inc. 555−505−3124
11003 ADatum Corporation 555−689−4312
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
  • Exposed Prefix: ______



  • Padding String: ______




  • Exposed Suffix: ______



Go to Question: