
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 row-level security to ensure that each healthcare provider can only access their own patients' data. How would you implement this security measure?
A
Use dynamic data masking to mask patient data for all users except administrators.
B
Implement Azure role-based access control (RBAC) to restrict access to the database.
C
Use row-level security policies to filter rows based on the healthcare provider's identity.
D
Encrypt the patient data columns and manage decryption keys through Azure Key Vault.