Databricks Certified Data Engineer - Associate

Ultimate access to all questions.

Which of the following commands will return the location of database customer360?

Real Exam

Community

KKeng

Last updated: January 13, 2026 at 09:03

DESCRIBE LOCATION customer360;

DROP DATABASE customer360;

DESCRIBE DATABASE customer360;

ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user');

USE DATABASE customer360;

Explanation:

The correct answer is C. DESCRIBE DATABASE customer360; because:

DESCRIBE DATABASE command in Spark SQL/Databricks shows detailed information about a database including its location, comment, and properties.
When you run DESCRIBE DATABASE customer360;, it displays the database metadata including the Location field which shows the HDFS or cloud storage path where the database is stored.
The other options are incorrect:
- A. DESCRIBE LOCATION customer360; - There is no such command as DESCRIBE LOCATION in Spark SQL
- B. DROP DATABASE customer360; - This would delete the database, not show its location
- D. ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'); - This sets a property but doesn't return the current location
- E. USE DATABASE customer360; - This switches to the database but doesn't display its location

Example output of DESCRIBE DATABASE:

Database Name: customer360
Description: 
Location: dbfs:/user/hive/warehouse/customer360.db
Properties:

Database Name: customer360
Description: 
Location: dbfs:/user/hive/warehouse/customer360.db
Properties:

Powered ByGPT-5.2

Comments

Loading comments...