We're so confident of our products that we provide no hassle product exchange.
COGNOS BI0-132 Exam Overview:
| Certification Vendor: | IBM |
|---|---|
| Exam Name: | IBM Cognos 8 BI Metadata Model Developer |
| Exam Number: | BI0-132 |
| Exam Format: | Multiple choice, Scenario-based questions |
| Available Languages: | English |
| Related Certifications: | IBM Cognos BI Report Developer IBM Cognos BI Administration |
| Certificate Validity Period: | Retired (no longer actively offered) |
| Sample Questions: | COGNOS BI0-132 Sample Questions |
| Exam Way: | Computer-based exam (historically delivered through IBM authorized testing centers or online proctored systems depending on region) |
| Pre Condition: | Basic knowledge of relational databases and data warehousing concepts is recommended. |
COGNOS BI0-132 Exam Syllabus Topics:
| Section | Objectives |
|---|---|
| Relational and Dimensional Modeling | - Dimensional design
|
| Framework Manager Modeling | - Metadata modeling fundamentals
|
| Business Rules and Calculations | - Expression building
|
| Cognos Architecture and Components | - IBM Cognos 8 BI architecture overview
|
| Security and Deployment | - Security implementation
|
| Troubleshooting and Performance | - Model optimization
|
COGNOS Cognos 8 BI Metadata Model Developer Sample Questions:
Question #1
In Framework Manager, it is recommended to model operational metadata as a virtual star schema for which one of the following reasons?
- A. Ensures inner joins between data source query subjects.
- B. Provides stability to the underlying data structure.
- C. Creates an easy-to-read data dictionary for end users.
- D. Helps to remove ambiguity and provide predictable results.
Correct Answer: D 🗳️
Question #2
What is true of a Framework Manager model of an operational database lacking a time dimension?
- A. Virtual star schema models require a time dimension for multi-fact queries.
- B. Report authors cannot create multi-fact, time-based queries unless using a union.
- C. Report authors cannot create multi-fact, time-based queries.
- D. Time-based rollups for multi-fact queries may be difficult to handle.
Correct Answer: D 🗳️
Question #3
In Framework Manager, which of the following statements is correct when working with a multilingual project?
- A. When a new language is added to a project, all locales for that language are added as well.
- 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. The design language can be changed at any point.
Correct Answer: C 🗳️
Question #4
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(Sales_Fact.Revenue for 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(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) at Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
- D. XSUM(XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line) in Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
Correct Answer: C 🗳️
Question #5
Although modelers can use model query subjects to create entire business views, it is recommended to use them to do which of the following?
- A. Provide dimensional information through the use of determinants.
- B. Combine facts and dimensions for intuitive ad hoc business views.
- C. Resolve reporting traps and simplify snowflake tables through consolidation.
- D. Resolve conflicting keys and indexes and generate minimized SQL.
Correct Answer: C 🗳️
By Joshua
