nerdexam
Microsoft

AZ-500 · Question #380

Drag and Drop Question 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…

The correct answer is XXXX; 1900-01-01. In Azure SQL Dynamic Data Masking, the 'default' masking function applies type-specific masks: for string/text columns (like Email), it replaces the value with 'XXXX' regardless of the actual content, and for date/datetime columns (like Birthday), it replaces the value with…

Submitted by layla.eg· Mar 6, 2026Implement data security and compliance in Azure SQL, specifically configuring Dynamic Data Masking to protect sensitive data from unauthorized users.

Question

Drag and Drop Question 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. Answer:

Exhibits

AZ-500 question #380 exhibit 1
AZ-500 question #380 exhibit 2
AZ-500 question #380 exhibit 3
AZ-500 question #380 exhibit 4

Answer Area

Drag items

1900-01-011900-01-01 00:00:00.00002010-XX-XXXXXX[email protected][email protected][email protected]

Correct arrangement

  • XXXX
  • 1900-01-01

Explanation

In Azure SQL Dynamic Data Masking, the 'default' masking function applies type-specific masks: for string/text columns (like Email), it replaces the value with 'XXXX' regardless of the actual content, and for date/datetime columns (like Birthday), it replaces the value with '1900-01-01' (the epoch date) to obscure the real date. These are fixed, predefined outputs of the default masking function and do not partially reveal the original data.

Topics

#Azure SQL Database#Dynamic Data Masking#Data Security#Default Masking Function

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full AZ-500 Practice