What is star Schema
-
Dimension is surrounded by Facts
-
Fact is surrounded by Dimensions
-
Dimension is surrounded by Dimensions
-
All of above
Reveal answer
Fill a bubble to check yourself
B
Correct answer
Explanation
A star schema is a dimensional database design where a central fact table (containing quantitative metrics and foreign keys) is directly connected to multiple dimension tables (containing descriptive attributes). The fact table is at the center 'surrounded by' dimension tables, creating a star-like pattern when visualized. Dimension tables are never at the center - they provide the context (who, what, where, when) for the metrics stored in the fact table. This design optimizes query performance for analytical queries.