IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 1:

  Bloom Filter in HBase can be used to determine which of the following?

  A. Whether a record exists in a region server
  B. Whether a record does not exist in a region server
  C. Items in the catalog database
  D. None of the above
  D. None of the above

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/en/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsights.bigsql.doc/doc/bsql_create_hbase_table.html

• Question 2:

  What keyword is used when loading in Hive from single file on the local file system?

  (Hint: If we leave off this keyword with the LOAD command, Hive assumes the location we are referring to is on HDFS)

  A. LOCAL
  B. INSERT
  C. DIRECTORY
  D. OVERWRITE
  A. LOCAL

  ---

  Reference: https://books.google.com.pk/books?id=i6NODQAAQBAJandpg=PA426andlpg=PA426anddq=keyword+is+used+when+loading+in+Hive+from+single+file+on+the+local+file+systemandsource=blandots=2Gr_lfxtCandsig=ACfU3U2VvuP0cOVrf2jyPFyDmwmuXRpbvwandhl=enandsa=Xandved=2ahUKEwjV_eaVxvfoAhUP2KQKHZwtBPsQ6AEwA3oECBYQNg#v=onepageandq=keyword%20is%20used%20when%20loading%20in%20Hive%20from%20single% 20file%20on%20the%20local%20file%20systemandf=false

• Question 3:

  Which of the following Hadoop command flags are used to copy data to the HDFS? (Choose two.)

  A. cp
  B. put
  C. get
  D. copyToLocal
  E. copyFromLocal
  D. copyToLocal
  E. copyFromLocal

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSPT3X_4.2.0/com.ibm.swg.im.infosphere.biginsights.import.doc/doc/data_rest_shell.html

• Question 4:

  Which of the following must happen before the Big SQL EXPLAIN command can execute?

  A. Run the ANALYZE command
  B. Set the COMPATIBILITY_MODE global variable
  C. Execute the SET HADOOP PROPERTY command
  D. Call the SYSPROC.SYSINSTALLOBJECTS procedure
  D. Call the SYSPROC.SYSINSTALLOBJECTS procedure

  ---

  Reference: https://developer.ibm.com/hadoop/docs/biginsights-ibm-open-platform/getting-started/tutorials/big-sql-hadoop-tutorial/getting-started-with-big-sql-4-0-lab-6-understanding-and-influencing-data-plans/

• Question 5:

  Which of the following is TRUE about storing an Apache Spark object in serialized form?

  A. It is advised to use Java serialization over Kryo serialization
  B. Storing the object in serialized from will lead to faster access times
  C. Storing the object in serialized from will lead to slower access times
  D. All of the above
  B. Storing the object in serialized from will lead to faster access times

  ---

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

• Question 6:

  Which ONE of the following statements regarding Sqoop is TRUE?

  A. By default, data is compressed with Sqoop
  B. Sqoop can only read committed transactions from a source database, not uncommitted ones
  C. When performing parallel imports, Sqoop always uses the primary key column in a table as the splitting column
  D. When performing parallel imports, each degree of parallelism corresponds to a concurrent database connection
  B. Sqoop can only read committed transactions from a source database, not uncommitted ones

  ---

  By default, Sqoop uses the read committed transaction isolation in the mappers to import data. This may not be the ideal in all ETL workflows and it may desired to reduce the isolation guarantees. The --relaxed-isolation option can be used to instruct Sqoop to use read uncommitted isolation level.

  Reference: https://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html

• Question 7:

  A Resilient Distributed Dataset is a good solution for which of the following?

  A. A search
  B. An SQL based data transformation
  C. A high throughput write oriented use cases
  D. An interactive query and iterative algorithms
  D. An interactive query and iterative algorithms

  ---

  Reference: https://www.usenix.org/system/files/conference/nsdi12/nsdi12-final138.pdf

• Question 8:

  Which of the following statements regarding importing streaming data from InfoSphere Streams into Hadoop is TRUE?

  A. InfoSphere Streams can both read from and write data to HDFS
  B. The Streams Big Data toolkit operators that interface with HDFS uses Apache Flume to integrate with Hadoop
  C. Streams applications never need to be concerned with making the data schemas consistent with those on Hadoop
  D. Big SQL can be used to preprocess the data as it flows through InfoSphere Streams before the data lands in HDFS
  D. Big SQL can be used to preprocess the data as it flows through InfoSphere Streams before the data lands in HDFS

• Question 9:

  What are the available document formats beside PDF and MS Word when export a redacted document using Optim Review Tool?

  A. TIFF, and CSF
  B. TIFF, and PNG
  C. JPEG, and PNG
  D. Plain Text, and CSV
  A. TIFF, and CSF

  ---

  Reference: https://www-01.ibm.com/software/info/channel-solution-profiles/Information_Graphics_Redact-It.html

• Question 10:

  Which ONE of the following statements regarding Sqoop is TRUE?

  A. HBase is not supported as an import target
  B. Data imported using Sqoop is always written to a single Hive partition
  C. Sqoop can be used to retrieve rows newer than some previously imported set of rows
  D. Sqoop can only append new rows to a database table when exporting back to a database
  C. Sqoop can be used to retrieve rows newer than some previously imported set of rows

  ---

  Reference: https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html