Databricks Certified Data Engineer - Associate

Explanation

In Databricks, when you create a database using the CREATE DATABASE command without specifying a custom location, the database is created in the default Hive metastore location. The default location for Hive databases in Databricks is:

dbfs:/user/hive/warehouse/

When you create a database named customer360, it will be stored as a directory under this default warehouse location:

dbfs:/user/hive/warehouse/customer360.db

Let's analyze why the other options are incorrect:

• Option A (dbfs:/user/hive/database/customer360): Incorrect - This is not the standard Hive metastore structure
• Option C (dbfs:/user/hive/customer360): Incorrect - Databases are stored under the warehouse directory, not directly under /user/hive/
• Option D (dbfs:/user/hive/database): Incorrect - This directory doesn't exist in the standard Hive metastore structure

Key Points:

1. The default Hive warehouse directory in Databricks is dbfs:/user/hive/warehouse/
2. Each database is created as a subdirectory with .db extension under this warehouse
3. You can specify a custom location using the LOCATION clause: CREATE DATABASE customer360 LOCATION 'dbfs:/custom/path'
4. Without a custom location, it defaults to the Hive warehouse directory