Which users can view the email addresses of the customers?

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.

View Answer

Answer: B

Explanation:

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

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/dynamic-data-masking