IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 21:

  Which of the following are CRUD operations available in HBase? (Choose two.)

  A. HTable.Put
  B. HTable.Read
  C. HTable.Delete
  D. HTable.Update
  E. HTable.Remove
  A. HTable.Put
  C. HTable.Delete

  ---

  Reference: https://www.tutorialspoint.com/hbase/hbase_client_api.htm

• Question 22:

  Which of the following statements is TRUE about Apache Spark RDDs?

  A. RDDs are immutable
  B. RDD transformations return values
  C. RDD actions return pointers to new RDDs
  D. RDDs can only be created using Java APIs
  B. RDD transformations return values

  ---

  Reference: https://spark.apache.org/docs/latest/rdd-programming-guide.html

• Question 23:

  Which statement is TRUE when loading data into Hadoop and creating Big SQL tables?

  A. It is optional to have INSERT privileges granted to LOAD into a table with the APPEND option
  B. You can either have INSERT or DELETE privileges granted to LOAD into a table with the OVERWRITE
  C. Authentication information is not necessary when you connect to a secured InfoSphere BigInsights cluster
  D. By using the LOAD HADOOP USING command, you can import data from external data sources into target Big SQL tables
  D. By using the LOAD HADOOP USING command, you can import data from external data sources into target Big SQL tables

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.1/com.ibm.swg.im.bigsql.db2biga.doc/doc/biga_load_from.html

• Question 24:

  What are the key elements that IBM Big Match Probabilistic Matching Engine leverages?

  A. Wildcard and sorting
  B. Wildcard and phonetics
  C. Phonetics and searching
  D. Phonetics and nicknames
  D. Phonetics and nicknames

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSWSR9_11.6.0/com.ibm.mdmhs.txn.ref.doc/r_searchPersonProbabilistic.html

• Question 25:

  Consider the following query: curl "http://localhost:8983/sorl/gettingstarted/select?wt=jsonandindent=trueandq=foundationandfl=id What is the restricted field?

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

  ---

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

• Question 26:

  Setting HDFS folder permissions most directly relates to which of these PCI compliance requirements?

  A. Protect stored data
  B. Install and maintain a firewall
  C. Encrypt the transmission of sensitive data
  D. Assign a unique ID to each person with access to data
  C. Encrypt the transmission of sensitive data

• Question 27:

  A large retailer is planning to create a data cloud using BigInsights. They would like to run queries using data that is stored in BigInsights as well as other databases like DB2 and Oracle. Which one of the following would enable them to write the queries without having to move data into one common data store?

  A. Hive
  B. HBase
  C. Big SQL
  D. BigSheets
  C. Big SQL

  ---

  Reference: https://www.ibmbigdatahub.com/blog/hadoop-meets-sql

• Question 28:

  A large Telecom company wants to store data from multiple databases into Hadoop. They plan to do bulk loads of data into Hadoop and run analytical queries. Which data store would be ideal for this scenario?

  A. Hive
  B. HBase
  C. BigSheets
  D. Apache Spark
  B. HBase

  ---

  Reference: https://developer.ibm.com/recipes/tutorials/big-data-and-hadoop-on-ibm-cloud/

• Question 29:

  When loading data into Big SQL, which statement is TRUE concerning the underlying storage mechanisms supported?

  A. Big SQL supports .DB2 files
  B. Big SQL supports Parquet files
  C. Big SQL natively supports XML file format
  D. Big SQL supports file stored in PDF format
  B. Big SQL supports Parquet files

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSCRJT_5.0.3/com.ibm.swg.im.bigsql.doc/doc/biga_fileformats.html

• Question 30:

  Use of Bulk Load in HBase for loading large volume of data will result in which of the following?

  A. It will use less CPU but will use more network resource
  B. It will use less network resource but more CPU
  C. It will behave same way as using HBase API for loading large volume of data
  D. None of the above
  C. It will behave same way as using HBase API for loading large volume of data