Answer-first summary for fast verification
Answer: Use row-level security policies to filter rows based on the healthcare provider's identity.
Row-level security allows you to filter rows in a database table based on the user's identity, which is crucial for ensuring that healthcare providers can only access their own patients' data. This approach directly addresses the need for granular access control as required by HIPAA regulations.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.