Snowflake
15 questionsArchitecture, virtual warehouses, time travel, streams & tasks. Master Snowflake for your cloud data warehouse interviews.
Multi-Cluster Shared Data Architecture
Explain Snowflake's architecture. How does it separate storage, compute, and cloud services?
Virtual Warehouse Sizing and Auto-Suspend
How do you choose the right virtual warehouse size? Explain auto-suspend and auto-resume.
Micro-Partitions and Clustering Keys
Explain micro-partitions in Snowflake. When and how would you define clustering keys?
Result Caching (Three Levels)
Describe the three levels of caching in Snowflake. How does each improve query performance?
Time Travel and Fail-Safe
What is Time Travel in Snowflake? How does it work with Fail-Safe?
Zero-Copy Cloning
What is zero-copy cloning in Snowflake? What are practical use cases?
Data Sharing
How does Snowflake Data Sharing work? What's the difference between direct sharing and the Snowflake Marketplace?
Snowpipe Auto-Ingest
How does Snowpipe work for continuous data loading? Compare it with batch COPY INTO.
Streams for Change Data Capture
How do Snowflake Streams work for CDC? Walk me through a practical implementation.
Snowflake vs Redshift vs BigQuery
Compare Snowflake, Redshift, and BigQuery. When would you choose each?
Cost Optimization Strategies
Your Snowflake bill doubled last month. Walk me through how you'd investigate and optimize costs.
External Tables and Stages
Explain Snowflake stages and external tables. When would you use an external table vs COPY INTO?
Materialized Views
How do materialized views work in Snowflake? When are they worth the cost?
Snowpark for Python
What is Snowpark and when would you use it instead of SQL or external Spark?
Tasks for Scheduling
How do Snowflake Tasks work? How do you build a task tree for a multi-step ETL pipeline?