Answer-first summary for fast verification
Answer: The location defined when creating its parent catalog
Under Unity Catalog, schemas live inside catalogs, and the catalog’s cloud storage location (set when the catalog is created) determines where data is stored. The old Hive metastore setting spark.sql.warehouse.dir no longer applies. This allows for centralized access control and cross-workspace data management. Reference: https://docs.databricks.com/aws/en/connect/unity-catalog/cloud-storage/managed-storage
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In Databricks with Unity Catalog enabled, what determines the physical storage location for a new schema created with:
CREATE SCHEMA sample_schema;
CREATE SCHEMA sample_schema;
A
Always dbfs:/user/hive/warehouse
B
The workspace default DBFS root folder
C
Hive metastore's spark.sql.warehouse.dir setting
D
The location defined when creating its parent catalog
E
A random location assigned by Databricks