Databricks Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Deep dive into the quiz with AI chat providers.
We prepare a focused prompt with your quiz and certificate details so each AI can offer a more tailored, in-depth explanation.
Which of the following commands will return the location of database customer360?
Real Exam
Community
KKeng
0
A
DESCRIBE LOCATION customer360;
B
DROP DATABASE customer360;
Explanation:
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.
Comments
Loading comments...