exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 947 discussion

Actual exam question from Snowflake's SnowPro Core
Question #: 947
Topic #: 1
[All SnowPro Core Questions]

While running a query on a virtual warehouse in auto-scale mode, additional clusters are started immediately if which setting is configured?

  • A. MAX_CLUSTER_COUNT is increased and new_max_clusters is greater than running_clusters
  • B. MAX_CLUSTER_COUNT is decreased and new_max_clusters is less than running_clusters
  • C. MIN_CLUSTER_COUNT is increased and new_min_clusters is greater than running_clusters
  • D. MIN_CLUSTER_COUNT is decreased and new_min_clusters is less than running_clusters
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Gudref
Highly Voted 1 year, 2 months ago
Selected Answer: C
Auto-scale: ↑ max If new_max_clusters > running_clusters, no changes until additional clusters are needed. ↓ max If new_max_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met. ↑ min If new_min_clusters > running_clusters, additional clusters immediately started to meet the minimum. ↓ min If new_min_clusters < running_clusters, excess clusters shut down when they finish executing statements and the scaling policy conditions are met.
upvoted 11 times
...
bor4un
Most Recent 2 months, 4 weeks ago
Selected Answer: C
https://docs.snowflake.com/en/user-guide/warehouses-multicluster#increasing-or-decreasing-clusters-for-a-multi-cluster-warehouse
upvoted 1 times
...
MultiCloudIronMan
3 months, 3 weeks ago
Selected Answer: A
Based on the Snowflake documentation, additional clusters are started immediately if the MAX_CLUSTER_COUNT is increased and the new maximum number of clusters is greater than the number of running clusters. This ensures that the warehouse can handle the increased workload by scaling out to additional clusters as needed.
upvoted 1 times
...
Mayankb024
8 months, 2 weeks ago
C. https://docs.snowflake.com/en/user-guide/warehouses-multicluster#increasing-or-decreasing-clusters-for-a-multi-cluster-warehouse
upvoted 1 times
...
DR369
1 year, 3 months ago
Answer A,D
upvoted 1 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago