IBM C2090-101 Exam Practice Test Instant Access

Question 1

Which of the following Big SQL statements is valid?

ACREATE TABLE t1 WITH CS;

BWITH t1 AS (...)
(SELECT * FROM t1 WITH RR USE AND KEEP SHARE LOCKS) UNION ALL
(SELECT * FROM t1 WITH UR);

CSELECT deptno, deptname, mgrno FROM t1 WHERE admrdept ='A00'
FOR READ ONLY WITH RS USE AND KEEP EXCLUSIVE LOCKS

DALTER TABLE t1 ALTER COLUMN deptname SET DATA TYPE VARCHAR(100) USE AND KEEP UPDATE LOCKS

Answer : C

Question 2

Which of the following Hive data types is directly supported in Big SQL without any changes?

AINT

BSTRING

CSTRUCT

DBOOLEAN

Answer : B

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

Question 3

Which one of the following is NOT provided by the SerDe interface?

ASerDe interface has to be built using C or C++ language

BAllows SQL-style queries across data that is often not appropriate for a relational database

CSerializer takes a Java object that Big SQL has been working with, and turns it into a format that BigSQL can write to HDFS

DDeserializer interface takes a string or binary representation of a record, and translates it into a Java object that Big SQL can manipulate

Answer : A

Question 4

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 5

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 6

Which of the following are capabilities of the Apache Spark project?

ALarge scale machine learning

BLarge scale graph processing

CLive data stream processing

DAll of the above

Answer : B

https://spark.apache.org/

Question 7

In which of the following the Flume open-source software is written?

AC / C++

BPrimarily Java

CPython and related tools

DA combination of C++ and Perl

Answer : B

https://en.wikipedia.org/wiki/Apache_Flume

IBM C2090-101 Big Data Engineer Exam Practice Test