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

Question 1

A team wants to build a custom business app to track inventory with minimal custom code. They need a cloud-based database that can store structured data and is tightly integrated with the low-code app platform. Which Microsoft 365 service should they use as the database?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse (formerly Common Data Service) is the cloud-scale database that stores data used by Power Apps, Power Automate, and Dynamics 365. It provides a relational data store with built-in security, business logic, and integration. Power Apps can connect directly to Dataverse to create custom apps with minimal code. SharePoint lists or Excel Online are less suitable for scalable business apps requiring relationships and business rules.

Answer

Microsoft SharePoint Online list

Answer

Microsoft Excel Online

Answer

Microsoft Forms

Question 2

A marketing team needs to create a printed newsletter that includes custom graphics, text boxes, and precise layout control. Which Microsoft 365 app is specifically designed for desktop publishing tasks like this?

Accepted Answer

Microsoft Publisher. Microsoft Publisher is the correct answer because it is specifically designed for desktop publishing (DTP) tasks such as creating printed newsletters with custom graphics, text boxes, and precise layout control. Unlike general-purpose word processors or presentation tools, Publisher provides advanced page layout features, including master pages, typography controls, and fine-grained object positioning, making it the appropriate choice for this scenario.

Answer

Microsoft Word

Answer

Microsoft Sway

Answer

Microsoft PowerPoint

Question 3

A sales team wants to maintain a shared list of high-priority leads with custom columns for company name, contact person, deal value, and stage. Team members need to update the list in real time and view the change history. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Lists. Microsoft Lists is designed for creating and sharing flexible lists with custom columns, real-time collaboration, and version history. Excel can be shared but is not as purpose-built for list management. SharePoint can host lists, but Microsoft Lists is the dedicated app. Teams can display a list as a tab, but the underlying app is Lists.

Answer

Microsoft Excel

Answer

Microsoft SharePoint

Answer

Microsoft Teams

Question 4

A graphic designer needs to create a professional printed brochure with custom page layouts, text wrapping around images, and precise control over typography. Which Microsoft 365 app is designed for this type of desktop publishing task?

Accepted Answer

Microsoft Publisher. Microsoft Publisher is the correct choice because it is specifically designed for desktop publishing tasks such as creating professional brochures with custom page layouts, text wrapping around images, and precise typography control. Unlike general-purpose apps, Publisher offers advanced layout tools like master pages, baseline guides, and typographic controls that are essential for print-ready documents.

Answer

Microsoft Sway

Answer

Microsoft Word

Answer

Microsoft PowerPoint

Question 5

A consulting firm needs a tool to allow customers to schedule appointments with specific consultants online. The tool must show available time slots, send confirmation emails, and allow customers to reschedule. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Bookings. Microsoft Bookings is the correct app because it is specifically designed for scheduling appointments, showing real-time availability of staff, sending automated confirmation and reminder emails, and allowing customers to self-manage rescheduling or cancellations. It integrates with Exchange Online for calendar synchronization and Teams for virtual meetings, meeting all stated requirements.

Answer

Microsoft Forms

Answer

Microsoft To Do

Answer

Microsoft Planner

Question 6

A project manager needs to create a visual timeline of project tasks, dependencies, and milestones to share with stakeholders. The timeline should be embedded in the project team's SharePoint site. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Project for the web. Microsoft Project for the web is the correct choice because it is designed specifically for creating Gantt charts that visualize project tasks, dependencies, and milestones over a timeline. It integrates directly with SharePoint, allowing the timeline to be embedded as a web part on a team site for stakeholder viewing.

Answer

Microsoft Planner

Answer

Microsoft To Do

Answer

Microsoft Lists

Question 7

A sales team needs to create a shared list of customer contact information with custom fields like company, email, phone, and deal stage. The list should be accessible from within Outlook and allow real-time updates by multiple users. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Lists. Microsoft Lists is the correct choice because it provides a customizable, shared list that supports custom columns (e.g., company, email, phone, deal stage) and real-time collaboration. It integrates directly with Outlook via the Lists app or by adding a list as a tab in Outlook, allowing the sales team to access and update the list without leaving their email client.

Answer

Microsoft To Do

Answer

Microsoft Planner

Answer

Microsoft Dynamics 365

Question 8

A project team needs to track action items and issues in a shared list that is accessible from within Outlook and SharePoint. They need to be able to create custom columns, set reminders, and view a history of changes. Which Microsoft 365 app is best suited for this?

Accepted Answer

