Answer-first summary for fast verification
Answer: DESCRIBE DATABASE customer360;
The correct command to retrieve the location of a database in Databricks is 'DESCRIBE DATABASE customer360;'. This command provides information about the database, including its location, whereas the other options either perform different actions (such as dropping the database or altering its properties) or are syntactically incorrect for retrieving the database location.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
In the context of working with Databricks, you may need to retrieve specific information about existing databases for various reasons such as understanding their structure or configurations. One common requirement might be to find the location path of a database. Given this scenario, which of the following commands will return the location of the database named 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;
No comments yet.