IBM Cognos 10 BI Data Warehouse Developer - C2090-625 Exam Questions [2026]

QUESTION NO: 1
A developer is working with the following relational table data source:

What should be done?

A. Create an output filter to flip the rows and columns. B. Create a user-defined function to flip the rows and columns. C. Define how the data will be pivoted in the DataStream of the fact build. D. Define how the data will be pivoted in the Delivery of the fact build.

Correct Answer: C

QUESTION NO: 2
Without modifying any of the settings,

what is the lowest level of granularity that will be shown in the Reference Explorer?

A. AllStaff B. Staff C. SalesStaff D. Staff (H)

Correct Answer: B

QUESTION NO: 3
Incoming fact data includes an audit reference column for each row. This column has been identified as an attribute in the transformation model. When executed, the fact build should designate this element as a key in the resulting fact table. This fact table will be created (not updated) by the fact build. What should the developer do?

A. Convert the attribute element into a derived dimension element. B. Specify the column as a key in the data source properties. C. Convert the attribute element into a derivation element. D. Specify the column as a key in the table delivery properties.

Correct Answer: D

QUESTION NO: 4
Why would an index be created on a fact table?

A. To enable the merging of duplicate rows. B. To make it easier to drop and recreate the fact table. C. To enable the rejecting of duplicate rows. D. To improve update performance on a relational delivery.

Correct Answer: D

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

A. Specify at least one aggregate rule for each dimension element for which breaking is enabled. B. Disable late arriving facts processing for the fact build. C. Ensure that each data source is sorted by the same set of dimensions, in the same sequence. D. Disable the hash table and page pool for the fact build.

Correct Answer: C

QUESTION NO: 6
A dimension table contains the following data:

If late arriving fact processing is enabled, what will be the value of the surrogate key assigned to the last row of fact data?

A. 11113 B. 11110 C. 11111 D. 11112

Correct Answer: C

QUESTION NO: 7
When executing a fact build, a developer wants to estimate the amount of input resources that the build will require, but does not want to deliver any data. What execution mode should be selected?

A. Test B. Object Creation C. Check Only D. Preproduction

Correct Answer: C

QUESTION NO: 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 dimension 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 fact table. E. How the items in the DataStream will be output to the columns of a dimension table.

Correct Answer: C

QUESTION NO: 9
Which of the following can a developer do with SQLTXT Designer?

A. Select data from multiple tables using joins. B. Specify sort order for the flat file. C. Specify row and column delimiters. D. Select data from multiple text files using joins.

Correct Answer: C