Question 11

You are onboarding a new data engineer to a Unity Catalog-enabled Azure Databricks workspace. They ask you to explain how the objects in the following script relate to one another and which one governs non-tabular data such as PDF and image files. ```sql CREATE CATALOG IF NOT EXISTS prod; CREATE SCHEMA IF NOT EXISTS prod.crm; CREATE TABLE prod.crm.customers (id BIGINT, name STRING); CREATE VOLUME prod.crm.raw_documents; ``` Which statement correctly describes the Unity Catalog object model represented by this script?

• A`prod` is the metastore, `crm` is a catalog, and both `customers` and `raw_documents` are tables in the three-level namespace `metastore.catalog.table`.
• B`prod` is a catalog and `crm` is a schema; `customers` is a table that governs tabular data, while `raw_documents` is a volume that governs non-tabular data — both are siblings under the schema in the namespace `catalog.schema.object`.
• CA volume cannot be created inside a schema, so `raw_documents` must be defined directly under the catalog `prod`, outside the three-level namespace.
• D`customers` and `raw_documents` are both volumes, because any object created under a schema in Unity Catalog is a volume; tables exist only in the legacy Hive metastore.
• E`crm` is a catalog nested inside the `prod` catalog, creating a four-level namespace `metastore.prod.crm.customers`.