A variation of the star schema that allows more than one central fact table.
A) snowflake schema
B) linked strar schema
C) distributed star schema
D) constellation schema

Question

Quizplus · Accepted Answer

A constellation schema is a variation of the star schema that allows for more than one central fact table. The fact tables are connected to each other through shared dimensions, creating a "constellation" of stars. This schema is useful for complex data models where multiple fact tables are needed to describe different business processes or analytics requirements. The constellation schema can provide more flexibility and scalability compared to traditional star schemas.

A Variation of the Star Schema That Allows More Than