SnowPro Core free question 8 / 10 · Domain 4: Performance Optimization, Querying, and Transformation
Which setting enables the Query Acceleration Service on a warehouse?
- ENABLE_QUERY_ACCELERATION = TRUE
- A different SCALING_POLICY
- ENABLE_SEARCH_OPTIMIZATION = TRUE
- A shorter AUTO_SUSPEND time
Show the answer and explanation
Answer: A
Why this is correct
To enable the query acceleration service, specify the ENABLE_QUERY_ACCELERATION = TRUE clause in the CREATE WAREHOUSE or ALTER WAREHOUSE command. It can be added to a warehouse that already exists.
Why the other options are wrong
"ENABLE_SEARCH_OPTIMIZATION = TRUE" … This is a setting of the search optimization service, a different feature.
"A shorter AUTO_SUSPEND time" … AUTO_SUSPEND sets how long a warehouse idles before suspending.
"A different SCALING_POLICY" … SCALING_POLICY is a multi-cluster warehouse policy for starting and stopping clusters.
Key point
The setting is made per warehouse. You can use SHOW WAREHOUSES to see whether it is enabled and what the maximum scale factor is.
Go to the SnowPro Core practice app (10 free questions; purchase unlocks all questions)