Top 12
Company roadmap
Updated weekly · Last refresh Sep 7
S

SBB Interview Questions

The questions to prepare for SBB interviews, across all roles. Questions from real interview reports rank first. Updated daily.

12questions
~2htotal time
Track your progressSign up free to work through all 12 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 4 questions + 2 drills · ~57 min
SQL: 7-Day Rolling AverageMedium
Practice

Calculate each CVS store's 7-day rolling sales average using a CTE, aggregation, join, and window function.

Window FunctionsDate FunctionsRunning TotalsSSBB
Ensuring SQL Data AccuracyEasy

Explain how to ensure data accuracy in SQL workflows using validation checks, reconciliation, and careful query design.

JoinsData WranglingQualitySSBB
Optimizing Slow PostgreSQL Research QueriesMedium

Explain how you diagnosed and optimized a slow PostgreSQL query using execution plans, indexing, and query rewrites.

JoinsData WranglingAggregationsSSBB
Top Daily Rides by VehicleMedium
Practice
Practice drill

Rank the top 3 completed rides per vehicle per day using joins, a CTE, and ROW_NUMBER.

Window FunctionsJoinsData WranglingWaymo
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership3 questions · ~28 min
More Behavioral & Leadership questions with a free account
3
More topics5 questions · ~47 min
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsSSBB
Design Test for New FeatureMedium

Design an A/B test for a new platform feature, including success metrics, power, guardrails, and a clear ship decision.

experiment designfeature evaluationA/B TestingSSBB
Statistical Significance in Hypothesis TestingEasy

Explain what statistical significance means and why it matters when interpreting experimental or analytical results.

Hypothesis TestingData AnalysisStatistical SignificanceSSBB
First Checks for Metric DropsEasy

Outline the first checks to diagnose a sudden drop in a core product metric, starting with data quality, scope, and decomposition.

Lagging IndicatorsLeading IndicatorsDiagnosisSSBB
Avoid Pitfalls in Online ExperimentsHard

Explain common online experimentation pitfalls and how to design, analyze, and decide in ways that avoid false wins.

Network InterferenceNovelty EffectSample Ratio MismatchSSBB

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 12 questions plus 2 hands-on drills to finish this plan.