Ctrl K
Data Engineer · Senior · System design

The business wants a real-time dashboard of revenue and order count, with no more than a minute of delay, and the numbers have to match the daily report. How would you design this system?

~10 min by voice

How to approach it

This checks whether the candidate can build real-time analytics that doesn't lie. They need to account for event time, late data, duplicates and order changes, honestly explain why the stream won't match the batch, and say how to fix that. Interviewers also look at whether the candidate clarifies requirements before reaching for an expensive stack.

Have you seen this question in a real interview?
Answers0
Avg. score—
Strong—
Practiced0
Topics
Similar questionsDesign a service where users upload CSV files of up to several gigabytes, and the service validates them and loads them into PostgreSQL. How would you build it in Python? Mid-levelA mobile app sends about a billion events a day. Design a system for collecting and storing these events so that analysts can build reports and product dashboards update within a few minutes. Mid-level

Answer by voice

The interviewer will ask this question and listen. Think out loud and ask for a hint if you need one. When you're done, pause or tap “That's my answer”. In about a minute, your score and the points you covered show up here.

Sign in to answer

Best with headphones · ~10 min