Answer-first summary for fast verification
Answer: Snowflake eliminates resource contention with its virtual warehouse implementation.
The question asks for a key feature of Snowflake's architecture. Option C is correct because Snowflake's virtual warehouse implementation, which separates compute from storage and allows independent scaling of compute resources, is a fundamental architectural feature that eliminates resource contention by providing dedicated compute clusters for different workloads. This is supported by the community discussion where C has the highest percentage (67%) and multiple comments with upvotes explain that virtual warehouses prevent contention by allowing isolated compute resources. Option D is incorrect because, as clarified in the discussion, multi-cluster warehouses handle concurrency (multiple queries across clusters), not a single query spanning multiple clusters—a single query runs within a single cluster. Options A, B, and E are not key architectural features: A misdescribes zero-copy cloning (clones are independent, not mirrors), B refers to maintenance, not architecture, and E is an optimization, not a core architectural element.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
What is a key characteristic of Snowflake's architecture?
A
Zero-copy cloning creates a mirror copy of a database that updates with the original.
B
Software updates are automatically applied on a quarterly basis.
C
Snowflake eliminates resource contention with its virtual warehouse implementation.
D
Multi-cluster warehouses allow users to run a query that spans across multiple clusters.
E
Snowflake automatically sorts DATE columns during ingest, for fast retrieval by date.
No comments yet.