Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Hortonworks Exam Hadoop-PR000007 Topic 2 Question 74 Discussion

Actual exam question for Hortonworks's Hadoop-PR000007 exam

Question #: 74
Topic #: 2

[All Hadoop-PR000007 Questions]

Which one of the following statements is true about a Hive-managed table?

ARecords can only be added to the table using the Hive INSERT command.

BWhen the table is dropped, the underlying folder in HDFS is deleted.

CHive dynamically defines the schema of the table based on the FROM clause of a SELECT query.

DHive dynamically defines the schema of the table based on the format of the underlying data.

Show Suggested Answer

Suggested Answer: B

by Altha at Jul 06, 2024, 09:54 AM

Limited Time Offer

25%

Off

Get Premium Hadoop-PR000007 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Lina

24 days ago

I'm pretty sure the correct answer is Option D. Hive is all about handling unstructured data, so it makes sense that it would define the schema based on the underlying files.

upvoted 0 times

...

Fanny

26 days ago

You might be right, I didn't consider that. Let's see what others think.

upvoted 0 times

...

Adela

26 days ago

Ooh, this is a tricky one! I'm going to go with Option D - it just makes more sense to me that Hive would look at the data format rather than the query.

upvoted 0 times

Lyla

12 days ago

User1: I think Option A is correct.

upvoted 0 times

...

...

Vernell

1 months ago

But doesn't the schema depend on the format of the data? I think D) is the right answer.

upvoted 0 times

...

Carri

1 months ago

Option C sounds like it could be true, but I'm not sure. Hive is supposed to be flexible, so it might define the schema dynamically.

upvoted 0 times

...

Dorian

1 months ago

I think Option D is the correct answer. Hive's schema is defined based on the format of the data, not the SELECT query.

upvoted 0 times

Darrin

6 days ago

I'm not sure, but I think option B is true. When the table is dropped, the underlying folder in HDFS is deleted.

upvoted 0 times

...

Darrin

7 days ago

I think it's actually option C. Hive defines the schema based on the FROM clause in a SELECT query.

upvoted 0 times

...

Darrin

8 days ago

I agree, option D is correct. Hive defines the schema based on the data format.

upvoted 0 times

...

Narcisa

9 days ago

C) Hive dynamically defines the schema of the table based on the FROM clause of a SELECT query.

upvoted 0 times

...

Reuben

17 days ago

B) When the table is dropped, the underlying folder in HDFS is deleted.

upvoted 0 times

...

Elmer

26 days ago

A) Records can only be added to the table using the Hive INSERT command.

upvoted 0 times

...

...

Katie

1 months ago

Option B is definitely true. Hive-managed tables are stored in HDFS, so dropping the table will delete the underlying folder.

upvoted 0 times

Coletta

17 days ago

B) When the table is dropped, the underlying folder in HDFS is deleted.

upvoted 0 times

...

Reena

18 days ago

A) Records can only be added to the table using the Hive INSERT command.

upvoted 0 times

...

...

Fanny

1 months ago

I disagree, I believe the correct answer is C) Hive dynamically defines the schema of the table based on the FROM clause of a SELECT query.

upvoted 0 times

...

Vernell

2 months ago

I think the answer is B) When the table is dropped, the underlying folder in HDFS is deleted.

upvoted 0 times

...