SnowPro Core Certification — Question 734

What type of query will benefit from the query acceleration service?

Answer options

• A. Queries without filters or aggregation
• B. Queries with large scans and selective filters
• C. Queries where the GROUP BY has high cardinality
• D. Queries of tables that have search optimization service enabled

Correct answer: B

Explanation

The correct answer is B because queries with large scans and selective filters can significantly benefit from acceleration, as the service optimizes performance for such scenarios. Options A and C do not involve conditions that would leverage the acceleration service effectively, while D refers to a feature that may not directly relate to query acceleration.