Dataford
Top 50
Prep plan
Updated weekly · Last refresh Aug 30

Snowflake Software Engineer Interview Questions

The questions to prepare for a Snowflake Software Engineer interview. Questions from real interview reports rank first. Updated weekly.

50questions
~7htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 12 questions · ~101 min
Role Privilege InheritanceMedium
Practice

Compute each Snowflake role's transitive privileges from a directed acyclic role-inheritance graph using DFS and memoization.

Snowflake
Delayed Binary SearchHard
Recently asked

Tests reasoning about search algorithms under delayed feedback and careful state management.

time complexitySearchingbasicsSnowflake
More Coding questions with a free account
2
Execution7 questions · ~59 min
Metadata Service for Columnar StorageHard
Recently asked

Tests distributed systems design for metadata reliability, sharding strategy, and cross-AZ replication.

design systemconsistencyshardingSnowflake
More Execution questions with a free account
3
System Design12 questions · ~101 min
Tracking Memory Usage Like DriveHard

Evaluates your ability to design scalable storage accounting and data modeling.

Snowflake
More System Design questions with a free account
4
Security & Infrastructure4 questions · ~34 min
Network Routing and Firewall ConceptsHard

Assesses your understanding of networking fundamentals and infrastructure concepts.

NetworkingSnowflake
More Security & Infrastructure questions with a free account
5
SQL & Data Manipulation10 questions + 3 drills · ~114 min
SQL Questions From ResumeMedium

Assesses your SQL proficiency and ability to apply it to resume-relevant topics.

sqlSnowflake
MQL Month-over-Month GrowthMedium
Practice
Practice drill

Calculate monthly MQL counts and month-over-month growth by Snowflake campaign channel using CTEs and LAG.

Window FunctionsDate FunctionsAggregationsSnowflakeSnowflake Computing
SQL Average Selling PriceMedium
Practice
Practice drill

Calculate weighted average selling prices by product using a date-range join, aggregation, and NULL handling.

leetcodesqlCostarCostar Group
SQL Query for Expected ResultsMedium
Practice
Practice drill

Use LEFT JOINs, a CTE, and aggregation to summarize 2025 claims and completed payments for active Guidewire PolicyCenter policies.

databasesqlGGuidewire Software
More SQL & Data Manipulation questions with a free account
6
Behavioral & Leadership3 questions · ~25 min
More Behavioral & Leadership questions with a free account
7
More topics2 questions · ~17 min
Distributed Scheduler With At-Least-OnceHard
Recently asked

Tests reliability engineering for distributed scheduling, retry semantics, and failure handling.

SchedulingOrchestrationfault toleranceSnowflake
Bi-Directional Sync With OrderingHard
Recently asked

Tests event ordering guarantees, idempotency, and fault-tolerant design for real-time bi-directional sync.

data integrationStream Processingfault toleranceSnowflake

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
The finish line: interview-readyComplete all 50 questions plus 3 hands-on drills to finish this plan.