DP-900 Describe core data concepts Practice Question
A retail company uses Azure SQL Database to store customer transactions. They need to analyze sales trends over time. Which Azure service should they use to build interactive dashboards and reports without moving data out of Azure?
⚠ Common exam trap
Many candidates confuse Azure Synapse Analytics as a reporting tool, but it is primarily a data warehousing and analytics platform that requires data movement or transformation, whereas Power BI is the native Azure service for direct, no-movement interactive reporting.
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 choice because it is a business analytics service that can connect directly to Azure SQL Database to build interactive dashboards and reports without requiring data movement. It supports DirectQuery mode, which queries the source database in real-time, enabling live analysis of sales trends while data remains in Azure.
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 Analysis Services
Why it's wrong here
Azure Analysis Services is designed for building semantic models over cleansed and transformed data, typically sourced from data warehouses, to enable complex analytical processing and calculations. For the stated requirement of interactive dashboards directly from an operational Azure SQL Database, it introduces an unnecessary data modelling and processing layer. This service would be the correct choice for enterprise-grade business intelligence solutions that require a robust, pre-calculated data model with intricate hierarchies and security, often for extensive reporting across large datasets.
- ✗
Azure Synapse Analytics
Why it's wrong here
Azure Synapse Analytics is a cloud-based data warehousing and big data analytics service designed for large-scale data processing and massive parallel execution. It does not serve as a front-end visualization tool via a dashboarding interface; rather, it is a backend engine that stores and processes enormous datasets. For lightweight, direct-to-database dashboards, Synapse introduces unnecessary complexity and is not the correct choice because its primary purpose is complex analytical workloads, not interactive business reporting.
- ✗
Microsoft Purview
Why it's wrong here
Microsoft Purview is a data governance and compliance platform that provides a unified data catalog, data lineage, classification, and policy management across an organization's data estate. It does not connect to Azure SQL Database for real-time visualization; instead, it manages metadata and helps track data origin and compliance, not present actual data reports. Therefore, it is incorrect for building interactive dashboards, as its functionality lies in governing and discovering data assets rather than rendering them visually to end users.
- ✓
Power BI
Why this is correct
Power BI is a business analytics service that natively connects to Azure SQL Database through built-in connectors, enabling you to create interactive dashboards and reports directly from your operational data. It supports DirectQuery and import modes, providing live or cached data access for rich, dynamic visualizations that can be refreshed on demand. With features like row-level security and natural language queries, it is the ideal tool for lightweight, user-facing dashboards at the retail company, offering immediate insights without an intermediate data transformation layer.
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
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.