DP-900 Describe an analytics workload on Azure Practice Question
A retail company needs to analyze streaming clickstream data from their website to detect shopping cart abandonment in real-time. They want to use Azure Stream Analytics to output results that can be visualized on a live dashboard. Which output sink allows the fastest data visualization for a real-time dashboard in Power BI?
⚠ Common exam trap
It's easy for candidates to confuse Azure Event Hubs as a visualization output because it is a streaming service, but Event Hubs is an ingestion endpoint, not a visualization sink; the correct sink for real-time Power BI dashboards is the Power BI dataset output directly from Stream Analytics.
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
✓
Power BI dataset
Power BI dataset is the correct output sink because Azure Stream Analytics can directly stream data into a Power BI dataset via the Power BI output adapter, enabling real-time dashboard updates with sub-second latency. This integration uses the Power BI REST API to push streaming data events, which Power BI then visualizes immediately without requiring intermediate storage or batch processing.
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 Blob Storage
Why it's wrong here
Azure Blob Storage is an object-store service designed for batch-oriented, unstructured data at rest. Although Azure Stream Analytics can write output files there, a dashboard would have to repeatedly read entire blobs, scan the contents, and manually load them into a visualization—no push-based query engine or native Power BI connector exists for live streaming. This file-based round-trip introduces seconds-to-minutes latency and requires custom glue code, making it unsuitable for real-time clickstream analysis.
- ✗
Azure Event Hubs
Why it's wrong here
Azure Event Hubs is a massively scalable event-ingestion broker that reliably accepts and replays telemetry streams, but it does not store queryable datasets or provide visualization endpoints. If Stream Analytics sent results there, another service would still be needed to consume, deserialize, and push the events into Power BI, adding extra hops and end-to-end latency. As an output destination for a real-time dashboard, Event Hubs only shifts the processing burden downstream rather than enabling immediate display.
- ✓
Power BI dataset
Why this is correct
A Power BI dataset—specifically a streaming or push dataset—is the correct target because Azure Stream Analytics includes a native output connector that pushes rows to Power BI in near-real time. Power BI then updates tile visualizations automatically without manual refresh or intermediate storage, and the dataset's in-memory analytics engine is optimized for interactive slicing, filtering, and drill-down. This direct path minimizes latency and is purpose-built for live dashboards fed by streaming clickstream data.
- ✗
Azure SQL Database
Why it's wrong here
Azure SQL Database is a transactional relational store with fixed schemas and centralized writes, so pushing high-velocity clickstream events from Stream Analytics causes insert contention and network round-trips, adding meaningful latency. To visualize it, Power BI must either use DirectQuery, which sends per-visual queries and can still be stale, or import/re-refresh, which is implicitly batch-oriented. Neither approach provides the sub-second push experience a live streaming dashboard requires, and SQL lacks a native push-to-Power-BI streaming protocol.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Dataset
A dataset is a collection of related data, usually in a structured format, that can be used for analysis, training models, or reporting in Azure data services.
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
One of 820 original DP-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. 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.