Free IBM C2090-101 Exam Dumps Questions & Answers


Exam Code/Number:	C2090-101Join the discussion
Exam Name:	IBM Big Data Engineer
Certification:	IBM
Free Question Number:	108
Publish Date:	Jul 19, 2026
# of views:	3210
Rating 100%

Page: 1 / 22
Total 108 questions

Question 1

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?

A.ORCFILE
B.SEQUENCEFILE
C.RCFILE
D.TEXTFILE

Question 2

Which of the following is TRUE regarding a schema In Jaql?

A.It must be provided when the data format is not otherwise known
B.It can be used both as a data constraint and to optimize processing and storage
C.It specifies a particular type for each field
D.It is used only when Jaql includes SQL statements

Question 3

Which format would be best for holding semi-structured data?

A.CSV
B.JSON
C.Avro
D.Text

Question 4

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

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

Question 5

Which Big SQL statement can be used to store a single row into an HBase table?

A.LOAD USING ... INTO HBASE TABLE
B.LOAD HIVE DATA
C.INSERT INTO HBASE
D.CREATE HBASE TABLE