Answer-first summary for fast verification
Answer: Use Azure SQL Database's built-in dynamic data masking feature to mask the sensitive data automatically based on the user's role or IP address.
Option A is the correct answer. Using Azure SQL Database's built-in dynamic data masking feature allows you to mask the sensitive data automatically based on the user's role or IP address. This provides a flexible and efficient way to protect sensitive data without requiring changes to the application code. Option B is incorrect because implementing a custom stored procedure for data masking can be complex and may not provide a consistent security model. Option C is incorrect because Azure Information Protection is used for classifying and protecting documents and emails, not for data stored in databases. Option D is incorrect because implementing a custom function for data masking can be complex and may not provide a consistent security model.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You are responsible for implementing data masking for a highly sensitive dataset stored in Azure SQL Database. Which of the following data masking techniques should you use to protect the sensitive data?
A
Use Azure SQL Database's built-in dynamic data masking feature to mask the sensitive data automatically based on the user's role or IP address.
B
Implement a custom stored procedure that applies a custom mask to the sensitive data when it is accessed.
C
Use Azure Information Protection统一 to classify and protect the sensitive data by applying a sensitive information type policy.
D
Implement a custom function that applies a custom mask to the sensitive data based on the user's role or other criteria.
No comments yet.