DP-900 Describe an analytics workload on Azure Practice Question
A logistics company needs to analyze GPS data from delivery trucks in real time to detect delays and reroute deliveries. The GPS data is streamed into Azure Event Hubs. They also need to combine this live data with static route information stored in Azure SQL Database. Which Azure service should they use for the real-time processing?
⚠ Common exam trap
Candidates often confuse Azure Stream Analytics with Azure Data Factory or Synapse Pipelines, mistakenly thinking that any data integration or pipeline service can handle real-time streaming, when in fact those services are batch-oriented and lack the low-latency stream processing engine required for live GPS analysis.
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
✓
Azure Stream Analytics
Azure Stream Analytics is the correct choice because it is designed for real-time stream processing, capable of ingesting data from Azure Event Hubs, applying SQL-like queries to detect delays, and joining live streams with static reference data from Azure SQL Database. This enables the logistics company to analyze GPS data as it arrives and trigger rerouting actions with minimal latency.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is a cloud data integration service that orchestrates and automates batch data movement and transformation, such as copying data between stores on a schedule or after a file arrives. While its triggers can initiate runs based on events, the service processes bounded datasets in discrete pipeline runs rather than continuously analyzing individual events as they stream. For GPS data that needs real-time route tracking or anomaly detection, you would need a true stream processor like Azure Stream Analytics, not an ETL orchestration tool.
- ✓
Azure Stream Analytics
Why this is correct
Azure Stream Analytics is a fully managed real-time analytics engine that executes SQL-like queries directly on streaming data from sources such as Azure Event Hubs, IoT Hub, or Blob storage. It can join live GPS event streams with reference data stored in Azure SQL Database to enrich delivery routes, and it supports windowing functions to detect patterns like delivery delays or geo-fence crossings. Its low-latency, continuous processing model makes it the appropriate service for analyzing GPS telemetry in motion, with outputs sent to Power BI, downstream alerts, or storage.
- ✗
Azure Analysis Services
Why it's wrong here
Azure Analysis Services is a semantic modeling platform that hosts tabular data models used for enterprise reporting and ad-hoc BI analytics, typically querying pre-aggregated historical data. It does not have a streaming ingestion pipeline or the ability to run continuous queries over unbounded event streams; it's a passive store that answers queries from tools like Power BI or Excel. Choosing it for real-time GPS analysis would require separately building batch ETL to populate the model, defeating the purpose of immediate detection.
- ✗
Azure Synapse Pipelines
Why it's wrong here
Azure Synapse Pipelines, which are powered by the same execution engine as Azure Data Factory, are designed for large-scale batch data integration, orchestration, and transformation across on-premises and cloud sources. They lack a native event-stream processing runtime, so they cannot evaluate each GPS ping as it arrives or maintain state across a sliding time window. While Synapse Analytics as a whole can query both batch and streaming data via Spark or SQL, the Pipelines component itself is not the real-time processing layer.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Azure Stream Analytics
Azure Stream Analytics is a fully managed, real-time data processing service that analyzes and transforms high volumes of streaming data from various sources to deliver low-latency insights and trigger actions.
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.
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.