Answer-first summary for fast verification
Answer: Implement row-level security using dynamic views that filter data based on user attributes, allowing for fine-grained access control without the need for multiple static views.
Option C is the most effective approach because it leverages dynamic views to provide fine-grained access control at the row level based on user attributes. This method is scalable, cost-effective, and complies with data governance policies by dynamically adjusting access without the need for creating and managing multiple static views or the administrative overhead associated with encryption and decryption processes. It ensures that users can only access the data they are authorized to see, aligning with the principles of least privilege and data minimization.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In a Databricks environment, you are tasked with implementing a solution to ensure that only authorized users can access specific datasets, considering the need for scalability, cost-effectiveness, and compliance with data governance policies. The solution must dynamically adjust access based on user roles and attributes without significant administrative overhead. Which of the following approaches would be most effective in achieving these goals? (Choose one correct option)
A
Create a single view for all users and rely on their self-discipline to access only the data they need, minimizing initial setup time.
B
Create multiple static views for each dataset, each accessible only by users with the appropriate permissions, ensuring strict access control.
C
Implement row-level security using dynamic views that filter data based on user attributes, allowing for fine-grained access control without the need for multiple static views.
D
Encrypt the entire dataset and decrypt it only when a user requests access, providing a high level of security but potentially increasing latency and administrative complexity.
No comments yet.