Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In a scenario where you are tasked with implementing a secure data access solution for a multinational corporation, you need to ensure that access to sensitive rows and columns in a dataset is strictly controlled based on user roles across different regions. The solution must comply with GDPR for European users, be cost-effective, and easily scalable to accommodate future roles and regions. Which of the following techniques would be the BEST to achieve this? (Choose one)
A
Implement a single static view that includes all data and use application-level filtering to restrict access based on user roles, ensuring compliance by manually updating the view for GDPR requirements.
B
Create multiple static views for each combination of user role and region, pre-filtering data to meet access control and compliance requirements, which requires manual updates for any changes in roles or regulations.
C
Develop a dynamic view that leverages SQL functions and role-based access control (RBAC) to automatically filter data based on the user's role and region, with built-in compliance checks for regulations like GDPR.
D
Use a dynamic view that includes all data and apply row-level security (RLS) policies to filter data at query time, but this requires additional manual setup for each new region or regulation.