Multiple choice

Which of the following schema in data warehousing is a method of normalising the dimension tables in a star schema and when it is completely normalised, the resultant structure resembles a schema with the fact table in the middle?

  1. Star schema

  2. Snowflake schema

  3. Fact constellation

  4. Physical data model

  5. Dimensional modeling
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

This schema in data warehouse is a method of normalising the dimension tables in a star schema and when one completely normalises all the dimension tables, the resultant structure resembles a schema with the fact table in the middle.

Keep practicing — related questions