Databricks-DE-Assoc Databricks Intelligence Platform Practice Question
A data engineer is working in a Databricks workspace where Unity Catalog is enabled. They need to run a SQL query that reads from the table sales in the catalog prod and schema marketing. Which fully qualified name should they use?
⚠ Common exam trap
The trap here is assuming the namespace order is schema.catalog.table or table.schema.catalog, which is incorrect for Unity Catalog.
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
✓
prod.marketing.sales
Unity Catalog uses a three-level namespace: catalog.schema.table. For a table named sales in the marketing schema of the prod catalog, the fully qualified name is prod.marketing.sales. This naming convention allows objects to be referenced unambiguously across the workspace and is fundamental to Unity Catalog governance.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
prod.sales.marketing
Why it's wrong here
This places the table name in the middle and the schema last. The correct order is catalog.schema.table, so prod.sales.marketing would incorrectly interpret sales as a schema and marketing as a table. This would fail to resolve the intended table.
- ✗
marketing.prod.sales
Why it's wrong here
This reverses the catalog and schema. In Unity Catalog, the first part is the catalog, the second is the schema, and the third is the table. Using marketing.prod.sales would look for a catalog named marketing and a schema named prod, which likely do not exist, causing an error.
- ✓
prod.marketing.sales
Why this is correct
In Unity Catalog, the three-level namespace is catalog.schema.table. The catalog is prod, the schema is marketing, and the table is sales, so the fully qualified name is prod.marketing.sales. This is the correct format for referencing objects in Unity Catalog and is required when the table is not in the current catalog and schema.
- ✗
sales.marketing.prod
Why it's wrong here
This is the reverse order of the correct namespace. Unity Catalog expects catalog first, then schema, then table. Using sales.marketing.prod would attempt to find a catalog named sales, a schema named marketing, and a table named prod, which is not the intended object.
About these practice questions
This Databricks-DE-Assoc question is part of Courseiva's 276-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.