DataDrivenDataDriven
LearnPracticeInterviewDailyJobsCommunity

The Query That Used to Be Fast

A medium Pipeline Design mock interview question on DataDriven. Practice with AI-powered feedback, real code execution, and a hire/no-hire decision.

Domain
Pipeline Design
Difficulty
medium
Seniority
L5

Interview Prompt

Analysts run interactive dashboards against a 2TB Snowflake fact table that used to answer in seconds; now the same date-filtered and merchant-filtered queries take minutes and blow past the 30-second interactive SLA. Design the remediation: give those dashboards a served surface fed from the warehouse, and stand up a scheduled job that tracks p95 query duration and pages the team when performance regresses, all within the CFO's cost ceiling.

Summary

Queries used to be fast. Something changed.

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 pipeline design solution with real code execution
  4. Get instant feedback and a hire/no-hire decision

Related

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