Answer-first summary for fast verification
Answer: dbfs:/accounting/data
The CREATE SCHEMA statement with a LOCATION clause specifies the exact storage path for the database. In this case, 'dbfs:/accounting/data' is explicitly defined as the storage location. Option D ('dbfs:/user/hive/warehouse/accounting.db') is incorrect because it represents the default Hive warehouse location, not the custom location specified in the statement. Options A and C are also incorrect as they append '.db' to the path, which doesn't match the specified location. The community discussion confirms this with 100% consensus on option B, noting that the other options are factually incorrect.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A database was created in Databricks SQL using the following statement:
CREATE SCHEMA accounting LOCATION 'dbfs:/accounting/data';
CREATE SCHEMA accounting LOCATION 'dbfs:/accounting/data';
Where will data for this database be stored?
A
dbfs:/accounting/data/accounting.db
B
dbfs:/accounting/data
C
dbfs:/accounting/data.db
D
dbfs:/user/hive/warehouse/accounting.db
No comments yet.