Home / DE Associate practice test / Governance and Security / Question

Databricks Data Engineer Associate · free practice question

A data engineer wants to reference a table in a query using its fully qualified name in Unity Catalog. The table is named orders, it lives in a schema named…

Exam-style question on Governance and Security from the free DE Associate practice test, with the answer and a full explanation below.

Updated November 10, 2026

Governance and Security

A data engineer wants to reference a table in a query using its fully qualified name in Unity Catalog. The table is named orders, it lives in a schema named sales, and that schema belongs to a catalog named prod. Which fully qualified reference is the correct one for the engineer to use?

  1. AThe engineer should reference sales.orders as a two-level name, because Unity Catalog resolves the catalog automatically from the metastore and only the schema and the table are ever written out in a qualified reference.
  2. BThe engineer should reference prod.sales.orders, because Unity Catalog uses a three-level namespace of catalog.schema.table, so the catalog name comes first, followed by the schema name, and then the table name last.
  3. CThe engineer should reference orders.sales.prod, because the Unity Catalog namespace is ordered from the most specific object outward, listing the table first, then its schema, and finally the enclosing parent catalog.
  4. DThe engineer should reference metastore.prod.sales.orders, because a fully qualified Unity Catalog name is a four-level path that begins with the metastore and then descends into the catalog, then the schema, then table.
  5. EThe engineer should reference prod.orders, because the schema layer is optional whenever a table name is unique and the catalog plus the table name alone form a valid fully qualified reference in Unity Catalog.
Answer & explanation

Correct answer: B

WHY B: Unity Catalog uses a three-level namespace catalog.schema.table, so the correct fully qualified name is prod.sales.orders. WHY NOT A: A two-level name relies on a default catalog and is not the fully qualified reference; the catalog must be named explicitly here. WHY NOT C: The order is catalog first then schema then table, not reversed from table outward. WHY NOT D: The metastore is not part of a table's qualified name; the namespace has three levels, not four. WHY NOT E: The schema is a required level; prod.orders omits the schema and is not a valid fully qualified name.

Take the full DE Associate practice test free →

Would you pass today?

This question is one of 45 in the free, timed Databricks Data Engineer Associate practice test. Take it and get a section-by-section score.

Start the free test →