IBM C2090-625 Actual Free Exam Questions & Community Discussion

Exam Code/Number: C2090-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 #19

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

A developer wants to create a connection to a database in a Data Manager catalog. When creating this connection, which of the following must the developer specify?

A. Names and port numbers of for Data Manager socket servers.

B. Location of the .ctg file..

C. A default schema name.

D. Method used to connect to the database.

Discussion 0

Correct Answer: D Vote an answer

Question #21

Which of the following is a use for a fact build?

A. To deliver fact data into a metadata star.

B. To acquire and transform transactional data.

C. To automate tasks related to the build process.

D. To deliver fact data into a dimensional framework.

Discussion 0

Correct Answer: B Vote an answer

Question #22

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

What kind of tool is Data Manager?

A. PDM

B. ETL

C. ERP

D. CRM

Discussion 0

Correct Answer: B Vote an answer

Question #24

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

Question #25

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

Which of the following is are characteristics of surrogate keys? (choose three)

A. Are unique.

B. Have no intrinsic meaning.

C. Are replaced by business keys in the data warehouse.

D. Are numbers.

E. Tend to be larger than keys from operational systems.

F. Are text-based.

Discussion 0

Correct Answer: A,B,D Vote an answer

Question #27

Which of the following is a potential challenge when developing conformed dimensions?

A. A DataStream must be manually created for each conformed dimension's data source.

B. Dimensional keys may be different across source systems and need to be standardized.

C. A developer may need to manually track changes to dimensional history by creating derived dimensions.

D. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.

E. A developer may need to manually track changes to dimensional history by creating derivations.

Discussion 0

Correct Answer: B Vote an answer

Download Free IBM C2090-625 Demo

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