Test information:
Number of questions: 53
Time allowed in minutes: 60
Required passing score: 71%
Former exam code was BI0-132.
Test COG-132: IBM Cognos 8 BI Metadata Model Developer
The Cognos 8 BI Metadata Model 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.
Common Data Structures and Traps (16%)
Identify Common Data Structures
Identify different data traps
Framework Manager Basics (16%)
Identify the different model types that can be published from Framework Manager
Define the purpose of Framework Manager
Create a project
Identify recommendations for preparing metadata
Predictable Results (16%)
Identify recommendations to achieve predictable results
Describe why and how to implement a time dimension
Identify techniques for creating intuitive business views
Security (9%)
Describe the Cognos 8 security environment
Describe how to implement security on models and packages
Project Management and Maintenance (5%)
Identify techniques for managing Framework Manager projects
Identify techniques for managing Framework Manager packages
Query Subject Types (9%)
Identify different query subject types and uses
Generated SQL and Complex Queries (18%)
Identify SQL Generation in Complex Queries
Identify aggregated result sets for multi-fact queries
Identify aggregations in Report Studio SQL
Optimization and Tuning (5%)
Describe the performance impact of queries
Advanced Techniques (7%)
Describe how to leverage user defined functions
Describe how to resolve a recursive relationship
Identify considerations for drill-through values and managing MUNs