New Year Sale ! 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

5 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

5 months ago

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

upvoted 0 times

...

Adela

5 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

3 months ago

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

upvoted 0 times

...

Artie

4 months ago

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

upvoted 0 times

...

Apolonia

4 months ago

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

upvoted 0 times

...

Lyla

4 months ago

I think Option A is correct.

upvoted 0 times

...

...

Vernell

5 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

5 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

5 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

4 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

4 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

4 months ago

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

upvoted 0 times

...

Narcisa

4 months ago

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

upvoted 0 times

...

Reuben

4 months ago

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

upvoted 0 times

...

Elmer

5 months ago

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

upvoted 0 times

...

...

Katie

5 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

4 months ago

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

upvoted 0 times

...

Reena

4 months ago

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

upvoted 0 times

...

...

Fanny

5 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

6 months ago

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

upvoted 0 times

...