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 #19

What does a star schema database structure typically consist of?

A. De-normalized hierarchy of dimension tables and fact tables.

B. De-normalized dimension tables and fact tables.

C. Normalized dimension tables and summarized fact tables.

D. Normalized dimension tables and detailed fact tables.

Discussion 0

Correct Answer: B Vote an answer

Question #20

In a transitive relationship scenario, what problems exist when reporting from the tables below?

A. The Order table must be included in each query.

B. Outer joins are generated when querying from Customer.

C. There is more than one possible path between the tables.

D. The Order Detail table has conflicting cardinalities.

Discussion 0

Correct Answer: C Vote an answer

Question #21

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. Resolve reporting traps and simplify snowflake tables through consolidation.

B. Combine facts and dimensions for intuitive ad hoc business views.

C. Provide dimensional information through the use of determinants.

D. Resolve conflicting keys and indexes and generate minimized SQL.

Discussion 0

Correct Answer: A Vote an answer

Question #22

In Cognos 8, what are the two distinct model types authors can work with?

A. Dimensional and DMR

B. OLAP and DMR

C. Relational and SAP BW

D. Relational and Dimensional

Discussion 0

Correct Answer: D Vote an answer

Question #23

Which of the following is correct regarding the Cognos 8 security environment?

A. To perform authentication of users, a connection to theCognos namespace must be defined.

B. In Framework Manager, object security is implemented by defining access to objects for users, groups and roles defined in the authentication providers.

C. In Framework Manager, object security is implemented by defining access to objects for groups and roles (of which users are members), not individual users.

D. Cognos 8 must be configured to use only one authentication provider at a time.

Discussion 0

Correct Answer: B Vote an answer

Question #24

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, create a separate namespace for the imported objects from each data source.

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, do not override the relationships defined between the data sources at the time of import.

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.