Which of the following statements is TRUE regarding the use of Data Click to load data into BigInsights?A . Data Click uses Map Reduce to create a Hive tableB . Only relational databases are supported...
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 of the following is NOT TRUE regarding InfoSphere Streams composite operators that are annotated as consistent regions?A . Disconnected subgraphs within the composite participate in the consistent regionB . The composite operator and the...
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
When we create a new table in Hive, which clause can be used in HiveSQL to indicate the storage file format?A . SAVE ASB . MAKE ASC . FORMAT ASD . STORED ASView AnswerAnswer: D
When running Hive Queries using Apache Spark, which of the following execution engines is invoked?A . TezB . SparkC . HiveQLD . MapReduceView AnswerAnswer: B Explanation: Explanation: When running queries, you can set hive.execution.engine so...
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...
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...
A large retailer is planning to create a data cloud using BigInsights. They would like to run queries using data that is stored in BigInsights as well as other databases like DB2 and Oracle. Which...
Which one of the following file formats is optimal for querying tables with many columns and performing aggregation operations such as SUM() and AVG()?A . TextB . AvroC . JSOND . PARQUETView AnswerAnswer: C
