MS-900 Describe Microsoft 365 apps and services Practice Question
A project manager wants to create a visual dashboard that tracks project tasks, deadlines, and progress. The dashboard should pull data from a Microsoft List and update in real time. Which Microsoft 365 app is best suited for building this interactive dashboard?
⚠ Common exam trap
Watch out — candidates often confuse Microsoft Lists (a data source) with a dashboard tool, or assume SharePoint's built-in list views are sufficient for interactive, real-time dashboards, overlooking Power BI's specialized visualization and refresh capabilities.
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 designed to create interactive, real-time dashboards with live data connectivity. It can connect directly to a Microsoft List as a data source and refresh automatically, enabling real-time tracking of project tasks, deadlines, and progress with visualizations like charts and gauges.
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 Lists
Why it's wrong here
Microsoft Lists provides structured data tracking with customizable column types, but its interface is limited to list and board views with no built-in interactive visualization system. While you can create a task list with deadlines, it cannot produce the dynamic charts, filters, and drill-through visuals required for a real-time project dashboard without exporting or connecting to an external BI tool like Power BI.
- ✓
Power BI
Why this is correct
Power BI is a dedicated business analytics suite that directly connects to Microsoft Lists, SharePoint, and other data sources to build live, interactive dashboards. It lets you create custom visuals, apply cross-filtering, set up conditional formatting, and publish reports to the Microsoft 365 ecosystem, making it the only option here that natively delivers the requested task-deadline dashboard with rich user interactivity and scheduled data refreshes.
- ✗
SharePoint Online
Why it's wrong here
SharePoint Online is a collaboration and content-management platform; although it can display lists via web parts and even include a simple 'Highlighted Content' web part for content, it lacks an integrated data model and authoring tools for charts and cross-source analytics. To get a true dashboard in SharePoint, you would embed a Power BI report, which underscores that SharePoint itself does not provide the standalone interactive dashboard experience requested.
- ✗
Microsoft Forms
Why it's wrong here
Microsoft Forms is designed solely for creating surveys, quizzes, and feedback forms; it supports no task tracking, deadline calculations, or visualization elements. Its primary output is a summary of responses in charts, but that is limited to the survey dataset and cannot connect to project tasks or display interdependent deadline metrics, making it completely unsuitable for a project-management dashboard.
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 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.