IBM Cognos 10 BI Scorecard Developer - C2090-642 Exam Questions [2026]

QUESTION NO: 1
The exhibit shows the monthly values for a specific metric and the rolled up quarterly values. Which rollup rule is applied?

A. Last of individual values B. Average of individual values C. Max of individual values D. Sum of individual values

Correct Answer: B

QUESTION NO: 2
When publishing a metric extract, which of the following is optional?

A. Transfer from staging to metric store B. Import data into staging tables C. Re-calculate values D. Create the job

Correct Answer: D

QUESTION NO: 3
The metric administrator has noticed that previous loads have failed. What should be done by the metric administrator in order to isolate the issue when the load is next run?

A. Recalculate metric store derived values B. Clear staging area of rejected data logs C. Update the search engine index D. Clear metric history and calendar data

Correct Answer: B

QUESTION NO: 4
A scorecard application has been implemented using the balanced model, where four scorecards were created for each perspective. Which perspectives contain the following metrics?
* Defects per unit
* Number of returns
* Number of recalls

A. Financial and Customer B. Customer and Internal Process C. Internal Process and Learning and Growth D. Financial and Learning and Growth

Correct Answer: B

QUESTION NO: 5
What type of diagram shows inventory metrics in different sales territories?

A. Impact diagram B. Geographical diagram C. Strategy map diagram D. Process diagram

Correct Answer: B

QUESTION NO: 6
The data that needs to be populated in the metric store requires consolidation and data cleansing from various data sources. What is the MOST appropriate data loading technique to accomplish this?

A. SQL scripts (structured query language) B. Metric Designer C. An ETL tool (extraction, transformation, and loading) D. Manual entry

Correct Answer: C

QUESTION NO: 7
What must be done to load the data successfully into Metric Studio using structured query language (SQL) scripts?

A. Perform the task Recalculate metric store derived values after each script execution. B. Structure the query language to map data from the relational database to the staging tables C. Structure the query language to map data from the relational database to the content store. D. Perform the task Import data from files into staging area after each script execution

Correct Answer: B

QUESTION NO: 8
What is the importance of assigning an owner?

A. To assign actions to a metric B. To allow tracking of accountability on an impact diagram C. To allow tracking of accountability on a metric D. To apply permissions to a metric

Correct Answer: C