MS-900 Describe Microsoft 365 apps and services Practice Test 3 — 15 Questions

Question 1

A project team needs a central location to store and collaborate on project documents, with version history, co-authoring, and the ability to share files securely with external partners. Which Microsoft 365 service provides these capabilities?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it provides a centralized document library with version history, real-time co-authoring via Office Online integration, and granular external sharing controls through secure links or direct invitations. These capabilities align directly with the project team's need for collaborative document management and secure external partner access.

Answer

Exchange Online

Answer

Microsoft Stream

Answer

Microsoft Viva Engage

Question 2

A marketing manager needs to create a modern intranet site that publishes news, important announcements, and upcoming events. The site must be responsive on mobile devices and allow employees to like, comment, and share articles. Which Microsoft 365 service should they use?

Accepted Answer

SharePoint Communication site. A SharePoint Communication site is designed for broadcasting news, announcements, and events to a broad audience, with built-in support for responsive mobile rendering and social features like likes, comments, and sharing. This makes it the correct choice for a modern intranet that needs to engage employees across devices.

Answer

Microsoft Teams

Answer

Microsoft Viva Engage

Answer

Microsoft Viva Connections

Question 3

A product design team wants to conduct remote brainstorming sessions where participants can draw, write sticky notes, and add images on a shared canvas in real time. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Whiteboard. Microsoft Whiteboard is the correct choice because it provides a free-form digital canvas that supports real-time collaboration, including drawing, sticky notes, and image insertion. This directly meets the requirement for remote brainstorming sessions where participants need to interact on a shared canvas simultaneously.

Answer

Microsoft To Do

Answer

Microsoft Forms

Answer

Microsoft Planner

Question 4

An HR manager needs to collect feedback from employees about a new wellness program. The manager wants to create a simple survey with multiple-choice questions and have the responses automatically visualized in charts. Which Microsoft 365 app is best suited for this task?

Accepted Answer

Microsoft Forms. Microsoft Forms is specifically designed for creating surveys, quizzes, and polls with automatic response collection and built-in chart visualization. It allows the HR manager to quickly add multiple-choice questions and instantly see aggregated results as charts without any manual setup.

Answer

Microsoft Excel

Answer

Microsoft Word

Answer

Microsoft Teams

Question 5

A project manager needs to collect weekly status reports from team members. They want to create a simple form where team members can submit updates, and the responses should automatically be stored in an Excel spreadsheet. The manager also wants a notification sent to their email when a new response is submitted. Which Microsoft 365 app(s) should be used together?

Accepted Answer

Microsoft Forms and Microsoft Power Automate. Microsoft Forms allows you to create a simple form for collecting weekly status reports, and its built-in integration with Microsoft Power Automate enables automatic storage of responses into an Excel spreadsheet and sending email notifications when a new response is submitted. Power Automate provides the workflow logic to connect Forms to Excel and trigger the notification, making this combination the correct solution.

Answer

Microsoft Forms only

Answer

Microsoft Lists and Power Automate

Answer

Microsoft Excel only

Question 6

A sales team needs a mobile-friendly solution to track and manage sales leads, meetings, and customer communications in a single interface. The solution should integrate with Outlook and include basic customer relationship management (CRM) capabilities. Which Microsoft 365 app is designed for this purpose?

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales (formerly Dynamics CRM) provides comprehensive sales management, including lead tracking, opportunity management, and integration with Outlook. While the question mentions 'Microsoft 365 app', Dynamics 365 is part of the broader Microsoft business applications family but closely integrated. However, for a 'Microsoft 365 app' that does this, the built-in app is 'Dynamics 365 Sales'. Some may think of 'Microsoft Lists' or 'Outlook', but those lack CRM capabilities. Alternatively, 'Microsoft Relationship Sales'? The question is straightforward: Dynamics 365 is the CRM solution. But note that the domain is 'apps and services', which includes Dynamics 365 as a service. The correct answer is Dynamics 365 Sales.

Answer

Microsoft Lists

Answer

Microsoft Viva Sales

Answer

Microsoft To Do

Question 7

A team of financial analysts needs to collaboratively build a complex budget model that includes data from multiple sources. They require real-time co-authoring, advanced formulas, and the ability to create custom charts. Which Microsoft 365 app is best suited for this task?

Accepted Answer

Microsoft Excel. Microsoft Excel is the correct choice because it is designed for complex numerical modeling with advanced formulas, real-time co-authoring via OneDrive or SharePoint, and custom chart creation. The team's requirements for multi-source data integration, collaborative editing, and analytical visualization align directly with Excel's core capabilities, unlike the other apps which lack these features.

Answer

Microsoft Word

Answer

Microsoft PowerPoint

Answer

Microsoft OneNote

Question 8

An IT administrator needs to ensure that all company-issued Windows 11 devices are configured with the latest security policies and that applications are deployed automatically. Which Microsoft 365 service should they use?

