Exam SnowPro Core topic 1 question 153 discussion

D is wrong. A single query does not span multiple clusters. It spans multiple nodes in a single cluster. This is why you expand the size of the WH to accommodate larger queries. C is correct.

The main feature

The answer is C. Multi cluster VWH supports concurrency meaning multiple queries can run in multiple clusters not one query spanning across multiple clusters

D Is correct,Multi Culster Warehouses contention with its virtual warehouse implementation.

D is correct. Multi cluster warehouses is the unique feature of SF.

C. Snowflake eliminates resource contention with its virtual warehouse implementation. Snowflake's architecture is built around the concept of separating compute resources from storage, allowing for scalability and eliminating resource contention through its virtual warehouse implementation. This architecture enables users to scale their compute resources up or down as needed without impacting the underlying data storage.

D based on docs

A. Zero-copy cloning creates a mirror copy of a database that updates with the original. is a key feature of Snowflake architecture. Snowflake's zero-copy cloning feature creates a snapshot of a database that is always up-to-date with the original database. This allows users to create clones of their databases for development, testing, and disaster recovery purposes without having to copy any data. Zero-copy cloning is also used to create time travel snapshots of databases.

Snowflake eliminates resource contention with multi-cluster " The overarching performance challenge with traditional data warehouses comes down to one thing: resource contention. Single-cluster systems—both in shared-disk and shared-nothing architectures—require all users in the data warehouse to share a limited set of resources. Too many concurrent users or workloads can lead to significant performance degradation and queueing. In contrast, Snowflake provides a patented multicluster, shared data architecture and intelligent use of readily available cloud resources to allow essentially limitless concurrency..." https://www.snowflake.com/wp-content/uploads/2020/01/how-snowflake-automates-performance-in-a-modern-cloud-data-warehouse.pdf#:~:text=Dedicated%20and%20separate%20virtual%20warehouses,It%20also%20eliminates%20contention.

D is correct. Multi cluster warehouses is the unique feature of SF.

"eliminates" is a strong word though, no? That skews me toward D.....

Snowflake eliminates resource contention with its virtual warehouse implementation.

C is correct

D is also correct but qst is about the key feature of snowflake

if its a single selection

C and D both correct answers

C is the answer