Free IBM P2090-038 Exam Dumps Questions & Answers

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

• A.  Trusted Context.
• B.  LDAP authentication
• C.  Secure file transfers through SFTP protocol.
• D.  Kerberos authentication protocol.

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

• A.  All of the above
• B.  Image and Video
• C.  Financial
• D.  Acoustic

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 Hive table.
• B.  You can use the Big SQL IMPORT FROM statement to load data into a Big SQL 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 options is CORRECT in regards to integrating InfoSphere BigInsights and warehousing environments?

• A.  There is no integration between InfoSphere BigInsights and warehousing environments since they deal with different type of data.
• 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 direct interaction between InfoSphere BigInsighs and data warehousing environments. However, InfoSphere Streams can be used to stream data between the two environments.

What is Big SQL?

• A.  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.
• 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 Data Explorer that allows for indexing of data from SQL sources such as data warehouses.
• D.  Big SQL is a feature in Streams that allows for real time analysis of data via standard SQL syntax.