
Ultimate access to all questions.
A data engineer has created a new database using the following command:
CREATE DATABASE IF NOT EXISTS customer360;
CREATE DATABASE IF NOT EXISTS customer360;
In which location will the customer360 database be located?
A
dbfs:/user/hive/database/customer360
B
dbfs:/user/hive/warehouse
C
dbfs:/user/hive/customer360
D
dbfs:/user/hive/database
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:
Key Points:
dbfs:/user/hive/warehouse/.db extension under this warehouseLOCATION clause: CREATE DATABASE customer360 LOCATION 'dbfs:/custom/path'