DP-900 Describe core data concepts Practice Question
A logistics company tracks package deliveries. When a package is scanned at a distribution center, the system immediately updates the delivery status in a database so customers can see the live tracking information. At the end of each day, the company runs a job that aggregates all delivery status changes into a report for operational analysis. Which of the following best describes these two data processing workloads?
⚠ Common exam trap
A common mix-up: candidates confuse the speed of the underlying database update with the processing pattern, leading candidates to assume that any database write is batch, or that any scheduled job is real-time, when the key distinction is whether the processing is triggered by each event or runs on 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
✓
The status update is a real-time workload, and the daily report is a batch workload.
The immediate status update upon scanning is a real-time workload, as it processes data instantly for live customer visibility. The end-of-day aggregation job is a batch workload, as it processes accumulated data in a scheduled, non-real-time manner for operational reporting.
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 are batch processing workloads.
Why it's wrong here
Incorrect. The status update is not batch processing because a batch workload processes a group of records on a schedule or after a threshold is met, causing a delay between when data is generated and when it is processed. A package status update, by contrast, is processed as soon as a scan event occurs, individually and immediately, which is a real-time/streaming pattern. If status updates were batched, tracking information would be stale and logistics operations would lose the ability to react to deliveries in real time.
When this WOULD be correct
This option would be correct if the question described a scenario where all data is collected throughout the day and then processed together at the end of the day, such as a system that logs all scans and updates delivery statuses only after a nightly batch job runs.
- ✓
The status update is a real-time workload, and the daily report is a batch workload.
Why this is correct
Correct. The package status update is triggered by a discrete event (a barcode scan at a checkpoint) and must be reflected immediately in the tracking system, so it is a real-time/streaming workload that handles one event at a time with low latency. In contrast, the daily delivery report runs on a fixed schedule (e.g., nightly) and processes a large volume of accumulated delivery records as a bulk operation, which is the defining characteristic of a batch workload.
- ✗
Both are real-time processing workloads.
Why it's wrong here
Incorrect. While the status update is indeed real-time, the daily report is not. A real-time workload continuously ingests events and produces results with minimal delay; a daily report, however, runs on a scheduled cadence (for example, once per day) and processes all of the day's aggregated data in one bulk job. Scheduling a job to run at a specific time and processing a large dataset in bulk is classic batch processing, not real-time.
When this WOULD be correct
If the question described a system where package scans trigger immediate updates to the report (e.g., streaming analytics) and the daily job was also real-time (e.g., continuous aggregation), then both could be considered real-time workloads.
- ✗
The status update is a batch workload, and the daily report is a real-time workload.
Why it's wrong here
Incorrect. This reverses the correct classification. The package status update cannot be a batch workload because it is initiated immediately when the package is scanned, and the update must be available to customers and operations staff without waiting for a scheduled processing window; that event-driven, low-latency behavior is real-time. The daily report cannot be real-time because it is not triggered by a business event but rather by a time schedule, and it aggregates a large set of records using a bulk processing run, which is the hallmark of batch processing.
When this WOULD be correct
This option would be correct if the status updates were collected throughout the day and processed in a nightly batch job (e.g., scanning data logged and updated in bulk), while the daily report was generated on-demand with live data (e.g., streaming aggregation).
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.
✓The status update is a real-time workload, and the daily report is a batch workload.Correct answer▾
Why this is correct
Correct. The package status update is triggered by a discrete event (a barcode scan at a checkpoint) and must be reflected immediately in the tracking system, so it is a real-time/streaming workload that handles one event at a time with low latency. In contrast, the daily delivery report runs on a fixed schedule (e.g., nightly) and processes a large volume of accumulated delivery records as a bulk operation, which is the defining characteristic of a batch workload.
✗Both are batch processing workloads.Wrong answer — click to see why▾
Why this is wrong here
The status update is triggered by each scan event and reflects changes immediately, which is real-time processing, not batch. The daily report aggregates data after the fact, which is batch processing.
★ When this WOULD be the correct answer
This option would be correct if the question described a scenario where all data is collected throughout the day and then processed together at the end of the day, such as a system that logs all scans and updates delivery statuses only after a nightly batch job runs.
Why candidates choose this
Candidates may confuse 'immediate update' with batch processing if they think the database update is part of a larger scheduled job, or they may not distinguish between transactional updates and analytical aggregation.
✗Both are real-time processing workloads.Wrong answer — click to see why▾
Why this is wrong here
The daily report aggregates historical data at a scheduled time, which is batch processing, not real-time. The status update is immediate, making it real-time, so both cannot be real-time.
★ When this WOULD be the correct answer
If the question described a system where package scans trigger immediate updates to the report (e.g., streaming analytics) and the daily job was also real-time (e.g., continuous aggregation), then both could be considered real-time workloads.
Why candidates choose this
Candidates may confuse 'immediate' updates with 'real-time' processing for both workloads, overlooking that the daily report is scheduled and not continuous.
✗The status update is a batch workload, and the daily report is a real-time workload.Wrong answer — click to see why▾
Why this is wrong here
The status update is immediate upon scanning, which is real-time, not batch. The daily report aggregates data over a day, which is batch, not real-time. Option D reverses these definitions.
★ When this WOULD be the correct answer
This option would be correct if the status updates were collected throughout the day and processed in a nightly batch job (e.g., scanning data logged and updated in bulk), while the daily report was generated on-demand with live data (e.g., streaming aggregation).
Why candidates choose this
Candidates may confuse 'daily report' with real-time reporting or think that any scheduled job is real-time, leading them to reverse the workload types.
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
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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
This DP-900 question is part of Courseiva's 820-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. 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.