Seconds to Trend

A medium Pipeline Design mock interview question on DataDriven, with an AI interviewer who asks follow-up questions and a hire or no-hire decision at the end.

Domain
Pipeline Design
Difficulty
medium
Seniority
mid

Interview Prompt

Design the pipeline that turns roughly 5 billion engagement events a day (views, likes, watch-time pings) from a short-video app into 2 outputs: a trending surface of the hottest videos and the daily active user and 7-day retention reports. Both read the same events, and streaming everything is not an option.

How This Interview Works

  1. Read the vague prompt (just like a real interview)
  2. Ask clarifying questions to the AI interviewer
  3. Draw your pipeline on the design canvas: sources, transforms, storage and checks
  4. Answer the interviewer's follow-up questions, then get a hire or no-hire decision