MS-900 Describe Microsoft 365 apps and services Practice Question
A marketing team needs to create a dashboard that shows real-time sales data from Dynamics 365 and customer feedback from social media. Which Microsoft 365 service should they use to build this dashboard?
⚠ Common exam trap
Watch out — candidates often confuse Power Automate or Power Apps as dashboard-building tools because they are part of the Power Platform, but only Power BI provides the dedicated data visualization and real-time analytics capabilities required for this scenario.
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
Microsoft Power BI is the correct service because it is designed to connect to multiple data sources, including Dynamics 365 for real-time sales data and social media APIs for customer feedback, and then create interactive, real-time dashboards. It provides built-in connectors, real-time streaming datasets, and the ability to publish dashboards for team-wide access, making it the ideal tool for this marketing requirement.
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 Power BI
Why this is correct
Microsoft Power BI is the correct choice because it is a dedicated business analytics and data visualization service that connects to dozens of data sources, including Dynamics 365, social media, and Azure, to build live dashboards. It supports streaming datasets, push datasets, and DirectQuery to render near-real-time visuals that update as underlying data changes, without requiring manual refresh. Team members can embed these dashboards in Microsoft Teams or SharePoint pages, but the visualization engine itself remains Power BI.
- ✗
Microsoft Power Automate
Why it's wrong here
Power Automate is a workflow automation platform that orchestrates tasks across applications via cloud flows, desktop flows, and business process flows, but it produces no charts or dashboard surfaces of its own. It could, for example, trigger a flow to import social media data into a Power BI dataset, yet the resulting dashboard would be created in Power BI, not in the flow. Since its output is action-oriented automation—not interactive analytics—it cannot satisfy the team's dashboard requirement.
- ✗
Microsoft SharePoint
Why it's wrong here
SharePoint is an enterprise content management and collaboration system for document libraries, lists, and team sites, and while list views offer basic tabular displays, they lack the ability to create aggregated, real-time dashboards across multiple external data sources. Its built-in web parts might show a static chart or embed a Power BI report, but the dashboard itself is not a native SharePoint capability. The team needs continuous data refresh and interactive filtering, which SharePoint does not implement without external visualization tools.
- ✗
Microsoft Power Apps
Why it's wrong here
Power Apps is a low-code application platform for building custom business apps with screens, forms, controls, and logic, but it is not intended for analytics or real-time dashboards. Although you can embed a Power BI tile or chart in a model-driven or canvas app, Power Apps itself offers no streaming dataset ingestion or visualization dashboard builder. An app's primary UX is interaction (e.g., entering data, invoking a flow), not the passive monitoring that a real-time dashboard demands.
Go deeper
Related to this question
Learn chapter
Data Loss Prevention (DLP) in Microsoft 365
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
This MS-900 question is part of Courseiva's 794-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 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.