Download IBM.C2090-101.TestKing.2020-05-04.44q.tqb

Download Exam

File Info

Exam IBM Big Data Engineer
Number C2090-101
File Name IBM.C2090-101.TestKing.2020-05-04.44q.tqb
Size 151 KB
Posted May 04, 2020
Download IBM.C2090-101.TestKing.2020-05-04.44q.tqb


How to open VCEX & EXAM Files?

Files with VCEX & EXAM extensions can be opened by ProfExam Simulator.

Purchase

Coupon: MASTEREXAM
With discount: 20%






Demo Questions

Question 1

Which ONE of the following statements regarding Sqoop is TRUE?


  1. HBase is not supported as an import target
  2. Data imported using Sqoop is always written to a single Hive partition
  3. Sqoop can be used to retrieve rows newer than some previously imported set of rows
  4. Sqoop can only append new rows to a database table when exporting back to a database
Correct answer: C
Explanation:
Reference: https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html
Reference: https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html



Question 2

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
Correct answer: D
Explanation:
Reference: https://spark.apache.org/docs/1.2.1/sql-programming-guide.html (overview)
Reference: https://spark.apache.org/docs/1.2.1/sql-programming-guide.html (overview)



Question 3

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
Correct answer: B
Explanation:
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
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









PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!



HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files