SnowPro Core Certification — Question 137

What is a key feature of Snowflake architecture?

Answer options

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

Correct answer: C

Explanation

The correct answer, C, is accurate because Snowflake's virtual warehouse architecture allows for independent scalability of compute resources, thus eliminating resource contention. Options A, B, D, and E, while they describe features of Snowflake, do not specifically address the architecture's key characteristic of resource management and scalability.