Answer-first summary for fast verification
Answer: Workloads that include on-demand data analyses
The Query Acceleration Service (QAS) in Snowflake is designed to improve performance for workloads with unpredictable or complex query patterns, particularly ad-hoc analytics and on-demand data analyses. Option B is correct because QAS excels at accelerating complex queries that require quick execution for interactive analysis, as confirmed by the community discussion where all comments (100%) selected B and provided detailed reasoning about QAS optimizing ad-hoc queries by offloading processing to shared resources. Option A is incorrect because predictable data volumes don't benefit as much from QAS's dynamic resource allocation. Option C is incorrect as QAS targets large scans with selective filters, not small scans. Option D is incorrect since queries without filters or aggregation are typically simple and don't require acceleration.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Which type of workload typically benefits from using the Query Acceleration Service?
A
Workloads with a predictable data volume for each query
B
Workloads that include on-demand data analyses
C
Queries with small scans and non-selective filters
D
Queries that do not have filters or aggregation
No comments yet.