IBM C2090-101 Exam Questions Instant Access

Question 1

Which file format support Column data compression? (Choose two.)

AText

BAvro

CRCFile

DParquet

ESequence_text

Answer : C, D

Question 2

Which of the following statements regarding Big SQL is TRUE?

ABig SQL doesn't support stored procedures

BBig SQL can be deployed on a subset of data nodes in the BigInsights cluster

CBig SQL provides a SQL-on-Hadoop environment based on map reduce

DOnly tables created or loaded via Big SQL can be accessed via Big SQL

Answer : B

https://books.google.com.pk/books?id=t13nCQAAQBAJ&pg=PA3&lpg=PA3&dq=Big+SQL+can+be

+deployed+on+a+subset+of+data+nodes+in+the+BigInsights

+cluster&source=bl&ots=RBbad0Xkel&sig=pMgmgDNLGUrkvOSXoVBj64xTMgk&hl=en&sa=X&redir_esc=y#v

=onepage&q=Big%20SQL%20can%20be%20deployed%20on%20a%20subset%20of%20data%20nodes% 20in%20the%20BigInsights%20cluster&f=false

Question 3

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

Acp

Bput

Cget

DcopyToLocal

EcopyFromLocal

Answer : D, E

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 is TRUE about a Resilient Distributed Dataset?

AIt is always mutable

BIt is always immutable

CIt can be configured to be either mutable or immutable

DIt can be changed from mutable to immutable state during its life cycle

Answer : B

http://beyondcorner.com/learn-apache-spark/spark-rdd-resilient-distributed-datasets/

Question 5

How are insights derived from Big Match moved to an MDM system?

AExtract insights from HBase and load into MDM through an API call

BExtract insights from Hive and load into MDM using standard tooling

CExtract insights from HDFS and load into MDM by stimulating delta load

DExtract insights from HBase and load into MDM using standard MDM batch processing tool

Answer : C

Question 6

The number of partitions created by DynamicPartitions in Hive can be controlled by which of the following?

Ahive.exec.max.dynamic.partitions.pernode

Bhive.exec.max.dynamic.partitions

Chive.exec.max.created.files

DAll of the above

Answer : A

https://resources.zaloni.com/blog/partitioning-in-hive

Question 7

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

AOne per cluster

BOne per data node

COne for each Mapper

DOne for each Reducer

Answer : A

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

IBM Big Data Engineer C2090-101 Exam Questions