Exam SnowPro Core topic 1 question 1105 discussion

Correct Answer: B. Workloads that include on-demand data analyses Workloads that include on-demand data analyses: These types of workloads often involve complex queries that need to be executed quickly and efficiently. The query acceleration service is designed to speed up query processing for such workloads by allocating additional resources, thus reducing query response times and improving performance for ad-hoc and interactive queries.

The query acceleration service (QAS) can accelerate parts of the query workload in a warehouse. When it is enabled for a warehouse, it can improve overall warehouse performance by reducing the impact of outlier queries, which are queries that use more resources than the typical query. The query acceleration service does this by offloading portions of the query processing work to shared compute resources that are provided by the service. Examples of the types of workloads that might benefit from the query acceleration service include: Ad hoc analytics. (Answer B) Workloads with unpredictable data volume per query. (Not A) Queries with large scans and selective filters. (Not C)