Hortonworks HDPCD - Hortonworks Data Platform Certified Developer Exam
Page: 3 / 22
Total 108 questions
Question #11 (Topic: )
Review the following data and Pig code.
M,38,95111
F,29,95060
F,45,95192
M,62,95102
F,56,95102
A = LOAD 'data' USING PigStorage('.') as (gender:Chararray,
age:int, zlp:chararray);
B = FOREACH A GENERATE age;
Which one of the following commands would save the results of B to a folder in hdfs named
myoutput?
M,38,95111
F,29,95060
F,45,95192
M,62,95102
F,56,95102
A = LOAD 'data' USING PigStorage('.') as (gender:Chararray,
age:int, zlp:chararray);
B = FOREACH A GENERATE age;
Which one of the following commands would save the results of B to a folder in hdfs named
myoutput?
A. STORE A INTO 'myoutput' USING PigStorage(',');
B. DUMP B using PigStorage('myoutput');
C. STORE B INTO 'myoutput';
D. DUMP B INTO 'myoutput';
Answer: C
Question #12 (Topic: )
Identify the tool best suited to import a portion of a relational database every day as files
into HDFS, and generate Java classes to interact with that imported data?
into HDFS, and generate Java classes to interact with that imported data?
A. Oozie
B. Flume
C. Pig
D. Hue
E. Hive
F. Sqoop
G. fuse-dfs
Answer: F
Question #13 (Topic: )
How are keys and values presented and passed to the reducers during a standard sort and
shuffle phase of MapReduce?
shuffle phase of MapReduce?
A. Keys are presented to reducer in sorted order; values for a given key are not sorted.
B. Keys are presented to reducer in sorted order; values for a given key are sorted in ascending order.
C. Keys are presented to a reducer in random order; values for a given key are not sorted.
D. Keys are presented to a reducer in random order; values for a given key are sorted in ascending order.
Answer: A
Question #14 (Topic: )
Consider the following two relations, A and B.
[Hortonworks-HDPCD-5.0/Hortonworks-HDPCD-12_2.png]
A Pig JOIN statement that combined relations A by its first field and B by its second field
would produce what output?
[Hortonworks-HDPCD-5.0/Hortonworks-HDPCD-12_2.png]
A Pig JOIN statement that combined relations A by its first field and B by its second field
would produce what output?
A. 2 Jim Chris 2 3 Terry 3 4 Brian 4
B. 2 cherry 2 cherry 3 orange 4 peach
C. 2 cherry Jim, Chris 3 orange Terry 4 peach Brian
D. 2 cherry Jim 2 2 cherry Chris 2 3 orange Terry 3 4 peach Brian 4
Answer: D
Question #15 (Topic: )
Which two of the following are true about this trivial Pig program' (choose Two)
[Hortonworks-HDPCD-5.0/Hortonworks-HDPCD-12_3.png]
[Hortonworks-HDPCD-5.0/Hortonworks-HDPCD-12_3.png]
A. The contents of myfile appear on stdout
B. Pig assumes the contents of myfile are comma delimited
C. ABC has a schema associated with it
D. myfile is read from the user's home directory in HDFS
Answer: A,D
