Which statement accurately describes Snowflake's architecture?
A.
It uses a local data repository for all compute nodes in the platform.
B.
It is a blend of shared-disk and shared-everything database architectures.
C.
It is a hybrid of traditional shared-disk and shared-nothing database architectures.
D.
It reorganizes loaded data into internal optimized, compressed, and row-based format.
The Answer Is:
C
This question includes an explanation.
Explanation:
Snowflake's architecture is unique in that it combines elements of both traditional shared-disk and shared-nothing database architectures. This hybrid approach allows Snowflake to offer the scalability and performance benefits of a shared-nothing architecture (with compute and storage separated) while maintaining the simplicity and flexibility of a shared-disk architecture in managing data across all nodes in the system. This results in an architecture that provides on-demand scalability, both vertically and horizontally, without sacrificing performance or data cohesion.