
Ultimate access to all questions.
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.