Câu 3: DP-750: Implementing Data Engineering Solutions Using Azure Databricks

You have an Azure Databricks workspace that is attached to a Unity Catalog metastore named metastore1, metastore1 contains a catalog named catalog1. You need to create a new schema named schema2 that meets the following requirements:Is contained in catalog1 -Uses abfss://[email protected]/data as the managed locationWhich SQL statement should you execute?

1. A. CREATE SCHEMA catalog1.schema2 -LOCATION ‘abfss://[email protected]/data’;
2. B. CREATE SCHEMA catalog1.schema2 -MANAGED LOCATION ‘abfss://[email protected]/data’; — đáp án hiện tại
3. C. CREATE CATALOG schema2 -MANAGED LOCATION ‘abfss://[email protected]/data’;
4. D. CREATE SCHEMA catalog1.schema2 -WITH DBPROPERTIES (LOCATION-’abfss://[email protected]/data’);