Answer-first summary for fast verification
Answer: Create a stored procedure that applies a custom mask to the SSNs when they are accessed.
Option B is the correct answer. Creating a stored procedure that applies a custom mask to the SSNs when they are accessed is an effective way to implement data masking. This allows you to control the level of masking applied based on the user's role or other criteria. Option A is incorrect because dynamic data masking is a feature of Azure SQL Database, not Azure Synapse Analytics. Option C is incorrect because row-level security is used to restrict access to rows in a table, not to mask data. Option D is incorrect because encrypting the entire table at rest does not provide data masking for specific columns.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Your company is implementing a new data warehousing solution using Azure Synapse Analytics. You are tasked with ensuring that sensitive data is protected. Which of the following steps should you take to implement data masking for a column containing social security numbers (SSNs)?
A
Use dynamic data masking to mask the SSNs with a default mask, such as XXX-XX-XXXX.
B
Create a stored procedure that applies a custom mask to the SSNs when they are accessed.
C
Implement row-level security to restrict access to the SSNs based on the user's role.
D
Encrypt the entire table containing the SSNs at rest using Transparent Data Encryption (TDE).