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

Download Exam

File Info

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

ProfExam Suite - Black Friday

How to open VCEX & EXAM Files?

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

Download
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



Question 4

Which of the following statements is TRUE regarding search visualization with Apache Hue?


  1. Hue submits MapReduce jobs to Oozie
  2. No additional setup is required to secure your session cookies
  3. Hue applications require some code to be installed on the client
  4. The File Browser application allows you to perform keyword searches across your Hadoop data
Correct answer: A



Question 5

In order for an SPSS Modeler stream to be incorporated for use in an InfoSphere Streams application leveraging SPSS Modeler Solution Publisher, you need to:


  1. add a Type node
  2. insert any Output node
  3. add a Table node as the terminal node
  4. Make the terminal node a scoring branch
Correct answer: D



Question 6

Which of the following Hive data types is directly supported in Big SQL without any changes?


  1. INT
  2. STRING
  3. STRUCT
  4. BOOLEAN
Correct answer: B
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.dev.doc/doc/biga_numbers.html
Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.dev.doc/doc/biga_numbers.html



Question 7

Which parameters are considered when configuring Big Match algorithm?


  1. Search and custom requirements
  2. Accuracy, search, and performance
  3. Adaptive weighting and standardization
  4. Empirical components, accuracy, and performance
Correct answer: B



Question 8

Which of the following are capabilities of the Apache Spark project?


  1. Large scale machine learning
  2. Large scale graph processing
  3. Live data stream processing
  4. All of the above
Correct answer: B
Explanation:
Reference: https://spark.apache.org/
Reference: https://spark.apache.org/



Question 9

Which of the following Big SQL statements is valid?


  1. CREATE TABLE t1 WITH CS;
  2. WITH t1 AS (…) 
    (SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) 
    UNION ALL 
    (SELECT * FROM t1 WITH UR);
  3. SELECT deptno, deptname, mgrno FROM t1 
    WHERE admrdept =‘A00’ 
    FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS
  4. ALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS
Correct answer: C



Question 10

Which of the following techniques is NOT employed by Big SQL to improve performance?


  1. Query Optimization
  2. Predicate Push down
  3. Compression efficiency
  4. Load data into DB2 and return the data
Correct answer: A
Explanation:
Reference: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm
Reference: https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm









CONNECT US

Twitter

Mastodon

Facebook

PROFEXAM WITH A 20% DISCOUNT

You can buy ProfExam with a 20% discount!

Get Now!


HOW TO OPEN VCEX FILES

Use ProfExam Simulator to open VCEX files