Preparing Practice Exam…
Please wait a moment while the system generates the exam questions, answers, and study session.
Please wait a moment while the system generates the exam questions, answers, and study session.
Question 40 of 66
Free Preview · 66 of 220 · questions 1–66 of 220 are free. Sign up free to sync your progress across devices.
Select one answer.
Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.
- Correct answer : D — `finance_catalog.sales_schema.orders_delta`, because Unity Catalog resolves objects through a three-level catalog, schema, and table hierarchy rather than a single database name. A . Omitting the catalog only works when a default catalog has already been set for the session, so it is not the reliable, fully qualified reference the scenario calls for when joining across business units. B . Every table in Unity Catalog belongs to a schema, so there is no mode where the schema and table collapse into a single flattened identifier under the catalog. C . Unity Catalog identifiers use dot separators between catalog, schema, and table, not an at-sign, so this syntax does not match how object names are resolved. D . Unity Catalog always resolves objects through the three-level `catalog.schema.table` hierarchy, so naming all three levels explicitly is the fully qualified reference the join requires.