IBM C2090-101 Online Practice Questions and Exam Preparation

IBM C2090-101 Online Questions & Answers

• Question 101:

  Which of the following statements regarding Sqoop is TRUE? (Choose two.)

  A. All columns in a table must be imported
  B. Sqoop bypasses MapReduce for enhanced performance
  C. Each row from a source table is represented as a separate record in HDFS
  D. When using a password file, the file containing the password must reside in HDFS
  E. Multiple options files can be specified when invoking Sqoop from the command line
  C. Each row from a source table is represented as a separate record in HDFS
  E. Multiple options files can be specified when invoking Sqoop from the command line

  ---

  Reference: https://data-flair.training/blogs/apache-sqoop-tutorial/

• Question 102:

  Which statement is TRUE concerning optimizing the load performance?

  A. You can improve the performance by increasing the number of map tasks assigned to the load
  B. When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement
  C. You can improve the performance by decreasing the number of map tasks that are assigned to the load and adjusting the heap size
  D. It is advantageous to run the LOAD HADOOP statement directly pointing to large files located in the host file system as opposed to copying the files to the DFS prior to load
  A. You can improve the performance by increasing the number of map tasks assigned to the load

  ---

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

• Question 103:

  Suppose that you have some log files that you need to load into HBase. What tool could you use to perform a bulk load of the log files?

  A. Import
  B. Fastload
  C. ImportTsv
  D. None of the above
  C. ImportTsv

  ---

  Reference: https://www.ibm.com/support/knowledgecenter/SSWSR9_11.6.0/com.ibm.swg.im.mdmhs.pmebi.doc/topics/running_automatic.html

• Question 104:

  Which statement about the Jaqi Programming Language is TRUE?

  A. Jaqi always produces a MapReduce job, but Combiner functionality is optional
  B. Jaqi includes the following operators: filter, extend, groupby, combine, and transform
  C. Data that is read from multiple blocks (splits) is always processed in parallel by MapReduce
  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
  C. Data that is read from multiple blocks (splits) is always processed in parallel by MapReduce

• Question 105:

  How many Job Trackers can be found in a MapReduce v1 cluster?

  A. One per cluster
  B. One per data node
  C. One for each Mapper
  D. One for each Reducer
  A. One per cluster

  ---

  Reference: https://www.cs.colorado.edu/~kena/classes/5448/s11/presentations/hadoop.pdf

• Question 106:

  Which of the following statements regarding Sqoop is TRUE?

  A. Output files are always delimited text files in HDFS
  B. The import of a single database table results in multiple files in HDFS
  C. When exporting data back to a database, a target table will be created if it doesn't already exist
  D. Sqoop processes the entire database table as a single unit rather than row-by-row for enhanced performance
  A. Output files are always delimited text files in HDFS

  ---

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