Design an Interactive SQL Notebook
Design a notebook where users run read-only SQL and retrieve durable results without overwhelming the browser or query workers.
Open practiceSnowflake interview practice
Practice from 65 Snowflake-tagged public coding problems, organized only by the stage, topic, difficulty, and recency metadata FastPrep can verify. The broader public catalog also includes 5 system-design exercises.
OA practice path
Build a timed implementation rhythm from prompt to edge cases. Problems are ranked by repeated public catalog sightings.
48 Snowflake-tagged Online Assessment problems available.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
SNSnowflake | String Formation (Also for AI/ML Software Engineer Intern :)Dynamic ProgrammingString | Hard | 5 public reportsLast reported Aug 2026 | Practice |
SNSnowflake | Horizontal Pod AutoscalerArraySegment Tree | Medium | 3 public reportsLast reported Jul 2026 | Practice |
SNSnowflake | Vowel SubstringStringSliding Window | Medium | 3 public reportsLast reported Jun 2026 | Practice |
SNSnowflake | Efficient DeploymentsDynamic ProgrammingArray | Hard | 3 public reportsLast reported Jun 2026 | Practice |
SNSnowflake | Generating Login CodesArrayTwo Pointers | Medium | 2 public reportsLast reported Aug 2026 | Practice |
SNSnowflake | Minimum Clicks Between Wiki PagesGraphBreadth-First Search | Easy | 2 public reportsLast reported Jul 2026 | Practice |
SNSnowflake | Minimum HeightTreeBinary Search | Medium | 2 public reportsLast reported Jul 2026 | Practice |
SNSnowflake | Maximum Order VolumeDynamic ProgrammingSorting | Hard | 2 public reportsLast reported Mar 2025 | Practice |
SNSnowflake | Minimum Total WeightHeapGreedy | Medium | 2 public reportsLast reported Mar 2025 | Practice |
SNSnowflake | Paint the CeilingSortingBinary Search | Medium | 2 public reportsLast reported Mar 2025 | Practice |
SNSnowflake | Unequal Elements (Also for Core/Database Intern :)Dynamic ProgrammingArray | Hard | 2 public reportsLast reported Mar 2025 | Practice |
SNSnowflake | Drawing EdgeGraphCombinatorics | Easy | 1 public reportLast reported Jun 2026 | Practice |
SNSnowflake | Minimum Index Distance Between Person and CakeArrayTwo Pointers | Easy | 1 public reportLast reported May 2026 | Practice |
SNSnowflake | Simple Array Rotation GameArrayMath | Easy | 1 public reportLast reported Apr 2026 | Practice |
SNSnowflake | Max Element Indexes After Rotations | Unrated | 1 public reportLast reported Mar 2026 | Practice |
SNSnowflake | Grid Traversal (Infrastructure Automation Internship)Breadth-First SearchMatrix | Hard | 1 public reportLast reported May 2025 | Practice |
SNSnowflake | Find the Maximum Length of a Good Subsequence I (LC 3176 :)Dynamic ProgrammingHash Table | Medium | 1 public reportLast reported Dec 2024 | Practice |
SNSnowflake | Remove Stones to Minimize the Total (LC 1962 :)HeapGreedy | Easy | 1 public reportLast reported Dec 2024 | Practice |
SNSnowflake | String Patterns (Also for Core/Database Intern :)Dynamic ProgrammingCombinatorics | Medium | 1 public reportLast reported Oct 2024 | Practice |
SNSnowflake | Solve Matrix Equations (Also for AI/ML Interns :)MathSimulation | Easy | 1 public reportLast reported Oct 2024 | Practice |
Phone practice path
Practice solving while explaining assumptions, tradeoffs, and complexity. Problems are ranked by repeated public catalog sightings.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
SNSnowflake | Minimum N-ary Tree Depth DeletionsTreeBreadth-First Search | Medium | 2 public reportsLast reported Aug 2026 | Practice |
SNSnowflake | Design In-Memory File SystemDesignHash Table | Hard | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Effective Access ControlGraphTopological Sort | Medium | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Recent Event Stream QueriesHash TableQueue | Medium | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Distributed Tree Counting State MachineTreeQueue | Medium | 1 public reportLast reported Jul 2026 | Practice |
SNSnowflake | Maximum Number of Events That Can Be AttendedArraySorting | Medium | 1 public reportLast reported Jul 2026 | Practice |
SNSnowflake | Simulate a Queued Multi-Rule Rate LimiterArrayQueue | Medium | 1 public reportLast reported Jul 2026 | Practice |
SNSnowflake | Closest Target CharacterString | Easy | 1 public reportLast reported Jul 2026 | Practice |
SNSnowflake | Character Frequencies Across Nested String ListsArrayHash Table | Easy | 1 public reportLast reported Jun 2026 | Practice |
SNSnowflake | Character Frequencies Across StringsArrayHash Table | Easy | 1 public reportLast reported Jun 2026 | Practice |
SNSnowflake | Top Two Users by Total Purchase AmountArrayHash Table | Easy | 1 public reportLast reported Jun 2026 | Practice |
SNSnowflake | Effective Role PrivilegesGraphTopological Sort | Medium | 1 public reportLast reported May 2026 | Practice |
SNSnowflake | Closest Bathroom / Desk on a Grid | Unrated | 1 public reportLast reported May 2026 | Practice |
Onsite practice path
Practice complete solutions and defend the choices behind them. Problems are ranked by repeated public catalog sightings.
| Company | Problem | Difficulty | Public evidence | Action |
|---|---|---|---|---|
SNSnowflake | Parallel Courses IIIGraphTopological Sort | Hard | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Sliding-Window Rate LimiterArrayQueue | Medium | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Execute Tasks by PriorityHeapHash Table | Medium | 1 public reportLast reported Aug 2026 | Practice |
SNSnowflake | Priority Task Execution with Duplicate IDsHeapHash Table | Medium | 1 public reportLast reported Aug 2026 | Practice |
Current official guidance
Snowflake describes an engineering process with an initial screen, technical interviews, and a panel, while explicitly noting that the sequence can vary by role and team and may include an in-person step.
Primary sources checked .
01 · Stage workflow
Use the assessment-heavy public coding inventory as transferable practice while keeping platform claims tied to individual records and current recruiter guidance. Your invitation and recruiter guidance remain the source of truth.
Use the timing and format in your invitation as the source of truth. In practice, work without interruptions, budget time to read constraints, and reserve a final review window for boundary cases.
Treat the problem as a conversation. Clarify the contract, describe the approach before implementation, and keep narrating meaningful decisions while you code and test.
Use the catalog's onsite labels as practice context, not as a promise about a specific loop. Focus on collaborative problem solving: compare approaches, implement cleanly, and explain how the solution behaves at scale.
02 · Broader technical practice
These public Snowflake-tagged exercises cover additional technical formats. They are included only when a verified catalog record and a crawlable practice page both exist.
Design a notebook where users run read-only SQL and retrieve durable results without overwhelming the browser or query workers.
Open practiceDesign a reliable data platform that ingests heterogeneous SaaS sources into one governed, lineage-preserving analytics layer.
Open practiceDesign a durable service that stores future jobs, dispatches them when due, and records retryable execution outcomes safely.
Open practiceDesign a calendar frontend that keeps day, week, and month views coherent across event creation, deletion, recurring series, and one-occurrence rescheduling.
Open practiceDesign a durable multi-tenant queue whose enqueue, receive, and acknowledge semantics remain understandable through network ambiguity and client or server crashes.
Open practice03 · Evidence boundary
It means practicing transferable implementation, testing, and technical reasoning with public catalog assets FastPrep tags to Snowflake. It does not mean FastPrep has access to the company's assessments or any private interview bank.
Repeated public sightings and last-reported dates can help you prioritize practice, but they cannot predict the questions, format, or platform in a specific interview.
04 · Plain answers
This page owns technical-practice intent for Snowflake. Hiring activity, timelines, and market signals remain on the separate hiring-insights page.
No. FastPrep currently has 42 Snowflake-tagged coding problems with an explicit HackerRank label. The other 23 coding records do not establish HackerRank for a current interview, so follow your invitation and recruiter guidance.
No. FastPrep is an independent interview-preparation product and is not affiliated with Snowflake. The page uses FastPrep's public practice catalog and does not claim official, private, leaked, or proprietary employer questions.
Stage labels come from FastPrep's public problem metadata. A problem can carry more than one reported stage, and hiring processes can change by role, level, location, and date. Treat the labels as preparation context, not a guarantee.
Start with the stage named in your invitation or recruiter message. If no stage is known, use the largest available set to build general problem-solving fluency, then rehearse explanation and testing separately.
No. Public catalog counts, stage tags, and last-reported dates can help prioritize practice, but they cannot predict a specific interview's questions, sequence, timing, or platform.
Your next stage, made concrete
Start with the stage named in your invitation, then use public evidence as context—not as a promise of what you will be asked.
Open the practice set