Snowflake Interview Questions
Practice the exact questions companies are asking right now.
Validate an extended tic-tac-toe state
Problem You are given a 3×3 tic-tac-toe board state as an array of 3 strings, each of length 3. Each cell is one of: - 'X' (player X) - 'O' (player O)...
Design an object store with deduplication
System Design Prompt Design a simplified cloud object storage service (similar to an object store) that allows users to upload and download files. The...
Implement course scheduling and rate limiter analysis
You are given two independent coding problems. --- Problem 1: Course Scheduling You are planning to take a set of courses and are given prerequisite r...
Design transactional in-memory key-value store
Problem Design and implement an in-memory key–value store that supports basic operations plus transactions. Core API Implement the following operation...
Contrast FCF vs NI; choose one statement
An asset-heavy company reports rising net income while free cash flow (FCF) is negative for three straight quarters. a) Explain when and why FCF can b...
Lead innovation and automate a critical process
Describe a specific project where you led an end-to-end innovation from idea to production. Be concrete: - What was the problem, constraints, and succ...
Design an analytic warehouse for event data
Design a warehouse-ready analytics data model and ingestion plan to support cohort retention, ARPU, and product-case analyses at scale (50M events/day...
Present an end-to-end project and defend decisions
End-to-End Project Presentation + Deep-Dive Follow-ups Instructions (10 minutes, max 5 slides) Present an end-to-end project you led that shipped to r...
Solve and optimize 3Sum and variants at scale
Implement a function that returns all unique triplets (i, j, k) of indices whose values sum to a target T, with strong performance and deduplication g...
Decide and justify product metrics amid trade-offs
Smart Sort Feed Ranking: Metrics, Experiment, Decisions, and Monitoring Context: You are introducing a new Smart Sort ranking for a content feed. It s...
Build a cohort dashboard with Streamlit and SQL
You are given three tables and asked to build a minimal Streamlit app that helps a PM explore weekly cohort retention and ARPU by country. Assume SQL ...
Describe navigating ambiguous, repetitive questioning
Behavioral: Handling Repeated, "Fishing" Questions Context: You're a Data Scientist in a technical screen or stakeholder review. The other person keep...
Design an A/B test for ML model launch
Feed Ranker A/B Test Design and Powering You are replacing the current ranker with a new model in a feed. Baseline CTR is 2.0%. You expect a +5% relat...
Design and validate a cost-sensitive classifier
Binary Purchase Prediction with Delayed Labels and Imbalanced Classes Context - Goal: Ship a real-time binary classifier that predicts whether a user ...
Query seven-day conversion with windows and dedupe
Assume all timestamps are UTC. Treat "today" as 2025-09-01. Define "last 7 days" as the inclusive window [2025-08-26 00:00:00, 2025-09-01 23:59:59]. S...
Derive uniform RNGs from limited or biased sources
Sampling Construction and Analysis: From rand5() to rand7(), General randM()→randN(), and Fairness from a Biased Source You have access to a uniform p...
Implement DFS with cycle detection and topo order
Implement DFS (recursive and iterative) with topo sort, cycle detection, and timestamps You are given a directed graph G with N nodes labeled 1..N and...
Check balanced parentheses with multiple bracket types
Given a string containing only parentheses '()', determine whether it is balanced. Follow-up: extend the solution to also support '[]' and '{}' with c...
Design cache for DAG-based query views
System Design: Caching Strategy for a DAG of Materialized Views Context You are designing an analytics system that computes materialized query views. ...
Design under vague distributed requirements
System Design Prompt: Distributed Metadata Catalog and Schema Registry Context Design a multi-tenant distributed Metadata Catalog and Schema Registry ...