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

Which of the following commands will return the location of database customer360?
A . DESCRIBE LOCATION customer360;
B . DROP DATABASE customer360;
C . DESCRIBE DATABASE customer360;
D . ALTER DATABASE customer360 SET DBPROPERTIES (‘location’ = ‘/user’};
E . USE DATABASE customer360;

View Answer

Answer: C

Explanation:

The command DESCRIBE DATABASE customer360; will return the location of the database customer360, along with its comment and properties. This command is an alias for DESCRIBE SCHEMA customer360;, which can also be used to get the same information. The other commands will either drop the database, alter its properties, or use it as the current database, but will not return its location12.

Reference: DESCRIBE DATABASE | Databricks on AWS

DESCRIBE DATABASE – Azure Databricks – Databricks SQL