Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home IBM C2090-101

IBM C2090-101 Exam Practice Questions (P. 2)

  • Full Access (106 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #6
Which one of the following statements is TRUE?
  1. A
    Spark SQL does not support HiveQL
  2. B
    Spark SQL does not support ANSI SQL
  3. C
    To use Spark with Hive, HiveQL queries have to rewritten in Scala
  4. D
    Spark SQL allows relational queries expressed in SQL, HiveQL, or Scala

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

Question #7
Which of the following statements regarding Big SQL is TRUE?
  1. A
    Big SQL doesn't support stored procedures
  2. B
    Big SQL can be deployed on a subset of data nodes in the BigInsights cluster
  3. C
    Big SQL provides a SQL-on-Hadoop environment based on map reduce
  4. D
    Only tables created or loaded via Big SQL can be accessed via Big SQL

Correct Answer:
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%20nodes%20in%20the%20BigInsights%20cluster&f=false

Question #8
The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following?
  1. A
    hive.exec.max.dynamic.partitions.pernode
  2. B
    hive.exec.max.dynamic.partitions
  3. C
    hive.exec.max.created.files
  4. D
    All of the above

Correct Answer:
A
Reference:
https://resources.zaloni.com/blog/partitioning-in-hive

Question #9
Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?
  1. A
    join
  2. B
    group
  3. C
    expand
  4. D
    transform

Correct Answer:
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%20key%20values%20and%20applies%20an%20aggregate%20expression&f=false

Question #10
Which of the following are CRUD operations available in HBase? (Choose two.)
  1. A
    HTable.Put
  2. B
    HTable.Read
  3. C
    HTable.Delete
  4. D
    HTable.Update
  5. E
    HTable.Remove

Correct Answer:
AC
Reference:
https://www.tutorialspoint.com/hbase/hbase_client_api.htm

Previous Questions Next Questions

All Pages