Answer-first summary for fast verification
Answer: `dbfs:/user/hive/warehouse/db_hr.db`
When a database is created without specifying a location, it defaults to the warehouse directory under `dbfs:/user/hive/warehouse`. The database folder is named with a `.db` extension. Similarly, a table created without a specified location becomes a managed table under the database directory, hence the employees table will be located in the `db_hr.db` folder. Reference: [Databricks SQL Language Manual](https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-create-schema.html).
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
After executing the following commands in sequence: CREATE DATABASE db_hr;, USE db_hr;, CREATE TABLE employees;, where will the employees table be stored?
A
dbfs:/user/hive/warehouse
B
dbfs:/user/hive/warehouse/db_hr
C
dbfs:/user/hive/warehouse/db_hr.db
D
dbfs:/user/hive/databases/db_hr.db
E
More information is needed to determine the correct answer