Exam Certified Data Engineer Associate All QuestionsBrowse all questions from this 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?

    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
MDWPartners

Repeated, correct.