IBM P2090-038 dumps - 100% Pass Guarantee!

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.

Which of the following options DOES NOT describe an advantage of InfoSphere BigInsights on top of regular standalone Hadoop distributions?

A. Integrated install

B. BigSheets

C. Adaptive MapReduce

D. Support to HiveQL and PigLatin languages.

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.

What are the "Vs"that characterize IBM Big Data initiative?

A. Variety, Versions, Velocity, Volatility

B. Velocity, Volatility, Variety, Veracity

C. Veracity, Variety, Volume, Velocity

D. Volume, Volatility, Velocity, Variety

How is data stored in a Hadoop cluster?

A. The data is divided into blocks, and copies of these blocks are replicated across multiple servers in the Hadoop cluster.

B. The data converted into a single block, and the block is stored in just one of the servers in the Hadoop cluster.

C. The data is divided into blocks, each block is stored in a different server in the Hadoop cluster, but the blocks are not replicated.

D. The data is converted into a single block, and copies of this block are replicated across multiple servers in the Hadoop cluster.