IBM C2090-101 Exam Questions Instant Access

Question 1

Which statement is TRUE concerning optimizing the load performance?

AYou can improve the performance by increasing the number of map tasks assigned to the load

BWhen loading large files the number of files that you load does not impact the performance of the LOAD HADOOP statement

CYou can improve the performance by decreasing the number of map tasks that are assigned to the load and adjusting the heap size

DIt is advantageous to run the LOAD HADOOP statement directly pointing to large files located in the host file system as opposed to copying the files to the DFS prior to load

Answer : A

https://www.ibm.com/support/knowledgecenter/en/SSCRJT_5.0.3/com.ibm.swg.im.bigsql.doc/doc/ bigsql_loadperf.html

Question 2

Which of the following is TRUE about storing an Apache Spark object in serialized form?

AIt is advised to use Java serialization over Kryo serialization

BStoring the object in serialized from will lead to faster access times

CStoring the object in serialized from will lead to slower access times

DAll of the above

Answer : B

https://spark.apache.org/docs/latest/rdd-programming-guide.html

Question 3

In order for an SPSS Modeler stream to be incorporated for use in an InfoSphere Streams application leveraging SPSS Modeler Solution Publisher, you need to:

Aadd a Type node

Binsert any Output node

Cadd a Table node as the terminal node

DMake the terminal node a scoring branch

Answer : D

Question 4

Which of the following Pig Latin expressions is used to sum a set of numbers in a bag?

AX = FOR EACH C -> (group,SUM(A.a1))

BX = FOR EACH C GEN [group, SUM (A.a1)];

CX = FOREACH C GENERATE group, SUM (A.a1);

DX = FOREACH C GENERATE FLATTEN SUM (A.a1);

Answer : C

https://github.com/rjurney/Cloud-Stenography/blob/master/CloudStenography/pig-0.3.0/src/docs/ src/documentation/content/xdocs/piglatin.xml

Question 5

Which of the following Jaq operators groups one or more arrays based on key values and applies an aggregate expression?

Ajoin

Bgroup

Cexpand

Dtransform

Answer : B

https://books.google.com.pk/books?id=Qj-5BQAAQBAJ&pg=PA174&lpg=PA174&dq=Jaq

+operators+groups+one+or+more+arrays+based+on+key+values+and+applies+an+aggregate

+expression&source=bl&ots=zobr8AZzWy&sig=ZRCIH9ee4Un3Aam1hX8TzxfrfQI&hl=en&sa=X&redir_esc=y# v=onepage&q=Jaq%20operators%20groups%20one%20or%20more%20arrays%20based%20on%20key% 20values%20and%20applies%20an%20aggregate%20expression&f=false

Question 6

Which BigInsights tool is able to export data from Big SQL?

AAmbari

BBigSheets

CFlume

DKnox

Answer : B

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

Question 7

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

IBM Big Data Engineer C2090-101 Exam Questions