Interview preparation
Snowflake interview questions for Data Engineers
Every question starts with a direct answer you could say out loud, then explains why, when and what goes wrong. Tick questions off as you practise.
All Snowflake questions
| # | Question | Difficulty | Type | Done |
|---|---|---|---|---|
| 1 | What are Snowflake virtual warehouses? | Easy | conceptual | |
| 2 | What caches does Snowflake use, and when does each one help? | Easy | conceptual, scenario | |
| 3 | What is the difference between Snowflake Time Travel and Fail-safe? | Easy | conceptual, scenario | |
| 4 | What is zero-copy cloning in Snowflake, and how would you use it? | Easy | conceptual, scenario | |
| 5 | How do micro-partitions affect Snowflake query performance? | Medium | conceptual, optimization | |
| 6 | How do you build an incremental pipeline with Snowflake streams and tasks? | Medium | architecture, coding | |
| 7 | Should you scale a Snowflake warehouse up or out? | Medium | optimization, scenario | |
| 8 | When should you define a clustering key on a Snowflake table? | Medium | optimization, scenario |
Ticks are saved in this browser only. No account needed.
No questions match these filters
Clear a filter to see more questions.
Concept review
- LessonBeginnerSnowflake Architecture: Storage, Compute and Cloud Services
- LessonAdvancedSnowflake Cost Optimization: Credits, Right-Sizing and Storage Costs
- LessonAdvancedSnowflake Data Sharing, Reader Accounts and the Marketplace
- LessonBeginnerLoading Data into Snowflake: Stages, COPY INTO and Snowpipe
- LessonIntermediateSnowflake Micro-Partitions, Clustering and Search Optimization
- LessonAdvancedSnowflake Security: RBAC, Masking, Row Access Policies and Network Policies
- LessonIntermediateSnowflake for Data Engineers
- LessonIntermediateSnowflake vs Databricks: How to Compare Them
- LessonIntermediateSnowflake Streams and Tasks: Change Data Capture and Scheduling
- LessonIntermediateSnowflake Table Types and Semi-Structured Data: VARIANT, FLATTEN, Dynamic and Iceberg Tables
- LessonIntermediateSnowflake Time Travel, Fail-safe and Zero-Copy Cloning
- LessonIntermediateSnowflake Virtual Warehouses: Sizing, Scaling and Concurrency