What type of query will benefit from the query acceleration service?
What type of query will benefit from the query acceleration service?
Queries with large scans and selective filters will benefit from the query acceleration service because this type of service is designed to optimize query performance by efficiently handling large data volumes and applying filters to reduce the data scanned. This technique improves the overall speed and efficiency of data retrieval in scenarios that involve extensive scanning and selective filtering.
B is correct. Examples of the types of workloads that might benefit from the query acceleration service: 1) Ad hoc analytics. 2) Workloads with unpredictable data volume per query. 3) Queries with large scans and selective filters. https://docs.snowflake.com/en/user-guide/query-acceleration-service#label-query-acceleration-scale-factor
B correct - https://docs.snowflake.com/en/user-guide/performance-query-warehouse-qas
Answer B is correct https://docs.snowflake.com/en/user-guide/query-acceleration-service