SnowPro Core Certification — Question 1257

Which type of query would benefit from enabling the query acceleration service on the virtual warehouse?

Answer options

• 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

Correct answer: C

Explanation

Enabling the query acceleration service is particularly beneficial for queries that require more resources than usual, as it helps optimize performance and reduce execution time. Other options, such as queries without filters or aggregation, queued queries, and those with high cardinality GROUP BY expressions, do not necessarily benefit from acceleration in the same way, as they may not be resource-intensive or may not be the bottleneck in processing.