Download IBM.C2090-101.TestKing.2020-05-04.44q.tqb
| Vendor: | IBM |
| Exam Code: | C2090-101 |
| Exam Name: | IBM Big Data Engineer |
| Date: | May 04, 2020 |
| File Size: | 151 KB |
Demo Questions
Question 1
Which ONE of the following statements regarding Sqoop is TRUE?
- HBase is not supported as an import target
- Data imported using Sqoop is always written to a single Hive partition
- Sqoop can be used to retrieve rows newer than some previously imported set of rows
- 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?
- Spark SQL does not support HiveQL
- Spark SQL does not support ANSI SQL
- To use Spark with Hive, HiveQL queries have to rewritten in Scala
- 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?
- Big SQL doesn’t support stored procedures
- Big SQL can be deployed on a subset of data nodes in the BigInsights cluster
- Big SQL provides a SQL-on-Hadoop environment based on map reduce
- 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
