SnowPro Core Certification — Question 598

Which statement accurately describes how a virtual warehouse functions?

Answer options

• 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.

Correct answer: C

Explanation

Option C is correct because it accurately describes that each virtual warehouse is made up of multiple compute nodes allocated by Snowflake from a cloud provider. Option A is incorrect as increasing size does not guarantee improved performance. Option B misrepresents the independence of compute clusters, and Option D inaccurately suggests that resources are shared among all warehouses, which is not the case.