Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
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 (?) , you can switch to a simple comment.
Switch to a voting comment New
Gudref
Highly Voted 10 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 9 times
...
Mayankb024
Most Recent 3 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
10 months, 2 weeks 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 ...