Ultimate access to all questions.
Answer-first summary for fast verification
Answer: Create a dynamic view with SQL transformations to mask specific columns based on user roles.
Dynamic views with SQL transformations allow for flexible and role-based data masking. This ensures that sensitive information is protected for non-researcher users while still providing access to necessary data for authorized users.
Author: LeetQuiz Editorial Team
You are responsible for securing a Databricks cluster that processes research data. The data includes project details, researcher names, and confidential findings. Describe how you would create a dynamic view to mask researcher names and redact confidential findings for users who do not have the 'Researcher' role.
A
Disable access to the cluster for non-researcher users.
B
Create a dynamic view with SQL transformations to mask specific columns based on user roles.
C
Encrypt the data at rest and in transit.
D
Use static views with predefined masking rules.
No comments yet.