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.
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
No comments yet.