Batch Processing vs Stream Processing
An e-commerce company runs a data pipeline that reads all orders from the previous hour, aggregates total sales per product category, and writes the results to a reporting database. The pipeline executes at the start of every hour. Which type of data processing workload does this pipeline represent?
Quick Answer
The answer is batch processing. This is the correct choice because the pipeline collects all orders from the previous hour and processes them as a single, scheduled job at the start of each hour, rather than handling each order as it arrives. In batch processing, data is gathered over a fixed time window—here, one hour—and then transformed in bulk, making it ideal for non-real-time, high-volume tasks like hourly sales aggregation. On the Microsoft Azure Data Fundamentals DP-900 exam, this scenario tests your ability to distinguish batch from stream processing, where stream processing would handle data continuously, such as updating sales totals with every new order. A common trap is confusing scheduled jobs with real-time processing; remember that if data waits for a timer before being processed, it is batch. For a memory tip, think of a baker who bakes all the cookies from orders placed in the last hour at once—that is batch, not baking each cookie the moment it is ordered.
⚠ Common exam trap
Many exam-takers confuse scheduled batch processing with stream processing because both can handle time-windowed aggregations, but batch processes data in discrete, scheduled chunks while stream processes data continuously as it arrives.
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
✓
Batch processing
This pipeline reads all orders from the previous hour, aggregates total sales per product category, and writes results to a reporting database at the start of every hour. This is a classic batch processing workload because data is collected over a fixed time window (one hour) and processed as a single, scheduled job, not continuously. Batch processing is ideal for non-real-time, high-volume data transformations like hourly sales aggregation.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Batch processing
Why this is correct
The pipeline processes a batch of data (hourly orders) on a schedule, which is batch processing.
- ✗
Stream processing
Why it's wrong here
Streaming processes data in real time as it's generated, not in scheduled batches.
When this WOULD be correct
A scenario where the pipeline must process orders as they arrive (e.g., within seconds) to update sales dashboards or trigger alerts would make stream processing correct.
- ✗
Transactional processing
Why it's wrong here
Transactional processing handles individual CRUD operations, not scheduled aggregations.
When this WOULD be correct
A question describing an OLTP system that records each order as it occurs, ensuring atomicity and consistency, would make transactional processing correct.
- ✗
Interactive processing
Why it's wrong here
Interactive processing supports user-initiated queries, not automated scheduled jobs.
When this WOULD be correct
A question describing a business analyst running ad-hoc queries on a sales database to explore trends and get immediate results would make interactive processing correct.
Option-by-option analysis
Why each answer is right or wrong
Understanding why wrong answers are wrong — and when they would be correct — is what separates a 750 score from a 900. The DP-900 exam frequently reuses these exact scenarios with slightly different constraints.
✓Batch processingCorrect answer▾
Why this is correct
The pipeline processes a batch of data (hourly orders) on a schedule, which is batch processing.
✗Stream processingWrong answer — click to see why▾
Why this is wrong here
The pipeline processes data in hourly intervals, not continuously, and does not require real-time or near-real-time analysis of streaming data.
★ When this WOULD be the correct answer
A scenario where the pipeline must process orders as they arrive (e.g., within seconds) to update sales dashboards or trigger alerts would make stream processing correct.
Why candidates choose this
Candidates may confuse 'hourly execution' with 'streaming' because both involve time-based triggers, but stream processing implies continuous, low-latency data ingestion, not periodic batch jobs.
✗Transactional processingWrong answer — click to see why▾
Why this is wrong here
Transactional processing focuses on individual transactions (e.g., order placement) with ACID guarantees, not on aggregating historical data in scheduled batches.
★ When this WOULD be the correct answer
A question describing an OLTP system that records each order as it occurs, ensuring atomicity and consistency, would make transactional processing correct.
Why candidates choose this
Candidates may confuse 'transactional' with any data operation involving business transactions, overlooking the batch scheduling and aggregation aspects.
✗Interactive processingWrong answer — click to see why▾
Why this is wrong here
Interactive processing involves real-time user interaction and immediate response, but the pipeline runs automatically every hour without user input, making it batch processing.
★ When this WOULD be the correct answer
A question describing a business analyst running ad-hoc queries on a sales database to explore trends and get immediate results would make interactive processing correct.
Why candidates choose this
Candidates may confuse 'interactive' with any automated process that runs periodically, or think that any data processing that produces reports is interactive.
Analysis generated from the official DP-900blueprint and verified against question context. The “when correct” sections are what AI assistants cite when candidates ask “what’s the difference between these options?”
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Batch processing
Batch processing is a method of running high-volume, repetitive data jobs where a group of transactions is collected, processed together automatically, and then results are produced without real-time user interaction.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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
1 more way 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 logistics company ingests GPS coordinates from delivery trucks in real-time to update a live tracking dashboard. They also run a nightly job to aggregate the day's deliveries into a report stored in Azure SQL Database. Which statement correctly describes the data processing types used for these two workloads?
easy- ✓ A.GPS ingestion is stream processing; nightly aggregation is batch processing.
- B.GPS ingestion is batch processing; nightly aggregation is stream processing.
- C.Both workloads are examples of stream processing.
- D.Both workloads are examples of batch processing.
Why A: The real-time ingestion of GPS coordinates from delivery trucks is a classic stream processing workload, where data is processed continuously as it arrives with low latency. The nightly aggregation of daily deliveries into a report stored in Azure SQL Database is a batch processing workload, where data is processed in bulk at scheduled intervals. Azure Stream Analytics is commonly used for the streaming ingestion, while Azure SQL Database or Azure Synapse Analytics can handle the batch aggregation.
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.