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

問題1

Below, what does Unknown Class (?Class) represent?

A. Manual level

B. Recursive level

C. Foster parent

D. Literal

正確答案: C

問題2

Which of the following is true of a derivation that has been created in the transformation model?

A. The derivation cannot be disabled once it has been added to the transformation model.

B. The derivation can be added to a dimension build delivery.

C. The derivation can be added to a fact build delivery.

D. The derivation can be used to perform calculations in the SQL statement of a data source.

正確答案: C

問題3

What can Data Manager be used for?

A. To extract operational data from multiple sources.

B. To create a metric store.

C. To create a content store.

D. To build an IBM Cognos Planning application.

正確答案: A

問題4

Which of the following is a potential challenge when developing conformed dimensions?

A. A developer may need to manually track changes to dimensional history by creating derived dimensions.

B. A DataStream must be manually created for each conformed dimension's data source.

C. Dimensional keys may be different across source systems and need to be standardized.

D. A developer may need to manually track changes to dimensional history by creating derivations.

E. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.

正確答案: C

問題5

Which would be reasons for modifying a hierarchy that was previously created using the Hierarchy wizard? (Choosetwo)

A. To add a level to the hierarchy.

B. To add a measure element to the hierarchy.

C. To add a derived dimension element to the hierarchy.

D. To specify a metadata dimension for the hierarchy.

E. To specify a fact build for the hierarchy.

F. To add an attribute to a hierarchy level.

正確答案: A,F

問題6

A developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?

A. Identifier

B. Member determinant

C. Lookup

D. Dimensional determinant

正確答案: C

問題7

A dimension table tracks employee data. If an employee's work location changes, the previous work location needs to be kept and a new record needs to be created. What kind of change is this?

A. Type 1

B. Type 0

C. Type 2

D. Type 3

正確答案: C

問題8

A developer wants to deliver fact data to a relational table. When the fact build is executed, any new rows must be added to this table. However, if an incoming row has the same key as a row that already exists in this table, the existing row must be updated accordingly. What should the developer do?

A. Set the refresh type for the relational table delivery module to INSERT.

B. Set the refresh type for the relational table delivery module to APPEND.

C. Set the refresh type for the relational table delivery module to TRUNCATE.

D. Set the refresh type for the relational table delivery module to UPDATE/INSERT.

E. Set the refresh type for the relational table delivery module to REPLACE.

F. Set the refresh type for the relational table delivery module to UPDATE.

正確答案: D

問題9

In the Dimension Build wizard, the developer has specified the schema type as "Star schema." What will be the result of this selection?

A. The dimension will be represented in a single table. Each row of this table will contain the ID of the member, together with the ID of its parent.

B. The dimension will be represented in a single table. Each level of the delivered hierarchy will be represented by one or more columns of this table.

C. The dimension will be represented by one table for each hierarchy level. Each table will have a foreign key to the level above.

D. The dimension will be represented in a table that contains only the keys of all the levels of the delivered hierarchy. The descriptions of the higher levels will reside in other tables.

正確答案: B

最新的IBM Cognos 10 BI Data Warehouse Developer - C2090-625免費考試真題

聯系我們

站內鏈接

最新更新