最新的IBM C2090-719免費考試真題

問題1

A customer wants to include analysis of product sales for their locations at various levels of their product lines and various levels of their geography. Which two schema considerations are necessary to satisfy the requirement? (Choose two.)

A. a product dimension with location attributes

B. a product dimension with geography hierarchies

C. a location dimension with product attributes

D. a location dimension with geography hierarchies

E. a product dimension with product line hierarchies

正確答案: D,E

問題2

For recovery purposes, it is desired to keep the output of several data flow operators after the execution has ended. This can be done in two different ways. Which two types of operators and properties would you use to keep the output? (Choose two.)

A. A Data Station operator with a type of view and a view name.

B. A Data Station operator with a type of persistent table and a table name.

C. A Data Station operator with a type of temporary table and a table name.

D. A Data Station operator defined as pass through.

E. A Data Station operator with a type of file and a file name.

正確答案: B,E

問題3

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

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

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

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

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

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

正確答案: D,E

問題4

What does a Data Design Project within Design Studio contain?

A. logical data model

B. SQW work flows

C. data mining flows

D. physical data model

正確答案: D

問題5

What are three valid control flow components?

A. operators, variables, connections

B. process flow, subflow, flow charts

C. sources, transformers, targets

D. stored procedures, triggers, subprocess

正確答案: A

問題6

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

A. control flow

B. mining flow

C. subprocess

D. subflow

E. data flow

正確答案: B,D

問題7

An administrator has created a database connection to the Production transactional relational database. A data mart is desired that extracts data from that database. Taking time and ease into account, how should the database physical model for the input tables be created?

A. The physical data model must be converted to a logical data model which can be imported intoDesign Studio.

B. The physical database must be used to create DDL which is then reverse engineered in Design Studio.

C. The physical database objects can be reverse engineered in Design Studio.

D. The physical database objects can be imported into Design Studio.

正確答案: C

問題8

Using InfoSphere Warehouse a physical data model provides the metadata for database objects that are useful for which task?

A. when designing data flows

B. when designing remote flows

C. when designing process flows

D. when designing work flows

正確答案: A

問題9

When connecting an Output Port of a Table Source to the Names Port of a Sequences Operator, what are two valid methods of mapping columns? (Choose two.)

A. by Index

B. by Position

C. by Key

D. by Name

E. by Attribute

正確答案: B,D

問題10

You are implementing a DB2 Workload Manager (WLM) schema to limit the number of load utilities that can execute concurrently. Which WLM object would be used to accomplish this?

A. work class with an associated service class and an appropriate threshold

B. workload with an associated work action and an appropriate threshold

C. work class with an associated work action and an appropriate threshold

D. workload with an associated service class and an appropriate threshold

正確答案: C

最新的IBM InfoSphere Warehouse V9.5 - C2090-719免費考試真題

聯系我們

站內鏈接

最新更新