Number of questions: 65
Time allowed in minutes: 90
Required passing score: 76%
Languages: English, Japanese
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI
IBM Certified Developer – Cognos 10 BI OLAP Models
The Cognos 10 BI OLAP 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.
Transformer Basics (5%)
Describe the Transformer development process
Data Sources (12%)
Identify data sources for use in Transformer
Describe the use of multiple data sources
Model Creation (17%)
Describe the process to build a basic Transformer model
Describe the implementation of a time dimension
Describe how to make data available in the Cognos 10 studios
Model Key Performance Measures (12%)
Differentiate between measures
Describe the use of measures
Describe the IBM Cognos 10 security environment
Describe how to secure a PowerCube
PowerCube Content Customization (20%)
Define techniques to customize dimensions
Describe the process to customize PowerCube content
Maintenance and Advanced Techniques (22%)
Describe techniques for model maintenance
Describe how to update published PowerCubes and PowerCube connections
Identify ways to trouble shoot issues
Identify considerations for optimization
Describe changes that impact MUNs
What should a developer do if some levels appear red after validating the model using Show Scope?
A. Ensure the level exists in the data source.
B. Specify a valid relationship between the level and the data source.
C. Re-attach the categories in the Dimension Diagram.
D. Apply unique move to the level and regenerate the categories.
When measures are calculated after rollup, when are the calculations performed?
A. Before time state rollup takes place.
B. After allocated measures are calculated.
C. Before regular rollup takes place on all measures.
D. After relative time calculations.
What objects can be created within the Cognos Namespace?
A. Roles and users
B. Groups and roles
C. Groups and users
Transformer is unable to locate one of the source files for a data source in the model, and
the model update fails. Which type of files can be used to restart the processing at the point of failure?