Building a Real-Time IoT Data Pipeline with Azure Services
A team is designing a data pipeline to process streaming sensor data from IoT devices. The data must be ingested, transformed in real time, and stored in a time-series database. Which combination of Azure services should they use?
Quick Answer
The correct combination is Azure IoT Hub, Azure Stream Analytics, and Azure Data Explorer. Azure IoT Hub serves as the secure ingestion point for streaming sensor data from IoT devices, while Azure Stream Analytics performs real-time transformation and analysis on the data streams as they flow through. Azure Data Explorer then stores the processed output in its optimized time-series database, purpose-built for high-velocity telemetry and log data. On the DP-900 exam, this scenario tests your understanding of how Azure services align with specific pipeline stages: ingestion, processing, and storage. A common trap is confusing Azure SQL Database or Cosmos DB for time-series storage, but remember that Data Explorer is the dedicated service for fast, analytical queries on timestamped data. Memory tip: think “Hub to Stream to Explorer” — each service handles one distinct phase of the real-time IoT pipeline.
⚠ Common exam trap
Candidates often confuse Azure Data Explorer with Azure Data Lake Storage or Azure SQL Database, assuming any storage service can handle time-series data, but ADX is the only Azure service purpose-built for high-ingestion-rate time-series analytics with features like materialized views and data sharding.
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 IoT Hub, Azure Stream Analytics, and Azure Data Explorer
Azure IoT Hub ingests streaming sensor data from IoT devices, Azure Stream Analytics provides real-time transformation and analysis of the data streams, and Azure Data Explorer (ADX) is a fully managed time-series database optimized for high-velocity telemetry data. This combination directly addresses the requirement for ingestion, real-time transformation, and time-series storage.
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 IoT Hub, Azure Data Lake Storage, and Azure Databricks
Why it's wrong here
Data Lake Storage is for batch storage, and Databricks is better for batch processing, not real-time stream processing.
- ✓
Azure IoT Hub, Azure Stream Analytics, and Azure Data Explorer
Why this is correct
IoT Hub ingests device data, Stream Analytics performs real-time transformations, and Data Explorer is a time-series database for fast analytics.
- ✗
Azure Event Hubs, Azure Functions, and Azure SQL Database
Why it's wrong here
Azure Functions can process streams but SQL Database is not designed for high-ingestion time-series workloads.
- ✗
Azure Event Hubs, Azure Synapse Pipelines, and Azure Cosmos DB
Why it's wrong here
Synapse Pipelines are for batch orchestration, not real-time, and Cosmos DB is not a time-series database.
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
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
About these practice questions
Courseiva writes every DP-900 question from scratch — 820 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
2 more ways this is tested on DP-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. You need to design a real-time dashboard that displays the number of orders placed in the last hour from an e-commerce application. The application writes orders to Azure Event Hubs. Which Azure service should you use to aggregate the data and serve the dashboard with minimal latency?
medium- A.Azure Databricks Structured Streaming
- ✓ B.Azure Stream Analytics with Power BI output
- C.Azure Analysis Services
- D.Azure Data Factory with tumbling window
Why B: Azure Stream Analytics is purpose-built for real-time data processing from sources like Event Hubs, and its native integration with Power BI enables direct output to a dashboard with sub-second latency. This combination provides the minimal-latency aggregation and serving required for a real-time orders dashboard without additional infrastructure.
Variation 2. A data engineer needs to process streaming data from IoT devices in near real-time and store the results in Azure Cosmos DB. Which Azure service should they use for the stream processing?
easy- A.Azure Synapse Analytics
- B.Azure Databricks
- ✓ C.Azure Stream Analytics
- D.Azure Data Factory
Why C: Azure Stream Analytics is the correct choice because it is a fully managed, real-time stream processing engine designed specifically for low-latency, near-real-time analytics on streaming data. It can ingest data from IoT devices via Event Hubs or IoT Hub, apply SQL-based transformations, and directly output the results to Azure Cosmos DB with millisecond latency, making it ideal for this scenario.
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.