Databricks Data Engineer Associate Question 529
Single answerA data engineering team is designing a Databricks Unity Catalog implementation for a company with multiple business units: Finance, Marketing, and HR. To ensure proper segregation of data and access controls as a best practice, which approach should they take?
- A
Create a single catalog for all business units and manage access using table-level permissions.
- B
Create separate catalogs for each business unit (e.g., Finance, Marketing, HR) to enforce logical segregation.
- C
Use a single catalog but define schemas for each business unit to separate their data.
- D
Create separate databases for each business unit within a single catalog and apply view-based access controls.
Show answer and explanation
Correct answer: B
Explanation
The best practice for implementing Unity Catalog in Databricks is to create separate catalogs for each business unit. This ensures logical segregation of data, simplifies access control at the catalog level, and aligns with enterprise data governance principles. Using a single catalog with schemas or databases can work for smaller setups but is not ideal for large organizations with multiple business units.
- A. Incorrect.
This option provides a single catalog approach, but it does not align with best practices for logical segregation across business units. Managing access at the table level can become complex and error-prone for large organizations.
- B. Correct.
This option follows the recommended best practice of creating separate catalogs for each business unit. This approach ensures logical segregation and simplifies access control management at the catalog level.
- C. Incorrect.
While schemas can help separate data, using a single catalog does not provide the same level of logical segregation as creating separate catalogs for each business unit. This approach is less scalable and harder to manage.
- D. Incorrect.
Using databases within a single catalog can provide some level of separation, but it is not as effective or secure as creating separate catalogs for business units. It also increases complexity in managing access controls.