Databricks Certified Data Engineer - Associate

Explanation

To find the location of a database in Databricks/Spark SQL, you need to use the DESCRIBE DATABASE command. This command provides detailed information about the database, including its location, comment, and properties.

Let's analyze each option:

A. DESCRIBE LOCATION customer360; - This is not a valid SQL command in Spark SQL. There is no DESCRIBE LOCATION syntax.

B. DROP DATABASE customer360; - This command would delete the database, not return its location.

C. DESCRIBE DATABASE customer360; - CORRECT. This command displays detailed information about the database, including the location where it's stored.

D. ALTER DATABASE customer360 SET DBPROPERTIES ('location='/user'); - This command would change the database properties, not return the current location.

E. USE DATABASE customer360; - This command switches to the database for subsequent operations, but doesn't return any information about its location.

When you execute DESCRIBE DATABASE customer360;, you'll see output that includes:

• Database Name
• Description/Comment
• Location (the HDFS or cloud storage path)
• Properties

This is the standard way to retrieve database metadata including its storage location in Databricks and Spark SQL environments.