We're so confident of our products that we provide no hassle product exchange.
COGNOS BI0-132 Exam Overview:
| Certification Vendor: | IBM / Cognos |
| Exam Name: | Cognos 8 BI Metadata Model Developer |
| Exam Number: | BI0-132 |
| Available Languages: | English |
| Passing Score: | 70% |
| Exam Format: | Multiple Choice |
| Related Certifications: | Cognos 8 BI Developer Cognos 8 BI Administrator |
| Exam Price: | Approx. $200 USD |
| Real Exam Qty: | 53-60 |
| Certificate Validity Period: | No expiration / Retired |
| Exam Duration: | 90 minutes |
| Recommended Training: | IBM Cognos 8 BI Framework Manager Modeling |
| Exam Registration: | Pearson VUE IBM Certification Portal |
| Sample Questions: | COGNOS BI0-132 Sample Questions |
| Exam Way: | Proctored at authorized test centers or online proctoring |
| Pre Condition: | No formal prerequisites; recommended hands-on experience with Cognos 8 BI |
| Official Syllabus URL: | https://www.ibm.com/certify |
COGNOS BI0-132 Exam Syllabus Topics:
| Section | Weight | Objectives |
|---|---|---|
| Topic 1: Advanced Modeling Techniques | 15% | - Handling multiple data sources - Troubleshooting model issues - Complex hierarchies and dimensions |
| Topic 2: Introduction to Metadata Modeling | 15% | - Metadata modeling concepts and principles - Cognos 8 BI architecture and Framework Manager overview - Role and purpose of metadata in BI solutions |
| Topic 3: Designing Metadata Models | 25% | - Dimensional and relational modeling techniques - Creating and structuring models in Framework Manager - Defining relationships, cardinalities and hierarchies - Gathering business requirements |
| Topic 4: Building Metadata Packages | 25% | - Publishing and managing metadata packages - Developing calculations, expressions and filters - Creating query subjects and query items - Importing and organizing data sources |
| Topic 5: Securing and Managing Models | 20% | - Implementing security and access control - Performance tuning and optimization - Model maintenance and version control |
COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
1. An author creates a Report Studio report that contains Month, Product Line and Revenue. Revenue has a footer to show the overall total. What will the author see in the generated Cognos SQL for the Revenue footer column?
A) XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
B) XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue2
C) XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
D) XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
2. What is true of a Framework Manager model of an operational database lacking a time dimension?
A) Report authors cannot create multi-fact, time-based queries unless using a union.
B) Report authors cannot create multi-fact, time-based queries.
C) Virtual star schema models require a time dimension for multi-fact queries.
D) Time-based rollups for multi-fact queries may be difficult to handle.
3. In Framework Manager, if a modeler changes the business key for a level in a regular dimension, which of the following may change?
A) Level identifier
B) Level MUN
C) Member MUNs
D) Member aliases
4. A recursive relationship exists between SALES_STAFF_CODE and MANAGER_CODE in the SALES_STAFF data source query subject. This query subject is provided in a model to report authors. Using this query subject alone, report authors cannot create a report that includes management staff and the sales staff that report to them. How can the existing recursive relationship in the model be modified to provide this ability to report authors?
A) Import a query subject that does not contain a recursive relationship.
B) Create a shortcut to the SALES_STAFF data source query subject, and report authors will use it instead of the underlying query subject to create the required report.
C) Create a star schema grouping that contains the SALES_STAFF data source query subject and a shortcut to the SALES_STAFF data source query subject.
D) Create a model query subject with the appropriate relationship to the existing SALES_STAFF data source query subject and make both available to report authors.
5. Which of the following is true of an OLAP data structure?
A) Organizes dimension tables into hierarchies and levels.
B) Comprised of normalized dimension and fact tables.
C) Cardinality between tables is typically configured as inner joins.
D) Allows "real time" analysis against disparate data sources.
Solutions:
| Question # 1 Answer: D | Question # 2 Answer: D | Question # 3 Answer: C | Question # 4 Answer: D | Question # 5 Answer: A |
By Daniel
