The correct answer is D. To control the potential costs associated with the Query Acceleration Service .
The Query Acceleration Service can use additional Snowflake-managed compute resources to accelerate eligible queries. The scale factor setting controls the maximum amount of additional compute that can be used relative to the warehouse.
Why D is correct:
A higher scale factor allows more acceleration resources to be used, which can improve performance but may increase credit consumption. A lower scale factor limits the amount of extra compute used, helping control cost.
Example concept:
ALTER WAREHOUSE my_wh
SET ENABLE_QUERY_ACCELERATION = TRUE
QUERY_ACCELERATION_MAX_SCALE_FACTOR = 4;
This limits the maximum acceleration scale factor for the warehouse.
Why the other options are incorrect:
A. Query Acceleration Service does not create clustering keys.
B. The scale factor does not control how many users can use the service.
C. The scale factor does not resize the virtual warehouse itself. It limits additional query acceleration resources.
Official Snowflake documentation reference:
Snowflake documentation explains that QUERY_ACCELERATION_MAX_SCALE_FACTOR limits the amount of compute resources that can be used by the Query Acceleration Service for a warehouse, which helps control cost.
[Reference: Snowflake Documentation — Query Acceleration Service; Snowflake Documentation — QUERY_ACCELERATION_MAX_SCALE_FACTOR; SnowPro Core Study Guide — Performance Optimization., ]
