IBM C2090-101 - IBM Big Data Engineer Exam
Page: 2 / 22
Total 106 questions
Question #6 (Topic: Topic 1)
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
Answer: D
Question #7 (Topic: Topic 1)
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
Answer: B
Question #8 (Topic: Topic 1)
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
Answer: A
Question #9 (Topic: Topic 1)
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
Answer: B
Question #10 (Topic: Topic 1)
Which of the following are CRUD operations available in HBase? (Choose two.)
A. HTable.Put
B. HTable.Read
C. HTable.Delete
D. HTable.Update
E. HTable.Remove
Answer: AC
