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: May 30, 2026

Question #10

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

B. 1200

C. 700

D. 200

Discussion 0

Correct Answer: A Vote an answer

Question #11

A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?

A. ODBC Administrator

B. SQLTXT Designer

C. Reference Explorer

D. SQLTerm

Discussion 0

Correct Answer: D Vote an answer

Question #12

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

A. Literal

B. Manual level

C. Recursive level

D. Foster parent

Discussion 0

Correct Answer: D Vote an answer

Question #13

What kind of tool is Data Manager?

A. PDM

B. ETL

C. ERP

D. CRM

Discussion 0

Correct Answer: B Vote an answer

Question #14

A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). If the incoming currency is not available through the lookup, what can be done to prevent the fact row from being rejected?

A. Create a derivation to insert a default value.

B. Accept unmatched member identifiers.

C. Set the "value if null" property on the table delivery.

D. Create a derived dimension to create a default value.

Discussion 0

Correct Answer: B Vote an answer

Question #15

Why has the developer selected the Output box for the ProductLine row?

A. To allow duplicate rows of incoming data at the ProductLine level.

B. To create detail level rows.

C. To merge duplicate rows of incoming data at the ProductLine level.

D. To create summary level rows.

Discussion 0

Correct Answer: D Vote an answer

Question #16

Which of the following is true of transformation model derivations?

A. They can consist of a string literal.

B. They can be created within a static member.

C. They can be used as sources for an attribute element.

D. They can be used as sources for a measure element.

Discussion 0

Correct Answer: A Vote an answer

Question #17

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. Data source derivation

C. Derived dimension

D. Derived measure

Discussion 0

Correct Answer: C Vote an answer

Question #18

Several conformed dimensions have been defined and must now be delivered to the data warehouse. Which is the best way to do this?

A. Deliver the dimension tables as part of a metadata collection.

B. Create a metadata dimension and add it to a metadata star.

C. Deliver the dimension tables through dimension builds.

D. Run the necessary CREATE TABLE statements in SQLTXT.

Discussion 0

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