Answer: Storage expands without the requirement to add more compute., Compute can be scaled up or down without the requirement to add more storage.

The correct answers are B and C because they directly describe the core benefits of Snowflake's separation of compute and storage. Option B ('Storage expands without the requirement to add more compute') highlights that storage can grow independently of compute resources, allowing organizations to scale storage as data volumes increase without being forced to provision additional compute capacity. Option C ('Compute can be scaled up or down without the requirement to add more storage') emphasizes that compute resources (virtual warehouses) can be scaled independently based on processing needs, without requiring changes to storage. This decoupling enables cost optimization and flexible resource management. Option A is incorrect because it describes tight coupling, which is the opposite of Snowflake's architecture. Option D is misleading because while compute and storage can be scaled together, the key benefit is that they can be scaled independently. Option E is unrelated to the separation of compute and storage, as disk spilling is a performance consideration, not a direct benefit of this architectural separation. The community discussion strongly supports B and C with 100% consensus and detailed reasoning about independent scaling.

Author: LeetQuiz Editorial Team