Design a Sensor Log Ingestion and Query Service
Versions of this have come up at Applied Intuition all through the past year. In a December 2025 in-person loop, one candidate was asked for a module programmers would use to interpret and process data from driving environments. A March 2026 phone screen handed over files full of schemas and asked how to query what they contain. A July 2026 technical screen framed it as sensor data processing, with raw versus processed data, schema design, time-range queries, aggregation and validation all on the table. In October 2026, an AI-assisted virtual onsite had one candidate build the query API over MCAP driving logs and then demo it.
A one-hour drive has camera images at one rate, GPS at another and IMU readings a hundred times a second, and every message is stamped with its own time. An engineer chasing a bug wants the vehicle's speed between two moments, or the location at the instant a frame was captured. The file was written for recording and playback. The service's job is to make it answer those questions in milliseconds. The scale here is per run, and it's lopsided. A few hundred thousand small messages sit next to tens of gigabytes of images. Most of the design follows from treating those two very differently.
Applied IntuitionPremium lesson · System design round
The Applied Intuition design, worked end to end.
- The API and data modelSystem design · Signature problem
- The design, drawn out1 diagram
- 6 deep divesWith the tradeoffs
$49 a year · all 107 companies · instant access
20,000+ candidate reports · guide updated
Applied Intuition interview guideKnow what Applied Intuition asks before you walk in.
10 coding · 4 system design · 15 behavioral questions
Get their questions first.
InterviewLegend is independent and not affiliated with or endorsed by any company it covers.