Multiple choice technology

The different types of schema in Dimensional Modeling are

  1. Snow Flake

  2. Star

  3. Integrated

  4. A & B

  5. A,B and C
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Dimensional modeling primarily uses two schema types: Star schema (central fact table with dimension tables directly connected) and Snowflake schema (normalized dimensions with hierarchical relationships). Integrated schema is not a standard dimensional modeling pattern. The A & B combination correctly identifies the two valid approaches.

Keep practicing — related questions