DataDriven
LearnPracticeInterviewDiscussDailyJobs

Clickstream and Session Schema

A medium 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
medium
Seniority
L5

Interview Prompt

We run a large e-commerce site with web and mobile apps. We capture every click, page view, and product interaction as raw events. Users browse from multiple devices, and we need to stitch their activity into sessions and build a complete picture of the purchase journey. We get about 600 million events per day. Design the data model.

Summary

Millions of clicks, mostly anonymous.

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