Answer-first summary for fast verification
Answer: Use SQL transformations within a dynamic view to apply conditional masking based on user roles.
Creating a dynamic view allows for real-time data masking based on user roles and specific conditions. SQL transformations within the view can apply different masking rules dynamically, ensuring that sensitive information is protected while still providing necessary data access to authorized users.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Consider a scenario where you are tasked with implementing dynamic views to perform data masking in a Databricks environment. The database contains sensitive information such as social security numbers, credit card details, and personal addresses. Describe how you would create a dynamic view that masks the last four digits of credit card numbers, replaces social security numbers with 'REDACTED', and hides the personal addresses for users with a 'Guest' role.
A
Create a static view with hardcoded masking rules.
B
Use SQL transformations within a dynamic view to apply conditional masking based on user roles.
C
Disable access to the database for users with the 'Guest' role.
D
Manually update each row to mask sensitive information.
No comments yet.