DataDrivenDataDriven
LearnPracticeInterviewDiscussDailyJobs

Between the Cameras

A easy Data Modeling mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
Data Modeling
Difficulty
easy
Seniority
L4

Interview Prompt

We run a toll road network where a camera reads a vehicle's license plate when it enters a tolled section and again when it leaves, and the same commuter plate turns up several times a day. Operations needs live traffic volume, the average time a vehicle spends crossing a section, and an alert for any plate that entered but never exited. Model each completed crossing as one record. Design the data model.

Summary

Every plate that goes in should come out. Watch the ones that don't.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Write your data modeling solution with real code execution
  4. Get instant feedback and a hire/no-hire decision

Related

  • All Mock Interviews
  • Practice Mode (untimed)
  • Data Modeling Interview Questions
  • Data Engineering Interview Prep Guide
  • Practice Problems
  • Daily Challenge