DATABRICKS-CERTIFIED-DATA-ENGINEER-ASSOCIATE · Question #84
Which of the following commands will return the location of database customer360?
The correct answer is C. DESCRIBE DATABASE customer360. DESCRIBE DATABASE <name> returns metadata about a database, including its location (storage path), owner, and properties. DROP (B) deletes the database. USE (E) sets it as the active database but returns no metadata. ALTER DATABASE SET DBPROPERTIES (D) modifies properties…
Question
Options
- ADESCRIBE LOCATION customer360;
- BDROP DATABASE customer360;
- CDESCRIBE DATABASE customer360;
- DALTER DATABASE customer360 SET DBPROPERTIES ('location' = '/user'};
- EUSE DATABASE customer360;
How the community answered
(34 responses)- A6% (2)
- C91% (31)
- D3% (1)
Explanation
DESCRIBE DATABASE <name> returns metadata about a database, including its location (storage path), owner, and properties. DROP (B) deletes the database. USE (E) sets it as the active database but returns no metadata. ALTER DATABASE SET DBPROPERTIES (D) modifies properties rather than displaying them. 'DESCRIBE LOCATION' (A) is not a valid Spark SQL command.
Topics
Community Discussion
No community discussion yet for this question.