Understanding Materialized Views
The Snowy Peak data team runs the same expensive aggregation every morning — sessions from the previous night, grouped by resort and app feature, to power the commercial dashboard. The results are stable until new session data arrives, and the query runs multiple times a day across different teams.
A senior analyst recommends a materialized view. Select all statements about materialized views that are correct.
This exercise is part of the course
Snowflake Architecture
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise