Question

A data engineer maintains a large fact table with a materialized view that pre-aggregates daily sales by region. Queries against the materialized view have grown slow because they filter on a specific region, and the engineer wants to improve partition pruning on the materialized view itself. Which action is supported in Snowflake to address this?

Accepted Answer

Define a clustering key directly on the materialized view to co-locate rows by region

Answer

Enable Time Travel on the materialized view to reorganize its micro-partitions

Answer

Create a second materialized view that references the first materialized view

Answer

Add a search optimization service configuration to the base table's aggregated columns