QuestionQ9

Secure compute, storage, and databases

You have an Azure subscription containing an Azure SQL database named SQLDB1. SQLDB1 includes the columns shown in the following table.

Question Image

For the Email and Birthday columns, dynamic data masking is implemented by using the default masking function. Which value will users see in each column?

Each value may be used once, more than once, or not at all.

Drag & Drop
Email:
Birthday:
Explanation

Azure SQL Database's default dynamic data masking function returns XXXX for string data. For date/time data it returns a 1900-01-01 value; a Date column displays this as 1900-01-01.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!