Databricks Data Engineer Associate Question 481
Select 3You are working on a Databricks Lakehouse implementation and need to configure data governance and access control. You want to understand the difference between a metastore and a catalog in Unity Catalog. Which of the following statements are correct about metastores and catalogs in Unity Catalog?
- A
A metastore is a top-level container that holds catalogs, schemas, and tables.
- B
A catalog is used to group schemas and tables logically within a metastore.
- C
Each Databricks workspace can only have one catalog associated with it.
- D
A metastore is region-specific, whereas catalogs are not tied to a specific region.
- E
Catalogs are the highest level of data organization in Unity Catalog.
Show answer and explanation
Correct answers: A, B, D
Explanation
In Unity Catalog, a metastore serves as the top-level container that holds catalogs, schemas, and tables. Catalogs are logical groupings within a metastore, designed to organize data and improve governance. Metastores are region-specific because of their dependency on cloud storage, but catalogs are not tied to any specific region. This distinction helps ensure proper organization and access control across data assets in the Databricks Lakehouse.
- A. Correct.
Correct: A metastore is indeed a top-level container in Unity Catalog that organizes catalogs, schemas, and tables. It provides a central governance layer for data access.
- B. Correct.
Correct: Catalogs are logical groupings within a metastore and are used to organize schemas and tables for better management and governance.
- C. Incorrect.
Incorrect: Each Databricks workspace can have multiple catalogs, as catalogs are logical containers within a metastore and can be created as needed.
- D. Correct.
Correct: Metastores are tied to a specific cloud region, but catalogs are logical entities and are not region-specific.
- E. Incorrect.
Incorrect: Metastores, not catalogs, are the highest level of data organization in Unity Catalog.