The correct answer is C. Query acceleration service .
The Query Acceleration Service is a Snowflake performance optimization feature that can temporarily provide additional compute resources to accelerate eligible queries. It is designed for queries that scan large amounts of data and would otherwise take longer or consume significant warehouse resources.
Why C is correct:
The Query Acceleration Service can offload portions of query processing to shared compute resources provided by Snowflake. This helps speed up expensive or long-running queries without permanently resizing the virtual warehouse.
Why the other options are incorrect:
A. Resource monitor controls and monitors credit usage. It can suspend warehouses or send alerts, but it does not scale compute for expensive queries.
B. Materialized view stores precomputed query results to improve performance for repeated query patterns, but it does not temporarily scale a warehouse.
D. Search optimization service improves point lookup and selective query performance on large tables, but it does not temporarily scale virtual warehouse compute.
Official Snowflake documentation reference:
Snowflake documentation describes the Query Acceleration Service as a feature that can improve the performance of eligible queries by using additional compute resources. It is commonly associated with accelerating parts of large scans and reducing the impact of outlier queries.
[Reference: Snowflake Documentation — Query Acceleration Service; SnowPro Core Study Guide — Performance Optimization., ========================]
