IBM C2020-625 Actual Free Exam Questions & Community Discussion

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

Exam Questions: 84
Updated On: Sep 06, 2026

Question #19

A fact build has been created that includes a Product Code dimension element. Each incoming product code must match a corresponding row in the Product dimension. What should the developer do?

A. Create an output filter and reference the output filter in the Product Code element.

B. Create a template and reference the template in the Product Code element.

C. Create a second dimension element in the transformation model that will check for valid product codes.

D. Create an attribute element in the transformation model that will check for valid product codes.

E. Create a lookup to the dimension and reference the lookup in the Product Code element.

Discussion 0

Correct Answer: E Vote an answer

Question #20

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. Create a data source connection to the Cognos 8 data store.

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

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

Discussion 0

Correct Answer: A Vote an answer

Question #21

A fact build has two data sources that need to undergo the same calculation for every input row, and the data will be merged. Where should the derivation be created?

A. In the DataStream.

B. In the transformation model.

C. In the output filter.

D. In each data source.

Discussion 0

Correct Answer: A Vote an answer

Question #22

A developer wants to be able to re-use a gross profit calculation in multiple builds. What should be created?

A. Measure

B. Derived dimension

C. Derivation

D. Attribute

E. User-defined function

Discussion 0

Correct Answer: E Vote an answer

Question #23

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 #24

A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?

A. Navigator

B. SQLTXT Designer

C. Hierachy wizard

D. Reference Explorer

E. SQLTerm

Discussion 0

Correct Answer: D Vote an answer

Question #25

To reduce memory usage, what should be done when setting up dimension breaking for a fact build?

A. Disable the hash table and page pool for the fact build.

B. Disable late arriving facts processing for the fact build.

C. Specify at least one aggregate rule for each dimension element for which breaking is enabled.

D. Ensure that each data source is sorted by the same set of dimensions, in the same sequence.

Discussion 0

Correct Answer: D Vote an answer

Question #26

Which element does Data Manager use to identify duplicate rows?

A. Measure

B. Attribute

C. Dimension

D. Index

Discussion 0

Correct Answer: C Vote an answer

Question #27

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

Download Free IBM C2020-625 Demo

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