APICS Certified Supply Chain Professional (CSCP) — Question 336

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

CREATE DATABASE IF NOT EXISTS customer360;

In which of the following locations 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. More information is needed to determine the correct response
• E. dbfs:/user/hive/database

Correct answer: B

Explanation

The correct answer is B because when a database is created in Hive, it is typically stored in the default warehouse location, which is dbfs:/user/hive/warehouse. The other options either suggest incorrect paths or require additional information that is not necessary for determining the default storage location.