DP-900 Describe core data concepts Practice Question
A company wants to provide self-service analytics to business users who need to create reports and dashboards from data in Azure Synapse Analytics. Which tool should you recommend?
⚠ Common exam trap
It's easy for candidates to confuse Azure Synapse Studio (a development tool) with a reporting tool, overlooking that Power BI is the designated Microsoft solution for self-service business intelligence and dashboards.
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 self-service analytics, enabling business users to create interactive reports and dashboards from data stored in Azure Synapse Analytics. Power BI connects directly to Synapse via its built-in connector, allowing users to build visualizations without writing code or relying on IT. This aligns with the requirement for business users to perform ad-hoc analysis and reporting.
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
Why this is correct
Power BI is a SaaS-based business analytics service specifically designed for self-service analytics. It provides a low-code environment with drag-and-drop visuals, natural language Q&A, and direct connectivity to a wide range of data sources. Power BI supports self-service data preparation via Power Query and enables governed sharing through workspaces, apps, and row-level security, making it the primary enterprise tool for business users to create and distribute interactive reports and dashboards independently.
- ✗
Microsoft Excel
Why it's wrong here
Microsoft Excel is a general-purpose spreadsheet application that includes data modeling via Power Pivot and connectivity to various data sources. However, it lacks centralized governance, row-level security, and enterprise-level sharing capabilities such as mobile consumption and dependency management. Excel is suitable for ad-hoc analysis, but it does not provide a governed, collaborative environment for enterprise-wide self-service reporting and dashboard delivery.
- ✗
Azure Synapse Studio
Why it's wrong here
Azure Synapse Studio is the unified workspace for Azure Synapse Analytics, an enterprise data warehouse and big data analytics service. It focuses on data integration, data engineering, and big data processing through SQL pools, Spark pools, and pipelines, requiring technical skills like T-SQL or PySpark to prepare and visualize data. While Synapse Studio can host Power BI reports for consumption, it is not a self-service reporting tool for business users; it is designed for data engineers and analysts, not for business users to author interactive dashboards.
- ✗
Azure Data Studio
Why it's wrong here
Azure Data Studio is a cross-platform database tool intended for data professionals to write SQL queries, manage database instances, and run notebooks. Its limited charting options apply only to query result sets and cannot be published as interactive dashboards or shared with defined roles. Business users needing self-service analytics would find Azure Data Studio unsuitable because it focuses on database development and operations rather than governed report authoring and distribution.
Go deeper
Related to this question
Learn chapter
Data Roles and Core Concepts
Key term
Azure Synapse Analytics
Azure Synapse Analytics is a cloud-based data integration, warehousing, and analytics service that brings together big data and data warehouse capabilities under one platform.
Key term
Service
A service is a software component or system that performs a specific function and is available to be used by other programs or users over a network.
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.