Databricks Certified Data Engineer Associate — Question 8

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

Answer options

• A. DESCRIBE LOCATION customer360;
• B. DROP DATABASE customer360;
• C. DESCRIBE DATABASE customer360;
• D. ALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
• E. USE DATABASE customer360;

Correct answer: C

Explanation

The command 'DESCRIBE DATABASE customer360;' is the correct choice because it provides detailed information about the specified database, including its location. The other options either modify, drop, or change the properties of the database but do not return its location information.