Snowflake Interview Questions
Master your tech interview with our curated database of real questions from top companies.
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...
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 ...
Serialize and deserialize a dictionary trie
Design data structures and algorithms to serialize and deserialize a dictionary trie storing lowercase English words. Specify a compact wire format th...
Implement crawler and bracket validator
Implement two tasks: ( 1) Write a function crawl(start_urls, fetch, max_depth, domain_filter) that visits pages starting from the given seed URLs usin...
Design resilient auth with flaky third-party tokens
System Design: Resilient, Secure Request Flow with Unreliable Third‑Party Authorization Context You are designing a multi‑region, HTTP/JSON API where ...