MS-900 Describe Microsoft 365 apps and services Practice Question
A sales manager wants to create an interactive dashboard that visualizes the sales pipeline, customer interactions, and team performance. The data resides in Dynamics 365. The manager needs to build the dashboard quickly without coding and share it with the team. Which Microsoft 365 app should they use?
⚠ Common exam trap
Many exam-takers confuse Power BI with Power Apps because both are part of the Power Platform and can integrate with Dynamics 365, but Power Apps is for building custom apps, not for creating dashboards or visualizations.
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 a business analytics service that enables users to create interactive dashboards and visualizations from data sources like Dynamics 365 without writing code. It supports quick data modeling, real-time updates, and easy sharing with team members via Power BI service or embedded reports, meeting the manager's need for speed and collaboration.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Power BI
Why this is correct
Power BI is Microsoft’s business analytics and data visualization service, purpose-built for creating interactive dashboards and reports from multiple data sources, including Dynamics 365, Excel, and Azure SQL. It provides drag-and-drop visual building, cross-filtering, user-friendly sharing through the Power BI Service, and natural-language querying, which directly supports a sales manager’s need to track and analyze performance data at a glance.
- ✗
Power Apps
Why it's wrong here
Power Apps is a low-code development platform for building custom business applications, such as inventory check-in forms, field-service tools, or expense-entry apps, with tailored user interfaces and logic. Although it can display data in galleries and forms, it is not a visualization engine and lacks the rich, interactive data-analysis capabilities like drill-through, measures, and dashboard tiles that Power BI provides.
- ✗
Power Automate
Why it's wrong here
Power Automate is a workflow-automation solution that connects hundreds of services to create cloud flows, trigger actions, and automate business processes, such as sending approval requests, copying files, or posting notifications when sales deals close. It does not render data as dashboards; its outputs are tasks, messages, and record updates, not interactive visualizations, so a manager looking for graphical insights would find it unsuitable.
- ✗
Power Virtual Agents
Why it's wrong here
Power Virtual Agents is a conversational AI platform for creating chatbots and virtual agents that answer user questions and perform simple actions through natural language conversations, often embedded on websites or in Teams. While it can query data to provide answers, it does not deliver an interactive, visual dashboard experience; its chat-based interface is fundamentally different from the visual, filterable dashboards a sales manager would expect.
Go deeper
Related to this question
Learn chapter
Power Apps: Low-Code Application Development
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.
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.
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.