Every Region Exports Its Own Way

A medium Pipeline Design interview practice problem on DataDriven. Write and execute real pipeline design code with instant grading.

Domain

Pipeline Design

Difficulty

medium

Seniority

L5

Problem

Our sales organization runs entirely on GCP and needs an end-to-end data pipeline to move transactional sales data from multiple regional databases into a centralized analytics layer. Right now every regional team runs its own ad-hoc exports. Design a unified pipeline that handles ingestion, transformation, and storage and delivers query performance that meets business SLAs.

Summary

Sales data, BigQuery, Dataflow. Make it all sing.

Practice This Problem

Solve this Pipeline Design problem with real code execution. DataDriven runs your solution and grades it automatically.