Which statement accurately describes Snowflake's architecture?

Question

Options

• AIt uses a local data repository for all compute nodes in the platform.
• BIt is a blend of shared-disk and shared-everything database architectures.
• CIt is a hybrid of traditional shared-disk and shared-nothing database architectures.
• DIt reorganizes loaded data into internal optimized, compressed, and row-based format.

• A
  3% (1)
• B
  3% (1)
• C
  85% (29)
• D
  9% (3)

Explanation

Snowflake's architecture is a hybrid of shared-disk and shared-nothing designs. Like shared-disk architectures, all virtual warehouses (compute nodes) access the same centralized cloud storage layer (S3, Azure Blob, GCS), so data does not need to be partitioned across nodes. Like shared-nothing architectures, each virtual warehouse has its own dedicated CPU, memory, and local disk cache - compute nodes do not share these resources with each other. Option A is wrong because the storage is centralized, not local per node. Option B is wrong because Snowflake is not 'shared-everything.' Option D is wrong because Snowflake stores data in columnar (not row-based) format.

No community discussion yet for this question.