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?

The correct answer is B. dbfs:/user/hive/warehouse. In Databricks, when a database is created with CREATE DATABASE without specifying a LOCATION clause, it is stored in the default Hive metastore warehouse directory, which is dbfs:/user/hive/warehouse. Specifically, the database files will reside under…

Submitted by yaw92· Apr 18, 2026Databricks Lakehouse Platform

Question

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?

Options

Adbfs:/user/hive/database/customer360
Bdbfs:/user/hive/warehouse
Cdbfs:/user/hive/customer360
DMore information is needed to determine the correct response
Edbfs:/user/hive/database

How the community answered

(33 responses)

B
94% (31)
C
3% (1)
D
3% (1)

Explanation

In Databricks, when a database is created with CREATE DATABASE without specifying a LOCATION clause, it is stored in the default Hive metastore warehouse directory, which is dbfs:/user/hive/warehouse. Specifically, the database files will reside under dbfs:/user/hive/warehouse/customer360.db. The other paths listed are not valid default Hive warehouse locations in Databricks.

Topics

#Database Storage#DBFS#Hive Metastore Defaults#CREATE DATABASE Command

Community Discussion

No community discussion yet for this question.

Full DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE Practice