C2090-642 IBM Cognos 10 BI Scorecard Developer

Test information:
Number of questions: 75
Time allowed in minutes: 90
Required passing score: 66%
Languages: English

Related certifications:
IBM Certified Developer – Cognos 10 BI Scorecards
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI

The IBM Cognos 10 BI Scorecard Developer exam covers key concepts, technologies, and functionality of the Cognos products. In preparation for an exam, we recommend a combination of training and hands-on experience, and a detailed review of product documentation.

Plan the Scorecard Application (5%)
Identify the components of Metric Studio architecture
Identify different scorecarding methodologies
Identify supported data sources for various types of data loading

Monitor Performance with Metrics (5%)
Describe the differences between the calendar control options
Identify methods of aligning performance with strategic objectives
Describe various methods of taking action on metrics

Define the Application Environment (20%)
Distinguish between the content store and metric store
Identify the various steps of creating a package
Identify the appropriate metric type performance pattern for a metric type
Identify the score calculations used for the tolerance-based method and threshold-based method
Describe the function of any of the score settings
Identify the appropriate use for the various rollup types
Identify the appropriate use of a qualifier
Identify the need for accountability on a metric
Describe scenarios for creating metric tasks

Load Data into the Scorecard Application (15%)
Distinguish between the different data management processes used to import and recalculate data
Distinguish between the three metric maintenance tasks that clear data
Define how a score is calculated
Identify the differences between the different trend options
Describe a business requirement that is satisfied by creating a formula-based calculated metric or a derived index metric
Identify the architectural components that are used as data moves through its various loading stages
Describe when typing in values is a valid data loading technique
Interpret the derived index score

Load Data Using IBM Cognos Metric Designer (8%)
Identify the supported data sources in Metric Designer
Distinguish between an object extract and a metric extract
Distinguish between executing and publishing extracts
Describe the process of creating a metric extract

Load Data Using Flat Files and SQL Server Scripts (11%)
Define the relationship between flat files and staging tables
Identify flat files by their extensions and explain what objects they support
Identify the process of checking for errors when loading flat files
Distinguish between various methods of deleting data from the metric store
Describe the process of how a SQL script loads data into the metric store

Refine the Scorecard Application (24%)
Identify the results of the different group roll up rules
Identify the options for handling metrics that are not included in any group
Describe the functionality in the settings for organizing group views
Identify the business purpose of impact diagrams and custom diagrams
Identify the methods for linking diagrams to scorecards
Identify the types of reports that can be added to metrics and scorecards
Describe the objects in the metric studio package that can be used to create Cognos BI reports
Describe how Metric Studio default and custom parameters can be used in Cognos BI reports
Describe the process of adding a watch list portlet
Identify the use of navigation paths and distinguish it from the Home View
Identify the conceptual relationship between group type and group

Secure the Scorecard Application (4%)
Identify the different permissions
Describe the importance of assigning the metric store administrator
Describe the nature of permission inheritance

Maintain the Scorecard Application (8%)
Describe the various import data settings
Describe the process of creating user-defined columns
Describe the effect of switching from three to five state indicators
Describe the effect of creating custom units
QUESTION 1
Which of the following can an administrator specify for a strategy element?

A. Scorecards to be included
B. Default color
C. Date range
D. Owner

Answer: D

QUESTION 2
A metric’s actual value may be significantly different than its target value during a particular period. Which of the following determines how much variance from the target is acceptable?

A. Calendar rollup value
B. Tolerance value
C. Planned finish value
D. Benchmark value

Answer: B

QUESTION 3
What must be done to import tab-delimited files from a previous version of Metric Studio?

A. Create staging tables for the previous version
B. Specify the file format as the previous version
C. Indicate the file version in the appropriate column of the tab-delimited file
D. Modify the staging tables to match the tab-delimited files from the previous version

Answer: B

QUESTION 4
How can a user view their most important metrics in Cognos Connection?

A. Add a Metric List portlet to Cognos Connection.
B. Add an Extended Applications portlet to Cognos Connection.
C. Add a Navigator portlet to Cognos Connections.
D. Add a Bookmarks Viewer portlet to Cognos Connection.

Answer: A

QUESTION 5
The HR department is required to monitor headcount. which is a metric type defined as ‘On Target is Positive’. The target is 1000 and the range for on target is positive is 50%. The
tolerance is 10%. What is the range of values for the upper yellow band?

A. 1001-1050
B. 1051-1150
C. 1101-1150
D. 1101-1199

Answer: B

Click here to view complete Q&A of C2090-642 exam
Certkingdom Review, Certkingdom PDF