DP-900 Describe core data concepts Practice Question
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?
⚠ Common exam trap
Many candidates confuse the terms 'stream processing' and 'batch processing' by focusing on the data source (GPS is continuous) versus the processing schedule (nightly is periodic), rather than the fundamental processing paradigm of continuous vs. bulk data handling.
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 ingestion is stream processing; nightly aggregation is batch processing.
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.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
GPS ingestion is stream processing; nightly aggregation is batch processing.
Why this is correct
GPS ingestion is correctly classified as stream processing because telematics devices emit position records as a continuous, unbounded sequence of events that must be captured and processed with low latency to support live tracking. In contrast, the nightly aggregation job is batch processing because it operates on a bounded, finite set of data already collected, executing on a fixed schedule to compute summaries like daily mileage or route efficiency.
- ✗
GPS ingestion is batch processing; nightly aggregation is stream processing.
Why it's wrong here
Reversing the classifications misinterprets the fundamental data characteristics: GPS coordinates arrive from thousands of trucks continuously, and any delay in ingestion would break live fleet visibility, so it must be streamed. The nightly aggregation, however, is a point-in-time operation triggered by a scheduler, not by the arrival of new events, making it batch. Stream processing is driven by event arrival; batch processing is driven by a clock or manual trigger, so this option swaps those definitions.
When this WOULD be correct
If the question described a scenario where GPS data is collected in files throughout the day and processed nightly, and the nightly aggregation updates a live dashboard in real-time, then B would be correct.
- ✗
Both workloads are examples of stream processing.
Why it's wrong here
Labeling both workloads as stream processing is incorrect because the nightly aggregation does not run continuously on each incoming event. Stream processing consumes and reacts to data in near-real-time as it arrives, whereas the nightly job waits for a predetermined time, pulls all data accumulated since the last run, and processes it as a single, discrete batch. A scheduled batch job lacks the event-driven, incremental nature that defines true stream processing.
When this WOULD be correct
If the question described both workloads as continuously processing data as it arrives (e.g., GPS coordinates streamed and aggregated in real-time for immediate reporting), then both would be stream processing.
- ✗
Both workloads are examples of batch processing.
Why it's wrong here
Claiming both are batch processing ignores the real-time, event-driven nature of GPS ingestion. Batch processing requires collecting a large volume of data over a period and then processing it in one bulk operation, which would introduce hours of delay—unacceptable for live tracking. GPS data is generated continuously and must be ingested, enriched, and made queryable almost immediately, which is the antithesis of a batch job that starts only after data collection ends.
When this WOULD be correct
If the question described a scenario where GPS data is collected in files throughout the day and processed in a nightly batch job, and the aggregation is also batch, then both would be batch processing. For example: 'A company collects GPS logs in daily CSV files and runs a nightly job to process them into a report.'
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.
✓GPS ingestion is stream processing; nightly aggregation is batch processing.Correct answer▾
Why this is correct
GPS ingestion is correctly classified as stream processing because telematics devices emit position records as a continuous, unbounded sequence of events that must be captured and processed with low latency to support live tracking. In contrast, the nightly aggregation job is batch processing because it operates on a bounded, finite set of data already collected, executing on a fixed schedule to compute summaries like daily mileage or route efficiency.
✗GPS ingestion is batch processing; nightly aggregation is stream processing.Wrong answer — click to see why▾
Why this is wrong here
GPS ingestion processes data in real-time as it arrives, which is stream processing, not batch. Nightly aggregation processes a fixed set of data at scheduled intervals, which is batch processing, not stream.
★ When this WOULD be the correct answer
If the question described a scenario where GPS data is collected in files throughout the day and processed nightly, and the nightly aggregation updates a live dashboard in real-time, then B would be correct.
Why candidates choose this
Candidates may confuse the continuous nature of GPS data collection with batch processing, or mistakenly think that nightly jobs are stream processing because they run regularly.
✗Both workloads are examples of stream processing.Wrong answer — click to see why▾
Why this is wrong here
The nightly aggregation job processes a full day's data at once, which is batch processing, not stream processing. Stream processing handles data in real-time as it arrives, which applies only to the GPS ingestion.
★ When this WOULD be the correct answer
If the question described both workloads as continuously processing data as it arrives (e.g., GPS coordinates streamed and aggregated in real-time for immediate reporting), then both would be stream processing.
Why candidates choose this
Candidates may confuse 'real-time' with any data processing that happens frequently, or mistakenly think that the nightly job is also stream processing because it runs regularly.
✗Both workloads are examples of batch processing.Wrong answer — click to see why▾
Why this is wrong here
GPS ingestion is real-time (stream processing), and the nightly aggregation is batch processing. Option D incorrectly classifies both as batch processing, ignoring the real-time nature of GPS data ingestion.
★ When this WOULD be the correct answer
If the question described a scenario where GPS data is collected in files throughout the day and processed in a nightly batch job, and the aggregation is also batch, then both would be batch processing. For example: 'A company collects GPS logs in daily CSV files and runs a nightly job to process them into a report.'
Why candidates choose this
Candidates may confuse 'ingestion' with 'batch' if they think of data being collected over time and processed later, not realizing that real-time ingestion is stream 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
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
Report
A report in Azure data services is a structured output that summarizes, visualizes, or details data stored in cloud databases or data warehouses, often used for business intelligence and monitoring.
About these practice questions
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
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.