Online Access Free P2090-038 Exam Questions

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

• A.Eclipse with InfoSphere BigInsights plug-in.
• B.IBM Data Studio with InfoSphere Data Explorer plug-in.
• C.InfoSphere Streams Studio
• D.InfoSphere Data Explorer.

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

• A.You can use the Big SQL IMPORT FROM statement to load data into a Big SQL table.
• B.You can use the Big SQL LOAD FROM statement to load data into a Hive table.
• C.You can use the Big SQL LOAD FROM statement to load data into a Big SQL table.
• D.You can use the Big SQL IMPORT FROM statement to load data into a HBase table.

Which of the following methods can be used by Cognos to connect with InfoSphere BigInsights? (Choose two)

• A.Connection via the Hive JDBC driver.
• B.Connection via the Pig JDBC driver.
• C.Connection via the Big SQL JDBC driver.
• D.Connection via the SPL JDBC driver.

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

• A.Adaptive MapReduce
• B.Support to HiveQL and PigLatin languages.
• C.BigSheets
• D.Integrated install

How is data stored in a Hadoop cluster?

• A.The data converted into a single block, and the block is stored in just one of the servers in the Hadoop cluster.
• B.The data is converted into a single block, and copies of this block are replicated across multiple servers in the Hadoop cluster.
• C.The data is divided into blocks, and copies of these blocks are replicated across multiple servers in the Hadoop cluster.
• D.The data is divided into blocks, each block is stored in a different server in the Hadoop cluster, but the blocks are not replicated.