Q: What type of schema consists of one fact table that references any number of dimension tables?
or
Q: One fact table that refers any number of dimension tables is what kind of schema is it?
- Snowflake
- Star
- Dimensional
- Relational
Explanation: The schema that consists of one fact table that references any number of dimension tables is the Star schema. In a star schema, the fact table is at the center and is connected to multiple dimension tables, resembling a star shape.
