IBM Big Data Engineer

Here you have the best IBM C2090-101 practice exam questions

Question 1 of 106

Which ONE of the following statements regarding Sqoop is TRUE?

HBase is not supported as an import target

Data imported using Sqoop is always written to a single Hive partition

Sqoop can be used to retrieve rows newer than some previously imported set of rows

Sqoop can only append new rows to a database table when exporting back to a database

Correct Answer: C

Question 2 of 106

Which one of the following statements is TRUE?

Spark SQL does not support HiveQL

Spark SQL does not support ANSI SQL

To use Spark with Hive, HiveQL queries have to rewritten in Scala

Spark SQL allows relational queries expressed in SQL, HiveQL, or Scala

Correct Answer: D

Question 3 of 106

Which of the following statements regarding Big SQL is TRUE?

Big SQL doesn't support stored procedures

Big SQL can be deployed on a subset of data nodes in the BigInsights cluster

Big SQL provides a SQL-on-Hadoop environment based on map reduce

Only tables created or loaded via Big SQL can be accessed via Big SQL

Correct Answer: B

Question 4 of 106

The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following?

hive.exec.max.dynamic.partitions.pernode

hive.exec.max.dynamic.partitions

hive.exec.max.created.files

All of the above

Correct Answer: A

Question 5 of 106

Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?

join

group

expand

transform

Correct Answer: B