DP-900 Describe an analytics workload on Azure Practice Question
A company uses Azure Synapse Analytics dedicated SQL pool as its data warehouse. New data is loaded into the warehouse every few minutes. The company wants to visualize the data with near real-time updates in a dashboard that can be refreshed automatically. Which tool and connection mode should they use?
⚠ Common exam trap
Test-takers frequently confuse DirectQuery with Import mode, assuming Import mode is always faster for dashboards, but Import mode cannot achieve near real-time updates without manual or scheduled refreshes, which fails the 'every few minutes' requirement.
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 with DirectQuery mode
Power BI with DirectQuery mode is correct because it allows the dashboard to query the Azure Synapse dedicated SQL pool directly for each visual refresh, enabling near real-time updates without importing data. This mode avoids the latency of data import and supports automatic page refresh, which aligns with the requirement for data loaded every few minutes.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Power BI with DirectQuery mode
Why this is correct
Power BI with DirectQuery mode is the correct choice because it sends native T-SQL queries directly to the dedicated SQL pool each time a report is opened or a visual is refreshed, without copying data into a separate model. This means any inserts or updates committed to the underlying tables are immediately reflected in dashboard visuals, enabling near real-time analytics. DirectQuery also leverages the MPP (massively parallel processing) engine of Azure Synapse to push down aggregation and filtering, so large datasets remain responsive. Unlike import mode, there is no stale snapshot, making it the ideal pattern for live operational monitoring in this scenario.
- ✗
Azure Data Studio with visualizations
Why it's wrong here
Azure Data Studio with visualizations is primarily an integrated development environment for querying and managing Azure SQL and Synapse, not a production-grade BI reporting platform. While it can produce chart views from query results, those visualizations are static ad-hoc artifacts that exist only in the query results grid and cannot be auto-refreshed, shared as interactive dashboards, or embedded into a business portal. It lacks scheduled refresh capabilities, row-level security management for non-technical users, and the centralized distribution model required by an enterprise near real-time dashboard solution. Therefore, despite being able to connect to the dedicated SQL pool, it is unsuitable for continuous, monitored reporting.
- ✗
SQL Server Reporting Services (SSRS) with cached reports
Why it's wrong here
SQL Server Reporting Services (SSRS) with cached reports is incorrect for near real-time dashboards because caching deliberately stores a point-in-time copy of the report dataset or report output, either in the SSRS report server or on a schedule. This means viewers see the last cached version rather than live data, and the cache is only refreshed according to a predefined set of parameters or a nightly schedule. While SSRS can technically query a dedicated SQL pool directly, the 'cached reports' choice in the question demonstrates a design that sacrifices timeliness for performance, which contradicts the requirement for near real-time insight. Additionally, SSRS paginated reports are not designed for interactive, self-service dashboard exploration that users expect from a modern BI tool.
- ✗
Excel Power Pivot with imported data
Why it's wrong here
Excel Power Pivot with imported data is inappropriate because Power Pivot loads a compressed in-memory copy of the data into an Excel workbook during the import process, after which the model no longer represents the live state of the dedicated SQL pool. To update the data, a user must manually trigger a refresh through the Excel workbook or configure a scheduled refresh using Power BI's on-premises data gateway, neither of which provides near real-time updates. Furthermore, an Excel workbook is a single-user artifact that requires extensive setup, lacks centralized sharing, and does not scale to meet enterprise dashboard concurrency requirements. Since the question explicitly calls for near real-time reporting, an import-based approach inherently introduces latency and stale data.
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
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.
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.