MS-900 Power BI Practice Question
A department asks for the Microsoft 365 service best suited for interactive business dashboards. Which service should they use?
⚠ Common exam trap
A common mix-up: candidates confuse Microsoft Purview Compliance Manager's dashboard-like compliance score interface with a business dashboard, but it is strictly for compliance posture assessment, not interactive business analytics.
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 Microsoft's dedicated business analytics service that enables users to create interactive dashboards and reports from various data sources. It provides real-time data visualization, drill-down capabilities, and natural language querying, making it ideal for business intelligence needs within Microsoft 365.
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 Purview Compliance Manager
Why it's wrong here
Microsoft Purview Compliance Manager assesses regulatory posture and tracks improvement actions; it cannot author interactive business dashboards. It is tempting because it displays compliance scores and assessment trends graphically, which fits continuous compliance monitoring rather than the requested interactive business reporting.
- ✓
Power BI
Why this is correct
Power BI is Microsoft's dedicated business intelligence service, delivering interactive dashboards and reports from varied data sources. It directly satisfies the department's requirement for interactive business dashboards, unlike productivity or collaboration tools. Its visualisation engine supports drill-downs, filtering and real-time refresh, matching the stated scenario precisely.
- ✗
Microsoft Defender for Endpoint
Why it's wrong here
Microsoft Defender for Endpoint provides endpoint detection and response telemetry, not interactive dashboard authoring. It is tempting because it does surface security data in portal views, but those are fixed operational reports, not the user-built interactive business dashboards the department requested.
- ✗
Microsoft Entra Privileged Identity Management
Why it's wrong here
Microsoft Entra Privileged Identity Management governs just-in-time role activation and access reviews, producing no dashboard-building capability. It is tempting because it presents privileged access reports and audit history in the portal, which suits eligibility and approval workflows rather than interactive business dashboards.
Go deeper
Related to this question
Learn chapter
Microsoft 365 Auditing and Activity Reports
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.
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.
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.