C2090-101

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 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 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_es c=y#v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on% 20key%20values%20and%20applies%20an%20aggregate%20expression&f=false

Which file format support Column data compression? (Choose two.)A . TextB . AvroC . RCFileD . ParquetE . Sequence_textView AnswerAnswer: CD

Which statement is TRUE concerning optimizing the load performance?A . You can improve the performance by increasing the number of map tasks assigned to the loadB . When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statementC . You...

Which of the following are CRUD operations available in HBase? (Choose two.)A . HTable.PutB . HTable.ReadC . HTable.DeleteD . HTable.UpdateE . HTable.RemoveView AnswerAnswer: AC Explanation: Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm

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 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...

Which parameters are considered when configuring Big Match algorithm?A . Search and custom requirementsB . Accuracy, search, and performanceC . Adaptive weighting and standardizationD . Empirical components, accuracy, and performanceView AnswerAnswer: B

A Resilient Distributed Dataset supports which of the following?A . Creating a new dataset from an old oneB . Returning a computed value to the driver programC . Both A and BD . Neither A nor BView AnswerAnswer: C Explanation: Reference: https://spark.apache.org/docs/latest/rdd-programming-guide.html (RDD operations)