Snowflake interview questionsQuestion 1 of 2
Snowflake interview question · Question 1 of 2
What are Snowflake virtual warehouses?
Short answer
A virtual warehouse is an independent compute cluster that runs queries against Snowflake's shared storage. You choose its size, and it is billed only while running, with auto-suspend and auto-resume to stop paying when idle. Because warehouses are independent, different workloads can use separate warehouses without slowing each other down; you scale up a warehouse for heavy queries and scale out with multi-cluster warehouses for many concurrent users.
Detailed explanation
- Independent: each warehouse has its own compute; a heavy transformation on one does not affect dashboards on another.
- Shared data: all warehouses read the same storage, so no data is copied.
- Elastic: resize at any time; suspend when idle.
| Problem | Response |
|---|---|
| Single large query is slow | Larger warehouse, after checking pruning |
| Many users, queries queueing | Multi-cluster (scale out) |
| High idle cost | Shorter auto-suspend, separate small warehouses |
Common mistakes
- Using one warehouse for everything.
- Scaling up to fix queueing.
- Forgetting that suspending clears the local cache, so the first queries after resume may be slower.
Progress is saved in this browser only. No account needed.