Snowflake Interview Questions and Guide
Database internals, query optimization, cloud storage engines, low-level concurrency, and distributed transactions.
The Snowflake interview loop
- Recruiter screen
- Technical phone screen (coding / systems)
- Onsite: 4–5 rounds covering algorithms, concurrency, database internals, and distributed systems
Snowflake interview questions
- Design a Distributed Cache
- Design a Distributed File System
- Design a Distributed Key-Value Store
- Design an Enterprise Data Integration Platform
- In-Memory Database (Multi-Part)
- Implement an LRU Cache
- Happy Number
- Shortest Word Distance
- Simplify Path
- Design Browser History
- The Maze
- Maximum Number of Events That Can Be Attended
- Boundary of Binary Tree
- Step-By-Step Directions From a Binary Tree Node to Another
- Count Nodes Equal to Average of Subtree
- Course Schedule II
- Max Area of Island
- Making A Large Island
- Possible Bipartition
- Parallel Courses III
- Most Stones Removed with Same Row or Column
- Shortest Bridge
- Parallel Courses
- Painting the Walls
- Maximize Distance to Closest Person
- Design In-Memory File System
- Design File System
- Tell me about a problem you noticed that nobody else was addressing
- Tell me about a difficult technical trade-off you made
- Tell me about a time you dove deep to find the root cause
- Tell me about a time you did more with less
- Tell me about solving a problem from first principles