Explanation:
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.
Ultimate access to all questions.
You are designing a data solution for a healthcare provider that must comply with HIPAA regulations. The solution involves storing patient 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.