Explanation:
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.
Ultimate access to all questions.
No comments yet.
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