Answer-first summary for fast verification
Answer: Queries with large scans and selective filters
The Query Acceleration Service in Snowflake is designed to improve performance for specific types of workloads. According to the official Snowflake documentation and the community discussion with high consensus (100% agreement on B), queries with large scans and selective filters benefit most from this service. This is because the service can accelerate the scanning and filtering phases of query execution. Option A (queries without filters or aggregation) would not benefit as there's minimal processing to accelerate. Option C (queries with high cardinality GROUP BY) is not specifically mentioned as a primary use case. Option D (tables with search optimization service enabled) refers to a different Snowflake feature and doesn't directly relate to query acceleration benefits.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
Which type of query benefits from the Query Acceleration Service?
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