Accepted Answer

Microsoft Intune. Microsoft Intune is the correct choice because it is a cloud-based endpoint management solution that provides mobile device management (MDM) and mobile application management (MAM). It allows IT administrators to enforce security policies (e.g., BitLocker, Windows Defender Firewall, compliance rules) and automate application deployment to Windows 11 devices without requiring on-premises infrastructure. Intune integrates with Microsoft Entra ID for identity-based conditional access but is the primary service for device configuration and app deployment.

Answer

Microsoft Microsoft Entra ID

Answer

Microsoft Defender for Endpoint

Answer

Microsoft 365 Apps for enterprise

Question 9

A company is planning to migrate its collaboration tools to Microsoft 365. They need a solution for real-time document co-authoring, instant messaging, and video conferencing, all in one integrated platform. Which two Microsoft 365 services should they use? (Choose two.)

Accepted Answer

Microsoft SharePoint. Microsoft SharePoint is correct because it provides the document storage and versioning infrastructure that enables real-time co-authoring of documents (e.g., Word, Excel, PowerPoint) via the Office Online Server integration. Microsoft Teams is correct because it integrates instant messaging, persistent chat, and video conferencing (using the underlying Skype for Business Online technology) with SharePoint and OneDrive for seamless file sharing and co-authoring within the same interface.

Answer

Microsoft OneDrive

Answer

Microsoft Stream

Question 10

A training manager needs to create a simple video that includes screen recordings, webcam overlay, and transitions to announce a new compliance policy. The manager wants to use a Microsoft 365 app that is designed for video creation and editing. Which Microsoft 365 app should the manager use?

Accepted Answer

Microsoft Clipchamp. Microsoft Clipchamp is the correct app because it is a dedicated video creation and editing tool included with Microsoft 365, specifically designed for tasks like combining screen recordings, webcam overlays, and transitions. Unlike other Microsoft 365 apps, Clipchamp provides a full timeline-based editor with built-in support for these features, making it ideal for producing a polished compliance policy announcement video.

Answer

Microsoft Stream

Answer

Microsoft Teams

Answer

Microsoft PowerPoint

Question 11

A training department needs to create interactive learning modules that include content pages, quizzes, and surveys. They also need to track completion and results for each learner. Which Microsoft 365 app should they use as the primary authoring tool for the quizzes and surveys?

Accepted Answer

Microsoft Forms. Microsoft Forms is the correct primary authoring tool because it is specifically designed for creating quizzes, surveys, and polls with automatic grading, branching logic, and result tracking. It integrates seamlessly with Microsoft Lists and Power Automate to record completion and results per learner, making it ideal for interactive learning modules.

Answer

Microsoft Stream

Answer

Microsoft Sway

Answer

Microsoft Viva Learning

Question 12

A marketing team needs to create a slide-based presentation that includes charts copied from an Excel spreadsheet and animated transitions. They also require the ability to collaborate in real-time with remote colleagues. Which Microsoft 365 app should they use?

Accepted Answer

PowerPoint. PowerPoint is the correct choice because it is specifically designed for creating slide-based presentations with rich media, including charts copied from Excel and animated transitions. It also supports real-time co-authoring via OneDrive or SharePoint, enabling multiple remote colleagues to edit simultaneously.

Answer

Word

Answer

Excel

Answer

Sway

Question 13

A team needs to create a shared online document and collaborate in real time with colleagues. They require built-in version history and the ability to access the document from any device. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Word Online. Microsoft Word Online is the correct choice because it is a browser-based version of Word that enables real-time co-authoring, automatic version history, and access from any device with an internet connection. Unlike the desktop app, it does not require installation and syncs changes instantly via OneDrive or SharePoint, meeting all stated requirements.

Answer

Microsoft Word (desktop)

Answer

Microsoft OneNote

Answer

Microsoft Teams

Question 14

A sales team needs to manage leads, track customer interactions, and automate follow-up emails. They also want to collect customer feedback through surveys. Which two Microsoft 365 apps should they adopt for these requirements? (Choose two.)

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales is a customer relationship management (CRM) application that provides lead management, customer interaction tracking, and automated follow-up email workflows. Microsoft Forms enables the creation and distribution of surveys to collect customer feedback, with responses automatically stored in Excel for analysis.

Answer

Microsoft Stream

Answer

Microsoft Planner

Question 15

A marketing team needs to create a short promotional video that includes screen recordings, webcam footage, and text overlays. Which Microsoft 365 app should they use to create this video?

Accepted Answer

Microsoft Clipchamp. Microsoft Clipchamp is the correct app because it is a built-in video editor in Microsoft 365 designed for creating and editing videos with features like screen recording, webcam capture, and text overlays. It provides a timeline-based editing interface that allows users to combine multiple media sources into a single promotional video, making it the ideal tool for this task.

Answer

Microsoft Stream

Answer

Microsoft PowerPoint

Answer

Microsoft Sway