Streaming vs Batch Processing in Azure Data Workloads
A data engineering team at a logistics company handles two distinct data processing workloads. The first workload ingests GPS data from delivery trucks every 10 seconds and updates a dashboard showing real-time vehicle locations. The second workload processes monthly CSV files of completed deliveries to generate reports on delivery times and route efficiency. Which statement correctly identifies these workloads?
Quick Answer
The correct answer is that the GPS data processing is a streaming workload and the monthly report processing is a batch workload. This distinction hinges on the timing and continuity of the data: streaming workloads handle continuous, near-real-time data flows—like GPS coordinates arriving every 10 seconds—and require constant processing to update live dashboards, while batch workloads process large, static datasets collected over a period, such as monthly CSV files, in a single scheduled job. On the Microsoft Azure Data Fundamentals DP-900 exam, this concept tests your ability to match data characteristics to Azure services: streaming workloads typically use Azure Stream Analytics or Event Hubs, whereas batch workloads rely on Azure Data Factory or Synapse Pipelines. A common trap is confusing periodic micro-batches (e.g., every 10 seconds) with true batch processing—remember that if data is processed as it arrives, it is streaming. For a quick memory tip, think “streaming is a river, batch is a bucket”—a river flows continuously, while a bucket fills up and is emptied all at once.
⚠ Common exam trap
Watch out — candidates often confuse the frequency of data arrival (every 10 seconds) with batch processing, not recognizing that continuous, low-latency ingestion defines a streaming workload, not just the presence of a schedule.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
GPS data processing is a streaming workload; monthly report processing is a batch workload
C is correct because GPS data ingested every 10 seconds is a continuous, near-real-time stream, making it a streaming workload. Monthly CSV file processing is a classic batch workload, as data is collected over a period and processed in a single, scheduled job. This distinction is fundamental in Azure data services: streaming workloads use services like Azure Stream Analytics or Event Hubs, while batch workloads use Azure Synapse Pipelines or Azure Data Factory.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Both workloads are streaming workloads
Why it's wrong here
Incorrect. The monthly file processing is not streaming; it is batch because data is processed in scheduled, large chunks.
- ✗
GPS data processing is a batch workload; monthly report processing is a streaming workload
Why it's wrong here
Incorrect. This reverses the correct classification. Real-time GPS updates are streaming, not batch.
- ✓
GPS data processing is a streaming workload; monthly report processing is a batch workload
Why this is correct
Correct. Real-time data ingestion and dashboard updates represent a streaming workload. Scheduled processing of large files is a batch workload.
- ✗
Both workloads are batch workloads
Why it's wrong here
Incorrect. Real-time GPS updates are not batch; they are processed continuously with low latency, characteristic of streaming.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
Key term
Azure Data Factory
Azure Data Factory is a cloud-based data integration service that lets you create, schedule, and orchestrate data pipelines to move and transform data from various sources to destinations.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A manufacturing company uses IoT sensors to monitor machine temperature. The data is analyzed immediately to trigger alerts if temperature exceeds a threshold. The same data is also stored and later analyzed to identify long-term trends. Which two terms best describe these data processing approaches?
easy- ✓ A.Real-time processing for alerts, batch processing for trend analysis
- B.Stream processing for alerts, transactional processing for trend analysis
- C.Batch processing for alerts, real-time processing for trend analysis
- D.OLAP for alerts, OLTP for trend analysis
Why A: Only Option A is correct. In this scenario, alerts require immediate analysis, which is achieved by real-time processing (or stream processing). For long-term trend analysis, data is stored and processed in bulk using batch processing. Option B incorrectly pairs stream processing with transactional processing: transactional processing (OLTP) is designed for transaction-oriented workloads, not analytical trend analysis. The correct approach for trend analysis is batch processing, not transactional processing. Options C and D reverse the pairings or use inappropriate terms (OLAP/OLTP) for the described workloads.
Variation 2. A car manufacturing company has two data processing systems: one system processes real-time sensor data from assembly lines to immediately detect equipment failures, and another system processes historical production records to generate monthly efficiency reports. Which two types of data processing workloads best describe these systems?
easy- ✓ A.Stream processing and batch processing
- B.OLTP and OLAP
- C.Online processing and offline processing
- D.Transactional processing and analytical processing
Why A: Stream processing (option A) handles real-time sensor data from the assembly line to detect equipment failures immediately, while batch processing (option A) is ideal for processing historical production records on a scheduled basis to generate monthly efficiency reports. Transactional processing (option D) refers to OLTP workloads that process business transactions, not real-time sensor streams, so it is not a correct description for the first system. The correct answer is A only.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DP-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DP-900 exam.