Answer-first summary for fast verification
Answer: Use column-level security policies to restrict access to specific columns based on user roles.
Column-level security policies allow you to restrict access to specific columns in a database table based on user roles. This approach provides the granularity needed to ensure that only authorized users can access sensitive information, enhancing the security of the data solution.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Your organization is implementing a new data solution that involves storing sensitive customer data in Azure SQL Database. You need to implement column-level security to ensure that only authorized users can access specific columns containing sensitive information. How would you implement this security measure?
A
Use dynamic data masking to mask sensitive columns for all users except administrators.
B
Implement Azure role-based access control (RBAC) to restrict access to the database.
C
Use column-level security policies to restrict access to specific columns based on user roles.
D
Encrypt the sensitive columns and manage decryption keys through Azure Key Vault.
No comments yet.