IBM C2090-101 Exam
IBM Big Data Engineer (Page 2 )

Updated On: 1-Feb-2026

Which statement is TRUE concerning optimizing the load performance?

  1. You can improve the performance by increasing the number of map tasks assigned to the load
  2. When loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement
  3. You can improve the performance by decreasing the number of map tasks that are assigned to the load and adjusting the heap size
  4. 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

Answer(s): A


Reference:

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



Which expression is making proper use of the "LOAD" function in Pig Latin?

  1. A = LOAD data -> name,age,gpa
  2. A = LOAD('data',[name, age, gpa]);
  3. A = LOAD 'data' -> {name:chararray, age:int, gpa:float};
  4. A = LOAD 'data' AS (name:chararray, age:int, gpa:float);

Answer(s): D


Reference:

https://pig.apache.org/docs/r0.17.0/basic.html



In Hive, there are a few different storage file format that can be used.
Which format allows data to be stored as a flat file consisting of binary key-value pairs?

  1. RCFILE
  2. ORCFILE
  3. TEXTFILE
  4. SEQUENCEFILE

Answer(s): A


Reference:

https://nxtgen.com/hadoop-file-formats-when-and-what-to-use



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

  1. Wildcard and sorting
  2. Wildcard and phonetics
  3. Phonetics and searching
  4. Phonetics and nicknames

Answer(s): D


Reference:

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



Which of the following is not a data-processing operations that is supported in Pig Latin?

  1. filter
  2. joins
  3. group by
  4. logistic regression

Answer(s): D


Reference:

https://pig.apache.org/docs/r0.15.0/basic.html



Viewing page 2 of 23
Viewing questions 6 - 10 out of 106 questions



Post your Comments and Discuss IBM C2090-101 exam prep with other Community members:

Join the C2090-101 Discussion