
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?
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.