
Ultimate access to all questions.
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).