Top 50
Company roadmap
Updated weekly · Last refresh Oct 17

Photon Interview Questions

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

50questions
~8htotal time
Track your progressSign up free to work through all 50 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 4 questions · ~41 min
2
SQL & Data Manipulation4 questions · ~41 min
7-Day Rolling Active UsersMedium
Practice

Compute daily active users and a 7-day rolling average using a CTE, distinct counts, and window functions.

Window FunctionsDate FunctionsRunning TotalsPhoton
More SQL & Data Manipulation 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
3
Pipelines4 questions · ~41 min
Data Quality and Schema EvolutionMedium

Approach for handling schema changes and data quality checks in a high-volume data lake pipeline.

schema evolutionData ModelingQualityPhoton
More Pipelines questions with a free account
4
Machine Learning3 questions · ~30 min
Fine-Tuning vs Prompted APIsMedium

Compare when to fine-tune a foundation model versus relying on prompt engineering with a managed API.

Trade-offsPrompt Engineeringmodel fine-tuningPhoton
More Machine Learning questions with a free account
5
Execution4 questions · ~41 min
Recover a Slipping ProjectMedium

Explain how you would diagnose and recover a project that is falling behind schedule without losing stakeholder trust.

Success CriteriaRoadmappingRisk AssessmentPhoton
More Execution questions with a free account
6
Metrics4 questions · ~41 min
Define Success for a ProjectEasy

Define what success means for a project using clear KPIs, a north star, and supporting metrics.

KPIsSuccess CriteriaDiagnosisPhoton
More Metrics questions with a free account
7
More topics27 questions · ~274 min
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 TestingPhoton
Design an LLM Serving PlatformHard

Design an LLM serving system that balances latency, cost, scalability, and safety for production traffic.

Cold StartFeature StoreModel ServingPhoton
More questions with a free account
The finish line: interview-readyComplete all 50 questions to finish this plan.