DP-900 Describe an analytics workload on Azure Practice Question
A data analyst needs to create a real-time dashboard in Power BI that displays sales data from an Azure SQL Database. The dashboard must update every 10 minutes without manual refresh. Which Power BI feature should they use?
⚠ Common exam trap
Many exam-takers confuse 'real-time dashboard' with 'streaming datasets' (Option C), but streaming datasets require a push-based architecture, not a pull from an existing database like Azure SQL Database, which DirectQuery handles natively.
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
✓
DirectQuery mode
DirectQuery mode is correct because it allows Power BI to query the Azure SQL Database directly for each visual interaction, ensuring the dashboard reflects the latest data without requiring a manual refresh. Since the requirement is for updates every 10 minutes, DirectQuery can be configured to auto-refresh at that interval via the 'Automatic page refresh' setting, which sends T-SQL queries to the database on a timer. This avoids the latency and storage overhead of importing data, making it ideal for near-real-time monitoring.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
DirectQuery mode
Why this is correct
DirectQuery mode in Power BI connects the dashboard directly to the Azure SQL Database, issuing a query to the source whenever a visual is rendered or the user interacts with the report. This avoids storing a copy of the data and provides near real-time updates without needing a scheduled refresh. So it is the correct choice for a real-time dashboard, though performance depends on the source's query response time and indexing.
- ✗
Scheduled refresh with Import mode
Why it's wrong here
Scheduled refresh with Import mode copies the SQL Database tables into Power BI's in-memory engine, and then a refresh job (often every few minutes or hours) updates that snapshot. Between refreshes, the dashboard shows stale data, so user interactions do not trigger queries back to the source. That makes it a batch-update solution, not a real-time dashboard, even if the refresh interval is short.
- ✗
Streaming datasets
Why it's wrong here
Streaming datasets are designed for data that is actively pushed into Power BI from sources such as Azure Stream Analytics, Event Hubs, or a custom application, and they are optimized for high-frequency, low-latency ingestion. They do not connect to or query an existing relational database like Azure SQL Database on demand. Trying to use a streaming dataset here would require setting up a separate pipeline to push data out of SQL, rather than reading directly from it, so it is not the appropriate mechanism.
- ✗
Paginated reports
Why it's wrong here
Paginated reports in Power BI are formatted to print on a specific page size and are meant for pixel-perfect, row-and-column reports such as invoices, statements, or operational documents. They do not provide interactive, auto-refreshing dashboard visuals, and they typically require manual page navigation or scheduled email subscriptions to update. Therefore they are not a viable approach for a real-time interactive dashboard.
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
Azure SQL Database
Azure SQL Database is a fully managed relational database-as-a-service (DBaaS) in Microsoft Azure, based on the SQL Server engine, that handles scaling, backups, patching, and high availability automatically.
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.