MS-900 Practice Exam 52 — 20 Questions

Question 1

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 2

A project team needs to create a central workspace where they can store project documents, assign tasks, track a shared calendar of milestones, and have threaded discussions about each item. The solution must integrate directly with Microsoft Teams. Which Microsoft 365 service provides this out-of-the-box?

Accepted Answer

SharePoint Online. SharePoint Online provides a central workspace with document libraries for storing project documents, task lists for assignment, shared calendars for milestones, and discussion boards for threaded conversations. It integrates natively with Microsoft Teams via the SharePoint tab, allowing the team to access all these features directly within the Teams interface without additional configuration.

Answer

Microsoft Lists

Answer

Planner

Answer

Project Online

Question 3

A project team needs to collaborate on Teams channel conversations and meetings and co-author related Office files. Which two Microsoft 365 capabilities are most relevant?

Accepted Answer

Microsoft Teams. Microsoft Teams is the correct answer because it provides the central hub for channel conversations, meetings, and real-time collaboration. SharePoint Online document storage is also correct because Teams channels use SharePoint as the underlying storage for all shared files, enabling co-authoring of Office documents directly within the Teams interface.

Answer

Microsoft Purview eDiscovery case

Answer

Exchange anti-malware policy

Question 4

During requirements gathering, an IT manager says the organization must track assets using columns such as owner, status, purchase date, and location. Microsoft 365 app or service is the best fit?

Accepted Answer

Microsoft Lists. Microsoft Lists is the best fit because it provides a structured, customizable data-tracking solution with columns for metadata like owner, status, purchase date, and location. Unlike simple task or form tools, Lists supports rich column types (e.g., choice, date, person), views, and integration with SharePoint, making it ideal for asset tracking.

Answer

Microsoft Forms

Answer

Microsoft Planner

Answer

Microsoft Purview Audit

Question 5

Your organization has a Microsoft 365 E5 subscription and wants to centrally manage security incidents across identities, endpoints, and cloud apps. Which Microsoft solution provides this capability?

Accepted Answer

Microsoft Defender XDR. Microsoft Defender XDR (formerly Microsoft 365 Defender) correlates signals from across the Microsoft 365 ecosystem into a unified incident view. Option A is correct. Option B is SIEM, Option C is for identity, Option D is for endpoints only.

Answer

Microsoft Entra ID Protection

Answer

Microsoft Sentinel

Answer

Microsoft Defender for Endpoint

Question 6

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 7

A department asks for the Microsoft 365 service best suited for task tracking using boards and buckets. Which service should they use? The design must avoid adding custom operational scripts.

Accepted Answer

Microsoft Planner. Microsoft Planner is the correct service because it provides task tracking using boards and buckets, which are core features of its Kanban-style interface. It is designed for lightweight project management within Microsoft 365, allowing users to create plans, organize tasks into buckets, and track progress without requiring custom scripts or additional configuration.

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Purview Compliance Manager

Question 8

A field service team needs a mobile-friendly app that allows technicians to view customer information from a central database, log completed tasks, and capture photos on-site. The IT department has limited development resources and wants to build this app quickly without writing extensive code. Which Microsoft 365 app is best suited for this requirement?

Accepted Answer

Microsoft Power Apps. Microsoft Power Apps is the correct choice because it enables rapid development of custom mobile-friendly apps with minimal code, allowing the field service team to view customer data from a central database (e.g., Dataverse or SharePoint), log completed tasks, and capture photos on-site. Its low-code platform provides pre-built connectors and templates that directly address the need for a data-driven, mobile-first application without extensive development resources.

Answer

Microsoft Forms

Answer

Microsoft Power Automate

Answer

Microsoft Power BI

Question 9

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 10

A healthcare organization must ensure that electronic protected health information (ePHI) in Microsoft 365 is encrypted both at rest and in transit. Which Microsoft 365 feature provides encryption for data in transit?

Accepted Answer

TLS/SSL encryption. Microsoft 365 uses TLS to encrypt data in transit between clients and Microsoft servers. Option A is correct. BitLocker encrypts at rest, Purview is for governance, and Rights Management is for access control.

Answer

Azure Information Protection

Answer

BitLocker Drive Encryption

Answer

Microsoft Purview Information Protection

Question 11

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 12

A project team needs to create a shared workspace to manage tasks, share files, track project milestones, and communicate through conversation threads. They want a single app that integrates with other Microsoft 365 services like Outlook and Teams. Which Microsoft 365 app is best suited for this requirement?

Accepted Answer

Microsoft Planner. Microsoft Planner is best suited because it provides a shared workspace with buckets and cards for task management, file attachments, milestone tracking via checklists and due dates, and conversation threads on each task. It integrates natively with Outlook for task visibility and with Teams via the Planner tab, meeting the requirement for a single app that combines these capabilities.

Answer

Microsoft To Do

Answer

Microsoft Project for the web

Answer

Microsoft Lists

Question 13

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 14

Which three options describe features or capabilities of Microsoft Viva? (Choose three.)

Accepted Answer

Integrates employee communications and company news in Viva Connections. Microsoft Viva is an employee experience platform (EXP) that brings together communications, knowledge, learning, resources, and insights. Viva Learning provides a centralized hub for learning and training resources from LinkedIn Learning, Microsoft Learn, and third-party content providers. Viva Connections delivers a personalized dashboard that integrates company news, conversations, and resources from SharePoint and Yammer. Viva Insights uses Microsoft Graph data to provide analytics on work patterns, such as meeting time, focus hours, and well-being trends, helping individuals and managers improve productivity and work-life balance.

Answer

Functions as a cloud-based customer relationship management (CRM) system

Answer

Automates complex business workflows using Power Automate

Answer

Delivers advanced threat protection for email and documents

Question 15

Which THREE of the following are valid data subject rights under GDPR? (Choose three.)

Accepted Answer

Right to data portability. GDPR grants individuals rights such as the right to erasure, portability, and access. Options B, C, and D are correct.

Answer

Right to perpetual storage

Answer

Right to monetization of data

Question 16

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 17

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 18

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 19

Refer to the exhibit. You are reviewing a Microsoft Purview Information Protection policy created by a colleague. The policy is intended to prevent users from sharing files labeled 'Highly Confidential' with external parties. However, users are still able to share these files externally. Which of the following is the most likely reason?

Accepted Answer

The sensitivity label is not published to the users.. Option A is correct because the policy uses sensitivityLabels condition, but the correct property should be 'sensitivityLabelIds' (or equivalent) and the label must be published. Option B is wrong because the condition is based on sensitivity labels, not file extensions. Option C is wrong because the action blockSharing is correctly specified. Option D is wrong because the policy is not missing an action; the action is present.

Answer

The policy is missing the 'blockAccess' action.

Answer

The action should be set to 'blockAccess' only.

Answer

The condition should check for file extension instead of sensitivity label.

Question 20

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?

Accepted Answer

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

Power Apps

Answer

Power Automate

Answer

Power Virtual Agents