Question
You have an Azure Databricks workspace that is enabled for Unity Catalog and contains a catalog named finance. finance contains two schemas named default and procurement.
You need to create a table named assets in the procurement schema. assets must contain the following columns:
- asset_id
- asset_type
- asset_name
How should you complete the SQL statement? To answer, drag the appropriate values to the correct targets. Each value may be used once, more than once, or not at all.
```sql
USE [Value 1];
USE [Value 2];
CREATE [Value 3] (
asset_id INT,
asset_name STRING,
asset_type STRING
);
```
NOTE: Each correct selection is worth one point.
Explanation
USE CATALOG finance comes first because setting a catalog resets the current schema to default, and the schema must exist within the current catalog. USE SCHEMA procurement then makes unqualified names resolve to the procurement schema, so CREATE TABLE assets creates the table in the right place. CATALOG hive_metastore points at the legacy metastore, not the finance catalog. A bare finance after USE would be treated as a schema name, and CREATE needs the TABLE keyword, so a bare assets is invalid.
