DP-900 Describe an analytics workload on Azure Practice Question
A company plans to implement a near-real-time analytics solution for streaming IoT sensor data. Which Azure service should they use to ingest and process the data streams?
⚠ Common exam trap
Test-takers frequently confuse batch-oriented services like Azure Data Factory or storage services like Data Lake Storage Gen2 with real-time stream processing, overlooking that Stream Analytics is the dedicated service for near-real-time data stream ingestion and 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 a real-time event processing engine designed to ingest, process, and analyze high-velocity streaming data from sources like IoT sensors. It supports SQL-based queries to transform and route data streams to outputs such as Power BI or Azure Synapse, making it ideal for near-real-time analytics.
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 an ETL/ELT orchestration service for data movement and transformation at scale, primarily batch-oriented. It can copy data from many sources to many sinks and trigger pipelines on schedules or events. However, it does not perform native stream processing with low-latency, event-at-a-time operations like windowing or anomaly detection; its streaming support is limited and it is not designed for near real-time analytics on live data streams.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is a unified analytics platform that combines data warehousing, big data analytics, and data integration. It can query data from various sources, including real-time data via Azure Stream Analytics or other pipelines, but it is not an ingestion or stream processing engine itself. Synapse provides serving and analytical capabilities (like T-SQL and Spark) on data that has already been collected, and its query engine is not built for continuous, low-latency event processing from IoT or telemetry streams in real time.
- ✗
Azure Data Lake Storage Gen2
Why it's wrong here
Azure Data Lake Storage Gen2 is a highly scalable and secure cloud storage service for big data analytics, built on Azure Blob Storage with a hierarchical namespace. It stores both structured and unstructured data at massive scale and acts as a landing zone or data lake for analytics. However, it is purely a storage service with no compute for data transformation or real-time processing; it cannot analyze or process streaming data by itself, only store it after ingestion.
- ✓
Azure Stream Analytics
Why this is correct
Azure Stream Analytics is a fully managed stream processing engine designed for real-time analytics on data from sources like Azure Event Hubs, Azure IoT Hub, or Azure Blob Storage. It supports a SQL-like query language to define windowing, aggregations, filtering, and alerts on live streams, with low-latency (sub-second to near real-time) results. It can output to many sinks including Power BI for dashboards, Synapse, storage, and more, making it the ideal service for near real-time analytics solutions.
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
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
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.