Snowflake Interview Questions
The questions to prepare for Snowflake interviews, across all roles. Questions from real interview reports rank first. Updated weekly.
Reverse a singly linked list in place using pointer manipulation in O(n) time.
SnowflakeCalculate monthly MQL counts and month-over-month growth by Snowflake campaign channel using CTEs and LAG.
SnowflakeAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreUse ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.
Replit
QuantcastSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Describe how you handled a project that failed or required a major pivot, including stakeholder alignment, trade-offs, and risk management.
SnowflakeDefine the core metrics for a new product launch, from early adoption and activation to retention and long-term value.
SnowflakeApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
SnowflakeA framework for deciding which features should ship first when building a new product.
SnowflakeDesign an LLM serving system that balances latency, cost, scalability, and safety for production traffic.
SnowflakeCompare Random Forest and Gradient Boosting, then choose the right ensemble for a supervised learning task.
Snowflake