Certified Data Engineer Associate Exam QuestionsBrowse all questions from this exam

Certified Data Engineer Associate Exam - Question 102


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?

Show Answer
Correct Answer: B

When a new database is created in Hive without specifying a location, it defaults to the Hive warehouse directory. In the context of Databricks File System (DBFS), this default location is typically 'dbfs:/user/hive/warehouse'. Therefore, the customer360 database will be located in this default directory.

Discussion

1 comment
Sign in to comment
MDWPartners
May 25, 2024

Repeated, correct.