Online Access Free P2090-038 Exam Questions

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.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.
• C.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.
• D.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.

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 integrates data from a variety of structured and unstructured sources.
• C.It enables analysis at scale.
• D.It complements your existing infrastructure by extending your data collection and analysis capabilities.

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

• A.The Text Analytics component only extracts information from structured data stored in a relational database.
• B.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.
• 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 options best describes the differences between a traditional data warehouse environment and a Hadoop environment?

• A.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.
• B.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.
• C.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.
• D.Typically, data stored in Hadoop environments is cleaned up before storing in the distributed file-system.

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 HBase 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 Big SQL table.