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.