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?
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.