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? The design must avoid adding custom operational scripts.
⚠ Common exam trap
Many exam-takers confuse Microsoft Purview Compliance Manager's compliance dashboards (which are static compliance scorecards) with interactive business dashboards, or assume that security tools like Defender for Endpoint include business analytics features, leading them to select a wrong option that sounds 'dashboard-like' but serves a completely different purpose.
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 drag-and-drop visualization tools, real-time data refresh, and natural language querying (Q&A) without requiring custom operational scripts, aligning perfectly with the department's requirement for no-code dashboard creation.
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
Purview Compliance Manager assesses regulatory posture and tracks improvement actions; it renders no dashboards from business data. It would be the right choice when the requirement is compliance scoring and assessment templates, not interactive reporting over operational datasets.
- ✓
Power BI
Why this is correct
Power BI delivers interactive dashboards natively, with no custom operational scripts required. Its semantic models and scheduled refresh handle data preparation, satisfying the stem's constraint directly. Unlike Excel or bespoke reporting, Power BI provides governed, shareable visualisations through Microsoft Fabric and Microsoft Entra ID authentication, matching the department's stated need.
- ✗
Microsoft Defender for Endpoint
Why it's wrong here
Defender for Endpoint delivers endpoint detection and response telemetry; it produces no interactive business dashboards. It would be the correct service when the requirement is threat detection, investigation and remediation on devices, rather than visual reporting over business data.
- ✗
Microsoft Entra Privileged Identity Management
Why it's wrong here
Privileged Identity Management grants just-in-time privileged roles in Microsoft Entra ID; it visualises no business data. It would be correct where standing admin access must be eliminated through approval-based activation, not where interactive dashboards over departmental data are required.
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
One of 794 original MS-900 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on MS-900
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A department asks for the Microsoft 365 service best suited for interactive business dashboards. Which service should they use?
medium- A.Microsoft Purview Compliance Manager
- ✓ B.Power BI
- C.Microsoft Defender for Endpoint
- D.Microsoft Entra Privileged Identity Management
Why B: 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.
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.