Databricks Data Engineer Associate Question 530
Single answerA company is designing its data governance strategy in Databricks and wants to ensure that each business unit has proper data segregation within the Unity Catalog. What is the best practice to achieve this?
- A
Create a separate catalog for each business unit to organize their data independently.
- B
Create a single catalog and use schema names to represent different business units.
- C
Store all data in a single schema and use table naming conventions to distinguish each business unit.
- D
Use workspace-level access control to segregate data instead of using Unity Catalog.
Show answer and explanation
Correct answer: A
Explanation
The best practice for segregating business units in Databricks Unity Catalog is to create a separate catalog for each business unit. This ensures logical and access control separation, making it easier to manage permissions and maintain data organization. Other methods, such as using schemas or table naming conventions, do not provide the same level of isolation or ease of governance.
- A. Correct.
Correct: Creating a separate catalog for each business unit is a best practice as it provides logical and access control segregation, making it easier to manage permissions and organize data.
- B. Incorrect.
Incorrect: While using schemas within a single catalog can organize data, it does not provide the same level of logical separation or access control granularity as separate catalogs.
- C. Incorrect.
Incorrect: Storing all data in a single schema with naming conventions can lead to poor organization, difficulty in managing permissions, and higher chances of errors.
- D. Incorrect.
Incorrect: Workspace-level access control is not sufficient for implementing fine-grained data governance within Unity Catalog, as it operates at a broader scope than desired.