Where is Snowflake metadata stored?

The correct answer is C. In the cloud services layer. Snowflake's architecture is divided into three layers: database storage, query processing, and cloud services. The metadata, which includes information about the structure of the data, the SQL operations performed, and the service-level policies, is stored in the cloud services…

Snowflake Cloud Data Platform Features and Architecture

Question

Options

AWithin the data files
BIn the virtual warehouse layer
CIn the cloud services layer
DIn the remote storage layer

How the community answered

(37 responses)

A
3% (1)
B
3% (1)
C
95% (35)

Explanation

Snowflake's architecture is divided into three layers: database storage, query processing, and cloud services. The metadata, which includes information about the structure of the data, the SQL operations performed, and the service-level policies, is stored in the cloud services layer. This layer acts as the brain of the Snowflake environment, managing metadata, query optimization, and transaction coordination.

Topics

#Snowflake Architecture#Metadata Management#Cloud Services Layer

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice