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