C2090-101

C2090-101 practice questions, page 2 of 5, with answer review and explanations.

Question 6

Which one of the following statements is TRUE?

  1. Spark SQL does not support HiveQL
  2. Spark SQL does not support ANSI SQL
  3. To use Spark with Hive, HiveQL queries have to rewritten in Scala
  4. Spark SQL allows relational queries expressed in SQL, HiveQL, or Scala

Question 7

Which of the following statements regarding Big SQL is TRUE?

  1. Big SQL doesn't support stored procedures
  2. Big SQL can be deployed on a subset of data nodes in the BigInsights cluster
  3. Big SQL provides a SQL-on-Hadoop environment based on map reduce
  4. Only tables created or loaded via Big SQL can be accessed via Big SQL

Question 8

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

  1. hive.exec.max.dynamic.partitions.pernode
  2. hive.exec.max.dynamic.partitions
  3. hive.exec.max.created.files
  4. All of the above

Question 9

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

  1. join
  2. group
  3. expand
  4. transform

Question 10

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

  1. HTable.Put
  2. HTable.Read
  3. HTable.Delete
  4. HTable.Update
  5. HTable.Remove