In the data warehouse, a snowflake schema is the variation of the star schema. It is the form of dimensional modeling where dimensions are being stored in multiple related dimension tables. It is majorly used to improve the performance of certain queries.

BY Best Interview Question ON 08 Nov 2021