
Answer-first summary for fast verification
Answer: Use dynamic views to apply conditional masking based on department roles.
Dynamic views with conditional masking based on department roles ensure that sensitive information is protected for non-HR users. This approach maintains data access for authorized users while safeguarding sensitive details.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
You are tasked with securing a Databricks workspace that handles employee data, including salaries, performance reviews, and personal contact information. Describe how you would create a dynamic view to mask salary details and redact personal contact information for users who are not in the HR department.
A
Create separate tables for HR and non-HR users.
B
Use dynamic views to apply conditional masking based on department roles.
C
Encrypt the sensitive columns.
D
Disable access to the workspace for non-HR users.