Designing an Azure Data Solution (legacy) — Question 28

You are designing an enterprise data warehouse in Azure Synapse Analytics that will contain a table named Customers. Customers will contain credit card information.
You need to recommend a solution to provide salespeople with the ability to view all the entries in Customers. The solution must prevent all the salespeople from viewing or inferring the credit card information.
What should you include in the recommendation?

Answer options

• A. row-level security
• B. data masking
• C. column-level security
• D. Always Encrypted

Correct answer: B

Explanation

Data masking is the correct choice because it allows users to see all entries while obscuring sensitive data such as credit card information. Row-level security would restrict access based on user roles, which doesn’t meet the requirement to view all entries. Column-level security controls access to specific columns but does not mask the data. Always Encrypted secures data at rest and in transit but does not allow for the visibility required by salespeople.