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 61 discussion

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

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

  • A. Configure the Maximum Clusters setting to ג€Auto-Scaleג€
  • B. Set the Warehouse type to ג€Autoג€
  • C. Set the Minimum Clusters and Maximum Clusters settings to the same value
  • D. Set the Minimum Clusters and Maximum Clusters settings to the different values
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Mallikharjuna452
4 months ago
D is Correct
upvoted 1 times
...
Mayuri917233
1 year, 6 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
Tapasgup007
1 year, 11 months ago
Selected Answer: D
D is correct
upvoted 1 times
...
kjdfsafc87456
2 years, 2 months ago
Selected Answer: D
The answer is correct as per Auto-scale: This mode is enabled by specifying different values for maximum and minimum number of clusters. In this mode, Snowflake starts and stops clusters as needed to dynamically manage the load on the warehouse: As the number of concurrent user sessions and/or queries for the warehouse increases, and queries start to queue due to insufficient resources, Snowflake automatically starts additional clusters, up to the maximum number defined for the warehouse. Similarly, as the load on the warehouse decreases, Snowflake automatically shuts down clusters to reduce the number of running clusters and, correspondingly, the number of credits used by the warehouse. refer: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
upvoted 1 times
...
moon2351
2 years, 10 months ago
Selected Answer: D
If you set the minimum cluster count less than the maximum cluster count, then the warehouse runs in Auto-scale mode.
upvoted 4 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 ...