Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-101

IBM C2090-101 Exam Questions
IBM Big Data Engineer (Page 3 )

Updated On: 21-Feb-2026
Page 3 of 23
PDF with 106 Questions

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

Answer(s): D


Reference:

https://spark.apache.org/docs/1.2.1/sql-programming-guide.html (overview)



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

Answer(s): B


Reference:

https://books.google.com.pk/books?id=t13nCQAAQBAJ&pg=PA3&lpg=PA3&dq=Big+SQL+can+be +deployed+on+a+subset+of+data+nodes+in+the+BigInsights +cluster&source=bl&ots=RBbad0Xkel&sig=pMgmgDNLGUrkvOSXoVBj64xTMgk&hl=en&sa=X&redir_ esc=y#v
=onepage&q=Big%20SQL%20can%20be%20deployed%20on%20a%20subset%20of%20data%20node s% 20in%20the%20BigInsights%20cluster&f=false



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

Answer(s): A


Reference:

https://resources.zaloni.com/blog/partitioning-in-hive



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

Answer(s): B


Reference:

https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq +operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate +expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir _esc=y#
v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20k ey% 20values%20and%20applies%20an%20aggregate%20expression&f=false



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

Answer(s): A,C


Reference:

https://www.tutorialspoint.com/hbase/hbase_client_api.htm






Post your Comments and Discuss IBM C2090-101 exam dumps with other Community members:

Join the C2090-101 Discussion