Databricks Certified Data Engineer - Professional
Comments
Loading comments...
Ultimate access to all questions.
In a scenario where you are tasked with implementing data masking for a dataset containing sensitive customer information, such as social security numbers, to comply with GDPR and ensure data privacy, while still enabling authorized users to perform analytics. The solution must be scalable, cost-effective, and not disrupt existing analytics workflows. Which of the following techniques would be the MOST appropriate to achieve these objectives? (Choose one option)
A
Implement static data masking by creating a copy of the dataset with sensitive data permanently altered, making it available for analytics without the original sensitive information.
B
Utilize dynamic data masking by creating views that conditionally mask sensitive data based on user roles and permissions, allowing authorized users to see unmasked data for analytics.
C
Exclude sensitive columns entirely from all datasets and views, ensuring no access to sensitive data but potentially limiting analytics capabilities.
D
Apply full dataset encryption, decrypting data only for users with the highest access levels, which may introduce performance overhead and complexity in analytics workflows.