Which is a better star schema or snowflake?
Star Schemas are better as they use fewer foreign keys, more in a denormalized form which makes them better for performance.
However, both schemas depend upon the size of the data. If the data is small then star schema comes into the process on the other hand if data is large with many relationships between them then you should go for Snowflake Schemas.
BY Best Interview Question ON 10 Nov 2020