Answer-first summary for fast verification
Answer: Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
Option C is correct because it accurately describes that each virtual warehouse is an MPP (Massively Parallel Processing) compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider, which aligns with Snowflake's official documentation. Option A is incorrect because increasing warehouse size doesn't always improve performance and depends on the workload characteristics. Option B is incorrect because virtual warehouses are independent and do NOT share compute resources with other warehouses. Option D is incorrect because virtual warehouses are isolated and performance degradation in one warehouse does not affect others. The community discussion shows unanimous consensus on C with 100% agreement and references to official documentation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
How does a virtual warehouse operate in Snowflake?
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.
No comments yet.