Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
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.