Data Architect Interview Question:

Tell me which schema is better – star or snowflake?

Submitted by: Muhammad

The choice of a schema always depends upon the project requirements & scenarios.

Since star schema is in de-normalized form, you require fewer joins for a query. The query is simple and runs faster in a star schema. Coming to the snowflake schema, since it is in normalized form, it will require a number of joins as compared to a star schema, the query will be complex and execution will be slower than star schema.
Submitted by: Muhammad