Multiple choice technology

What are the two common schema types

  1. Star schema

  2. Ring schema

  3. Snow flake schema

  4. Circular schema
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

The two primary schema types for data warehouse dimensional modeling are star schema and snowflake schema. Star schema has a central fact table connected directly to dimension tables (denormalized dimensions), while snowflake schema further normalizes dimension tables into sub-dimensions. Snowflake reduces redundancy but adds join complexity; star schema is simpler for queries but has some dimension data duplication.

Keep practicing — related questions