Databricks Data Engineer Associate Question 467
Single answerA data engineering team is responsible for managing a Delta Lake table that contains sensitive customer data. To ensure compliance with data governance policies, they need to implement controls to restrict access to specific columns, such as social security numbers (SSNs). Which feature in Databricks should the team use to achieve this?
- A
Row-level security
- B
Column-level encryption
- C
Dynamic views
- D
Column-level security
Show answer and explanation
Correct answer: D
Explanation
Column-level security is a key feature in Databricks that allows organizations to enforce data governance policies by restricting access to sensitive information at the column level. This ensures that users or roles can only access the data they are authorized to see, which is essential for handling sensitive data like social security numbers.
- A. Incorrect.
Row-level security is used to restrict access to specific rows of data based on conditions, but it does not address restricting access at the column level.
- B. Incorrect.
Column-level encryption protects data by encrypting it, but it does not provide access control for specific users or roles.
- C. Incorrect.
Dynamic views allow for the creation of custom views that can include or exclude certain data, but they are not specifically suited for column-level access control.
- D. Correct.
Column-level security is the correct feature to restrict access to specific columns, such as SSNs, ensuring compliance with data governance requirements.