DP-900 Describe core data concepts Practice Question
A data analyst needs to create interactive dashboards that display real-time data from Azure SQL Database. Which Microsoft tool should they use?
⚠ Common exam trap
Many exam-takers confuse Azure Data Studio (a database management tool) with a visualization tool, or assume Microsoft Excel is sufficient for real-time dashboards, when Power BI is the only option that natively supports interactive, real-time visualizations with Azure SQL Database.
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
Power BI is the correct tool because it is designed specifically for creating interactive dashboards and reports, and it supports real-time data connectivity to Azure SQL Database through DirectQuery or streaming datasets. This allows the data analyst to visualize live data without manual refreshes, meeting the requirement for real-time dashboards.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Microsoft Excel
Why it's wrong here
Although Microsoft Excel supports pivot tables, slicers, and charts, it is not designed for real-time operational dashboards. Its refresh model relies on manual data connections or scheduled Excel Services/OneDrive refresh, but it lacks native streaming ingestion, live tile updates, and dashboard sharing with row-level security across an organization. Consequently, Excel is best for ad-hoc analysis and static visual reports, not live business monitoring.
- ✗
Microsoft Copilot
Why it's wrong here
Microsoft Copilot is a generative AI assistant embedded across Microsoft 365 and Power Platform, not a dashboard authoring or hosting tool. Although it can help summarize data or draft content within Power BI or Excel, Copilot itself cannot connect to data sources, create interactive visualizations, or manage scheduled refresh. Relying on Copilot alone would leave the analyst without a rendering engine or a persistent dashboard surface for real-time updates.
- ✗
Azure Data Studio
Why it's wrong here
Azure Data Studio is a modern cross-platform database management tool aimed at SQL Server and Azure SQL developers, offering query editors, notebooks, and chart visualizations of result sets. It does not provide a shared, interactive dashboarding environment with live data connectors to heterogeneous sources, nor does it support end-user consumption via the web or mobile. Its basic charts are for validating query output rather than building enterprise real-time analytics dashboards.
- ✓
Power BI
Why this is correct
Power BI is the correct answer because it is Microsoft's dedicated business analytics platform, with Power BI Desktop for modeling and the Power BI Service for publishing live dashboards. It supports real-time scenarios through DirectQuery, push datasets, streaming datasets, and automatic page refresh, integrating with services like Azure Stream Analytics and Event Hubs. These dashboards offer interactive cross-filtering, natural-language Q&A, and row-level security, making them suitable for operational monitoring.
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
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.