Home
Hortonworks
Hadoop-PR000007: Hortonworks-Certified-Apache-Hadoop-2.0-Developer(Pig and Hive Developer)

Hortonworks Hadoop-PR000007 Exam

Certification Provider: Hortonworks

Exam Name: Hortonworks-Certified-Apache-Hadoop-2.0-Developer(Pig and Hive Developer)

Duration: 120 Minutes

Number of questions in our database: 104

Exam Version: Nov. 29, 2023

Hadoop-PR000007 Exam Official Topics:

Topic 1: Configure a local HDP repository
Topic 2: Define and deploy a rack topology script
Topic 3: Restart an HDP service
Topic 4:

Free Hortonworks Hadoop-PR000007 Exam Actual Questions

The questions for Hadoop-PR000007 were last updated On Nov. 29, 2023

Question #1

Examine the following Hive statements:

Assuming the statements above execute successfully, which one of the following statements is true?

AHive reformats File1 into a structure that Hive can access and moves into to/user/joe/x/

BThe file named File1 is moved to to/user/joe/x/

CThe contents of File1 are parsed as comma-delimited rows and loaded into /user/joe/x/

DThe contents of File1 are parsed as comma-delimited rows and stored in a database

Reveal Solution

Correct Answer: B

Question #2

Which one of the following files is required in every Oozie Workflow application?

Ajob.properties

BConfig-default.xml

CWorkflow.xml

DOozie.xml

Reveal Solution

Correct Answer: C

Question #3

Given the following Hive command:

INSERT OVERWRITE TABLE mytable SELECT * FROM myothertable;

Which one of the following statements is true?

AThe contents of myothertable are appended to mytable

BAny existing data in mytable will be overwritten

CA new table named mytable is created, and the contents of myothertable are copied into mytable

DThe statement is not a valid Hive command

Reveal Solution

Correct Answer: B

Question #4

Which one of the following files is required in every Oozie Workflow application?

Ajob.properties

BConfig-default.xml

CWorkflow.xml

DOozie.xml

Reveal Solution

Correct Answer: C

Question #5

Assuming the following Hive query executes successfully:

Which one of the following statements describes the result set?

AA bigram of the top 80 sentences that contain the substring 'you are' in the lines column of the input data A1 table.

BAn 80-value ngram of sentences that contain the words 'you' or 'are' in the lines column of the inputdata table.

CA trigram of the top 80 sentences that contain 'you are' followed by a null space in the lines column of the inputdata table.

DA frequency distribution of the top 80 words that follow the subsequence 'you are' in the lines column of the inputdata table.

Reveal Solution

Correct Answer: D

Unlock all Hadoop-PR000007 Exam Questions with Advanced Practice Test Features:

Select Question Types you want
Set your Desired Pass Percentage
Allocate Time (Hours : Minutes)
Create Multiple Practice tests with Limited Questions
Customer Support

Get Full Access Now

Disscuss Hortonworks Hadoop-PR000007 Topics, Questions or Ask Anything Related

Submit Cancel