DP-900 Describe core data concepts Practice Question
Your team is building a real-time dashboard for monitoring website traffic. The data source is streaming click events from Azure Event Hubs. The dashboard must update within seconds. Which Azure service should you use to process the stream?
⚠ Common exam trap
Microsoft often tests the misconception that any data processing service can handle streaming, but the trap here is that Azure Data Factory and Synapse Pipelines are batch-oriented, while Databricks Structured Streaming, though capable, is not the simplest or most cost-effective choice for a quick, SQL-based real-time dashboard.
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 designed for real-time stream processing with low-latency output, making it ideal for processing click events from Event Hubs and updating a dashboard within seconds. It provides a SQL-like query language to define transformations and can output directly to Power BI or other visualization tools for near-instantaneous dashboard updates.
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 fully managed stream processing engine that natively supports real-time ingestion from Azure Event Hubs and IoT Hub. It provides sub-second latency via continual SQL-like queries over temporal windows, and it has a built-in Power BI output adapter, making it ideal for live dashboards. Unlike batch tools, it executes queries continuously on unbounded streams, delivering results as events arrive.
- ✗
Azure Synapse Pipelines
Why it's wrong here
Azure Synapse Pipelines is designed for orchestrating batch data movement and transformation, typically through copy activities and scheduled pipelines. It does not consume live event streams or execute continuous queries; instead, it copies data on a scheduled or tumbling-window basis. For a real-time dashboard, the latency introduced by batch scheduling and its lack of native streaming inputs make it fundamentally unsuitable.
- ✗
Azure Data Factory
Why it's wrong here
Azure Data Factory is a cloud ETL/ELT service focused on batch data movement, transformation, and orchestration across heterogeneous data stores. It relies on triggers that fire on schedules or events, but each pipeline run processes a finite, bounded dataset rather than an unbounded event stream. Its data flow execution is designed for throughput, not low-latency streaming, so it cannot power a real-time dashboard with sub-second updates.
- ✗
Azure Databricks Structured Streaming
Why it's wrong here
Azure Databricks Structured Streaming processes data as micro-batches using Apache Spark, which means each mini-batch introduces overhead and typically yields latencies of seconds to minutes. While it can handle near-real-time scenarios, it requires significant cluster management and configuration, and its default micro-batch engine is not optimized for the sub-second latency that a real-time dashboard demands. It is also more complex to integrate directly with Power BI for live visualization compared to a purpose-built streaming service.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Stream processing
Stream processing is a data processing method that continuously analyzes and acts on data in real time as it arrives, rather than storing it first and processing it later.
Key term
Power BI
Power BI is a Microsoft business analytics tool that transforms raw data into interactive visual reports and dashboards for informed decision-making.
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.