DP-900 Describe core data concepts Practice Question
A company operates an online store that processes customer orders. When a customer places an order, the system must immediately reduce the inventory count for the purchased items and record the order details. At the end of each month, the company runs reports that aggregate sales data over the past month to analyze trends. Which type of data processing workload best describes the order placement activity?
⚠ Common exam trap
A common mix-up: candidates confuse the immediate, atomic nature of order placement with batch or stream processing, when the key differentiator is the need for ACID compliance in a single, discrete operation.
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
✓
Transactional processing
Order placement requires immediate inventory reduction and order recording, which demands ACID (Atomicity, Consistency, Isolation, Durability) guarantees. This is a classic transactional processing workload, typically handled by OLTP (Online Transaction Processing) systems like SQL Server or Azure SQL Database, ensuring data integrity even under concurrent access.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Transactional processing
Why this is correct
Order placement is the archetypal OLTP workload: it demands immediate, atomic updates to both inventory and order tables, where a failure in any step rolls back the entire transaction. ACID properties (atomicity, consistency, isolation, durability) guarantee that stock levels never go negative and orders are never left half-recorded, even under concurrent customer requests. Unlike reporting or analytics, this is a low-latency, write-heavy operation that cannot tolerate deferred or inconsistent updates.
- ✗
Analytical processing
Why it's wrong here
Analytical processing (OLAP) is optimized for read-heavy, complex queries that aggregate historical data across millions of rows to support reporting, OLAP cubes, or data mining. It does not provide the row-level transactional integrity needed for a single order insertion that must atomically decrement inventory and insert an order record. While a monthly sales report is a valid OLAP use case, using OLAP to perform the order-placement write would introduce unacceptable latency and no ACID guarantees for the operational store.
When this WOULD be correct
If the question asked about the activity of generating monthly sales trend reports, analytical processing would be correct, as it involves aggregating and analyzing historical data to support decision-making.
- ✗
Batch processing
Why it's wrong here
Batch processing groups large volumes of data and executes them on a fixed schedule, such as nightly, rather than immediately on demand. If order placement were queued for a batch run, inventory counters would become stale and the system could accept orders for items that are already out of stock, leading to overselling. Batch is appropriate for periodic ETL or generating reports, but it violates the real-time consistency required at the moment a customer clicks 'buy'.
When this WOULD be correct
Batch processing would be correct for the end-of-month reporting activity described in the same question, where large volumes of historical sales data are aggregated periodically without real-time requirements.
- ✗
Stream processing
Why it's wrong here
Stream processing handles continuous data streams, such as sensor data or clickstreams, often with near real-time analysis. While order placement could be considered a stream, the primary need here is transactional integrity, not continuous stream analytics.
When this WOULD be correct
A question describing a system that continuously ingests real-time sensor data from IoT devices and must detect anomalies within milliseconds would make stream 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.
✓Transactional processingCorrect answer▾
Why this is correct
Order placement is the archetypal OLTP workload: it demands immediate, atomic updates to both inventory and order tables, where a failure in any step rolls back the entire transaction. ACID properties (atomicity, consistency, isolation, durability) guarantee that stock levels never go negative and orders are never left half-recorded, even under concurrent customer requests. Unlike reporting or analytics, this is a low-latency, write-heavy operation that cannot tolerate deferred or inconsistent updates.
✗Analytical processingWrong answer — click to see why▾
Why this is wrong here
Order placement requires immediate, atomic updates to inventory and order records, which is the hallmark of transactional processing, not analytical processing, which focuses on querying and aggregating historical data.
★ When this WOULD be the correct answer
If the question asked about the activity of generating monthly sales trend reports, analytical processing would be correct, as it involves aggregating and analyzing historical data to support decision-making.
Why candidates choose this
Candidates may confuse the need to process data (orders) with the eventual use of that data for analysis, mistakenly thinking that any data processing is analytical.
✗Batch processingWrong answer — click to see why▾
Why this is wrong here
Order placement requires immediate inventory reduction and recording, which is real-time, interactive, and ACID-compliant—characteristics of transactional processing, not batch processing. Batch processing would delay these updates, causing inventory inconsistencies.
★ When this WOULD be the correct answer
Batch processing would be correct for the end-of-month reporting activity described in the same question, where large volumes of historical sales data are aggregated periodically without real-time requirements.
Why candidates choose this
Candidates may confuse the monthly reporting (which is batch) with the order placement activity, or think that any data processing involving multiple records (like orders) is batch, overlooking the real-time transactional nature of order placement.
✗Stream processingWrong answer — click to see why▾
Why this is wrong here
Order placement requires immediate inventory reduction and recording, which is transactional processing (ACID properties). Stream processing handles continuous data flows but does not guarantee immediate, consistent updates per transaction.
★ When this WOULD be the correct answer
A question describing a system that continuously ingests real-time sensor data from IoT devices and must detect anomalies within milliseconds would make stream processing correct.
Why candidates choose this
Candidates may confuse 'real-time' order placement with stream processing, not realizing that transactional processing is designed for immediate, atomic updates to a database.
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
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
Key term
OLTP
OLTP (Online Transaction Processing) is a data processing system designed to manage and record high volumes of real-time transactions, such as bank deposits or online purchases, quickly and reliably.
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.