Hortonworks-Certified-Apache-Hadoop-2.0-Developer(Pig and Hive Developer) Sample Questions:
1. You want to understand more about how users browse your public website, such as which pages they
visit prior to placing an order. You have a farm of 200 web servers hosting your website. How will you
gather this data for your analysis?
A) Channel these clickstreams inot Hadoop using Hadoop Streaming.
B) Sample the weblogs from the web servers, copying them into Hadoop using curl.
C) Import all users' clicks from your OLTP databases into Hadoop, using Sqoop.
D) Ingest the server web logs into HDFS using Flume.
E) Write a MapReduce job, with the web servers for mappers, and the Hadoop cluster nodes for reduces.
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?
A) B = JOIN A BY (gender = = 'M' AND zip = = '95102');
B) B= FOREACH A BY (gender = = 'M' AND zip = = '95102');
C) B = FILTER A BY (zip = = '95102' AND gender = = M");
D) B= GROUP A BY (zip = = '95102' AND gender = = 'M');
3. A NameNode in Hadoop 2.0 manages ______________.
A) A single namespace
B) No namespaces
C) An arbitrary number of namespaces
D) Two namespaces: an active namespace and a backup namespace
4. 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?
A) STORE B INTO 'myoutput';
B) DUMP B INTO 'myoutput';
C) DUMP B using PigStorage('myoutput');
D) STORE A INTO 'myoutput' USING PigStorage(',');
5. In a large MapReduce job with m mappers and n reducers, how many distinct copy operations will there
be in the sort/shuffle phase?
A) mXn (i.e., m multiplied by n)
B) m+n (i.e., m plus n)
C) mn (i.e., m to the power of n)
D) m
E) n
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: C | Question # 3 Answer: A | Question # 4 Answer: A | Question # 5 Answer: A |

We're so confident of our products that we provide no hassle product exchange.


By Cyril


