exam questions

Exam SnowPro Core Recertification All Questions

View all questions & answers for the SnowPro Core Recertification exam

Exam SnowPro Core Recertification topic 1 question 44 discussion

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

What happens when a suspended virtual warehouse is resized in Snowflake?

  • A. It will return an error.
  • B. It will return a warning.
  • C. The suspended warehouse is resumed and new compute resources are provisioned immediately.
  • D. The additional compute resources are provisioned when the warehouse is resumed.
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
NPass
2 weeks, 6 days ago
Selected Answer: D
Answer D. https://docs.snowflake.com/en/user-guide/warehouses-tasks#label-resizing-a-warehouse Resizing a suspended warehouse does not provision any new compute resources for the warehouse. It simply instructs Snowflake to provision the additional compute resources when the warehouse is next resumed, at which time all the usage and credit rules associated with starting a warehouse apply.
upvoted 1 times
...
tejarun
2 months, 4 weeks ago
Selected Answer: D
https://docs.snowflake.com/en/sql-reference/sql/alter-warehouse
upvoted 1 times
...
Hansa123
6 months, 3 weeks ago
Answer is D
upvoted 2 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