Question 1
In Ralph Kimball's dimensional modeling, what does the term 'grain' of a fact table refer to?
Correct Answer:
The level of detail represented by a single row in the fact table
Question 2
A star schema differs from a snowflake schema primarily in that the star schema:
Correct Answer:
Keeps dimension tables denormalized in a single flat table per dimension
Question 3
Which slowly changing dimension (SCD) technique preserves full history by inserting a new dimension row each time a tracked attribute changes?
Correct Answer:
Type 2
Question 4
Bill Inmon's Corporate Information Factory recommends building the enterprise data warehouse using which modeling style?
Correct Answer:
Normalized (third normal form) relational modeling
Question 5
In the ETL process, what is the primary purpose of the 'transform' stage?
Correct Answer:
To apply business rules, cleansing, and conform data to the target structure
Question 1
Exam overview

About this Exam

Prepare with the TDWI CBIP Practice Questions - Certified Business Intelligence Professional Exam practice quiz. This question bank includes 100 questions covering data, dimension, modeling, dimensional, and fact. Use it to review important concepts, identify knowledge gaps, and build confidence for the related exam, course, or assessment.

More details

Additional Information

TDWI CBIP Practice Questions - Certified Business Intelligence Professional Exam

This practice set contains 100 questions from the matching question bank and focuses on data, dimension, modeling, dimensional, and fact. Work through each question carefully, review the provided solutions, and revisit topics that need more study before your next attempt.

This is an independent study resource intended for practice and review; it is not an official examination or an endorsement by any organization named in the title.

Quiz information

Frequently Asked Questions

The complete question count is available after full access is unlocked.
No fixed duration is currently configured for this quiz.
Question explanations are included where they are available in the quiz content, helping you review the reasoning after answering.
Yes. You can retake the practice test again as you continue studying during your available access period.
After your access is confirmed, you can continue into the complete practice exam from this quiz flow.
Unless explicitly stated otherwise, this page provides independent practice material for study and exam preparation and is not the official examination itself.
Keep studying

Related Questions