IBM C2090-101 Exam Questions Instant Access

Question 1

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 2

PCI compliance requirements allow the use of real customer data during testing and development only when:

AThe data is only processed in memory

BCustomer data is never allowed in testing or development

CThe data is never stored longer than 24 hours in the test system

DThe data is only stored in volatile storage that expires on power loss

Answer : D

Question 3

What are the available document formats beside PDF and MS Word when export a redacted document using Optim Review Tool?

ATIFF, and CSF

BTIFF, and PNG

CJPEG, and PNG

DPlain Text, and CSV

Answer : A

https://www-01.ibm.com/software/info/channel-solution-profiles/Information_Graphics_Redact- It.html

Question 4

Given a file named readme.txt, which command will copy the readme.txt file to the directory on the HDFS?

Ahadoop fs --cp readme.txt hdfs://test.ibm.com:9000/<user>

Bhadoop fs --cp hdfs://test.ibm.com:9000/<user> readme.txt

Chadoop fs --put readme.txt hdfs://test.ibm.com:9000/<user>

Dhadoop fs --put hdfs://test.ibm.com:9000/<user> readme.text

Answer : B

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

A Resilient Distributed Dataset supports which of the following?

ACreating a new dataset from an old one

BReturning a computed value to the driver program

CBoth ''Creating a new dataset from an old one'' and ''Returning a computed value to the driver program''

DNeither ''Creating a new dataset from an old one'' nor ''Returning a computed value to the driver program''

Answer : C

https://spark.apache.org/docs/latest/rdd-programming-guide.html (RDD operations)

Question 7

When we create a new table in Hive, which clause can be used in HiveSQL to indicate the storage file format?

ASAVE AS

BMAKE AS

CFORMAT AS

DSTORED AS

Answer : D

IBM Big Data Engineer C2090-101 Exam Questions