Answer-first summary for fast verification
Answer: Use dynamic data masking with a custom string for the credit card numbers, showing only the last four digits to customer service representatives.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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?
A
Use dynamic data masking with a custom string for the credit card numbers, showing only the last four digits to customer service representatives.
B
Encrypt the entire credit card number column and provide decryption keys only to financial analysts.
C
Use row-level security to restrict customer service representatives from viewing any credit card numbers.
D
Implement column-level security to allow only financial analysts to access the credit card number column.