Number of questions: 53
Time allowed in minutes: 60
Required passing score: 71%
Languages: English, French, Japanese
IBM Certified Advanced Developer – Risk Information Governance for BI
IBM Certified Solution Expert – Cognos BI
IBM Certified Developer – Cognos 10 BI Metadata Models
IBM Certified Solution Expert – Cognos 8 BI Migration
The Cognos 10 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
Describe the Cognos 10 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 (17%)
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
Which of the following is correct regarding the Cognos 10 security environment?
A. Cognos 10 must be configured to use only one authentication provider at a time.
B. To perform authentication of users, a connection to the Cognos namespace must be defined.
C. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.
D. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.
In Framework Manager, which of the following statements is correct when working with a multi-lingual project?
A. The design language can be changed at any point.
B. A project language cannot be deleted once defined in Framework Manager.
C. A language must be added to the project before it can be published with a package.
D. When a new language is added to a project, all locales for that language are added as well.
The groups and roles defined in the Cognos namespace can be used to assign access rights to which of the following Framework Manager objects?
A. Query items.
B. Data sources.
D. Parameter maps.
What must a modeler consider when modeling for drill-through between multiple data sources?
A. Drill-through values must be cast.
B. Drill-through values must be conformed.
C. Drill-through values must be consolidated.
D. Drill-through values must be identifiers.