Skip to main content

C2090-101 Real Exam Questions

IBM Big Data Engineer

106 questions available · Page 1 of 11

Updated Exam DumpsVerified AnswersPass Guarantee

Get Complete Exam Dumps
Question 1 Single choice

What is a method for loading RDBMS data into an HBase table?

  1. A

    HDFS LOAD

  2. B

    SQOOP IMPORT

  3. C

    LOAD HADOOP USING

  4. D

    Hadoop jar hbase-VERSION.jar importtsv

Show answer and explanation

Correct answer: B

Question 2 Single choice

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

Show answer and explanation

Correct answer: B

Explanation

References:
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 3 Single choice

Consider the following Solr query:

curl "http://localhost:8983/solr/gettingstarted/select?

wt=json&indent=true&q=foundation" What is the term that is being searched?

  1. A

    indent

  2. B

    json

  3. C

    gettingstarted

  4. D

    foundation

Show answer and explanation

Correct answer: D

Explanation

References:
https://lucene.apache.org/solr/6_0_0/quickstart.html

Question 4 Single choice

For what purpose SPSS models are embedded within InfoSphere Streams application?

  1. A

    To provide high availability

  2. B

    To score streaming data using existing models

  3. C

    To create new models based on streaming data

  4. D

    To ingest and parse binary and other complex data types

Show answer and explanation

Correct answer: B

Explanation

References:
https://www.ibm.com/developerworks/data/tutorials/dm-1109spssscoringinfospherestreams1/
dm-1109spssscoringinfospherestreams1-pdf.pdf

Question 5 Single choice

When running Hive Queries using Apache Spark, which of the following execution engines is invoked?

  1. A

    Tez

  2. B

    Spark

  3. C

    HiveQL

  4. D

    MapReduce

Show answer and explanation

Correct answer: B

Explanation

When running queries, you can set hive.execution.engine so as to choose the execution engine. To run on Spark, set it to spark. To run on MapReduce, set it to mr.

References:
https://www.ibm.com/support/knowledgecenter/en/SSPT3X_4.2.5/com.ibm.swg.im.infosphere.biginsights.admin.doc/doc/admin_hive_on_spark.html

Question 6 Single choice

Which statement about the Jaqi Programming Language is TRUE?

  1. A

    Jaqi always produces a MapReduce job, but Combiner functionality is optional

  2. B

    Jaqi includes the following operators: filter, extend, groupby, combine, and transform

  3. C

    Data that is read from multiple blocks (splits) is always processed in parallel by MapReduce

  4. D

    The read operator loads data from different source and formats, and then converts this data into JSON format for internal processing by the Jaqi interpreter

Show answer and explanation

Correct answer: C

Question 7 Multiple choice

Which file format support Column data compression? (Choose two.)

  1. A

    Text

  2. B

    Avro

  3. C

    RCFile

  4. D

    Parquet

  5. E

    Sequence_text

Show answer and explanation

Correct answers: C, D

Question 8 Single choice

A large bank was planning to offload existing data from a data warehouse into Hadoop and use SQL queries to access historical data.

Which one of the following statements is true for using HiveQL?

  1. A

    It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

  2. B

    It does not support nested sub-queries

  3. C

    Hive supports all ANSI SQL 2011 syntax

  4. D

    All of the above

Show answer and explanation

Correct answer: A

Explanation

References:
https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.5/bk_data-access/content/hive-013-feature-subqueries-in-where-clauses.html

Question 9 Single choice

Considering the following properties:

1. Automated creation of target database schema and bulk extract and load
2. Real-time replication subscriptions (with CDC)
3. Managed workload for optimized performance of potentially thousands of artifacts
4. Ensured governance around both data access as well as for metadata capture (to support data lineage and impact assessment)

Which tool supports all of the above?

  1. A

    Pig

  2. B

    JAQL

  3. C

    Data Click

  4. D

    BigSheets

Show answer and explanation

Correct answer: A

Explanation

References:
http://meta7.forsythe.com/_wss/clients/508/news_feed/20151130202508951.pdf

Question 10 Single choice

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

  1. A

    Query Optimization

  2. B

    Predicate Push down

  3. C

    Compression efficiency

  4. D

    Load data into DB2 and return the data

Show answer and explanation

Correct answer: A

Explanation

References:
https://www.ibm.com/support/knowledgecenter/en/SSZLC2_7.0.0/com.ibm.commerce.developer.soa.doc/refs/rsdperformanceworkspaces.htm