
Ultimate access to all questions.
You are tasked with designing a solution for a financial services company that needs to share a large dataset containing customer information, including sensitive data such as social security numbers, with various departments within the organization. The solution must ensure that sensitive data is dynamically masked based on the user's role or permissions, without permanently altering the original dataset. Additionally, the solution should be cost-effective, scalable, and comply with data protection regulations. Which of the following approaches best meets these requirements? (Choose one option)
A
Implement a static view that excludes sensitive columns entirely and provide access to this view for all users, regardless of their role or permissions.
B
Create a dynamic view that includes all columns and use row-level security (RLS) to conditionally mask sensitive data based on the user's role or permissions.
C
Create a copy of the dataset with sensitive data permanently removed and provide access to this copy for users who do not require access to sensitive information.
D
Use a third-party data masking tool to permanently mask sensitive data in the original dataset before sharing it with any users.