Pig DATA-SCIENCE-OPTIMIZE Practice Questions (Page 1)

Questions 1–5

1. 1application · hard

   A Pig script loads a file with the schema: id:int, items:bag{t:(item:chararray, qty:int)}. The analyst needs to calculate the total quantity for each item. Which Pig Latin script correctly does this?

   • Agrouped = GROUP data BY items.item; result = FOREACH grouped GENERATE group, SUM(data.items.qty);
   • Bflattened = FOREACH data GENERATE id, FLATTEN(items); grouped = GROUP flattened BY item; result = FOREACH grouped GENERATE group, SUM(flattened.qty);
   • Cresult = FOREACH data GENERATE item, SUM(qty);
   • Dgrouped = GROUP data BY item; result = FOREACH grouped GENERATE group, SUM(data.qty);
   Reveal Solution Discussion Select an answer first
2. 2foundation · easy

   In a Pig Latin script, which statement is used to read data from HDFS into a relation?

   • ALOAD
   • BSTORE
   • CFILTER
   • DFOREACH
   Reveal Solution Discussion Select an answer first
4. 3foundation · easy

   What is the purpose of a User Defined Function (UDF) in Apache Pig?

   • ATo define the schema of a relation in a Pig script
   • BTo extend Pig's built-in functionality with custom processing logic
   • CTo manage the execution of Pig scripts on a cluster
   • DTo store data in HDFS in a custom format
   Reveal Solution Discussion Select an answer first
5. 4foundation · easy

   Which language is commonly used to write Pig UDFs?

   • ASQL
   • BScala
   • CJavaScript
   • DJava
   Reveal Solution Discussion Select an answer first
6. 5application · hard

   A Pig script loads a file with the schema: id:int, name:chararray, scores:bag{t:(subject:chararray, score:int)}. The analyst needs to find the average score for each subject. Which Pig Latin statement correctly does this?

   • Aresult = FOREACH data GENERATE subject, AVG(score);
   • Bflattened = FOREACH data GENERATE id, FLATTEN(scores); grouped = GROUP flattened BY subject; result = FOREACH grouped GENERATE group, AVG(flattened.score);
   • Cgrouped = GROUP data BY scores.subject; result = FOREACH grouped GENERATE group, AVG(data.scores.score);
   • Dgrouped = GROUP data BY subject; result = FOREACH grouped GENERATE group, AVG(data.score);
   Reveal Solution Discussion Select an answer first