Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. IBM
  5. C2090-101

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

Updated On: 1-Feb-2026
Page 4 of 23
PDF with 106 Questions

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

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

Answer(s): D


Reference:

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



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

  1. ANY
  2. NO_PREF
  3. BACK_LOCAL
  4. NODE_LOCAL
  5. PROCESS_LOCAL

Answer(s): E


Reference:

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



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

  1. Whether a record exists in a region server
  2. Whether a record does not exist in a region server
  3. Items in the catalog database
  4. None of the above

Answer(s): D


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



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

  1. InfoSphere Streams utilizes Flume to interface to Hadoop
  2. The HDFSFileSink operator writes files in parallel to a Hadoop Distributed File System
  3. Buffering techniques are used to process incoming streams from InfoSphere Streams
  4. When you use the HDFS operators to access GPFS, you must install InfoSphere Streams on an InfoSphere Big Insights data node

Answer(s): C


Reference:

https://books.google.com.pk/books?id=JWfRAgAAQBAJ&pg=PA147&lpg=PA147&dq=IBm +Buffering+techniques+are+used+to+process+incoming+streams+from+InfoSphere +Streams&source=bl&ots=Z6XhA0-
Owk&sig=ACfU3U3T9ydrZHWTMvB31qQOyf6FtoDQgw&hl=en&sa=X&ved=2ahUKEwj6wsnvqvfoAhV USxUIH
WNDAycQ6AEwA3oECBEQAQ#v=onepage&q=IBm%20Buffering%20techniques%20are%20used%20t o% 20process%20incoming%20streams%20from%20InfoSphere%20Streams&f=false



Which of the following statements regarding Sqoop is TRUE?

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

Answer(s): A


Reference:

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



Viewing page 5 of 23
Viewing questions 21 - 25 out of 106 questions



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

Join the C2090-101 Discussion