DP-900 Describe core data concepts Practice Question
A data analyst needs to visualize sales data from Azure SQL Database in real-time dashboards. Which tool should they use to create interactive reports?
⚠ Common exam trap
Many exam-takers confuse database query tools (Azure Data Studio) or data storage/processing services (Azure Synapse Analytics) with dedicated visualization and reporting tools, leading candidates to overlook Power BI's specific role in real-time dashboard creation.
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
✓
Microsoft Power BI
Microsoft Power BI is the correct tool because it is designed specifically for creating interactive, real-time dashboards and reports from various data sources, including Azure SQL Database. It supports live connections and DirectQuery to enable near-real-time visualization without requiring data movement.
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 Power BI
Why this is correct
Microsoft Power BI is the correct choice because it is a dedicated enterprise business intelligence platform designed for interactive data visualization. Its native Azure SQL Database connector supports both Import and DirectQuery modes, allowing the analyst to model sales transactions, build DAX measures, and publish shareable, refreshable dashboards that users can filter and drill into in real time.
- ✗
Azure Data Studio
Why it's wrong here
Azure Data Studio is a modern, cross-platform database management and development tool used mainly for Azure SQL querying, administration, and Jupyter-style notebooks. Although it can render basic result-set charts in its grid, it lacks Power BI's semantic modeling, publishing, row-level security, and scheduled-refresh capabilities, making it unsuitable for delivering interactive sales dashboards to business stakeholders.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is a cloud-scale analytics and data warehousing service, not an end-user visualization tool. It can store processed sales data in dedicated or serverless SQL pools and run complex aggregations, but it has no dashboard-authoring interface for interactive business reports; a separate BI client such as Power BI is needed to build the actual visuals.
- ✗
Microsoft Excel
Why it's wrong here
Microsoft Excel can pull Azure SQL sales data through Power Query and create pivot charts, but it remains a file-based spreadsheet application rather than an interactive BI platform. Refresh is manual or user-configured, sharing requires external services, and dashboards cannot support cross-page drill-through or governed mobile access the way Power BI does, so it is wrong as the primary visualization answer.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
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.
Key term
Data
Data is raw, unprocessed information, like numbers, words, or measurements, that can be stored, processed, and analyzed by computers.
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.