InfoSphere Warehouse V9.5 (C2090-719) Free Practice Test

Question 1

You manage a store and want to increase the sales of some high profit items. One way to do this is by placing these items close to other products that are often purchased with the high profit items.
You have a year's history of all sales, including all the items that were purchased in each sale. To determine optimal product placement for the high profit items, which mining method should be used to analyze your data?

A. Regression

B. Classification

C. Association

D. Clustering

Correct Answer: C

Question 2

When InfoSphere Warehouse is implemented in a three node configuration, which two servers can contain Cubing Services components? (Choose two.)

A. Web Server

B. Data Server

C. Application Server

D. WebSphere Administration Server

E. Mining Server

Correct Answer: B,C

Question 3

What are two primary goals of denormalization? (Choose two.)

A. to simplify the querying of the database

B. to improve performance of a system

C. to decrease the redundancy of data within a database

D. to increase the number of tables in the model

E. to allow for data compression

Correct Answer: A,B

Question 4

What does a Data Design Project within Design Studio contain?

A. SQW work flows

B. data mining flows

C. logical data model

D. physical data model

Correct Answer: D

Question 5

When debugging a data flow, how do you set a break point in the execution plan graph (EPG)?

A. Select Set Breakpoint on a connector.

B. Select Set Breakpoint on a node.

C. Select Toggle Breakpoint on a node.

D. Select Toggle Breakpoint on a connector.

Correct Answer: C

Question 6

Which two functions can the Design Studio perform? (Choose two.)

A. Drop cube models from the InfoSphere Warehouse metadata database.

B. Rebuild an OLAP cube's member cache.

C. Move and transform data.

D. Add an OLAP cube to the cube server.

E. Run the Optimization Advisor and analyze whether the recommended MQTs will be used given a predefined workload.

Correct Answer: A,C

Question 7

Which two modeling techniques are similar in nature in performing prediction except for the type of the predicted value it uses? (For example, one predicts a class label, the other predicts a numeric value.) (Choose two.)

A. Regression

B. Classification

C. Associations

D. Sequencing

E. Clustering

Correct Answer: A,B

Question 8

Click the Exhibit button.
The diagram in the exhibit illustrates which SQW flows? (Choose two.)

A. data flow

B. subflow

C. mining flow

D. control flow

E. subprocess

Correct Answer: B,C

Question 9

Customer Relationship Management (CRM) requires business insights that enable firms to offer specific, personalized services, and products to their customers. Which mining method is used for customer segmentation CRM applications?

A. Regression

B. Association

C. Sequencing

D. Clustering

Correct Answer: D

Question 10

What is meant by "Information as a Service"?

A. expanding a traditional data warehouse with XML capabilities for the data

B. extending the traditional data warehouse by providing business context layers to the data

C. storing all analytical data in a multidimensional cube instead of a traditional data warehouse

D. accessing a traditional data warehouse with a Web-based application for the data

Correct Answer: B

Welcome to TestSimulate

IBM InfoSphere Warehouse V9.5 (C2090-719) Free Practice Test