Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
You are tasked with implementing data masking in an Azure SQL Database to protect sensitive information such as credit card numbers. The database is used by both financial analysts and customer service representatives. Financial analysts require full access to the data for reporting purposes, while customer service representatives only need to see the last four digits of the credit card numbers. How would you implement this data masking strategy?
You are tasked with implementing data masking in an Azure SQL Database to protect sensitive information such as credit card numbers. The database is used by both financial analysts and customer service representatives. Financial analysts require full access to the data for reporting purposes, while customer service representatives only need to see the last four digits of the credit card numbers. How would you implement this data masking strategy?
Explanation:
Dynamic data masking allows you to specify how much of the sensitive data to reveal to users based on their role. In this scenario, using a custom string masking function to show only the last four digits of the credit card numbers to customer service representatives while allowing financial analysts full access is the most appropriate solution.