Architecture Flashcards
What is Snowflake Architecture an Hybrid off?
Traditional Share Disk and Shared Nothing Database Architecture
How does Snowflake processes queries?
Using MPP(Massive Parallel Processing) compute clusters where each node in the cluster stores a portion of the entire data set locally
How does Snowflake reorganizes data?
Snowflake reorganizes that data into its internal optimized, compressed, columnar format.
Three layers of the Snowflake Architecture
Database Storage
Query Processing
Cloud Services
Services managed in Cloud Services Layer
Authentication
Infrastructure management
Metadata management
Query parsing and optimization
Access control
Which ONE of the following terms BEST describes Snowflake’s Architecture?
- Shared Disk
- Shared Nothing
- Shared Data
- Shared Memory
Shared Data
What happens when a virtual warehouse is scaled up
All subsequent queries take advantage of the additional resources
What are data storage cost calculations based on in Snowflake?
Compressed Size and Amount Store (Daily Average)
How often does Snowflake release new features?
Weekly
