Databricks Certified Data Engineer - Professional
Comments
Loading comments...
Ultimate access to all questions.
In a Databricks environment, you are tasked with implementing a solution to ensure that users can only access specific columns in a dataset based on their roles. The solution must be scalable, support dynamic changes in user roles, and minimize administrative overhead. Additionally, the solution should comply with data governance policies requiring detailed access logs. Which of the following approaches would BEST meet these requirements? (Choose one)
A
Create a single view for all users and rely on their self-discipline to access only the columns they need, logging all access attempts for compliance.
B
Create multiple static views for each user role, each containing only the columns that the role is authorized to access, and manually update these views as roles change.
C
Implement column-level security using dynamic views that filter columns based on user attributes, automatically adjusting access as roles change, and logging access for compliance.
D
Encrypt the entire dataset and decrypt specific columns only when a user requests access, maintaining logs of decryption events for compliance.