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 data masking for a dataset containing sensitive information in Databricks, you need to ensure compliance with GDPR and minimize operational costs while maintaining data utility for analytics. Considering these constraints, which of the following SQL functions would be the most appropriate to use for dynamic data masking based on user roles and permissions? Choose the best option.
A
CASE WHEN - Allows for conditional logic to mask data based on specific conditions but may require complex queries for dynamic role-based masking.
B
IF ELSE - Suitable for simple conditional checks to mask data but lacks the flexibility for complex role-based scenarios without extensive scripting.
C
COALESCE - Useful for replacing NULL values with a default value, thus masking NULLs, but does not address the need for dynamic masking based on user roles.
D
All of the above - By combining these functions, you can create dynamic views that perform comprehensive data masking tailored to user roles and permissions, ensuring compliance and data utility.