Adaface Sample Hive Questions

Consider the following two Hive tables in a space adventure context:

Assume that the astronauts table is small and can fit in memory. Which of the following queries will take full advantage of a map-side join?

You have a partitioned Hive table sales_data with the following schema:

You want to archive the oldest partition (date='2023-01-01', region='North America') and store it in the Hadoop Distributed File System (HDFS) at /archive/sales_data. Which of the following steps is the correct approach to perform the archiving operation?

A: Enable archiving on the table, and then issue an ALTER TABLE statement to move the partition to the archive directory.
            
            B: Issue an ALTER TABLE statement to move the partition to the archive directory, and then lock the partition to prevent further modifications.
            
            C: Enable archiving on the table, and then use the EXPORT command to export the partition to the archive directory.
            
            D: Use the EXPORT command to export the partition to the archive directory, and then lock the partition to prevent further modifications.
            
            E: Use the EXPORT command to export the partition to the archive directory, and then drop the partition from the sales_data table.

Assuming the following Hive statements execute successfully, choose the correct statements that describe the result:

A. Hive reformats JobsFile2 into a structure that Hive can access and moves into to /user/steve/fenty/
            B. The file named JobsFile2 is moved to to/user/steve/fenty/
            C. The contents of JobsFile2 are parsed as comma-delimited rows and loaded into /user/steve/fenty/
            D. The contents of JobsFile2 are parsed as comma-delimited rows and stored in a database