Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
You are designing a data access control system for a multi-tenant application using Azure SQL Database. Which of the following approaches should you use to implement column-level security?
A
Create a separate schema for each tenant and implement column-level security using schema-level permissions.
B
Create a single schema with a tenant_id column in each table and implement column-level security using dynamic data masking.
C
Implement column-level security by creating a stored procedure for each tenant that filters the data based on the tenant_id and the required columns.
D
Use Azure role-based access control (RBAC) to assign permissions to specific columns for each tenant.
