QuestionQ58
Secure and govern Unity Catalog objectsYou have an Azure Databricks workspace 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]/dataas its managed location.
Which SQL statement should you execute?
- A CREATE SCHEMA catalog1.schema2 -LOCATION ‘abfss://[email protected]/data’;
- B CREATE SCHEMA catalog1.schema2 -MANAGED LOCATION ‘abfss://[email protected]/data’;
- C CREATE CATALOG schema2 -MANAGED LOCATION ‘abfss://[email protected]/data’;
- D CREATE SCHEMA catalog1.schema2 -WITH DBPROPERTIES (LOCATION-’abfss://[email protected]/data’);
Community Discussion