IBM COG-625 問題集

質問 1：
Incoming records show the number of drink packs sold by date. This information is referenced by lookups. Each drink pack contains two or more individual drinks. The developer wants to add a column to the fact table that shows how many individual drinks have been sold, not how many drink packs have been sold. What should be created to accomplish this?
A. DataStream derivation
B. Derived measure
C. Data source derivation
D. Derived dimension
正解：D

質問 2：
A developer wants to execute a fact build in a test environment. In order to ensure optimum performance, the developer wants to see messages related to resource usage (such as paging information), in case the build needs to be modified. What type of messages are these?
A. ExecutedSQL
B. Internal
C. Detail
D. User
正解：B

質問 3：
The data in the Product dimension table appears as follows:

What is one of the things that must be done to ensure that all of these records are delivered into the dimension table?
A. In the properties of the dimension table, specify that late arriving dimension details are to be written to a table.
B. In the properties of the template that is used to deliver the dimension build, include an attribute with effective start date behavior.
C. In the properties of the underlying hierarchy, set the Unbalanced Hierarchy feature to Accept.
D. In the properties of the underlying hierarchy, set the Multiple Parents feature to Accept.
正解：B

質問 4：
Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?
A. Accept unmatched member identifiers in the measure element properties.
B. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
C. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.
D. Modify the SQL for the reference structure to exclude the missing product codes.
正解：C

質問 5：
A developer wants to create a connection to a published Framework Manager package in a Data Manager catalog. Before this connection can be created successfully, what must the developer do?
A. Create a data source connection to the Cognos 8 data store.
B. Add an LDAP or NTLM namespace in Cognos Configuration.
C. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.
D. Log on to Cognos Connection as a user in the Data Manager Authors role.
正解：C

質問 6：
Which of the following is true of a derivation that has been created in the transformation model?
A. The derivation can be added to a dimension build delivery.
B. The derivation cannot be disabled once it has been added to the transformation model.
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

質問 7：
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 TRUNCATE.
C. Set the refresh type for the relational table delivery module to REPLACE.
D. Set the refresh type for the relational table delivery module to UPDATE.
E. Set the refresh type for the relational table delivery module to APPEND.
F. Set the refresh type for the relational table delivery module to UPDATE/INSERT.
正解：F

質問 8：
Which of the following is true of transformation model derivations?
A. They can be used as sources for an attribute element.
B. They can be created within a static member.
C. They can consist of a string literal.
D. They can be used as sources for a measure element.
正解：C