Free BI0-132 Questions for COGNOS Cognos 8 BI Metadata Model Developer BI0-132 Exam as PDF & Practice Test Engine

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: Aug 19, 2026

Question #1

A user-defined function imported into Framework Manager can be viewed and used in the following locations?

A. Viewed in the Diagram and used in the SQL of a data source query subject.

B. Viewed in the Explorer and used in the expression editor.

C. Viewed in the Explorer and used in the SQL of a model query subject.

D. Viewed in the Project Viewer and used in the expression editor.

Discussion 0

Correct Answer: B Vote an answer

Question #2

In Framework Manager, which of the following statements is correct when working with a multilingual project?

A. The design language can be changed at any point.

B. A language must be added to the project before it can be published with a package.

C. A project language cannot be deleted once defined in Framework Manager.

D. When a new language is added to a project, all locales for that language are added as well.

Discussion 0

Correct Answer: B Vote an answer

Question #3

What technique can Framework Manager modelers use to implement a time dimension for models that lack a time dimension?

A. Use parameter maps to map date values in one query subject to date values in another query subject.

B. Use the Time Dimension wizard to generate a time dimension and create the appropriate relationships.

C. Identify a time dimension table source, import into the model and create relationships to fact query subjects.

D. Create relationships from date fields in one dimension to date fields in another dimension.

Discussion 0

Correct Answer: C Vote an answer

Question #4

Which of the following is true of the generated native SQL below? select
"RETURNED_ITEM"."RETURN_QUANTITY" AS
"RETURN_QUANTITY",
"RETURN_REASON"."REASON_DESCRIPTION_EN" AS "REASON_DESCRIPTION_EN"
from
(select "RETURNED_ITEM"."RETURN_REASON_CODE",
"RETURNED_ITEM"."RETURN_QUANTITY" from
"GOSL"."dbo"."RETURNED_ITEM",
"GOSL"."dbo"."ORDER_HEADER"
"ORDER_HEADER", "GOSL"."dbo"."ORDER_DETAILS" "ORDER_DETAILS"
where
"RETURNED_ITEM"."ORDER_DETAIL_CODE" =
"ORDER_DETAILS"."ORDER_DETAIL_CODE" and "ORDER_HEADER"."ORDER_NUMBER" =
"ORDER_DETAILS"."ORDER_NUMBER")
"RETURNED_ITEM"
inner join
"GOSL"."dbo"."RETURN_REASON" "RETURN_REASON"
on
"RETURN_REASON"."RETURN_REASON_CODE" =
"RETURNED_ITEM"."RETURN_REASON_CODE"

A. The parent select statement uses an inner join to directly match columns from physical tables in the database.

B. The outer projection list will return more columns than listed, due to extra columns retrieved in the derived table.

C. The derived table is executed independently, using Pass-Through SQL, and then processed locally.

D. The derived table is used to retrieve one data set, in order to fulfill the join condition of another data set.

Discussion 0

Correct Answer: D Vote an answer

Question #5

Which of the following are proven practices for organizing the objects in a project?

A. When importing metadata from more than one data source, create a separate folder for the imported objects from each data source.

B. When importing metadata from more than one data source, do not override the relationships defined between the data sources at the time of import.

C. When importing metadata from more than one data source, include all imported objects in the root namespace.

D. When importing metadata from more than one data source, create a separate namespace for the imported objects from each data source.

Discussion 0

Correct Answer: D Vote an answer

Question #6

In Framework Manager, why is it recommended that modelers alter the default all-inclusive select statements of data source query subjects as little as possible?

A. To generate the most efficient SQL at run time and simplify model maintenance.

B. To provide authors with access to all columns in a database table which reduces requests to the modeler.

C. To prevent the exclusion of columns from a table that may be required in future reports.

D. To prevent improperly constructed SQL and reduce issues with model documentation and readability.

Discussion 0

Correct Answer: A Vote an answer

Free BI0-132 Questions for COGNOS Cognos 8 BI Metadata Model Developer BI0-132 Exam as PDF & Practice Test Engine

Download Free COGNOS BI0-132 Demo