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

Snap Business Analyst Interview Questions

The questions to prepare for a Snap Business Analyst interview. Questions from real interview reports rank first. Updated weekly.

16questions
~2htotal time
Track your progressSign up free to work through all 16 questions and resume where you left off.
Start practicing free →
1
MetricsStart here. 3 questions · ~24 min
Diagnose a Sudden DAU DropHard

Investigate whether an 8.2% DAU decline is driven by product breakage, logging issues, or normal seasonal patterns.

DAU/MAUDiagnosisTime SeriesSnap
Diagnose Cross Campaign CTR DropMedium

Investigate a 15% CTR drop across multiple campaigns by decomposing performance and separating measurement issues from real demand changes.

Funnel AnalysisKPIDiagnosisSnap
Metrics for Snapchat+ AdoptionMedium

Tests product analytics thinking and metric selection for subscription feature adoption.

adoptionkpi hierarchySnap
2
SQL & Data Manipulation3 questions + 3 drills · ~54 min
Window Functions vs AggregationsMedium

Tests understanding of SQL analytics patterns and when to use window functions.

Window FunctionsAggregationsSnap
Optimize Slow Join QueriesHard

Tests performance troubleshooting and query optimization strategies for large datasets.

Performance TuningJoinssqlSnap
SQL Scenario-Based Problem SolvingHard

Evaluates ability to apply SQL to real-world scenarios and reason through data problems.

Problem SolvingsqlSnap
Weekly Service KPI by TeamMedium
Practice
Practice drill

Analyze weekly service delivery performance by team using joins, a CTE, date aggregation, and KPI calculations.

KPIJoinssqlDeloitteReputation
Identify Funnel Bottlenecks in OnboardingHard
Practice
Practice drill

Use joins, CTEs, and aggregations to find the weakest step in an onboarding funnel and estimate lost conversions.

Funnel AnalysissqlDiagnosisAtlassianRevolut
Advanced SQL With PartitionsHard
Practice
Practice drill

Use CTEs, aggregations, and window functions to compare gender pay and find each department's second-highest salary.

Window FunctionsJoinssqlMeesho

Sign up to see every question

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

Get my prep plan
3
Behavioral & Leadership8 questions · ~64 min
More Behavioral & Leadership questions with a free account
4
More topics2 questions · ~16 min
Ad Inventory Allocation DecisionHard

Tests data-driven strategy and tradeoff analysis for ad product allocation.

Cost-Benefit AnalysisBusiness ModelSnap
Social Media Saturation StrategyMedium

Assesses strategic thinking for maintaining growth and engagement in a saturated market.

market analysissocial mediaSnap
The finish line: interview-readyComplete all 16 questions plus 3 hands-on drills to finish this plan.