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 row-level security?
A
Create a separate database for each tenant and implement role-based access control (RBAC) at the database level.
B
Create a single database with a tenant_id column in each table and implement row-level security using a filter predicate.
C
Implement row-level security by creating a stored procedure for each tenant that filters the data based on the tenant_id.
D
Use Azure Active Directory (AAD) to manage user authentication and implement RBAC at the database level.
