A Hive table `sales` is partitioned by `year` and `month`. The team wants to add a new partition for December 2023 and load data from an HDFS directory `/data/sales/2023/12`. Which HiveQL statement should they use?

CREATE TABLE sales_2023_12 AS SELECT * FROM sales WHERE year=2023 AND month=12;

LOAD DATA INPATH '/data/sales/2023/12' INTO TABLE sales PARTITION (year=2023, month=12);

ALTER TABLE sales ADD PARTITION (year=2023, month=12);

INSERT INTO TABLE sales PARTITION (year=2023, month=12) SELECT * FROM /data/sales/2023/12;

What happens to the underlying data when a managed table in Hive is dropped?

The data is only removed from the metastore.

The data is moved to a trash directory.

Dell Data Science Optimize

Domain 2Objective 2

Hive DATA-SCIENCE-OPTIMIZE Practice Questions (Page 4)

Part of the Hadoop Ecosystem and NoSQL domain, which accounts for 15% of the DATA-SCIENCE-OPTIMIZE exam.

31questions here

7free pages

8concepts

15%of the exam

Questions 16–20

16application · medium
A team creates a Hive table to store intermediate results of a data transformation pipeline. These results are temporary and will be deleted after the pipeline completes. The team wants to ensure that when they drop the table, the underlying data files are also removed from HDFS. Which table type should they use?
Select an answer first
17application · medium
A Hive table `sales` is partitioned by `year` and `month`. The team wants to add a new partition for December 2023 and load data from an HDFS directory `/data/sales/2023/12`. Which HiveQL statement should they use?
Select an answer first
18foundation · easy
What happens to the underlying data when a managed table in Hive is dropped?
Select an answer first
19foundation · easy
Which Hadoop component is responsible for resource management and scheduling when Hive queries run on a cluster?
Select an answer first
20foundation · easy
Which Hive data type is best suited for storing a key-value pair where both keys and values are strings?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to DATA-SCIENCE-OPTIMIZE

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Dell Technologies. “DATA-SCIENCE-OPTIMIZE” is a trademark of its owner, used for identification only.

Hive DATA-SCIENCE-OPTIMIZE Practice Questions (Page 4)

Questions 16–20

A Hive table `sales` is partitioned by `year` and `month`. The team wants to add a new partition for December 2023 and load data from an HDFS directory `/data/sales/2023/12`. Which HiveQL statement should they use?

What happens to the underlying data when a managed table in Hive is dropped?

Which Hadoop component is responsible for resource management and scheduling when Hive queries run on a cluster?

Which Hive data type is best suited for storing a key-value pair where both keys and values are strings?

Keep studying — Hadoop Ecosystem and NoSQL