Answer-first summary for fast verification
Answer: Queries that use more resources than the typical query
The Query Acceleration Service (QAS) is specifically designed to improve warehouse performance by handling outlier queries that consume more resources than typical queries. According to Snowflake documentation and the community discussion with high upvotes, option C directly matches the official description of QAS benefits. Option D is explicitly mentioned as one of the query types NOT supported by QAS, making it incorrect. Options A and B describe general query states without specific resource characteristics that would benefit from QAS acceleration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which type of query would benefit from enabling the Query Acceleration Service on a virtual warehouse?
A
Queries with no filters or aggregation
B
Queries that are queued in the warehouse
C
Queries that use more resources than the typical query
D
Queries that contain a high cardinality GROUP BY expression
No comments yet.