COGNOS BI0-132 Actual Free Exam Questions & Community Discussion

Exam Code/Number: BI0-132
Exam Name/Title: Cognos 8 BI Metadata Model Developer
Certification Provider: COGNOS
Corresponding Certification: Cognos Buiness Intelligence Certifications

Exam Questions: 53
Updated On: Jul 13, 2026

Question #1

In order to create complex joins in Framework Manager, a modeler can use which of the following techniques?

A. Select the relationship, and then from the Actions menu, select "Merge in New Query Subject".

B. Right-click a relationship in the Object diagram or Context Explorer, and then select "Create Compound Join".

C. Open the Relationship Definition dialog, and then edit the join expression as required.

D. Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.

Discussion 0

Correct Answer: C Vote an answer

Question #2

The generated Cognos SQL below contains which one of the following joins? select
Return_Reason_Dimension.REASON_DESCRIPTION_EN as REASON_DESCRIPTION_EN, Returned_Items_Fact.RETURN_QUANTITY as RETURN_QUANTITY from go_data_warehouse.GOSLDW.dbo.RETURN_REASON_DIMENSION Return_Reason_Dimension join go_data_warehouse.GOSLDW.dbo.RETURNED_ITEMS_FACT Returned_Items_Fact on (Return_Reason_Dimension.RETURN_REASON_KEY = Returned_Items_Fact.RETURN_REASON_KEY)

A. Inner join on RETURN_REASON_KEY.

B. Left outer join on RETURN_REASON_KEY.

C. Outer join on RETURN_REASON_KEY.

D. Left inner join on RETURN_REASON_KEY.

Discussion 0

Correct Answer: A Vote an answer

Question #3

With respect to Cognos 8 security, which of the following is true of the Cognos namespace?

A. Can be deleted if a different namespace is used to secure the environment.

B. Can be used to createCognos 8 specific groups and roles.

C. Only contains predefined groups and roles.

D. Can be used to create custom groups, roles and users.

Discussion 0

Correct Answer: B Vote an answer

Question #4

Users want to compare Actual Revenue and Sales Target values by Month. Actual Revenue values are stored at the day grain in the Orders Fact table. Sales Target values are stored at the month grain in the Sales Target Fact table. In Framework Manager, which technique will best prevent Sales Target values from being double-counted in Query Studio reports?

A. Set scope for Actual Revenue at the Day level and Sales Target at the Month level in the Dimension Map.

B. Define both Month and Day determinant levels in the Time Dimension and Group By Month.

C. Create separate star schema groupings for Orders Fact and Sales Target Fact, both at the month grain.

D. Define both Month and Day determinant levels in the Time Dimension and Group By Day.

Discussion 0

Correct Answer: B Vote an answer

Question #5

In Framework Manager, which of the following is true about verifying your model?

A. The model can be verified fromCognos Connection or through the Publish Packages wizard.

B. The model can only be verified through the Publish Packages wizard.

C. The entire model must be verified, individual objects cannot be verified.

D. It is possible to select to automatically repair certain issues that have been detected.

Discussion 0

Correct Answer: D Vote an answer

Question #6

In Framework Manager, which of the following will have a negative impact on query performance?

A. Add filters and calculations to model query subjects rather than data source query subjects.

B. Enable the Allow Enhanced Model Portability governor.

C. Set the Cross-product joins and Outer Joins governors to Deny.

D. Ensure that, where required, queries are executed against materialized views which contain only aggregated data rather than base tables that contain all the data.

Discussion 0

Correct Answer: B Vote an answer

Download Free COGNOS BI0-132 Demo

Simply submit your e-mail address below to get started with our free demo of your COGNOS BI0-132 exam.