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?

Simulated

Use dynamic data masking to mask sensitive columns for all users except administrators.

23.8%

Implement Azure role-based access control (RBAC) to restrict access to the database.

19.0%

Use column-level security policies to restrict access to specific columns based on user roles.

42.9%

Encrypt the sensitive columns and manage decryption keys through Azure Key Vault.

14.3%

Microsoft Azure Data Engineer Associate - DP-203