P2090-038 Online Practice Questions and Answers

What is Big SQL?

A. Big SQL is a feature in Data Explorer that allows for indexing of data from SQL sources such as data warehouses.

B. Big SQL is a feature in BigInsights that allows for native SQL query access for Hadoop, providing full ANSI SQL 92 compliance and standardSQL syntax such as joins, for data contained in a variety of formats such as structured Hive tables, Hbase tables, or csv and other delimitedfiles in HDFS.

C. Big SQL is a feature in Streams that allows for real time analysis of data via standard SQL syntax.

D. Big SQL is a feature in BigInsights that provides a SQL like interface to data contained in Hbase tables only. Other data sources in HDFS mustbe accessed via other means such as HiveQL.

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 NOT CORRECT?

A. Big data solutions are ideal for analyzing not only raw structured data, but semi structured and unstructured data from a wide variety ofsources.

B. Big data solutions are ideal when all, or most, of the data needs to be analyzed versus a sample of the data; or a sampling of data isn nearlyBig data solutions are ideal when all, or most, of the data needs to be analyzed versus a sample of the data; or a sampling of data isn? nearlyas effective as a larger set of data from which to derive analysis.

C. Big data solutions are ideal for Online Transaction Processing (OLTP) environments.

D. Big data solutions are ideal for iterative and exploratory analysis when business measures on data are not predetermined.

What is the difference between Hadoop MapReduce and IBM Adaptive MapReduce feature available in InfoSphere BigInsights?

A. Hadoop Map Reduce is optimized for operating on small files or splits, while IBM Adaptive MapReduce is optimized for operating on largepartitioned files.

B. Hadoop MapReduce is optimized for operating on large files, while IBM Adaptive MapReduce is configurable to operate optimized on large or small files or splits

C. Hadoop MapReduce is optimized for operating on small files or splits, while IBM Adaptive MapReduce is optimized for operating on large files stored in individual blocks.

D. Hadoop MapReduce is optimized for operating on small partitioned tables stored in the HBase component, while IBM? Adaptive MapReduceis optimized for operating on large partitioned files.

Which of the following options is CORRECT?

A. InfoSphere BigInsights is based on a branched Hadoop distribution, and therefore backwards compatibility is not guaranteed.

B. InfoSphere BigInsights is a distributed file system used as base for Hadoop distributions.

C. InfoSphere BigInsights is based on the non forked core Hadoop distribution, but backwards compatibility with the Apache Hadoop project is not guaranteed, therefore applications written for Hadoop might not run on BigInsights.

D. InfoSphere BigInsights is based on the non forked core Hadoop distribution, and backwards compatibility with the Apache Hadoop project will always be maintained. Therefore, all applications written for Hadoop will run on BigInsights.

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 options is CORRECT in regards to integrating InfoSphere BigInsights and warehousing environments?

A. There is no direct interaction between InfoSphere BigInsighs and data warehousing environments. However, InfoSphere Streams can be used to stream data between the two environments.

B. Frequently accessed data should be maintained in the BigInsights environment while old?or outdated information can be offloaded to the Frequently accessed data should be maintained in the BigInsights environment while ?old?or outdated information can be offloaded to the warehouse environment.

C. InfoSphere BigInsights Enterprise Edition also comes with a standard Java Database Connectivity (JDBC) connector, making it possible for organizations to quickly integrate with a wide variety of data and information systems, including Oracle, Microsoft SQL Server, MySQL and Teradata.

D. There is no integration between InfoSphere BigInsights and warehousing environments since they deal with different type of data.

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 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.