MS-900 Describe Microsoft 365 apps and services — Timed 100 Questions

Question 1

A marketing team needs to collaboratively create and edit documents in real time, share files securely, and track version history. Which Microsoft 365 service should they primarily use?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it is designed for team collaboration with real-time co-authoring, granular permission-based file sharing, and built-in version history that tracks every change. Unlike OneDrive, which is optimized for individual file storage and sharing, SharePoint provides a centralized team site where multiple users can simultaneously edit documents and manage versions at the site or library level.

Answer

Microsoft Teams

Answer

OneDrive for Business

Answer

Microsoft Viva Engage

Question 2

A global sales team uses Microsoft Teams for communication. They need to automate business workflows such as sending approval requests when a new lead is created in Dynamics 365. Which Microsoft 365 service should they integrate with Teams?

Accepted Answer

Power Automate. Power Automate (Option B) is the correct service because it is designed specifically for automating business workflows across Microsoft 365 and third-party services. When a new lead is created in Dynamics 365, a Power Automate flow can trigger an approval request in Teams, enabling seamless process automation without custom code.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 3

A multinational organization wants a central hub for employee communication that includes company-wide announcements, topic-based communities, and the ability to integrate with SharePoint and Power BI dashboards. Which Microsoft 365 service is designed specifically for this purpose?

Accepted Answer

Microsoft Viva Engage. Microsoft Viva Engage (formerly Yammer) is designed as a social networking and employee communication hub that provides company-wide announcements, topic-based communities, and seamless integration with SharePoint and Power BI dashboards. It focuses on fostering open communication across the organization, unlike collaboration tools that are team-centric.

Answer

Microsoft Teams

Answer

SharePoint Online

Answer

Outlook

Question 4

A sales manager wants to track customer interactions, manage leads, and automate follow-up emails from a single platform. Which Microsoft 365 service is specifically designed for customer relationship management (CRM)?

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales is the dedicated CRM service within the Microsoft 365 ecosystem, purpose-built for tracking customer interactions, managing leads, and automating follow-up emails. Unlike general productivity tools, it provides a unified platform with lead scoring, opportunity management, and workflow automation specifically for sales processes.

Answer

Microsoft Bookings

Answer

Microsoft Power Automate

Answer

Microsoft To Do

Question 5

A project manager wants a shared workspace where team members can create and track tasks, set deadlines, and collaborate on documents. This workspace should integrate with Microsoft Teams for quick access. Which Microsoft 365 service is best suited for this purpose?

Accepted Answer

Microsoft Planner. Microsoft Planner is the correct choice because it provides a shared workspace (Plan) where team members can create and track tasks, set deadlines, and collaborate on documents. It integrates natively with Microsoft Teams via the Planner tab, allowing quick access within a Teams channel, and supports file attachments from SharePoint/OneDrive for collaboration.

Answer

Microsoft Lists

Answer

Microsoft To Do

Answer

Microsoft Project Online

Question 6

A company uses a third-party Human Resources (HR) system. Whenever a new employee is added to the HR system, they want to automatically create a user account in Microsoft 365, assign the appropriate license, and send a welcome email. Which Microsoft 365 service should be used to orchestrate this automation?

Accepted Answer

Microsoft Power Automate. Microsoft Power Automate is the correct service because it provides a low-code workflow automation platform that can trigger actions based on events in external systems (e.g., a new employee record in a third-party HR system) and then orchestrate a sequence of tasks in Microsoft 365, such as creating a user account via the Microsoft Graph API, assigning a license, and sending a welcome email. It integrates seamlessly with hundreds of connectors, including HR systems and Microsoft 365 services, making it the ideal tool for this cross-system automation scenario.

Answer

Microsoft Identity Manager

Answer

Microsoft Entra ID Connect

Answer

Microsoft Graph API

Question 7

A manager wants to quickly create a survey to collect employee feedback on a new policy. The survey must automatically store responses in an Excel spreadsheet and trigger an email notification when a response is submitted. Which Microsoft 365 service should the manager use?

Accepted Answer

