Number of questions: 66
Time allowed in minutes: 90
Required passing score: 71%
The Cognos BI Professional 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.
Iterative Development and CSIM (9%)
Identify different approaches for implementing BI projects
Identify the value of using a methodology
Distinguish between an approach and a methodology
Describe the iterative development process
Dimensional Design and Key Metrics (14%)
Describe the relationship between dimensions, facts, and granularity
Identify the differences between SQL and MDX
Define the Key Performance Indicators and identify their business purpose
Map Cognos components to KPI process flow
Describe the functional and organizational scope of Corporate Performance Management
Identify the Right Tool for the Business Need (16%)
Identify the differences between reporting, querying, and analysis
Map the Cognos products to reflect relationship between interactivity and formatting
Identify the need for scorecarding
Identify the need for planning
Identify the need for data manager
Identify the need for event management
Identify the need for analysis, reporting and querying
Identify different roles and categories of users
Determine User Requirements (15%)
Describe the importance of and the activities in the Analyze phase
Identify the elements of conducting a successful interview
Identify the dimensional elements of how users think about their business
Identify the metric elements and KPI of the dimensional design
Identify the business area to prototype with the highest return on investment
Identify methods of enriching the dimension map
Common Data Stores (14%)
Describe the data normalization process
Identify the difference between relational and OLAP data structures
Compare data store designs
Identify variations on data warehouse designs
Compare operational vs. reporting database designs
Identify considerations for modeling dimensionally (DMR) in Framework Manager
Cognos BI Architecture (12%)
Identify components and services of the Cognos Services Oriented Architecture
Describe benefits of the Cognos Application Firewall (CAF)
Describe the installation process
Identify considerations for installing to environments that include separate instances of a security provider
Identify considerations for addressing high availability and failover
Identify a properly designed installation map
Cognos BI Request Flows and Queues (8%)
Identify the correct flow of the request between architectural components and services for a given request
Identify the differences between high affinity and low affinity report execution requests and associated connections
Identify the relationship between scheduled jobs and batch reporting
Design, Build, and Deploy Considerations (8%)
Understand the use of the V-model testing
Considerations for moving between environments
Identify the important considerations for monitoring and tuning for performance
Identify application design and system considerations for performance
Maintain the BI Application (4%)
Identify the importance of ongoing monitoring the performance of the application
Describe the tracking and planning for enhancement requests and subsequent development phases
Identify integrating the new solution into regular backups and maintenance programs
IBM Certified Solution Expert – Cognos BI
Job Role Description / Target Audience
The BI Solution Expert (Professional) is responsible to analyze, plan, design, deploy, and operate Cognos applications using an appropriate methodology and development approach.
To achieve the IBM Certified Solution Expert – Cognos BI certification, candidates must possess the skills identified under Recommended Prerequisite Skills, if any, and pass four (4) exams.
Click the test link below to see the overview, objectives, and test preparation recommendations.
Recommended Prerequisite Skills
Prior to your preparation for this professional-level certification, the following knowledge and skills are recommended and assumed:
Knowledge of the Cognos Solutions Implementation Methodology
Technical proficiency in features of the Cognos Managers and Studios
A multi-server installation of Cognos BI must be performed. Which of the following is a valid strategy for installing across multiple servers?
A. Separate the gateway component from other server components to restrict report request processing to the Web server tier.
B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act as a primary dispatcher for routing requests to other dispatchers.
C. Scale the system vertically by installing one instance of all Cognos 8 services on a larger computer capable of managing more concurrent request threads.
D. Enable load balancing of requests for content management services by installing multiple instances of Content Manager.
Which of the following is a critical component in delivering Corporate Performance Management throughout an enterprise?
A. Drill down from summary to detailed information within individual subject areas.
B. Drill across from one subject area to another through conformed dimensions.
C. Star schema data marts designed to facilitate analysis and reporting.
D. Event management designed to monitor the status of Key Performance Indicators.
A company has several operational data stores. They wish to compare data from the various data stores against one another. The data in the various stores must be manipulated to match. Eventual report performance is more important than development time. Which of the following Cognos 8 components would BEST address their requirements?
A. Report Studio and Query Studio
B. Analysis Studio and Report Studio
C. Data Manager and Analysis Studio
D. Planning, Data Manager, and Report Studio
Why should an application’s performance be monitored on an ongoing basis after it goes into production?
A. Initial performance tests are usually too optimistic.
B. There is little value in performance tests before a system goes into production.
C. Usage patterns on applications tend to change over time.
D. New releases of system and application software usually degrade performance.
Which of the following describes common methods for enriching an initial dimension map?
A. Add exception and range band dimensions and include additional metrics and calculations.
B. Merge dimensions and include additional metrics and calculations.
C. Include additional metrics and calculations and core metrics and dimensions from related business areas.
D. Include additional metrics, calculations, and hierarchy levels, and dimensions from related subject areas.