
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, it defaults to the Hive metastore warehouse directory. The default location is `dbfs:/user/hive/warehouse/`. Within this directory, each database gets its own subdirectory. Key points: 1. **Default Location**: `dbfs:/user/hive/warehouse/` is the default Hive warehouse directory in Databricks. 2. **Database Subdirectory**: When you create the `customer360` database, it will create a subdirectory `customer360.db` within the warehouse directory. 3. **Complete Path**: The actual database location would be `dbfs:/user/hive/warehouse/customer360.db/`. 4. **Option Analysis**: - **Option A**: Incorrect - There is no standard `/user/hive/database/` path in Databricks. - **Option B**: Correct - This is the default warehouse directory where databases are stored. - **Option C**: Incorrect - Databases are not stored directly under `/user/hive/`. - **Option D**: Incorrect - The default location is known and doesn't require additional information. **Note**: If you want to specify a custom location, you would use the `LOCATION` clause in the `CREATE DATABASE` command, but since no location was specified in this command, it uses the default 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
No comments yet.