MS-900 Describe Microsoft 365 apps and services Practice Question
A manager needs to create a custom dashboard that visualizes sales data from multiple data sources in real-time. Which service should they use?
⚠ Common exam trap
Many exam-takers confuse Power Apps with Power BI, assuming both are for dashboards, but Power Apps is for building apps, not for data visualization or real-time 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 specifically designed for creating interactive, real-time dashboards that aggregate data from multiple sources, including databases, cloud services, and streaming data. It provides live tile updates and direct query capabilities, enabling real-time visualization of sales data without manual refresh.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Excel
Why it's wrong here
Excel can create static charts and pivot tables, and even connect to external data using Power Query and Power Pivot. However, it is not designed for real-time, multi-source data integration or interactive dashboard experiences that update automatically for multiple simultaneous users. Excel files are typically siloed and require manual refresh, lack centralized governance and row-level security, and do not provide the same mobile-optimized, shared, and live dashboard capabilities as Power BI, making it a limited choice for this requirement.
- ✗
Power Apps
Why it's wrong here
Power Apps is a low-code application development platform for building custom business applications, such as forms, approvals, and data-entry tools. It uses data sources like Dataverse and can display simple galleries or charts, but it is not optimized for BI-style visualization, complex aggregations, or real-time analytical dashboards. Creating a sales analytics dashboard in Power Apps would require significant custom code and would still lack Power BI's rich visualization library, built-in AI insights, and enterprise-level sharing and governance, so it is incorrect for this task.
- ✓
Power BI
Why this is correct
Power BI is a dedicated business analytics service that connects to a wide variety of on-premises and cloud data sources, such as SQL Server, Azure, Salesforce, and SharePoint. It enables real-time data refreshes, interactive visuals with cross-filtering and drill-downs, and secure sharing via the Power BI service. Its robust data modeling with DAX, row-level security, and integration with Microsoft Teams and SharePoint make it the correct choice for a custom, live sales dashboard.
- ✗
SharePoint
Why it's wrong here
SharePoint is primarily a collaboration and document management platform, not a business intelligence tool. While it can display data from lists through web parts or embed Power BI reports, it lacks native capabilities for real-time data ingestion, advanced visual interactions like slicers and drill-through, and complex analytics across multiple data sources. Using SharePoint alone would require extensive custom development and still miss Power BI's out-of-the-box intelligence features, making it unsuitable for this scenario.
Go deeper
Related to this question
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.