IBM COG-625 Actual Free Exam Questions & Community Discussion

Exam Code/Number: COG-625
Exam Name/Title: IBM Cognos 10 BI Data Warehouse Developer
Certification Provider: IBM
Corresponding Certification: IBM Cognos

Exam Questions: 84
Updated On: Sep 05, 2026

Question #1

When delivering fact data to a text file, what can be specified?

A. Whether the file is in ASCII or EBCDIC format

B. Line and field delimiters

C. Default text editor to use with the file

D. Maximum number of rows to be stored in the file

Discussion 0

Correct Answer: B Vote an answer

Question #2

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

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

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/INSERT.

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

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

Discussion 0

Correct Answer: D Vote an answer

Question #3

A developer has created a fact build to process the incoming data shown in the table:

The developer wants to create a monthly summary fact table. If the aggregate behavior for the Credit Limit column is set to LAST, what will be the value of Credit Limit for the first row delivered for Customer 2?

A. 500

B. 1200

C. 1500

D. 1100

Discussion 0

Correct Answer: B Vote an answer

Question #4

A developer wants to move a selection of components from a development environment to a production environment. What should the developer do?

A. Create a SQL script to transfer the components.

B. Create a package file (.pkg).

C. Create a catalog backup file (.ctg).

D. Create a JobStream to transfer the components..

Discussion 0

Correct Answer: B Vote an answer

Question #5

Which of the following is true of pivoting?

A. Each data source column in the array must be mapped to a corresponding pivot value.

B. It decreases the number of output rows.

C. Each data source column in the array must be mapped to a pivot derivation element.

D. It increases the number of output columns.

Discussion 0

Correct Answer: A Vote an answer

Question #6

A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?

A. Derived dimension

B. Derivation

C. Lookup

D. Dimension

E. Hierarchy

Discussion 0

Correct Answer: E Vote an answer

Question #7

A developer has created a fact build where separate summary tables will be created for monthly and quarterly data. What should be created on these fact deliveries to prevent monthly data from being delivered to the quarterly summary table?

A. Level filters

B. User-defined functions

C. Output filters

D. Derivations

Discussion 0

Correct Answer: A Vote an answer

Question #8

What is depicted below?

A. How the items in the DataStream will be output to the columns of a fact table.

B. How the elements of the transformation model will be output to the columns of a fact table.

C. How the columns of the data source map to the elements of the transformation model.

D. How the elements of the transformation model will be output to the columns of a dimension table.

E. How the items in the DataStream will be output to the columns of a dimension table.

Discussion 0

Correct Answer: C Vote an answer

Question #9

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 fact build delivery.

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

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

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

Discussion 0

Correct Answer: A Vote an answer

Download Free IBM COG-625 Demo

Simply submit your e-mail address below to get started with our free demo of your IBM COG-625 exam.