ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam AZ-500 All Questions

View all questions & answers for the AZ-500 exam
Go to Exam

Exam AZ-500 topic 5 question 51 discussion

Actual exam question from Microsoft's AZ-500
Question #: 51
Topic #: 5
[All AZ-500 Questions]

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

Show Suggested Answer Hide Answer
Suggested Answer:
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
by FishBurger at Sept. 21, 2022, 10:28 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
wsrudmen
Highly Voted 2 years, 8 months ago
Correct answers should be: Email: XXXX ==> Default masking function is used (and not email function) Birthday: 1900-01-01 ==> as explained in the documentation for date type using default https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
upvoted 21 times
zellck
2 years, 2 months ago
XXXX is only used if the size of the field is fewer than 4 characters for string data types. https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql#dynamic-data-masking-policy Use XXXX (or fewer) if the size of the field is fewer than 4 characters for string data types (nchar, ntext, nvarchar).
upvoted 4 times
...
...
zellck
Highly Voted 2 years, 2 months ago
1. [email protected] 2. 1900-01-01 https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql#dynamic-data-masking-policy - Default Full masking according to the data types of the designated fields • Use 1900-01-01 for date/time data types (date, datetime2, datetime, datetimeoffset, smalldatetime, time). - Email Masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address. [email protected]
upvoted 12 times
DeviantMoto
1 year, 9 months ago
It's not using email masking for the email, it's only using default. so XXXX and 1900-01-01
upvoted 2 times
...
...
Pamban
Most Recent 1 year, 1 month ago
Email: XXXX * Use XXXX (or fewer) if the size of the field is fewer than 4 characters for string data types (nchar, ntext, nvarchar). https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
upvoted 1 times
...
[Removed]
1 year, 8 months ago
tested in lab Correct answers should be: Email: XXXX ==> Default masking function is used (and not email function) Birthday: 1900-01-01 ==> as explained in the documentation for date type using default
upvoted 2 times
...
Yaser111999
2 years, 1 month ago
I agree with the answers given https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql
upvoted 2 times
...
Psychosikh
2 years, 2 months ago
In exam 15/04/2023
upvoted 3 times
...
majstor86
2 years, 4 months ago
Email: XXXX Birthday: 1900-01-01 Default masking
upvoted 3 times
...
Muaamar_Alsayyad
2 years, 8 months ago
Correct anser should Email: XXXX ==> Default masking function is used (and not email function) Birthday: 1900-01-01
upvoted 6 times
ETV
2 years, 2 months ago
email exposes the first letter then .com
upvoted 1 times
...
zellck
2 years, 2 months ago
XXXX is only used if the size of the field is fewer than 4 characters for string data types. https://learn.microsoft.com/en-us/azure/azure-sql/database/dynamic-data-masking-overview?view=azuresql#dynamic-data-masking-policy Use XXXX (or fewer) if the size of the field is fewer than 4 characters for string data types (nchar, ntext, nvarchar).
upvoted 4 times
[Removed]
1 year, 8 months ago
I have proof on this link tested in lab https://drive.google.com/file/d/1Qyn7UbSFG66w4nXLwCsSyqFUn6Wre84O/view?usp=sharing
upvoted 3 times
wingcheuk
1 year, 5 months ago
thanks! seeing is believing.
upvoted 1 times
...
...
billo79152718
2 years, 1 month ago
It states in the question. Using the default masking function so not using the email function. I will also go for: XXXX in the first box.
upvoted 3 times
...
...
...
Pasapugazh
2 years, 8 months ago
Here the catch is it's using the default data masking function for both the columns. So it will be XXXX only, if the email function could have been used the second column then the given answer would be correct. For the second question it should be 01.01.1900 00:00:00.0000000 as per the MS docs. But not sure why 1900.01.01 is selected. Someone can help here.
upvoted 1 times
pentium75
11 months ago
The data type is "date", not "datetime".
upvoted 1 times
...
lt9898
1 year, 7 months ago
I was confused by this too, but it appears the time portion is only valid for SQL Server 2022 (link below) https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16#define-a-dynamic-data-mask If you look at the links others have shared for AzureSQL, you'll see different default() masking for dates plus other differences from SQL2022
upvoted 1 times
...
...
wyindualizer
2 years, 9 months ago
Default masking will be applied depending on the data type. For the string data type, it will be masked to ‘XXXX’. This is valid for the char, nchar, varchar, nvarchar, text and ntext data types. The value of numeric data types will be masked as 0. This is will be valid for bigint, int, smallint, tinyint, bit, decimal, money, numeric, smallmoney, float, real. All the date time data types such as date, datetime2, datetime, datetimeoffset, smalldatetime, time will be masked at 1900/01/01 00:00:00 etc.
upvoted 3 times
...
domtopics
2 years, 9 months ago
First answer should be XXXXX default() masking option on varchar yields a fixed 5-character XXXXX https://www.sqlshack.com/dynamic-data-masking-in-sql-server-2/
upvoted 2 times
domtopics
2 years, 9 months ago
*four character XXXX
upvoted 2 times
...
...
Amit3
2 years, 9 months ago
Given answers are correct. Use 01-01-1900 for date/time data types (date, datetime2, datetime, datetimeoffset, smalldatetime, time). Masking method, which exposes the first letter and replaces the domain with XXX.com using a constant string prefix in the form of an email address.
upvoted 3 times
...
FishBurger
2 years, 9 months ago
I think the second option is incorrect, looking at the default dynamic data masking information on Microsoft shows it should be all 'xxxx'. Not too sure here and have my exam today https://learn.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking?view=sql-server-ver16
upvoted 3 times
FishBurger
2 years, 9 months ago
*First option
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel