P2090-038 Online Practice Questions and Answers

Which of the following options best describes the differences between a traditional data warehouse environment and a Hadoop environment?

A. Traditional data warehousing environments are mostly ideal for analyzing structured data from various systems, while a Hadoop environment is well suited to deal with structured, semi- structured, and unstructured data, as well as when a data discovery process is needed.

B. Hadoop environments are mostly ideal for analyzing structured and semi-structured data from a single system, while traditional data warehousing environment is well suited to deal with unstructured data, as well as when a data discovery process is needed.

C. Typically, data stored in Hadoop environments is cleaned up before storing in the distributed file-system.

D. Typically, data stored in data warehousing environments is rarely filtered and pre-processed. On the other hand, data injected into Hadoop environments is always pre-processed and filtered.

What is the InfoSphere BigInsights Credential Store?

A. The InfoSphere BigInsights credentials store is a table stored in the HBase relational database that stores passwords, tokens, and other potentially sensitive information.

B. The InfoSphere BigInsights credentials store is a designated folder on the distributed file system (DFS) that stores passwords, tokens, and other potentially sensitive information.

C. The InfoSphere BigInsights credentials store is a designated folder in the local file system (not HDFS) that stores the authorities and privileges for all users in the BigInsights environment.

D. The InfoSphere BigInsights credentials store is a designated file defined by an environment variable that stores the authorities and privileges for all users in the BigInsights environment.

Which of the following components is NOT included in the BigInsights Basic Edition distribution?

A. Hadoop Distributed File System.

B. Hive.

C. Pig.

D. BigSheets.

Hadoop environments are optimized for:

A. Processing transactions (random access).

B. Low latency data access.

C. Batch processing on large files.

D. Intensive calculation with little data.

Which of the following options is CORRECT in regards of Text Analytics component?

A. The Text Analytics component extracts information from unstructured and semi-structured data. By using its components, enterprises can analyze large volumes of text and produce annotated documents that provide valuable insights into unconventionally stored data.

B. The Text Analytics component only extracts information from structured data stored in a relational database.

C. The Text Analytics component is a programming model for processing large data sets, and the name of an implementation of the model by Google. Text Analytics is typically used to do distributed computing on clusters of computers.

D. Jaql is the language for developing text analytics extractors in the InfoSphere BigInsights Text Analytics system. A Jaql extractor is a program written in Jaql that extracts structured information from unstructured or semi-structured text.

Which of the following statements should be used to import data from DB2 into InfoSphere BigInsights?

A. You can use the Big SQL LOAD FROM statement to load data into a Big SQL table.

B. You can use the Big SQL IMPORT FROM statement to load data into a HBase table.

C. You can use the Big SQL LOAD FROM statement to load data into a Hive table.

D. You can use the Big SQL IMPORT FROM statement to load data into a Big SQL table.

Which of the following options best describes the proper usage of MapReduce jobs in Hadoop environments?

A. MapReduce jobs are used to process vast amounts of data in-parallel on large clusters of commodity hardware in a reliable, fault-tolerant manner.

B. MapReduce jobs are used to process small amounts of data in-parallel on expensive hardware, without fault-tolerance.

C. MapReduce jobs are used to process structured data in sequence, with fault-tolerance.

D. MapReduce jobs are used to execute sequential search outside the Hadoop environment using a built-in UDF to access information stored in non-relational databases.

Which of the following InfoSphere BigInsights features provides a vast library of extractors enabling actionable insights from large amounts of native textual data?

A. Text Analytics.

B. Adaptive MapReduce.

C. General Parallel File System.

D. BigSheets.

InfoSphere BigInsights offers the following benefits to your organization, EXCEPT:

A. It cuts costs by providing an efficient compression algorithm based on row level compression using a dictionary to store repetitive patterns.

B. It complements your existing infrastructure by extending your data collection and analysis capabilities.

C. It integrates data from a variety of structured and unstructured sources.

D. It enables analysis at scale.

Which of the following options contain security enhancements available in InfoSphere BigInsights (choose two) ?

A. LDAP authentication

B. Secure file transfers through SFTP protocol.

C. Trusted Context.

D. Kerberos authentication protocol.

Which of the following integrated development environment (IDE) can be used to develop programs to be used with InfoSphere BigInsights?

A. InfoSphere Data Explorer.

B. IBM Data Studio with InfoSphere Data Explorer plug-in.

C. InfoSphere Streams Studio

D. Eclipse with InfoSphere BigInsights plug-in.

The analytic capabilities that come built-in with the Big Data platform include:

A. Image and Video

B. Acoustic

C. Financial

D. All of the above

InfoSphere BigInsights supports the following types of authentication, EXCEPT:

A. Kerberos authentication

B. LDAP authentication

C. PAM authentication.

D. Flat File.

Which of the following compression algorithms is used by InfoSphere BigInsights to provide an additional compression option over the ones that come with the base Hadoop distribution?

A. gzip.

B. brzip2.

C. lza.

D. lzo.

Which of the following InfoSphere Biglnsights editions includes the Adaptive MapReduce feature?

A. InfoSphere Biglnsights Express Edition.

B. InfoSphere Biglnsights Enterprise Edition.

C. InfoSphere Biglnsights Extended Developer Edition.

D. InfoSphere Biglnsights Advanced Enterprise Edition.