Explanation:
The correct command to find the location of a database in the underlying storage is DESCRIBE DATABASE EXTENDED db_hr. This command provides comprehensive details, including the storage location. Other options like DESCRIBE DATABASE db_hr offer basic information but may not include the storage location. Commands such as DESCRIBE db_hr and SELECT location FROM db_hr.db are syntactically incorrect for this purpose. Relying on the default hive metastore directory is unreliable as databases can be created in other locations.
Ultimate access to all questions.
No comments yet.
A data engineer is working with a database named db_hr and wishes to determine its creation location in the underlying storage. Which command should they use?
A
DESCRIBE db_hr
B
SELECT location FROM db_hr.db
C
DESCRIBE DATABASE EXTENDED db_hr
D
DESCRIBE DATABASE db_hr
E
There is no need for a command since all databases are created under the default hive metastore directory