Databricks Certified Data Engineer Associate — Question 64

A data engineer has created a new database using the following command:

CREATE DATABASE IF NOT EXISTS customer360;

In which location will the customer360 database be located?

Answer options

• A. dbfs:/user/hive/database/customer360
• B. dbfs:/user/hive/warehouse
• C. dbfs:/user/hive/customer360
• D. dbfs:/user/hive/database

Correct answer: B

Explanation

The correct answer is B because when a database is created in Hive, it is typically located in the warehouse directory by default. The other options refer to specific paths that do not represent the default location for new databases in Hive.