Databricks Certified Data Engineer - Professional
Get started today
Ultimate access to all questions.
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)
Explanation:
Option C is the best solution because it dynamically controls access to data based on user roles and regions, ensuring compliance with GDPR and other regulations without the need for manual updates. This approach is both scalable and cost-effective, as it automatically adjusts to new roles and regions, and leverages SQL functions for efficient data filtering. It provides a flexible and secure method for managing data access across a multinational corporation.