Cognos 8 BI Metadata Model Developer (BI0-132) Free Practice Test

Question 1

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

A. Relational and SAP BW

B. OLAP and DMR

C. Relational and Dimensional

D. Dimensional and DMR

Correct Answer: C

Question 2

What is true of a Framework Manager model of an operational database lacking a time dimension?

A. Report authors cannot create multi-fact, time-based queries.

B. Virtual star schema models require a time dimension for multi-fact queries.

C. Report authors cannot create multi-fact, time-based queries unless using a union.

D. Time-based rollups for multi-fact queries may be difficult to handle.

Correct Answer: D

Question 3

The illustration below represents which of the following data traps?

A. Bridge

B. Connection

C. Parallel relationship

D. Many-to-many relationship

Correct Answer: C

Question 4

What must a modeler consider when modeling for drill-through between multiple data sources?

A. Drill-through values must be cast.

B. Drill-through values must be identifiers.

C. Drill-through values must be conformed.

D. Drill-through values must be consolidated.

Correct Answer: C

Question 5

In Framework Manager, which of the following will have a positive impact on query performance without intervention from an author?

A. Create stand-alone filters.

B. Add performance indicators to functions.

C. For a query item having an integer data type, set the Display Item Reference property to display an integer value.

D. Configure data sources in a project pointing to the same database instance to use the same connection.

Correct Answer: D

Question 6

Which of the following is true regarding the operational data structure illustrated below?

A. It should be consolidated into one table.

B. It illustrates a parallel relationship.

C. The cardinality between the tables should be reversed.

D. It should be examined for a connection trap.

Correct Answer: D

Welcome to TestSimulate