Databricks Data Engineer Associate Question 528
Single answerA company is using Databricks Unity Catalog to manage data access across various business units. As part of best practices, how should the company design its catalog structure to ensure proper segregation of business units and access control?
- A
Create a separate catalog for each business unit to organize their respective data and enforce access controls independently.
- B
Place all data for every business unit in a single catalog and manage access by creating multiple schemas within that catalog.
- C
Store all data in a single schema and use table-level permissions to segregate access across business units.
- D
Use one catalog for sensitive data and another catalog for non-sensitive data, regardless of the business unit ownership.
Show answer and explanation
Correct answer: A
Explanation
Best practices for Unity Catalog recommend creating separate catalogs for each business unit. This approach ensures clear segregation of data ownership, simplifies access control policies, and minimizes the risk of accidental data exposure across units. This structure aligns with data governance requirements and makes it easier to manage permissions at the catalog level for each business unit.
- A. Correct.
Creating a separate catalog for each business unit ensures clear segregation of data, simplifies access control, and aligns with best practices for data governance in Unity Catalog.
- B. Incorrect.
Using a single catalog with multiple schemas can lead to complicated access control configurations and potential data governance issues when multiple business units share the same catalog.
- C. Incorrect.
Storing all data in a single schema and relying on table-level permissions is not recommended as it complicates governance and increases the risk of unauthorized access.
- D. Incorrect.
Using catalogs based on data sensitivity rather than business unit ownership does not align with best practices for segregating business units, as it mixes data from different units and complicates governance.