The correct answer is A. DESCRIBE LOCATION customer360; is the command that will return the location of the database customer360.
Explanation:
- Option A (DESCRIBE LOCATION customer360;) - This is the correct command to retrieve the location information of a database in Databricks. The DESCRIBE command with the LOCATION keyword shows where the database is stored in the underlying storage system.
- Option B (DROP DATABASE customer360;) - This command would delete the entire database, not return its location information. This is a destructive operation that removes the database and its contents.
In Databricks SQL, you can use DESCRIBE DATABASE EXTENDED customer360; or DESCRIBE LOCATION customer360; to get detailed information about a database including its location path.