Databricks-DE-Assoc Governance and Security Practice Question
A data engineer is migrating legacy tables to Unity Catalog. Which TWO of the following statements regarding the transition to three-level namespace (catalog.schema.table) are true?
⚠ Common exam trap
Candidates often assume permissions must be explicitly assigned at the table level, overlooking the inheritance model where catalog-level grants automatically cascade down to schemas and tables.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Three-level namespace applies to all Unity Catalog objects.
Unity Catalog introduces a hierarchical namespace that forces a clear separation between data assets. Understanding this structure is critical for governance, as permissions are inherited down from the catalog and schema levels. By adopting this structure, organizations can enforce consistent policies across environments, simplify cross-workspace data sharing, and ensure that all metadata is discoverable through a centralized catalog that replaces the legacy Hive Metastore structure.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Three-level namespace applies to all Unity Catalog objects.
Why this is correct
Unity Catalog enforces a strict hierarchy consisting of catalog, schema, and table or view. This structure provides a unified way to manage permissions and lineage across different workspaces. Every managed or external object must adhere to this naming convention to be correctly registered within the Unity Catalog metadata store.
- ✗
Hive Metastore objects are automatically migrated to Unity Catalog.
Why it's wrong here
The legacy Hive Metastore does not automatically move to Unity Catalog. Data engineers must explicitly use the 'SYMLINK' feature or run manual migration scripts to register tables in Unity Catalog. This manual process ensures that existing security configurations remain undisturbed until the administrator explicitly defines new access policies.
- ✓
Permissions at the catalog level cascade to all child schemas and tables.
Why this is correct
Unity Catalog uses an inheritance model where privileges granted at a higher level, such as the catalog, automatically apply to all schemas and tables contained within it. This design significantly reduces the administrative burden of managing individual permissions for thousands of database objects across an entire enterprise organization.
- ✗
External locations are not required for three-level namespace tables.
Why it's wrong here
External locations are essential for managing data stored in cloud object storage that isn't under Unity Catalog's managed storage root. Even with the three-level namespace, you must define an external location object to provide the necessary permissions for Databricks to read and write to the underlying cloud files.
- ✗
Three-level namespace is optional in Unity Catalog.
Why it's wrong here
The three-level namespace is a mandatory architectural requirement for any data asset managed by Unity Catalog. Unlike the legacy Hive Metastore, which only supported a two-level namespace, Unity Catalog requires the catalog name to ensure global uniqueness and proper access control grouping across multiple Databricks workspaces and environments.
About these practice questions
Courseiva writes every Databricks-DE-Assoc question from scratch — 276 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Databricks exam blueprint
This Databricks-DE-Assoc practice question is part of Courseiva's free Databricks certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the Databricks-DE-Assoc exam.