Microsoft Forms. Microsoft Forms is the correct choice because it is designed specifically for creating surveys and quizzes, and it natively integrates with Excel to automatically store responses in a spreadsheet. Additionally, Forms supports Power Automate flows out of the box, allowing you to trigger an email notification whenever a new response is submitted, meeting both requirements without custom development.

Answer

Microsoft Lists

Answer

Microsoft Power Apps

Answer

Microsoft SharePoint

Question 8

A project team uses Microsoft Teams and wants to create a shared space where they can track tasks, deadlines, and assign work items without leaving Teams. Which Microsoft 365 app should be integrated into Teams for this purpose?

Accepted Answer

Microsoft Planner. Microsoft Planner is the correct choice because it provides a lightweight, Kanban-style task management solution that integrates directly into Microsoft Teams via the Planner tab. This allows the project team to create, assign, and track tasks with deadlines and progress indicators without leaving the Teams interface, fulfilling the requirement for a shared workspace for work items.

Answer

Microsoft Project Online

Answer

Microsoft To Do

Answer

Microsoft Lists

Question 9

A manager needs to create a custom dashboard that visualizes sales data from multiple data sources in real-time. Which service should they use?

Accepted Answer

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

Excel

Answer

Power Apps

Answer

SharePoint

Question 10

A marketing team needs to create a visually rich newsletter that includes dynamic content from a SharePoint list, such as upcoming events and product images. Which Microsoft 365 app is specifically designed for creating interactive newsletters and presentations?

Accepted Answer

Microsoft Sway. Microsoft Sway is specifically designed for creating interactive, visually rich newsletters and presentations that can pull dynamic content from SharePoint lists, such as upcoming events and product images. It uses a web-based canvas with responsive design and supports embedding live data via SharePoint connectors, making it ideal for marketing teams needing dynamic, shareable content without coding.

Answer

Microsoft Forms

Answer

Microsoft Stream

Answer

Microsoft Microsoft Viva Engage

Question 11

A project manager wants to schedule a meeting with team members to discuss project progress. They need to find a time that works for everyone based on their calendars. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Outlook. Microsoft Outlook includes a scheduling assistant that displays the free/busy information of attendees' calendars, allowing the project manager to find a mutually available time slot. This feature is specifically designed for coordinating meetings across an organization using Exchange Online calendar data.

Answer

Microsoft Teams

Answer

Microsoft Bookings

Answer

Microsoft Shifts

Question 12

A sales team needs a centralized repository for customer proposals that multiple team members can edit simultaneously and that maintains version history. Which Microsoft 365 service should they use?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it provides a centralized document library where multiple users can co-author documents simultaneously, with built-in version history to track changes over time. This aligns directly with the requirement for a shared repository with real-time collaboration and versioning, which OneDrive for Business lacks for team-wide access.

Answer

OneDrive for Business

Answer

Microsoft Teams

Answer

Exchange Online

Question 13

A marketing team wants to create a visual task board to track campaign activities, assign owners, and set deadlines. They do not need subtasks or dependencies. Which Microsoft 365 app is most suitable?

Accepted Answer

Microsoft Planner. Microsoft Planner is the most suitable app because it provides a visual Kanban-style task board specifically designed for team collaboration, allowing users to create tasks, assign owners, set deadlines, and track progress without requiring subtasks or dependencies. It integrates seamlessly with Microsoft Teams and other Microsoft 365 services, making it ideal for lightweight project management like campaign tracking.

Answer

Microsoft Project

Answer

Microsoft To Do

Answer

Microsoft Lists

Question 14

A public relations team needs to create an interactive, visually rich newsletter that includes embedded video and dynamic content from a SharePoint list. Which app should they use?

Accepted Answer

Sway. Sway is the correct choice because it is designed specifically for creating interactive, visually rich newsletters that can embed videos and dynamically pull content from SharePoint lists using its integration with Microsoft 365. Unlike other apps, Sway offers a responsive design canvas that adapts to different devices and allows embedding of multimedia elements directly, making it ideal for a public relations team's needs.

Answer

