DP-900 Describe core data concepts Practice Question
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?
⚠ Common exam trap
Watch out — candidates often confuse real-time processing with batch-oriented services like Azure Data Factory or assume that any big data platform (like Databricks) is automatically the best choice for low-latency dashboards, overlooking the purpose-built streaming-to-visualization pipeline of Stream Analytics and Power BI.
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 with Power BI output
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.
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 Databricks Structured Streaming
Why it's wrong here
Azure Databricks Structured Streaming is a unified analytics platform built on Apache Spark that provides micro-batch processing for near-real-time workloads. However, for a simple real-time dashboard with low-latency aggregation and direct Power BI visualization, it requires cluster provisioning, Spark tuning, and additional connector layers to export results. The micro-batch nature introduces several seconds of latency, and the operational overhead is unjustified compared to a purpose-built streaming service.
- ✓
Azure Stream Analytics with Power BI output
Why this is correct
Azure Stream Analytics is a fully managed streaming analytics service that consumes events from sources like Event Hubs or IoT Hub and applies SQL-like queries for windowed aggregations with sub-second to second latency. It provides a native Power BI output connector that updates dashboards in near real-time without custom code, and the service handles scaling and checkpointing automatically. This makes it the most direct and cost-effective solution for a real-time dashboard with simple aggregate metrics.
- ✗
Azure Analysis Services
Why it's wrong here
Azure Analysis Services is an enterprise OLAP engine that hosts tabular models in memory, optimized for fast queries against historical, pre-aggregated data. It is not an event-processing platform and cannot ingest live streams; data must be loaded through scheduled ETL/ELT processes, introducing batch latency. Using it for a real-time dashboard would require an intermediate pipeline and still yield stale data, so it is fundamentally unsuitable.
- ✗
Azure Data Factory with tumbling window
Why it's wrong here
Azure Data Factory is a cloud ETL/ELT orchestration service that executes pipelines on schedules or triggers, with tumbling windows representing fixed-duration, non-overlapping slots like hourly batches. The minimum latency is minutes, and the service is not designed for continuous event processing or low-latency streaming. Since it lacks a direct real-time dashboard output, results must be stored in a data store first, which makes it impossible to meet the real-time requirement.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Dashboard
A dashboard is a visual display of key metrics and data points that helps IT professionals monitor, analyze, and manage systems or processes in real time.
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
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.