DP-900 Describe an analytics workload on Azure Practice Question
A manufacturing company connects thousands of IoT sensors on an assembly line, each sending telemetry data every second. The data volume is terabyte-scale per day. The company needs to analyze the sensor data in near real-time to detect anomalies (e.g., temperature spikes) and also allow data scientists to run interactive ad-hoc queries on the historical data to find patterns. They prefer using a query language similar to SQL. Which Azure service should they choose?
⚠ Common exam trap
Test-takers frequently choose Azure Stream Analytics because it handles real-time streaming and uses SQL-like syntax, but they overlook the requirement for interactive ad-hoc queries on historical data, which Stream Analytics cannot efficiently support.
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 Data Explorer
Azure Data Explorer (ADX) is designed for high-velocity telemetry data, ingesting terabytes per day from IoT sensors with sub-second latency. It supports Kusto Query Language (KQL), which is SQL-like and optimized for time-series analysis, anomaly detection, and interactive ad-hoc queries on both real-time and historical data. This makes it the ideal choice for the described 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 it's wrong here
Azure Stream Analytics is a real-time stream processing engine that runs continuous SQL-like queries over unbounded live data, but it is not an interactive analytical store. It outputs results to sinks such as Event Hubs, Azure Storage, or Power BI, without natively retaining a queryable historical dataset or providing an ad-hoc KQL/SQL interface for exploration. This focused, one-way processing pattern makes it unsuitable for the requirement to interactively query both streaming and historical time-series data from millions of IoT sensors.
When this WOULD be correct
A company needs to process real-time streaming data from IoT devices and output alerts or aggregated results to a storage or dashboard, without requiring interactive ad-hoc querying on historical data. For example, filtering sensor readings and sending alerts when temperature exceeds a threshold.
- ✓
Azure Data Explorer
Why this is correct
Azure Data Explorer (ADX) is purpose-built for high-velocity time-series telemetry, using columnar storage with a clustered columnstore index and the Kusto Query Language (KQL) for powerful time-series functions like series_fft and anomaly detection. It supports streaming ingestion with sub-second latency and retains both hot and cold caches, allowing the same KQL queries to run interactively over both live and historical data. This makes it the optimal choice for IoT sensor data requiring near real-time monitoring and ad-hoc exploration.
- ✗
Azure Synapse Analytics dedicated SQL pool
Why it's wrong here
Azure Synapse Analytics dedicated SQL pool is a massively parallel processing (MPP) data warehouse optimized for large-scale relational analytics via T-SQL and standard BI workloads. While it can ingest and query large volumes of data, its ingestion path is batch-oriented (e.g., PolyBase) and less suited for high-frequency, low-latency IoT streams; schema-on-write and maintenance overhead add friction. Its query engine is also not designed for specialized time-series functions or interactive anomaly detection on streaming telemetry, making it too heavyweight for this use case.
When this WOULD be correct
A company needs to run complex SQL-based analytics on petabytes of structured historical data from multiple sources (e.g., sales, inventory) with high concurrency and predictable performance. They do not require real-time ingestion or streaming, and the data is already stored in a data lake or warehouse.
- ✗
Azure Databricks with Structured Streaming
Why it's wrong here
Azure Databricks with Structured Streaming excels at complex real-time data processing, ETL, and machine learning on streaming data, supporting SQL-like queries. This makes it tempting for high-volume stream ingestion and anomaly detection. However, for interactive ad-hoc SQL queries directly on terabyte-scale historical data with near real-time performance, Databricks can incur higher operational overhead and latency compared to services specifically designed for low-latency analytical querying of time-series data. It would be ideal for scenarios demanding extensive data engineering or sophisticated ML model training on the stream.
When this WOULD be correct
A company needs to process streaming data from IoT sensors, perform complex transformations (e.g., joining with static datasets), and train machine learning models on the processed data using Python or Scala. They require a unified platform for both stream processing and advanced analytics.
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.
✓Azure Data ExplorerCorrect answer▾
Why this is correct
Azure Data Explorer (ADX) is purpose-built for high-velocity time-series telemetry, using columnar storage with a clustered columnstore index and the Kusto Query Language (KQL) for powerful time-series functions like series_fft and anomaly detection. It supports streaming ingestion with sub-second latency and retains both hot and cold caches, allowing the same KQL queries to run interactively over both live and historical data. This makes it the optimal choice for IoT sensor data requiring near real-time monitoring and ad-hoc exploration.
✗Azure Stream AnalyticsWrong answer — click to see why▾
Why this is wrong here
Azure Stream Analytics is designed for real-time stream processing but lacks native support for interactive ad-hoc queries on historical data at terabyte scale. It cannot serve as a single service for both real-time anomaly detection and historical pattern analysis with SQL-like queries.
★ When this WOULD be the correct answer
A company needs to process real-time streaming data from IoT devices and output alerts or aggregated results to a storage or dashboard, without requiring interactive ad-hoc querying on historical data. For example, filtering sensor readings and sending alerts when temperature exceeds a threshold.
Why candidates choose this
Candidates may think Stream Analytics can handle both real-time and historical analysis because it uses SQL-like queries, but they overlook its limitations in storing and interactively querying large historical datasets.
✗Azure Synapse Analytics dedicated SQL poolWrong answer — click to see why▾
Why this is wrong here
Azure Synapse Analytics dedicated SQL pool is optimized for large-scale data warehousing and complex queries on structured data, but it is not designed for near real-time ingestion and analysis of high-velocity streaming data like IoT telemetry at terabyte-per-day scale. Its batch-oriented architecture introduces latency that conflicts with the near real-time anomaly detection requirement.
★ When this WOULD be the correct answer
A company needs to run complex SQL-based analytics on petabytes of structured historical data from multiple sources (e.g., sales, inventory) with high concurrency and predictable performance. They do not require real-time ingestion or streaming, and the data is already stored in a data lake or warehouse.
Why candidates choose this
Candidates may associate 'SQL-like queries on large datasets' with Synapse's dedicated SQL pool, overlooking the near real-time and high-velocity streaming requirements that make Azure Data Explorer a better fit.
✗Azure Databricks with Structured StreamingWrong answer — click to see why▾
Why this is wrong here
Azure Databricks with Structured Streaming is optimized for complex ETL and machine learning pipelines, not for low-latency interactive ad-hoc queries on terabyte-scale historical data with SQL-like syntax. It requires more setup and is less efficient for pure analytics compared to Azure Data Explorer.
★ When this WOULD be the correct answer
A company needs to process streaming data from IoT sensors, perform complex transformations (e.g., joining with static datasets), and train machine learning models on the processed data using Python or Scala. They require a unified platform for both stream processing and advanced analytics.
Why candidates choose this
Candidates may associate 'near real-time' and 'IoT sensors' with streaming solutions like Databricks Structured Streaming, overlooking that the primary requirement is interactive ad-hoc querying on historical data, which is not a strength of Databricks.
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
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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
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.