Amazon Interview Question

Difference between Star schema and snowflake. Query Tuning. SQL coding. Behavioral questions(LP). What is the most complex data pipeline you have built.