DP-900 Describe an analytics workload on Azure Practice Question
A company needs to analyze streaming data from IoT devices in real time. They want to identify anomalies and trigger alerts. Which Azure service should they use as the core processing engine?
⚠ Common exam trap
It's easy for candidates to confuse batch processing tools like Synapse Analytics or Databricks with real-time stream processing, overlooking that only Azure Stream Analytics is designed as a dedicated, low-latency stream processing engine for this exact pattern.
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 purpose-built for real-time stream processing, allowing you to define SQL-like queries that run continuously against streaming data from sources like IoT Hub. It can detect anomalies and trigger alerts on the fly, making it the correct core processing engine for this IoT scenario.
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 Stream Analytics
Why this is correct
Azure Stream Analytics is a real-time event-processing engine that can ingest millions of events per second from IoT devices via Event Hubs or IoT Hub, apply a SQL-based query language with temporal windows (tumbling, hopping, sliding) to detect anomalies or threshold breaches, and emit instantaneous alerts to Power BI, Logic Apps, or Azure Functions. Its native support for time-sliced aggregations and low-latency pipelines makes it the most fitting choice for the specific requirement of analyzing streaming telemetry and triggering immediate notifications.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is a unified analytics service that bridges enterprise data warehousing with big data processing using SQL pools and Apache Spark, optimized for T-SQL queries over massive historical datasets, data integration pipelines, and interactive BI dashboards. Although it can consume streaming data via Spark Structured Streaming, its architecture prioritizes batch-oriented, multi-stage transformations and complex analytical workloads over event-by-event, sub-second alert generation, making it too heavyweight and higher-latency for instantaneous IoT anomaly responses.
- ✗
Azure Databricks
Why it's wrong here
Azure Databricks is not designed for the immediate, low-latency processing required for real-time IoT anomaly detection and instantaneous alerting. While it supports streaming data via Structured Streaming, its underlying micro-batch architecture introduces latency unsuitable for sub-second, event-by-event analysis. Databricks excels in advanced analytics, machine learning, and complex data transformations over large datasets, including historical streaming data, making it suitable for deeper insights or model training rather than instantaneous alerts.
- ✗
Azure Data Lake Storage
Why it's wrong here
Azure Data Lake Storage Gen2 is a hierarchical, massively scalable object store that provides secure, cost-effective petabyte-scale persistence for raw or curated data, including streams archived from IoT devices, but it contains no built-in compute engine capable of running queries, evaluating conditions in real time, or emitting alerts. It serves as a durable landing zone where Stream Analytics or other services can later read and process data, not as the mechanism that performs the actual analysis or notification.
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 →
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.