Hortonworks Hadoop-PR000007 HDPCD Exam Practice Test Instant Access

Question 1

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

Answer : B

Question 2

Review the following data and Pig code:

What command to define B would produce the output (M,62,95l02) when invoking the DUMP operator on B?

AB = FILTER A BY (zip = = '95102' AND gender = = M');

BB= FOREACH A BY (gender = = 'M' AND zip = = '95102');

CB = JOIN A BY (gender = = 'M' AND zip = = '95102');

DB= GROUP A BY (zip = = '95102' AND gender = = 'M');

Answer : A

Question 3

Which one of the following Hive commands uses an HCatalog table named x?

ASELECT * FROM x;

BSELECT x.-FROM org.apache.hcatalog.hive.HCatLoader('x');

CSELECT * FROM org.apache.hcatalog.hive.HCatLoader('x');

DHive commands cannot reference an HCatalog table

Answer : A

Question 4

Which one of the following statements describes a Pig bag. tuple, and map, respectively?

AUnordered collection of maps, ordered collection of tuples, ordered set of key/value pairs

BUnordered collection of tuples, ordered set of fields, set of key value pairs

COrdered set of fields, ordered collection of tuples, ordered collection of maps

DOrdered collection of maps, ordered collection of bags, and unordered set of key/value pairs

Answer : B

Question 5

Which two of the following statements are true about Pig's approach toward data? Choose 2 answers

AAccepts only data that has a key/value pair structure

BAccepts data whether it has metadata or not

CAccepts only data that is defined by metadata tables stored in a database

DAccepts tab-delimited text data only

EAccepts any data: structured or unstructured

Answer : B, E

Question 6

A NameNode in Hadoop 2.0 manages ______________.

ATwo namespaces: an active namespace and a backup namespace

BA single namespace

CAn arbitrary number of namespaces

DNo namespaces

Answer : B

Question 7

Which one of the following statements is FALSE regarding the communication between DataNodes and a federation of NameNodes in Hadoop 2.0?

AEach DataNode receives commands from one designated master NameNode.

BDataNodes send periodic heartbeats to all the NameNodes.

CEach DataNode registers with all the NameNodes.

DDataNodes send periodic block reports to all the NameNodes.

Answer : A

Hortonworks-Certified-Apache-Hadoop-2.0-Developer(Pig and Hive Developer) Hadoop-PR000007 HDPCD Exam Practice Test