**Batch**: Reporting, reconciliation, EOD. Higher latency; simpler; better for large scans. **Stream**: Fraud, trading, alerts. Low latency; complex; exactly-once critical. **Trade-off**: Batch cheaper; stream real-time. **Best practice**: Use both—batch for EOD; stream for...
This hard-level General/Other question appears frequently in data engineering interviews at companies like Goldman Sachs. While less common, it tests deeper understanding that distinguishes strong candidates.
This is a senior-level question that tests architectural thinking. Lead with the high-level design, then drill into specifics. Discuss trade-offs explicitly - there is rarely one correct answer. Show awareness of scale, fault tolerance, and operational complexity.
Batch: Reporting, reconciliation, EOD. Higher latency; simpler; better for large scans. Stream: Fraud, trading, alerts. Low latency; complex; exactly-once critical. Trade-off: Batch cheaper; stream real-time. Best practice: Use both—batch for EOD; stream for time-sensitive. Lambda architecture or Kappa.
Want feedback on your answer?
Paste your answer to this question and our AI Coach scores it, finds gaps, and shows you the FAANG-level version.
Get the most asked SQL questions with expert answers. Instant download.
No spam. Unsubscribe anytime.
Paste your answer and get instant AI feedback with a FAANG-level improved version.
Analyze My Answer — FreeAccording to DataEngPrep.tech, this is one of the most frequently asked General/Other interview questions, reported at 1 company. DataEngPrep.tech maintains a curated database of 1,863+ real data engineering interview questions across 7 categories, verified by industry professionals.