Top 2
Prep plan
Updated weekly · Last refresh Oct 17Snowflake Research Analyst Interview Questions
The questions to prepare for a Snowflake Research Analyst interview. Questions from real interview reports rank first. Updated daily.
2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →1
SQL & Data ManipulationStart here. 2 questions + 3 drills · ~46 min
LLM Training Methods and ScalingHard
Assesses understanding of LLM optimization methods and distributed training at scale.
SnowflakeSnowflake Tools and Data WorkflowsMedium
Assesses familiarity with Snowflake-centric data and analytics tooling and workflows.
SnowflakeSQL Query OptimizationMedium
Practice
Practice drillOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
Performance Tuningdatabase optimizationindexesDDroisys
Capgemini
Nomura
CapgeminiNomuraSecond and Nth Highest ValuesMedium
Practice
Practice drillFind the second highest distinct salary and adapt the query to retrieve any requested salary rank.
Data Manipulationsqldatabase querying
Snowflake ComputingKKGISL
SBS
Snowflake ComputingKKGISLSBSRolling 7-Day Average QueryMedium
Practice
Practice drillCalculate Deliveroo's daily order volume and rolling 7-day average using a date spine, aggregation, and window functions.
sql query
Koch Minerals & Trading
DeliverooLLSEG (London Stock Exchange Group)
Koch Minerals & TradingDeliverooLLSEG (London Stock Exchange Group)Sign up to see every question
Create a free account to unlock this list and practice real interview questions.
The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.