Snowpro Core · Free Practice Question Medium
Question 67
Suppose you have an auto-scaling mode setup with a Standard policy. In what situation does Snowflake spin up an additional cluster?
- A The first cluster starts immediately when either a query is queued or the system detects that there’s one more query than the currently-running clusters can execute.
- B Only if the system estimates there’s enough query load to keep the cluster busy for at least 6 minutes.
Reveal correct answer
Correct answer: A
Explanation
In Standard Scaling policy, the first cluster starts immediately when either a query is queued, or the system detects that there’s one more query than the currently-running clusters can execute.
Each successive cluster waits to start 20 seconds after the prior one has started. For example, if your warehouse is configured with ten max clusters, it can take 200+ seconds to start all 10 clusters.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
You must be logged in to post a comment.
