Create Next App

Exam contains 102 questions

Page 1 of 17

Question 1 🔥

Which one of the following statements is TRUE?

Which database solution meets these requirements?

A. Spark SQL does not support HiveQL

Highly voted

B. Spark SQL does not support ANSI SQL

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 2 🔥

Which of the following statements regarding Big SQL is TRUE?

Which database solution meets these requirements?

A. Big SQL doesn't support stored procedures

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Question 3 🔥

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

Which database solution meets these requirements?

A. hive.exec.max.dynamic.partitions.pernode

Highly voted

B. hive.exec.max.dynamic.partitions

Highly voted

C. hive.exec.max.created.files

Highly voted

D. All of the above

Highly voted

Discussion of the question

Question 4 🔥

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

Which database solution meets these requirements?

A. join

Highly voted

B. group

Highly voted

C. expand

Highly voted

D. transform

Highly voted

Discussion of the question

Question 5 🔥

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

Which database solution meets these requirements?

Discussion of the question

Question 6 🔥

Which ONE of the following statements regarding Sqoop is TRUE?

Which database solution meets these requirements?

A. HBase is not supported as an import target

Highly voted

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

Highly voted

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

Highly voted

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

Highly voted

Discussion of the question

Ready to Pass Your Certification Test

ibm C2090_101

Exam contains 102 questions

Lorem ipsum dolor sit amet consectetur. Eget sed turpis aenean sit aenean. Integer at nam ullamcorper a.

Company

Product

Resources

Follow us