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 annotation is used to exclude operators from a consistent region?

A@consistent

B@standalone

C@indepedent

D@autonomous

Answer : D

https://www.ibm.com/support/knowledgecenter/en/SSCRJU_4.2.1/com.ibm.streams.dev.doc/doc/ consistentscope.html

Question 3

Which tool below can be used for extracting data directly from an RDBMS and placing a copy within BigInsights as a ready-to-query table?

AFlume

BSqoop

CNZ Load

DDistributed Copy

Answer : B

https://www.ibm.com/support/knowledgecenter/da/SSPT3X_4.2.0/ com.ibm.swg.im.infosphere.biginsights.import.doc/doc/data_warehouse_sqoop.html

Question 4

Which of the following statements is TRUE regarding search visualization with Apache Hue?

AHue submits MapReduce jobs to Oozie

BNo additional setup is required to secure your session cookies

CHue applications require some code to be installed on the client

DThe File Browser application allows you to perform keyword searches across your Hadoop data

Answer : A

Question 5

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 6

Which of the following statements about MapReduce is true?

AMapReduce source programs must be written in Java

BThe output from MapReduce is one or more files stored in the DFS

CMapReduce programs always have four phases: Mapper, Shuffle, Combiner, and Reducer

DIntermediate files, sent from Map tasks to Reduce tasks, are replicated with the number of copies equal to the number of Reducers

Answer : B

Question 7

What is Flume?

AA distributed filesystem

BA platform for executing MapReduce jobs

CA programming language that translates high-level queries into map tasks and reduce tasks

DA service for moving large amounts of data around a cluster soon after the data is produced.

Answer : D

https://www.ibm.com/support/knowledgecenter/en/SSPT3X_4.1.0/ com.ibm.swg.im.infosphere.biginsights.product.doc/doc/bi_flume.html

IBM Big Data Engineer C2090-101 Exam Practice Test