C2090-101

Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?A . joinB . groupC . expandD . transformView AnswerAnswer: B Explanation: Reference: https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y#v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key%20values%20and%20applies%20an%20aggregate%20expression&f=false

Which of the following Hive data types is directly supported in Big SQL without any changes?A . INTB . STRINGC . STRUCTD . BOOLEANView AnswerAnswer: B Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.dev.doc/doc/biga_numbers.html

Which of the following is TRUE about storing an Apache Spark object in serialized form?A . It is advised to use Java serialization over Kryo serializationB . Storing the object in serialized from will lead to faster access timesC . Storing the object in serialized from will lead to slower...

Which of the following statements is TRUE regarding search visualization with Apache Hue?A . Hue submits MapReduce jobs to OozieB . No additional setup is required to secure your session cookiesC . Hue applications require some code to be installed on the clientD . The File Browser application allows you...

Which of the following is the most effective method for improving query performance on large Hive tables?A . IndexingB . BucketingC . PartitioningD . De-normalizing dataView AnswerAnswer: B Explanation: Reference: https://dzone.com/articles/how-to-improve-hive-query-performance-with-hadoop

The GPFS implementation of Data Management API is compliant to which Open Group storage management Standard?A . XSHB . XBDC . XDSMD . X /OpenView AnswerAnswer: C Explanation: Reference: https://www.ibm.com/support/knowledgecenter/en/SSFKCN_4.1.0/com.ibm.cluster.gpfs.v4r1.gpfs400.doc/bl1dmp_intro.htm

Which of the following statements regarding Big SQL is TRUE?A . Big SQL doesn’t support stored proceduresB . Big SQL can be deployed on a subset of data nodes in the BigInsights clusterC . Big SQL provides a SQL-on-Hadoop environment based on map reduceD . Only tables created or loaded...

The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following?A . hive.exec.max.dynamic.partitions.pernodeB . hive.exec.max.dynamic.partitionsC . hive.exec.max.created.filesD . All of the aboveView AnswerAnswer: A Explanation: Reference: https://resources.zaloni.com/blog/partitioning-in-hive

Which one of the following statements is TRUE?A . Spark SQL does not support HiveQLB . Spark SQL does not support ANSI SQLC . To use Spark with Hive, HiveQL queries have to rewritten in ScalaD . Spark SQL allows relational queries expressed in SQL, HiveQL, or ScalaView AnswerAnswer: D...

Which statement about the Jaqi Programming Language is TRUE?A . Jaqi always produces a MapReduce job, but Combiner functionality is optionalB . Jaqi includes the following operators: filter, extend, groupby, combine, and transformC . Data that is read from multiple blocks (splits) is always processed in parallel by MapReduceD ....