C2090-101 Online Practice Questions and Answers

Which of the following are CRUD operations available in HBase? (Choose two.)

A. HTable.Put

B. HTable.Read

C. HTable.Delete

D. HTable.Update

E. HTable.Remove

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

A. The data is only processed in memory

B. Customer data is never allowed in testing or development

C. The data is never stored longer than 24 hours in the test system

D. The data is only stored in volatile storage that expires on power loss

Which annotation is used to exclude operators from a consistent region?

A. @consistent

B. @standalone

C. @indepedent

D. @autonomous

What Redaction feature needs to be selected when manually redacting a form through the Optim Review Tool?

A. Text Redaction

B. Image Redaction

C. Region Redaction

D. Redact by Information Type

Bloom Filter in HBase can be used to determine which of the following?

A. Whether a record exists in a region server

B. Whether a record does not exist in a region server

C. Items in the catalog database

D. None of the above

Which statement is TRUE when loading data into Hadoop and creating Big SQL tables?

A. It is optional to have INSERT privileges granted to LOAD into a table with the APPEND option

B. You can either have INSERT or DELETE privileges granted to LOAD into a table with the OVERWRITE

C. Authentication information is not necessary when you connect to a secured InfoSphere BigInsights cluster

D. By using the LOAD HADOOP USING command, you can import data from external data sources into target Big SQL tables

For which level of Apache Spark data locality is the data closest to the code that processes it?

A. ANY

B. NO_PREF

C. BACK_LOCAL

D. NODE_LOCAL

E. PROCESS_LOCAL

A Resilient Distributed Dataset with Replicated storage level does which of the following?

A. Protects from data loss by recomputing the data

B. Allows you to continue running the task in case of a node failure

C. Guarantees a performance benefit

D. Both "Protects from data loss by recomputing the data" and "Allows you to continue running the task in case of a node failure"

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

A. C / C++

B. Primarily Java

C. Python and related tools

D. A combination of C++ and Perl

One option to import data to your BigInsights cluster is to use Sqoop.

Which of the following examples shows a data exchange with a DB2 database by using the built-in DB2 connector?

A. $SQOOP_HOME/bin/sqoop export --connect jdbc:db2://db2.my.com:50000/myDB --username db2user --password db2pwd --table db2tbl --export-dir /sqoop/dataFile.csv

B. $SQOOP_HOME/bin/sqoop import -connect jdbc:db2://db2.my.com:50000/testdb -username db2user password db2pwd -table db2tbl -split-by tbl_primarykey -target-dir sqoopimports

C. $SQOOP_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb --username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports

D. $BIGINSIGHTS_HOME/bin/sqoop import --connect jdbc:db2://db2.my.com:50000/testdb -- username db2user --password db2pwd --table db2tbl --split-by tbl_primarykey --target-dir sqoopimports