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

Question 1

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?

Choose an answer to begin — your selection is scored in the full session.

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

Question 2

A sales team uses SharePoint Online to store contract templates. When a new contract is added to a specific library, a notification should be sent to a Microsoft Teams channel with a direct link to the document. Additionally, the contract owner must receive a custom approval request via email before the document is shared externally. Which Microsoft 365 services must be combined to achieve this?

Accepted Answer

Microsoft Power Automate and Microsoft Teams. Microsoft Power Automate can trigger a flow when a new contract is added to a SharePoint Online library, sending a notification with a direct link to a Microsoft Teams channel. Additionally, Power Automate can initiate a custom approval request via email to the contract owner before external sharing is allowed. This combination directly addresses both requirements without needing additional services.

Answer

Microsoft Teams and Microsoft Power Apps

Answer

Microsoft Forms and Microsoft Teams

Answer

Microsoft Power BI and Microsoft Teams

Question 3

A project manager needs to assign tasks to team members, set deadlines, and track progress in a shared workspace. The workspace should integrate with 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 task assignment, deadline setting, and progress tracking via Kanban boards, and it integrates natively with Outlook for task synchronization and with Teams as a tab app for collaborative access.

Answer

Microsoft To Do

Answer

SharePoint

Answer

Microsoft Lists

Question 4

A sales team needs to track leads, manage customer contact information, record interactions, and automate follow-up email sequences. Which Microsoft 365 app should they use as the primary platform?

Accepted Answer

Microsoft Dynamics 365 Sales. Microsoft Dynamics 365 Sales is a customer relationship management (CRM) application specifically designed to manage leads, track customer contact information, record interactions, and automate sales processes such as follow-up email sequences. It provides built-in lead scoring, opportunity management, and workflow automation that directly match the sales team's requirements, making it the correct primary platform.

Answer

Microsoft Power Automate

Answer

Microsoft SharePoint

Answer

Microsoft Teams

Question 5

A company wants to automate a business process where an approval request is sent to a manager when a new employee is added to the HR system. The HR system is a custom list in SharePoint Online. The process should run without any custom code. Which Microsoft 365 tool should they use to create this automation?

Accepted Answer

Microsoft Power Automate. Microsoft Power Automate is the correct tool because it is designed specifically for creating automated workflows between apps and services without custom code. In this scenario, Power Automate can use a trigger (e.g., 'When an item is created or modified' in SharePoint) to send an approval request to a manager, fully meeting the requirement for a no-code solution.

Answer

Microsoft Power Apps

Answer

Microsoft SharePoint Designer

Answer

Microsoft Visio

Question 6

A company wants to automatically send an email notification to a manager when a new request is submitted in a SharePoint list. The process should require no custom code. Which Microsoft 365 tool should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it provides a no-code, trigger-based workflow engine that can automatically send an email when a new item is added to a SharePoint list. It integrates directly with SharePoint and Outlook, requiring no custom code or developer intervention.

Answer

SharePoint Designer

Answer

Power Apps

Answer

Microsoft Lists

Question 7

A department needs a shared document library with version history, permissions, and co-authoring for team files. Which service should they primarily use?

Accepted Answer

SharePoint Online.. SharePoint Online is the correct choice because it provides a centralized, team-based document library with built-in version history, granular permission management, and real-time co-authoring. Unlike OneDrive for Business, which is designed for personal file storage, SharePoint Online supports shared workspaces where multiple users can collaborate simultaneously on the same documents while maintaining full audit trails and access controls.

Answer

OneDrive for Business.

Answer

Microsoft Forms.

Answer

Microsoft Planner.

Question 8

A department asks for the Microsoft 365 service best suited for personal work files that follow a user across devices. Which service should they use?

Accepted Answer

OneDrive for Business. OneDrive for Business is the correct service because it provides personal cloud storage for work files that sync across a user's devices, enabling access from anywhere. Unlike SharePoint or Teams, which are team-based, OneDrive is designed for individual file storage and synchronization, making it ideal for files that follow the user.

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Purview Compliance Manager

Question 9

A department asks for the Microsoft 365 service best suited for task tracking using boards and buckets. Which service should they use?

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 project management interface. This aligns directly with the department's request for organizing tasks visually, making it the appropriate Microsoft 365 app for lightweight project coordination.

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Purview Compliance Manager

Question 10

A project team needs to collaborate on forms-based surveys and quizzes and co-author related Office files. Which two Microsoft 365 capabilities are most relevant?

Accepted Answer

SharePoint Online document storage. SharePoint Online provides document storage and co-authoring capabilities, enabling team members to simultaneously edit Office files (e.g., Word, Excel, PowerPoint) stored in document libraries. Microsoft Forms allows the team to create forms-based surveys and quizzes, with responses automatically collected and easily exportable to Excel for analysis.

Answer

Exchange anti-malware policy

Answer

Microsoft Purview eDiscovery case

Question 11

A department asks for the Microsoft 365 service best suited for workflow approvals between Microsoft 365 and Dynamics 365. Which service should they use?

Accepted Answer

Power Automate. Power Automate (Option C) is the correct service because it provides a low-code, workflow automation platform that integrates directly with both Microsoft 365 (e.g., SharePoint, Teams) and Dynamics 365. It enables users to create automated approval workflows using prebuilt templates and connectors, making it the ideal choice for cross-service approval processes.

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Purview Compliance Manager

Question 12

A department asks for the Microsoft 365 service best suited for custom low-code business apps. Which service should they use?

Accepted Answer

Power Apps. Power Apps is the correct choice because it is a low-code application development platform within Microsoft 365 that enables users to build custom business apps without extensive coding. It provides pre-built templates, connectors to Microsoft and third-party services, and a drag-and-drop interface, making it ideal for department-level custom app needs.

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Purview Compliance Manager

Question 13

A department asks for the Microsoft 365 service best suited for interactive business dashboards. Which service should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is Microsoft's dedicated business analytics service that enables users to create interactive dashboards and reports from various data sources. It provides real-time data visualization, drill-down capabilities, and natural language querying, making it ideal for business intelligence needs within Microsoft 365.

Answer

Microsoft Purview Compliance Manager

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Entra Privileged Identity Management

Question 14

A department asks for the Microsoft 365 service best suited for Teams channel conversations and meetings. Which service should they use?

Accepted Answer

Microsoft Teams. Microsoft Teams is the correct service because it is specifically designed to host channel-based conversations and meetings within Microsoft 365. Teams provides persistent chat channels, audio/video conferencing, and meeting scheduling, directly fulfilling the department's request.

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Defender for Endpoint

Answer

Microsoft Purview Compliance Manager

Question 15

A department asks for the Microsoft 365 service best suited for department document libraries with version history. Which service should they use? The design must avoid adding custom operational scripts.

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it provides document libraries with built-in version history, allowing users to track, restore, and manage previous versions of documents without any custom scripting. This service is designed for collaborative document management and meets the requirement of avoiding custom operational scripts.

Answer

Microsoft Purview Compliance Manager

Answer

Microsoft Entra Privileged Identity Management

Answer

Microsoft Defender for Endpoint