Free IBM COG-625 Practice Test & Real Exam Questions

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: Oct 20, 2026

Question #1

Where can a developer define variables in Data Manager?

A. Metadata collections

B. Metadata dimensions

C. Connections

D. JobStreams

Discussion 0

Correct Answer: D Vote an answer

Question #2

The following hierarchy has been created:

Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?

A. Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.

B. Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.

C. Specify that duplicate rows are to be rejected on the Audit tab of the dimension build's properties.

D. Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.

Discussion 0

Correct Answer: A Vote an answer

Question #3

A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). What should be done?

A. Create a measure dimension which references the conversion rate.

B. Move the lookup to a fact build conversion map.

C. Create a derivation which uses the reference atttributes of the lookup.

D. Reference the lookup in the properties of the affected dimension build(s).

Discussion 0

Correct Answer: C Vote an answer

Question #4

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. Configure Data Manager to access the Cognos 8 Gateway and Dispatcher URLs.

B. Log on to Cognos Connection as a user in the Data Manager Authors role.

C. Create a data source connection to the Cognos 8 data store.

D. Add an LDAP or NTLM namespace in Cognos Configuration.

Discussion 0

Correct Answer: A Vote an answer

Question #5

What kind of tool is Data Manager?

A. CRM

B. PDM

C. ERP

D. ETL

Discussion 0

Correct Answer: D Vote an answer

Question #6

Which of the following is an advantage of using conformed dimensions in a data warehouse?

A. Conformed dimensions enable users to drill from one area of their business to another.

B. Conformed dimensions enable database views to be reused across the data warehouse.

C. Conformed dimensions do not require the use of lookups.

D. Conformed dimensions do not require the use of surrogate keys.

Discussion 0

Correct Answer: A Vote an answer

Question #7

Where can a variable be declared?

A. In a build specification.

B. In a data source connection.

C. In a hierarchy.

D. In a Data Manager folder.

Discussion 0

Correct Answer: A Vote an answer

Question #8

A developer has created a fact build to process the incoming data shown in the table: The build has been set to merge records with duplicate keys. Both the Customer and Date columns represent dimension elements. If the merge behavior for the Amount column is set to SUM, what will be the value of Amount for the first row delivered for customer 2?

A. 1200

B. 700

C. 500

D. 200

Discussion 0

Correct Answer: C Vote an answer

Question #9

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

A. Manual level

B. Recursive level

C. Foster parent

D. Literal

Discussion 0

Correct Answer: C 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.