exam questions

Exam SnowPro Core All Questions

View all questions & answers for the SnowPro Core exam

Exam SnowPro Core topic 1 question 611 discussion

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

Which statement accurately describes how a virtual warehouse functions?

  • A. Increasing the size of a virtual warehouse will always improve data loading performance.
  • B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
  • C. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
  • D. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.
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
chuks_charley
Highly Voted 1 year, 2 months ago
Selected Answer: C
https://docs.snowflake.com/en/user-guide/intro-key-concepts Query Processing Query execution is performed in the processing layer. Snowflake processes queries using “virtual warehouses”. Each virtual warehouse is an MPP compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
upvoted 6 times
...
MultiCloudIronMan
Most Recent 11 months, 3 weeks ago
Selected Answer: C
Correct
upvoted 1 times
...
ChrisQ
1 year, 2 months ago
Selected Answer: C
C is correct.
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 ...