IBM C2090-101 Exam Questions

Question 6 of 106

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

Correct Answer: D

Question 7 of 106

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 accessed via Big SQL

Correct Answer: B

Question 8 of 106

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

Correct Answer: A

Question 9 of 106

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

A.

join

B.

group

C.

expand

D.

transform

Correct Answer: B

Question 10 of 106

Which of the following are CRUD operations available in HBase? (Choose two.)