Answer-first summary for fast verification
Answer: Develop a dynamic view that includes all columns and uses row-level security to conditionally mask sensitive data based on the user's role, ensuring compliance without duplicating data.
Option B is the correct choice because it leverages dynamic data masking and row-level security to conditionally hide sensitive information based on the user's role. This approach complies with data protection regulations by ensuring that sensitive data is only accessible to authorized users, without the need for data duplication or permanent alteration, thus avoiding unnecessary costs and complexity. It provides a flexible and efficient solution to manage access to sensitive data dynamically.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
In a scenario where you are tasked with managing a dataset that includes personal and sensitive information of employees, such as salary details, for a multinational corporation. The corporation requires that sensitive data be dynamically masked for users based on their role within the organization to comply with global data protection regulations. Additionally, the solution must ensure that the data remains accessible in its original form for authorized users and that the implementation does not incur unnecessary costs or complexity. Which of the following approaches best meets these requirements? (Choose one option)
A
Implement a static view that excludes sensitive columns entirely, requiring separate views for each user role, which increases management overhead.
B
Develop a dynamic view that includes all columns and uses row-level security to conditionally mask sensitive data based on the user's role, ensuring compliance without duplicating data.
C
Create a copy of the dataset with sensitive information permanently removed for unauthorized users, leading to data inconsistency and increased storage costs.
D
Apply permanent data masking to the entire dataset, restricting all users from accessing sensitive information, which undermines the needs of authorized personnel.