Databricks Data Engineer Associate Question 477
Single answerIn a Databricks Lakehouse environment, how do metastores and catalogs differ in terms of their purpose and scope?
- A
A metastore is a top-level container for organizing data objects, while a catalog is used to manage schemas and tables within the metastore.
- B
A catalog is a top-level container for organizing data objects, while a metastore is a storage layer for metadata across many catalogs.
- C
Metastores are used to manage access control for data objects, while catalogs are used to store metadata about those objects.
- D
A metastore is specific to a single workspace, while a catalog can span across multiple workspaces.
Show answer and explanation
Correct answer: B
Explanation
In Databricks, a metastore is the centralized metadata storage layer that governs the management of catalogs, schemas, and tables. A catalog, on the other hand, functions as the top-level container and is used to organize schemas and tables within the metastore. Understanding this distinction is crucial for properly configuring and utilizing the Databricks Lakehouse platform.
- A. Incorrect.
Incorrect: A metastore is not the top-level container; it serves as the metadata layer for managing catalogs, schemas, and tables.
- B. Correct.
Correct: A catalog is the top-level container that organizes schemas and tables, and the metastore acts as the metadata storage for managing these catalogs.
- C. Incorrect.
Incorrect: While access control can be defined at different levels, this does not clearly differentiate a metastore from a catalog.
- D. Incorrect.
Incorrect: A metastore can actually span multiple workspaces depending on the configuration, while a catalog operates within the metastore.