MS-900 Describe Microsoft 365 apps and services Practice Question
A marketing team at Contoso Ltd. needs a cloud-based workspace where they can create and share interactive dashboards, reports, and datasets with colleagues without setting up any on-premises servers. Which Microsoft 365 service should they use?
⚠ Common exam trap
The trap here is assuming that any Microsoft 365 app that displays information visually can serve as a reporting and dashboard platform, which leads to selecting presentation or video tools instead of the dedicated analytics service.
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
✓
Microsoft Power BI
Power BI is the Microsoft 365 service specifically designed for cloud-based business analytics, enabling users to create interactive dashboards, reports, and datasets and share them with colleagues. Viva Insights, Stream, and Sway serve different purposes—employee productivity analytics, enterprise video, and visual storytelling—and none provide the data modeling and dashboard-sharing capabilities the marketing team needs.
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 Sway
Why it's wrong here
Sway is a presentation and newsletter tool that helps users create visually engaging reports and stories from text, images, and media. It does not connect to datasets or provide interactive dashboards or analytical reporting, so it cannot fulfill the team's requirement to build and share data-driven dashboards and reports.
- ✗
Microsoft Viva Insights
Why it's wrong here
Viva Insights focuses on employee productivity and wellbeing by analyzing collaboration patterns such as meeting load and focus time. It does not provide a platform for creating or sharing general business dashboards, reports, or datasets, so it cannot satisfy the marketing team's requirement to build and distribute interactive data visualizations.
- ✗
Microsoft Stream
Why it's wrong here
Microsoft Stream is an enterprise video service for uploading, sharing, and managing video content within an organization. It is designed for video delivery and does not include data modeling, report authoring, or dashboard sharing capabilities, so it is not a suitable workspace for the marketing team's analytics and reporting needs.
- ✓
Microsoft Power BI
Why this is correct
Power BI is Microsoft 365's cloud business analytics service that lets users build interactive dashboards, reports, and datasets and share them across the organization. It requires no on-premises infrastructure and supports natural-language queries, making it the right fit for a marketing team that needs to visualize and distribute data insights quickly and collaboratively.
Go deeper
Related to this question
Learn chapter
Power Apps: Low-Code Application Development
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 →
JA
Written and reviewed by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
Last reviewed September 2026 · checked against the official Microsoft exam blueprint
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.