Databricks Certified Data Engineer - Associate
Get started today
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?
Real Exam
Community
KKeng
A
dbfs:/user/hive/database/customer360
B
dbfs:/user/hive/warehouse
C
dbfs:/user/hive/customer360
D
dbfs:/user/hive/database
Explanation:
Explanation
In Databricks, when you create a database using the CREATE DATABASE command without specifying a location, the database is created in the default Hive warehouse location. The default location is dbfs:/user/hive/warehouse/.
Let's break down the options:
A. dbfs:/user/hive/database/customer360 - Incorrect. This is not the standard location for databases in Databricks.
B. dbfs:/user/hive/warehouse - CORRECT. This is the default Hive warehouse location where databases are created when no explicit location is specified. The actual database directory would be dbfs:/user/hive/warehouse/customer360.db.
C. dbfs:/user/hive/customer360 - Incorrect. Databases are not created directly under /user/hive/.
D. dbfs:/user/hive/database - Incorrect. This is not the standard location for databases in Databricks.
Key Points:
- The default Hive warehouse location in Databricks is
dbfs:/user/hive/warehouse/. - When you create a database without specifying a location, it creates a directory with
.dbextension under this warehouse location. - The actual path would be
dbfs:/user/hive/warehouse/customer360.db/. - You can specify a custom location using the
LOCATIONclause:CREATE DATABASE customer360 LOCATION 'dbfs:/mnt/data/customer360'.
Comments
Loading comments...