Answer-first summary for fast verification
Answer: Implement a dynamic view that filters rows based on a tenant identifier.
Dynamic views can be used to filter rows based on a tenant identifier, ensuring that each tenant only sees their own data. This approach is scalable and maintains data isolation without the need for multiple tables or manual data filtering.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a multi-tenant Databricks environment, you need to control access to rows and columns of a table containing financial data. Each tenant should only have access to their own data. Describe how you would use dynamic views to ensure that tenant-specific data is isolated and accessible only to the respective tenant.
A
Create separate tables for each tenant.
B
Use row-level security features within the database engine.
C
Implement a dynamic view that filters rows based on a tenant identifier.
D
Manually filter data for each tenant upon request.
No comments yet.