MS-900 Power BI Practice Question
A compliance-aware administrator is selecting the right Microsoft 365 capability to create dashboards showing sales and operational trends from multiple data sources. Microsoft 365 app or service is the best fit?
⚠ Common exam trap
It's easy for candidates to confuse Microsoft Purview Audit with Power BI due to both involving data, but Purview is strictly for compliance logging and not for analytical 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
✓
Power BI
Power BI is the correct choice because it is a business analytics service that enables users to create interactive dashboards and reports by connecting to multiple data sources, including Excel, SQL databases, and cloud services. It provides built-in data transformation, visualization, and sharing capabilities, making it ideal for aggregating sales and operational trends into a single dashboard.
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 connects to multiple data sources and builds interactive dashboards visualising sales and operational trends. It directly satisfies the requirement for a Microsoft 365 capability producing multi-source dashboards, whereas Power Apps builds apps and Power Automate orchestrates workflows.
- ✗
Microsoft Purview Audit
Why it's wrong here
Purview Audit records user and admin activity for investigation and retention; it cannot query multiple data sources or render dashboards. It is tempting because it is a reporting-adjacent compliance tool, and it would be correct when the requirement is retrieving audit events. Power BI builds cross-source dashboards.
- ✗
Microsoft Planner
Why it's wrong here
Planner manages tasks and kanban boards, holding no data-source connectors or chart visualisations, so it cannot aggregate sales figures into dashboards. It is tempting because it is a Microsoft 365 app for tracking work; it would be correct for assigning project tasks and tracking their completion status across a team.
- ✗
Microsoft Forms
Why it's wrong here
Forms collects survey responses into a single questionnaire, offering no connectors to multiple data sources or dashboard visualisation. It is tempting as a lightweight Microsoft 365 data-gathering tool; it would be correct for building a feedback or registration form whose responses feed a spreadsheet.
Go deeper
Related to this question
Learn chapter
Power Virtual Agents and Chatbots
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.
Key term
Microsoft 365
Microsoft 365 is a subscription-based cloud service from Microsoft that combines productivity tools like Office apps with security, device management, and online storage.
About these practice questions
Courseiva writes every MS-900 question from scratch — 794 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 MS-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 MS-900 exam.