Top 28
Prep plan
Updated weekly · Last refresh Oct 17

Root Data Analyst Interview Questions

The questions to prepare for a Root Data Analyst interview. Questions from real interview reports rank first. Updated daily.

28questions
~4htotal time
Track your progressSign up free to work through all 28 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 5 questions · ~46 min
Optimizing a Slow QueryMedium
Practice

Rewrite a slow PostgreSQL reporting query to reduce scanned rows, avoid join multiplication, and return accurate monthly site metrics.

Subqueriesdatabase optimizationJoinsRoot
Handling Missing DataMedium
Practice

Standardize missing observation fields with fallback values, missingness flags, and ordered output.

Window Functionsmissing valuesdata cleaningRoot
More SQL & Data Manipulation questions with a free account
2
Metrics4 questions · ~37 min
Measure Core Feature EngagementMedium

Define the metrics that show whether engagement in a core feature is improving.

RetentionDiagnosisEngagement MetricsRoot
Improve Customer Retention with DataMedium

Tests metric selection and causal reasoning for retention initiatives.

KPIsRetentionDiagnosisRoot
More Metrics questions with a free account
3
A/B Testing & Experimentation3 questions · ~28 min
Pitfalls in Streaming Experiment AnalysisHard

Identify major online experiment pitfalls and explain how they can bias results in a streaming product A/B test.

Network InterferenceNovelty EffectSample Ratio MismatchRoot
Case Analysis for A/B TestingHard

Evaluates your ability to design and reason through real-world A/B test analysis.

ExperimentationRoot
More A/B Testing & Experimentation questions with a free account
4
Behavioral & Leadership12 questions · ~111 min
More Behavioral & Leadership questions with a free account
5
More topics4 questions · ~37 min
Prioritize Customer Segment for ImprovementMedium

Decide which customer segment should get a new product improvement first.

User SegmentsFeature PrioritizationValue PropositionRoot
Data Quality in ETL PipelinesEasy

Approach for maintaining data quality and integrity across ETL pipelines.

IdempotencyData ModelingQualityRoot
More questions with a free account

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 28 questions to finish this plan.