PowerPoint

Answer

SharePoint News

Answer

Microsoft Stream

Question 15

A project manager needs a centralized location to store all project documents, assign tasks to team members, and track project milestones. The solution must integrate with Microsoft Teams and allow real-time co-authoring. Which Microsoft 365 service should they use?

Accepted Answer

Microsoft SharePoint Online. SharePoint Online provides document libraries for storing files with real-time co-authoring, plus lists for tracking tasks and milestones. It integrates deeply with Teams through tabs. Microsoft Planner is task-focused but does not natively store documents. Project Online is more complex and expensive. To Do is for personal tasks.

Answer

Microsoft Planner

Answer

Microsoft Project Online

Answer

Microsoft To Do

Question 16

A sales representative needs to quickly create a professional-looking price quote that includes dynamic pricing from a company database and send it as a PDF to a customer. Which Microsoft 365 app is best suited for this?

Accepted Answer

Microsoft Word. Microsoft Word is best suited because it supports mail merge and dynamic content from external data sources like a company database. Using Word's 'Insert Quick Parts' or mail merge features, a sales rep can pull live pricing data into a professional quote template and then export the document as a PDF directly from Word.

Answer

Microsoft Excel

Answer

Microsoft Sway

Answer

Microsoft SharePoint Online

Question 17

A project manager wants to create a collaborative workspace that includes a shared calendar, a document library, and a task list. The workspace should be accessible from within Microsoft Teams and allow team members to discuss topics in a threaded conversation. Which Microsoft 365 service should they use as the foundation?

Accepted Answer

SharePoint Team Site. A SharePoint Team Site provides the foundational structure for a collaborative workspace with a shared calendar, document library, and task list. It integrates natively with Microsoft Teams, allowing the workspace to be accessed via a Teams channel, and supports threaded conversations through the connected Teams channel or Yammer web parts. This makes it the correct choice for the described requirements.

Answer

Microsoft Teams with a channel

Answer

Microsoft Planner

Answer

Microsoft Viva Engage Community

Question 18

A sales manager wants to create a visual representation of the sales pipeline, including stages, deal values, and win probability. They want to share this interactive chart with the team via a web link that updates automatically from the underlying data in Microsoft Lists. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Power BI. Microsoft Power BI allows creation of interactive dashboards and reports that can connect to various data sources, including Microsoft Lists. It can publish a web-accessible interactive report that automatically refreshes. Excel charts are static unless published as a web workbook, but they lack interactivity and automatic refresh from Lists without complex setup. SharePoint lists display data in tabular format, not interactive charts. Forms is for surveys.

Answer

Microsoft Excel

Answer

Microsoft Forms

Answer

Microsoft SharePoint

Question 19

A project team needs a centralized workspace that includes a shared calendar for deadlines, a document library for storing deliverables, and a task list with assignments. They also want threaded discussions about each item. Which Microsoft 365 service provides this integrated experience out of the box?

Accepted Answer

Microsoft 365 Groups. Microsoft 365 Groups is the correct answer because it provides a unified, out-of-the-box workspace that includes a shared calendar, document library (via connected SharePoint), task list (via Planner or To Do), and a group mailbox with threaded conversations. Unlike standalone services, a Microsoft 365 Group bundles these resources together automatically when created, offering the integrated experience described without requiring manual configuration.

Answer

Microsoft Teams

Answer

SharePoint Online

Answer

Microsoft Outlook

Question 20

A sales manager needs a visual tool to track the sales pipeline with stages, deal values, and assigned team members. The team should be able to update the board in real time and see changes instantly. Which Microsoft 365 app is most suitable?

Accepted Answer

Microsoft Lists. Microsoft Lists is the most suitable app because it provides a customizable, real-time collaborative board view that can track sales pipeline stages, deal values, and assigned team members. Lists supports real-time co-authoring and instant updates via SharePoint, making it ideal for a visual, always-current sales tracking tool without requiring a full CRM system.

Answer

Microsoft Dynamics 365 Sales

Answer

Microsoft Planner

Answer

Microsoft Excel