LFC Unity Catalog & Data Governance 2 — Questions and Answers
Question 1: In Unity Catalog, which object is the top-level container that maps to a single Databricks account?
- Catalog
- Metastore (Correct answer)
- Schema
- Namespace
Correct answer: Metastore
The metastore is the top-level Unity Catalog object and there is one metastore per region per Databricks account.
Question 2: A data engineer wants to grant a group of analysts read access to a specific table in Unity Catalog without giving them access to other tables in the same schema. Which privilege should be granted?
- USE SCHEMA
- SELECT (Correct answer)
- READ FILES
- BROWSE
Correct answer: SELECT
The SELECT privilege on a specific table allows users to read data from that table without granting access to other tables.
Question 3: Which Unity Catalog feature allows you to track which downstream tables and dashboards were created from a specific upstream table?
- Data lineage (Correct answer)
- Delta sharing
- Table ACLs
- Column masking
Correct answer: Data lineage
Data lineage in Unity Catalog automatically tracks data flow from source to downstream consumers across tables and dashboards.
Question 4: When using Unity Catalog, what is the correct three-level namespace format to fully qualify a table?
- schema.catalog.table
- catalog.schema.table (Correct answer)
- metastore.catalog.table
- catalog.table.column
Correct answer: catalog.schema.table
Unity Catalog uses a three-level namespace in the format catalog.schema.table to uniquely identify tables.
Question 5: A company needs external partners to access specific Delta tables without giving them Databricks workspace access. Which Unity Catalog feature best supports this?
- Row-level security
- Delta Sharing (Correct answer)
- Column masking
- Table ACLs
Correct answer: Delta Sharing
Delta Sharing is an open protocol in Unity Catalog that allows secure sharing of data with external parties without requiring Databricks access.
Question 6: In Unity Catalog, which privilege must be granted on both the catalog AND the schema before a user can access a table within that schema?
- USAGE (Correct answer)
- SELECT
- READ
- BROWSE
Correct answer: USAGE
The USAGE privilege must be granted at both the catalog and schema levels to allow navigation to objects within them.
Question 7: Which Unity Catalog object type is used to store and govern non-tabular files such as images or raw logs in cloud storage?
- External table
- Volume (Correct answer)
- Managed table
- Storage credential
Correct answer: Volume
Volumes in Unity Catalog provide governed access to non-tabular files stored in cloud object storage.
LFC Unity Catalog & Data Governance 2
In Unity Catalog, which object is the top-level container that maps to a single Databricks account?