C2090-719 by IBM Actual Free Exam Questions And Answers

Question 1

What are two benefits for using an Eclipse-based tool such as Design Studio? (Choose two.)

A. A basic architecture for which tool developers must write numerous services.

B. A rich infrastructure including such components as a runtime environment, a generic user interface, and a help system.

C. A broad selection of third-party tools that have already been developed and are available to be installed.

D. A proprietary framework that is used to integrate tools together quickly.

E. A rich, inclusive, infrastructure for which tool developers must only develop a help system.

Discussion 0

Correct Answer: B,C Vote an answer

Question 2

You work for an insurance company and have been asked to help find a way to detect which health care providers may be submitting fraudulent claims. Which mining method would you employ?

A. sequences

B. clustering

C. regression prediction

D. associations

Discussion 0

Correct Answer: B Vote an answer

Question 3

Relational database and a database model that is often a star or snowflake schema are characteristics of which engine storage structure?

A. ROLAP

B. Proprietary

C. MOLAP

D. Multidimensional cubing

Discussion 0

Correct Answer: A Vote an answer

Question 4

A new data mart or star schema has been physically designed in a data modeling tool by someone in the team, and the SQW developer wants to use that model to design some data flows. Which data modeling tool is supported by the Data Model Import Wizard of Design Studio?

A. ER/Studio

B. ModelRight

C. ERwin

D. Oracle Designer

Discussion 0

Correct Answer: C Vote an answer

Question 5

When using InfoSphere Warehouse, in which two occasions is it appropriate to run the InfoSphere Warehouse configuration tool? (Choose two.)

A. immediately before installation

B. any time you need to do reverse engineering

C. immediately after installation

D. any time after installation to modify your configuration

E. any time after a new user is added to the warehousing solution

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

When using the Design Studio to define hierarchies for a cube model, you specify the hierarchy type and deployment method. If you were to specify a hierarchy type of
"balanced" and a deployment of "standard", what would that imply?

A. The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.

B. The levels in the hierarchy have a consistent parent-child relationship and levels are logically inconsistent. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.

C. The levels in the hierarchy have associated meaning, branches have consistent depth and the parent of any member is found in the level above. The data used to define EACH level for a specific branch of the hierarchy is found in a single row in the dimension table.

D. The levels in the hierarchy have associated meaning, branches have consistent depth andtheparent of any member is found in the level above. The data used to define the members of ALL of the levels for a specific branch of the hierarchy is found in a single row in the dimension table.

Discussion 0

Correct Answer: D Vote an answer

Question 7

A cube model has been created but one of the dimensions does not have a hierarchy defined.
After right-clicking on the dimension and selecting "Add Hierarchy", which two steps are required to complete the definition of the new hierarchy? (Choose two.)

A. On the Levels Property page, specify the levels to include in the hierarchy.

B. On the Default Measure page, specify the default measure.

C. On the General Properties page, specify a hierarchy name.

D. On the Calculated Measures page, specify the measures to include in the hierarchy.

E. Under the new hierarchy name, right-click on "MDX Calculated Measures" and select
"Add MDX Calculated Measure".

Discussion 0

Correct Answer: A,C Vote an answer

Question 8

The administrator has created a data flow that contains a fact table to a dimension table join. Which operators will allow for inserting the output into a permanent database table?

A. Add a File Export operator and write the data to a file; add a Table Target to load the exported data.

B. Add a Data Station operator and select create suitable table on the output port.

C. Add a Custom SQL operator and a Table Target operator and connect the output of the Custom SQL to the input of the Table Target.

D. Add a Table Target operator and give the target a table name for output.

Discussion 0

Correct Answer: B Vote an answer

Question 9

Certain operators cannot be placed directly into a parallel container. Some of these operators are iterators, variable comparisons, and parallel containers. Which technique could you use to overcome this restriction?

A. Place them first in a subflow and then place the subflow in the parallel container.

B. Place them first in a data flow and then place the data flow in the parallel container.

C. Place them first in a control flow and then place the control flow in the parallel container.

D. Place them first in a subprocess and then place the subprocess in the parallel container.

Discussion 0

Correct Answer: D Vote an answer

Question 10

In a three node configuration, which two servers can contain InfoSphere Warehouse Intelligent Miner components? (Choose two.)

A. WebSphere Administration Server

B. Mining Server

C. Client

D. Data Server

E. Web Server

Discussion 0

Correct Answer: C,D Vote an answer

IBM InfoSphere Warehouse V9.5 - C2090-719 Exam Practice Test

Contact Us

Useful Links

Latest Updated