Limited Time Discount Offer
30% Off - Ends in 02:00:00

X

IBM C2090-719 Dumps

IBM
InfoSphere Warehouse V9.5
IBM
InfoSphere Warehouse V9.5

Questions & Answers for IBM C2090-719

Showing 1-15 of 93 Questions

Question #1

Click the Exhibit button.
Referring to the exhibit, control flow operators can be grouped as subprocesses. Control
flows are grouped into warehouse applications. Warehouse applications are deployed to
the Admin Console. Once a warehouse application has been deployed, the names of the
objects that make up the warehouse application change. Within the Admin Console what is
the highest level object that can be scheduled?

A. a deployed application

B. a subprocess

C. an activity

D. a process

Question #2

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

A. Mining Server

B. Application Server

C. Web Server

D. Data Server

E. WebSphere Administration Server

Question #3

Which statement describes the conceptual data model?

A. The conceptual data model is where the data model actually gets defined.

B. The conceptual data model includes the DDL file for the warehouse.

C. The conceptual data model is a high-level business view of the data.

D. The conceptual data model contains the configuration, keys, indexes selected, and constraints.

Question #4

What is a benefit of using warehouse based analytics?

A. It provides more functions in the available calculation set.

B. It ensures the user response time will always be fast.

C. It provides end users the ability to add additional calculations at report time.

D. It provides a common pool of analytic methods to produce consistent answers across all users.

Question #5

If you roll-in daily and roll-out monthly, which approach reduces the number of table
partitions and eases the DBA administrative tasks?

A. Specify a MDC on day and a table partition key for day.

B. Specify a MDC on day and a table partition key for month.

C. Specify a MDC on month and a table partition key for month.

D. Specify a MDC on month and a table partition key for day.

Question #6

A customer wants to evaluate deep data compression in an AIX development environment.
Which edition of InfoSphere Warehouse should they buy?

A. InfoSphere Warehouse Base

B. InfoSphere Warehouse Intermediate

C. InfoSphere Warehouse Advanced

D. InfoSphere Warehouse Developer

Question #7

Which two InfoSphere Warehouse components are included in the logical group for the
Application Server? (Choose two.)

A. IBM Data Server Client

B. Intelligent Miner Visualization

C. WebSphere Application Server

D. Workload Management plug-in

E. Design Studio

Question #8

Input variables allow variable values to be passed to data flows, mining flows and
subprocesses. What supports output variables?

A. data flows

B. mining flows

C. subprocesses

D. subflows

Question #9

During which installation and configuration process can user groups be mapped to each
role?

A. the installation of InfoSphere Warehouse Server for the Administration node

B. the installation of InfoSphere Warehouse Server for Data node

C. the installation of WebSphere Application Server

D. the execution of the InfoSphere Warehouse Configuration Tool

Question #10

What are two ways MDCs provide features that facilitate the roll-in and roll-out of data?
(Choose two.)

A. Inserts are faster because MDC can quickly create new empty blocks.

B. Inserts are faster because the block index is only updated once the block is deleted.

C. There is only a need to REORG data after roll-out.

D. Locking is reduced for inserts because they occur at a block level rather than at a row level.

E. There is no need to REORG data after roll-in and roll-out.

Question #11

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 General Properties page, specify a hierarchy name.

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

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

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".

Question #12

What correctly describes how the InfoSphere Intelligent Miner components are used for
predictive modeling?

A. The scoring component is first invoked to score an existing model to generate a new predicted value. This value is then used by the modeling component to generate a new predictive model.

B. The modeling component creates a new mining model based on existing data. The scoring component then trains and applies this model to new data in a DB2 table to generate a predicted value.

C. The modeling process is first invoked to create and train the prediction model based on existing data. The scoring process then applies this model to new data to generate a predicted value.

D. The visualization component can only be used to view the scoring results. The model can beviewed by the modeling component.

Question #13

Which two statements are true about a hierarchies, levels, and dimensions? (Choose two.)

A. A hierarchy object is an ordered list of level objects.

B. A hierarchy object is an ordered list of dimension objects.

C. Each dimension can have multiple hierarchies.

D. Levels store information about how the hierarchies within a dimension are related to each other and how they are structured.

E. Dimensions store information about how the hierarchies within a level are related to each other and how they are structured.

Question #14

Which statement is true about iterator operators?

A. They can be controlled by either variable values or file input.

B. They are used in data flows where a number of tables are combined.

C. They are needed for processing tables that contain slowly changing dimensions.

D. They are used as the first step in application development.

Question #15

You want an employee to be able to create, deploy, and schedule applications in the
InfoSphere Warehouse. At a minimum, which roles should be assigned to the employee?

A. Administrator and Manager

B. Manager and Operator

C. Administrator and Operator

D. Administrator, Manager, and Power User

×