COGNOS Cognos 8 BI Metadata Model Developer - BI0-132 Exam Questions [2026]

QUESTION NO: 1
Which of the following data structures typically contain normalized data?

A. Operational B. Star schema C. Cube D. Flat file

Correct Answer: A

QUESTION NO: 2
To create a report in Report Studio, a report author accesses which object?

A. The runtime version of a Framework Manager model. B. A development model from Framework Manager. C. A file that contains query subjects externalized from Framework Manager. D. A report specification.

Correct Answer: A

QUESTION NO: 3
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. 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. B. Import a query subject that does not contain a recursive relationship. C. 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. D. 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.

Correct Answer: A

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

A. Open the Relationship Definition dialog, and then edit the join expression as required. B. Right-click a relationship in the Object diagram or Context Explorer, and then select "Create Compound Join". C. Select the relationship, and then from the Actions menu, select "Merge in New Query Subject". D. Open the Relationship Expression dialog, and then change both cardinality settings to 0..n or 0..1.

Correct Answer: A

QUESTION NO: 5
In Cognos 8, which of the following is true of multi-fact result sets?

A. Only contiguous result sets can have repeating fact values. B. Both contiguous and correlated lists can have repeating fact values. C. Only correlated result sets can have repeating fact values. D. Both contiguous and correlated lists cannot have repeating fact values.

Correct Answer: B

QUESTION NO: 6
In Framework Manager, what are the minimum requirements to implement a stored procedure that expects arguments and make it available to authors?

A. Import the stored procedure, add it as a model calculation, and then publish it as part of a package. B. Import the stored procedure, use it to create a calculation in the expression editor and then publish the calculation as part of a package. C. Import the stored procedure, set the type to Data Modification, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package. D. Import the stored procedure, provide values that satisfy the procedure's arguments, retrieve a projection list and then publish it as part of a package.

Correct Answer: D