
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.