Multiple choice technology databases

Which of the following are schema's in Data Warehouse models

  1. Star

  2. Snow Flake

  3. Both of the Above

  4. None of the Above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Star and Snowflake are both standard dimensional modeling schemas used in data warehousing. Star schema has a central fact table directly connected to dimension tables, while Snowflake normalizes dimensions into multiple related tables. Both are valid approaches depending on the trade-off between query performance and storage normalization.

Keep practicing — related questions