Question 146 of 170 from exam DP-200: Implementing an Azure Data Solution

Prev Question Next Question

You have an Azure SQL database that contains a table named Customer. Customer contains the columns shown in the following table.

You apply a masking rule as shown in the following table.

Which users can view the email addresses of the customers?

A. Server administrators and all users who are granted the UNMASK permission to the Customer_Email column only.

B. All users who are granted the UNMASK permission to the Customer_Email column only.

C. Server administrators only.

D. Server administrators and all users who are granted the SELECT permission to the Customer_Email column only.

Click on the arrows to vote for the correct answer

A. B. C. D.

Grant the UNMASK permission to a user to enable them to retrieve unmasked data from the columns for which masking is defined.

Prev Question Next Question