
Answer-first summary for fast verification
Answer: dbfs:/user/hive/warehouse
## Explanation In Databricks, when you create a database using the `CREATE DATABASE` command without specifying a location, the database is created in the default Hive warehouse location. The default location for Hive databases in Databricks is: **dbfs:/user/hive/warehouse/** When you create a database without specifying a custom location, Databricks creates a subdirectory for that database within the warehouse directory. For the `customer360` database, the actual directory would be: **dbfs:/user/hive/warehouse/customer360.db** Let's analyze why the other options are incorrect: - **Option A (dbfs:/user/hive/database/customer360)**: This is not the standard Databricks Hive warehouse structure. - **Option C (dbfs:/user/hive/customer360)**: This path doesn't follow the standard warehouse directory structure. - **Option D (More information is needed)**: This is incorrect because we have enough information - databases created without a specified location go to the default warehouse. - **Option E (dbfs:/user/hive/database)**: This is not the standard warehouse location. **Key Points:** 1. The default Hive warehouse location in Databricks is `dbfs:/user/hive/warehouse` 2. Databases are created as subdirectories with `.db` extension within this location 3. You can specify a custom location using: `CREATE DATABASE customer360 LOCATION 'dbfs:/custom/path'` 4. Without a custom location, it defaults to the warehouse directory
Author: Keng Suppaseth
Ultimate access to all questions.
A data engineer has created a new database using the following command: CREATE DATABASE IF NOT EXISTS customer360;
In which of the following locations will the customer360 database be located?
A
dbfs:/user/hive/database/customer360
B
dbfs:/user/hive/warehouse
C
dbfs:/user/hive/customer360
D
More information is needed to determine the correct response
E
dbfs:/user/hive/database
No comments yet.