DP-900 Describe an analytics workload on Azure Practice Question
A company wants to provide self-service analytics to business users, allowing them to create reports and dashboards from data stored in Azure Data Lake Storage. Which tool should they use?
⚠ Common exam trap
Candidates often confuse Azure Synapse Studio (a big data and data warehousing tool) with a reporting tool, but it is not designed for self-service business user dashboard creation like Power BI is.
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 provides self-service analytics capabilities, allowing business users to connect to data stored in Azure Data Lake Storage, create interactive reports and dashboards, and share insights without requiring deep technical skills. Options A, B, and D are incorrect: Azure Synapse Studio is a big data and data warehousing tool, not designed for self-service business user dashboard creation; Azure Machine Learning studio is for building, training, and deploying machine learning models, not for creating reports; Azure Data Studio is a database management and query tool, not a reporting tool.
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 Synapse Studio
Why it's wrong here
Synapse Studio serves data engineers building pipelines, SQL pools and notebooks, not business users creating self-service reports and dashboards. It tempts because it works across Azure Data Lake Storage and analytics workloads, which fits a data engineering team rather than self-service business analytics.
- ✗
Azure Machine Learning studio
Why it's wrong here
Azure Machine Learning studio builds, trains and deploys machine learning models; it provides no self-service report or dashboard authoring for business users. It tempts because it reads data from Azure Data Lake Storage, which suits data scientists developing models rather than business reporting.
- ✓
Power BI
Why this is correct
Power BI is the correct tool because it provides self-service analytics capabilities, allowing business users to connect to data stored in Azure Data Lake Storage, create interactive reports and dashboards, and share insights without requiring deep technical skills.
- ✗
Azure Data Studio
Why it's wrong here
Azure Data Studio is a query and notebook editor for developers and data professionals, not a self-service report and dashboard builder for business users. It tempts because it does connect to data sources and run SQL, which suits engineering tasks rather than interactive business reporting.
Go deeper
Related to this question
Learn chapter
Azure Database for MySQL
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
This DP-900 question is part of Courseiva's 851-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.