The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following? A. hive.exec.max.dynamic.partitions.pernode B. hive.exec.max.dynamic.partitions C. hive.exec.max.created.files D. All of the above Reference: https://resources.zaloni.com/blog/partitioning-in-hive

Which of the following statements regarding Big SQL is TRUE? A. Big SQL doesn’t support stored procedures B. Big SQL can be deployed on a subset of data nodes in the BigInsights cluster C. Big SQL provides a SQL-on-Hadoop environment based on map reduce D. Only tables created or loaded via Big SQL can be […]

Which one of the following statements is TRUE? A. Spark SQL does not support HiveQL B. Spark SQL does not support ANSI SQL C. To use Spark with Hive, HiveQL queries have to rewritten in Scala D. Spark SQL allows relational queries expressed in SQL, HiveQL, or Scala Reference: https://spark.apache.org/docs/1.2.1/sql-programming-guide.html (overview)

Which ONE of the following statements regarding Sqoop is TRUE? A. HBase is not supported as an import target B. Data imported using Sqoop is always written to a single Hive partition C. Sqoop can be used to retrieve rows newer than some previously imported set of rows D. Sqoop can only append new rows […]

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 serialization B. Storing the object in serialized from will lead to faster access times C. Storing the object in serialized from will lead to slower access times D. All of […]

Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE? A. InfoSphere Streams can both read from and write data to HDFS B. The Streams Big Data toolkit operators that interface with HDFS uses Apache Flume to integrate with Hadoop C. Streams applications never need to be concerned with […]

Which of the following statements are TRUE regarding the use of Data Click to load data into BigInsights? (Choose two.) A. Big SQL cannot be used to access the data moved in by Data Click because the data is in Hive B. You must import metadata for all sources and targets that you want to […]

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 load B. When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement C. You can improve the performance by […]