Independence Day Deal! Unlock 25% OFF Today – Limited-Time Offer - 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

11 months 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

11 months ago

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

upvoted 0 times

...

Adela

11 months 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

Dalene

10 months ago

Hmm, now that you mention it, Option D does make sense.

upvoted 0 times

...

Artie

10 months ago

I'm leaning towards Option D, it seems more logical to me.

upvoted 0 times

...

Apolonia

10 months ago

I disagree, I believe Option B is the right answer.

upvoted 0 times

...

Lyla

10 months ago

I think Option A is correct.

upvoted 0 times

...

...

Vernell

11 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

11 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

11 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

10 months 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

10 months 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

10 months ago

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

upvoted 0 times

...

Narcisa

10 months ago

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

upvoted 0 times

...

Reuben

11 months ago

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

upvoted 0 times

...

Elmer

11 months ago

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

upvoted 0 times

...

...

Katie

11 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

11 months ago

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

upvoted 0 times

...

Reena

11 months ago

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

upvoted 0 times

...

...

Fanny

11 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

12 months ago

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

upvoted 0 times

...