Exam Number/Code: BI0-132
Exam Name: Cognos 8 BI Metadata Model Developer
Questions and Answers: 55 Q&As
Price: $125.00
Update Time: 2009-2-20

1. What does a star schema database structure typically consist of?
A. De-normalized hierarchy of dimension tables and fact tables.
B. Normalized dimension tables and detailed fact tables.
C. Normalized dimension tables and summarized fact tables.
D. De-normalized dimension tables and fact tables.
Answer: D
2. Which of the following is true of an OLAP data structure?
A. Comprised of normalized dimension and fact tables.
B. Organizes dimension tables into hierarchies and levels.
C. Allows “real time” analysis against disparate data sources.
D. Cardinality between tables is typically configured as inner joins.
Answer: B
3. If you are successful with this exam, do you agree to have your name made available to relevent IBM personnel for project staffing?.
A. Yes
B. No
Answer: A
4. Which of the following data structures typically contain normalized data?
A. Cube
B. Flat file
C. Operational
D. Star schema
Answer: C

Download BI0-132 exam demo