Microsoft Lists. Microsoft Lists is the correct choice because it provides a shared, customizable list that integrates directly with both Outlook and SharePoint. It allows users to create custom columns, set reminders via Power Automate or column formatting, and track version history for changes, meeting all specified requirements.

Answer

Microsoft To Do

Answer

Microsoft Planner

Answer

Microsoft Viva Engage

Question 9

A consulting firm needs a tool to allow customers to book 30-minute online consulting sessions. The tool must show real-time availability of consultants, send automatic reminders, and allow customers to reschedule. Which Microsoft 365 app should they use?

Accepted Answer

Microsoft Bookings. Microsoft Bookings is the correct choice because it is a Microsoft 365 app specifically designed for scheduling and managing appointments. It provides a public booking page that shows real-time consultant availability, sends automatic email and SMS reminders, and allows customers to reschedule or cancel bookings directly, meeting all the stated requirements.

Answer

Microsoft Teams

Answer

Microsoft Forms

Answer

Microsoft Lists

Question 10

A project manager needs to create a detailed project schedule with a Gantt chart view, task dependencies, critical path analysis, and milestones. The schedule must be shared with team members who can update their tasks, and the manager wants to track progress against a baseline. Which Microsoft 365 app is specifically designed for this type of project management?

Accepted Answer

Microsoft Project. Microsoft Project is the correct answer because it is specifically designed for advanced project management, offering native support for Gantt charts, task dependencies, critical path analysis, milestones, baseline tracking, and collaborative task updates. Unlike simpler tools, Project provides the scheduling engine and analytical capabilities required for detailed, enterprise-grade project plans.

Answer

Microsoft Lists

Answer

Microsoft Planner

Answer

Microsoft Excel

Question 11

An administrator is reviewing a request from users who need to create a team site with document libraries, version history, permissions, and news pages. Microsoft 365 app or service is the best fit?

Accepted Answer

SharePoint Online. SharePoint Online is the correct choice because it provides team sites with document libraries, version history, granular permissions, and news pages as core features. These capabilities are built into SharePoint's site architecture, allowing administrators to create collaboration spaces with full control over content management and access.

Answer

Microsoft Forms

Answer

Microsoft Planner

Answer

Microsoft Purview Audit

Question 12

During a Microsoft 365 planning workshop, store personal work files in the cloud, sync them to a laptop, and share selected files. Microsoft 365 app or service is the best fit?

Accepted Answer

OneDrive for Business. OneDrive for Business is the correct answer because it provides cloud storage for personal work files, syncs them to a laptop via the OneDrive sync client (using the Windows or macOS sync engine), and allows granular sharing of selected files with internal or external users through shareable links with configurable permissions (e.g., view, edit, expiry). This directly matches the scenario's requirements for storing, syncing, and sharing personal work files.

Answer

Microsoft Purview Audit

Answer

Microsoft Planner

Answer

Microsoft Forms

Question 13

A tenant administrator is advising a department that wants to use persistent chat, online meetings, channels, and shared files organized by project. Microsoft 365 app or service is the best fit?

Accepted Answer

Microsoft Teams. Microsoft Teams is the best fit because it provides persistent chat, online meetings, channels, and shared files organized by project. Teams integrates with SharePoint for file storage and OneNote for notes, allowing each channel to have its own file repository and meeting scheduling, directly matching the department's requirements.

Answer

Microsoft Forms

Answer

Microsoft Planner

Answer

Microsoft Purview Audit

Question 14

A business stakeholder asks how Microsoft 365 can help them support organization-wide communities, leadership announcements, and broad employee conversations. Microsoft 365 app or service is the best fit?

Accepted Answer

Microsoft Viva Engage. Microsoft Viva Engage (formerly Yammer) is the correct choice because it is specifically designed for organization-wide social networking, enabling communities, leadership announcements, and broad employee conversations. It provides a dedicated platform for posts, polls, and threaded discussions that can reach the entire organization, unlike other Microsoft 365 tools that focus on task management, surveys, or compliance auditing.

Answer

Microsoft Planner

Answer

Microsoft Forms

Answer

Microsoft Purview Audit

Question 15

While preparing a Microsoft 365 adoption plan, a consultant is asked to create a quick survey and export responses to Excel. Microsoft 365 app or service is the best fit?

Accepted Answer

Microsoft Forms. Microsoft Forms is the correct choice because it is specifically designed for creating quick surveys, quizzes, and polls with automatic response collection and native export to Excel. The consultant needs a lightweight, no-code tool that integrates directly with Excel Online for real-time data analysis, which Forms provides out of the box.

Answer

Microsoft Purview Audit

Answer

Microsoft Planner