SnowPro Core Certification — Question 1269

What virtual warehouse feature or setting will reduce the performance impact when running larger-than-average queries, by offloading portions of the query processing work to shared compute resources?

Answer options

• A. Using a multi-cluster virtual warehouse
• B. Using the query acceleration service
• C. Using the search optimization service
• D. Disabling auto-suspend

Correct answer: B

Explanation

The query acceleration service is designed to enhance performance for demanding queries by distributing the processing load across shared resources. The other options do not specifically address the offloading of query processing, with multi-cluster warehouses helping with concurrency and auto-suspend merely managing resource usage.