Stream Processing vs Batch Processing in Azure Data Fundamentals
A manufacturing company collects sensor data from equipment on the factory floor. The data is generated continuously and must be processed immediately to detect anomalies and trigger alerts. Which type of data processing workload best describes this scenario?
Quick Answer
The correct choice is stream processing. This scenario demands continuous data ingestion and immediate analysis to detect anomalies and trigger alerts in real time, which is the defining characteristic of stream processing—it handles unbounded, constantly flowing data with low latency. In contrast, batch processing operates on static datasets at scheduled intervals, making it unsuitable for urgent, event-driven responses. On the Microsoft Azure Data Fundamentals DP-900 exam, this distinction tests your understanding of workload types for Azure data services; a common trap is confusing high-volume data with batch processing, but the key differentiator is whether the data must be acted upon instantly or can wait. Remember the memory tip: if the data never stops and the alert can’t wait, think “stream” for immediate action.
⚠ Common exam trap
It's easy for candidates to confuse 'stream processing' with 'batch processing' because both can involve large volumes of data, but the key differentiator is the requirement for immediate, continuous processing versus scheduled, deferred processing.
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
✓
Stream processing
B is correct because the scenario requires continuous data ingestion and immediate processing to detect anomalies and trigger alerts, which is the defining characteristic of stream processing. Technologies like Azure Stream Analytics or Apache Kafka are designed to handle unbounded data streams with low-latency processing, unlike batch processing which operates on static datasets at scheduled intervals.
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 it's wrong here
Batch processing collects data over a period and processes it later, which would not allow immediate detection of anomalies.
When this WOULD be correct
A question where data is collected over a period (e.g., daily sensor logs) and then processed later for historical analysis or reporting, such as generating monthly equipment performance summaries. The key constraint would be that immediate action is not needed.
- ✓
Stream processing
Why this is correct
Stream processes data in real time as it arrives, making it suitable for scenarios requiring immediate alerts and actions.
- ✗
Transactional processing
Why it's wrong here
Transactional processing is used for individual operations like order processing, not for continuous real-time analysis.
When this WOULD be correct
A question describing an online transaction processing (OLTP) system, such as a retail point-of-sale system processing individual sales transactions with immediate inventory updates, would make transactional processing the correct answer.
- ✗
Analytical processing
Why it's wrong here
Analytical processing is used for historical analysis and reporting, not for immediate real-time detection.
When this WOULD be correct
A company wants to analyze historical sales data to identify trends and generate monthly reports. The data is collected over time and processed in large batches for business intelligence purposes.
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.
✓Stream processingCorrect answer▾
Why this is correct
Stream processes data in real time as it arrives, making it suitable for scenarios requiring immediate alerts and actions.
✗Batch processingWrong answer — click to see why▾
Why this is wrong here
The scenario requires immediate processing of continuously generated sensor data to detect anomalies and trigger alerts, which is the definition of stream processing. Batch processing processes data in large, delayed chunks, which cannot meet the real-time requirement.
★ When this WOULD be the correct answer
A question where data is collected over a period (e.g., daily sensor logs) and then processed later for historical analysis or reporting, such as generating monthly equipment performance summaries. The key constraint would be that immediate action is not needed.
Why candidates choose this
Candidates may confuse batch processing with any form of data processing involving large volumes of sensor data, overlooking the critical real-time requirement specified in the scenario.
✗Transactional processingWrong answer — click to see why▾
Why this is wrong here
Transactional processing is designed for discrete, ACID-compliant transactions (e.g., order entry), not for continuous, real-time sensor data streams that require immediate anomaly detection.
★ When this WOULD be the correct answer
A question describing an online transaction processing (OLTP) system, such as a retail point-of-sale system processing individual sales transactions with immediate inventory updates, would make transactional processing the correct answer.
Why candidates choose this
Candidates may confuse 'real-time' with 'transactional' because both involve immediate processing, but transactional processing focuses on individual, atomic operations rather than continuous data streams.
✗Analytical processingWrong answer — click to see why▾
Why this is wrong here
Analytical processing is used for historical analysis and reporting on large datasets, not for immediate anomaly detection and alerting on continuously generated sensor data.
★ When this WOULD be the correct answer
A company wants to analyze historical sales data to identify trends and generate monthly reports. The data is collected over time and processed in large batches for business intelligence purposes.
Why candidates choose this
Candidates may confuse 'analytical' with 'real-time analytics' or think that any data analysis, including anomaly detection, falls under analytical processing.
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
Stream processing
Stream processing is a data processing method that continuously analyzes and acts on data in real time as it arrives, rather than storing it first and processing it later.
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.
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 hospital collects patient vital signs every minute using IoT sensors. Each reading contains a timestamp, patient ID, heart rate, blood pressure, and temperature. This data is ingested continuously for real-time monitoring and alerting. Which type of data workload does this scenario best represent?
easy- A.A. Transactional workload
- B.B. Analytical workload
- C.C. Batch processing
- ✓ D.D. Real-time streaming
Why D: This scenario requires continuous ingestion of sensor data with immediate processing for real-time monitoring and alerting. Real-time streaming workloads, such as those handled by Azure Stream Analytics or Apache Kafka, are designed to process unbounded data streams with low latency, making option D correct.
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.