DRAG DROP - You have an Azure subscription that contains an Azure SQL database named SQLDB1. SQLDB1 contains the columns shown in the following table. For the E...


Microsoft AZ-500 Exam

Questions Number: 371 out of 443 Questions
83.75%

Question 371
DRAG DROP -
You have an Azure subscription that contains an Azure SQL database named SQLDB1. SQLDB1 contains the columns shown in the following table.
AZ-500_371Q_1.jpg related to the Microsoft AZ-500 Exam
For the Email and Birthday columns, you implement dynamic data masking by using the default masking function.
Which value will the users see in each column? To answer, drag the appropriate values to the correct columns. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
AZ-500_371Q_2.jpg related to the Microsoft AZ-500 Exam



Box 1: aXXXX @XXXX.com -
The Email masking method, exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address.
Example: [email protected] -
Box 2: 1900-01-01 -
Use 01-01-1900 (or 1900-01-01) for date/time data types (date, datetime2, datetime, datetimeoffset, smalldatetime, time).
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview





Previous Questions Next Questions