Question

A data engineer has a database named db_hr, and they want to know where this database was created in the underlying storage.

a) DESCRIBE db_hr
b) DESCRIBE EXTENDED db_hr
c) DESCRIBE DATABASE db_hr
d) SELECT location FROM db_hr.db
e) There is no need for a command since all databases are created under the default hive metastore directory

Answer 1

The correct command to find out where a database named db_hr was created in the underlying storage is 'DESCRIBE DATABASE db_hr'. This command reveals the database's location and other metadata, while 'DESCRIBE' is used for table details.

Step-by-step explanation:

To find out where the database db_hr was created in the underlying storage by a data engineer, the correct command among the choices provided would be c) DESCRIBE DATABASE db_hr. This command provides metadata about the specified database, including its location on the file system.Other commands such as DESCRIBE are used for describing details of a table, and would not provide information about the database storage location. Also, the assumption that all databases are created under the default hive metastore directory is not always true, as it can be specified otherwise at the time of database creation. Hence, the use of the DESCRIBE DATABASE command is the correct approach to retrieve such information.