IBM Big Data Engineer (C2090-101) Free Practice Test

Question 1

What is a standard method of monitoring sensitive data in Hadoop?

A. All of the above

B. Use STAP on each Hadoop Node

C. Use any database monitoring tool

D. Use HBASE GET or hadoop fs -cat commands

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 2

When running Hive Queries using Apache Spark, which of the following execution engines is invoked?

A. Spark

B. MapReduce

C. HiveQL

D. Tez

Correct Answer: A

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 3

Which of the following statements regarding Sqoop is TRUE?

A. Sqoop processes the entire database table as a single unit rather than row-by-row for enhanced performance

B. When exporting data back to a database, a target table will be created if it doesn't already exist

C. The import of a single database table results in multiple files in HDFS

D. Output files are always delimited text files in HDFS

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 4

Which ONE of the following statements regarding Sqoop is TRUE?

A. Sqoop can only append new rows to a database table when exporting back to a database

B. Sqoop can be used to retrieve rows newer than some previously imported set of rows

C. HBase is not supported as an import target

D. Data imported using Sqoop is always written to a single Hive partition

Correct Answer: B

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 5

Which of the following Hadoop command flags are used to copy data to the HDFS? (Choose two.)

A. copyToLocal

B. cp

C. copyFromLocal

D. put

E. get

Correct Answer: A,C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 6

A large retailer is planning to create a data cloud using BigInsights. They would like to run queries using data that is stored in BigInsights as well as other databases like DB2 and Oracle.
Which one of the following would enable them to write the queries without having to move data into one common data store?

A. BigSheets

B. HBase

C. Hive

D. Big SQL

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 7

Which of the following is TRUE about a Resilient Distributed Dataset?

A. It can be changed from mutable to immutable state during its life cycle

B. It is always mutable

C. It can be configured to be either mutable or immutable

D. It is always immutable

Correct Answer: D

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 8

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

A. NO_PREF

B. BACK_LOCAL

C. ANY

D. NODE_LOCAL

E. PROCESS_LOCAL

Correct Answer: E

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Question 9

The Distributed File Copy application copies files to and from a remote source to the InfoSphere BigInsights distributed file system by using data movement options.
Which of the following is the complete list of options for moving data with Distributed File Copy?

A. General Parallel File System (GPFS), FTP, and SFTP

B. Hadoop Distributed File System (HDFS) and FTP

C. Hadoop Distributed File System (HDFS), FTP, SFTP, GPFS, and also copy files to and from your local file system

D. File Transfer Protocol (FTP) and SFTP

Correct Answer: C

Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).

Welcome to TestSimulate

IBM Big Data Engineer (C2090-101) Free Practice Test