IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 61:

  For a customer satisfaction application, a large eCommerce company is loading click stream data into MySQL and running Cognos Reports which are accessed by 50 plus customer service reps (CSR). The IT team decided to move the application to the new BigInsights-based Hadoop cluster and load the data into a Hive Warehouse and run the queries. Which one of the following would enable them to reuse the SQL queries without extensive rewrite?

  A. Pig
  B. NoSQL
  C. HiveQL
  D. Big SQL
  D. Big SQL

• Question 62:

  Consider the following Solr query: curl "http://localhost:8983/solr/gettingstarted/select?wt=jsonandindent=trueandq=foundation" What is the term that is being searched?

  A. indent
  B. json
  C. gettingstarted
  D. foundation
  D. foundation

  ---

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

• Question 63:

  Which of the following is the most effective method for improving query performance on large Hive tables?

  A. Indexing
  B. Bucketing
  C. Partitioning
  D. De-normalizing data
  B. Bucketing

  ---

  Reference: https://dzone.com/articles/how-to-improve-hive-query-performance-with-hadoop

• Question 64:

  One option to import data to your BigInsights cluster is to use Sqoop.

  Which of the following examples shows a data exchange with a DB2 database by using the built-in DB2 connector?

  A. $SQOOP_HOME/bin/sqoop export --connect jdbc:db2://db2.my.com:50000/myDB --username db2user --password db2pwd --table db2tbl --export-dir /sqoop/dataFile.csv
  B. $SQOOP_HOME/bin/sqoop import -connect jdbc:db2://db2.my.com:50000/testdb -username db2user -password db2pwd -table db2tbl -split-by tbl_primarykey -target-dir sqoopimports
  C. $SQOOP_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb --username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports
  D. $BIGINSIGHTS_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb -- username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports
  C. $SQOOP_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb --username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsights.import.doc/doc/data_warehouse_sqoop.html

• Question 65:

  Which keyword can be inserted before a Jaql statement to understand how it may be rewritten into MapReduce?

  A. explain
  B. describe
  C. transcribe
  D. mapreduce
  D. mapreduce

• Question 66:

  For which level of Apache Spark data locality is the data closest to the code that processes it?

  A. ANY
  B. NO_PREF
  C. BACK_LOCAL
  D. NODE_LOCAL
  E. PROCESS_LOCAL
  E. PROCESS_LOCAL

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSZU2E_2.4.1/performance_tuning/application_spark_parameters.html

• Question 67:

  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?

  A. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS
  B. It does not support nested sub-queries
  C. Hive supports all ANSI SQL 2011 syntax
  D. All of the above
  A. It supports four logical operators in query predicates: IN, NOT IN, EXISTS, and NOT EXISTS

  ---

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

• Question 68:

  Which one of the following is NOT provided by the SerDe interface?

  A. SerDe interface has to be built using C or C++ language
  B. Allows SQL-style queries across data that is often not appropriate for a relational database
  C. Serializer takes a Java object that Big SQL has been working with, and turns it into a format that BigSQL can write to HDFS
  D. Deserializer interface takes a string or binary representation of a record, and translates it into a Java object that Big SQL can manipulate
  A. SerDe interface has to be built using C or C++ language

• Question 69:

  What is Flume?

  A. A distributed filesystem
  B. A platform for executing MapReduce jobs
  C. A programming language that translates high-level queries into map tasks and reduce tasks
  D. A service for moving large amounts of data around a cluster soon after the data is produced.
  D. A service for moving large amounts of data around a cluster soon after the data is produced.

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSPT3X_4.1.0/com.ibm.swg.im.infosphere.biginsights.product.doc/doc/bi_flume.html

• Question 70:

  Which of the following statement is TRUE with BigSheets?

  A. You can create any type of sheet from a parent workbook
  B. You must create a child workbook in order to create a chart
  C. You can delete a parent workbook without deleting the child workbooks
  D. You must run the workbook on the data to get the full results of the analysis
  A. You can create any type of sheet from a parent workbook

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.1.0/com.ibm.swg.im.infosphere.biginsights.analyze.doc/doc/bigsheets_con_workbooks.html