PL-900 Power Platform Book: Study Guide & Exam Questions
  • 1.Describe the business value of Microsoft Power Platform

1.1 Describe the business value of Microsoft Power Platform

Organizations today are expected to offer digital services, remove manual handoffs, and use data consistently, even with limited developer time. Microsoft Power Platform meets that need as a connected set of tools that helps teams build apps, automate processes, create websites, organize business data, deploy AI agents, integrate services, and plan complete, end-to-end solutions.

A connected family of tools

Each product solves a different business problem, but the products are designed to share the same data and connections. For example, a community sports club could keep its membership list in one place, let members update details through an app, send renewal reminders automatically, publish schedules on a website, and answer common questions with an AI helper, all working from the same information.

Product area

How it helps an organization

Power Apps

Builds custom business apps for tasks such as tracking requests, inventory, or approvals

Power Automate

Automates repetitive processes and moves information between people and systems

Power Pages

Creates external-facing websites for customers, partners, or community members

Dataverse

Organizes and secures shared business data so apps and processes use consistent information

Copilot Studio and copilots

Deploys AI agents and generative AI assistance that answer questions and take actions

Connectors

Integrates services by linking Power Platform tools to other Microsoft and third-party systems

Plan Designer

Plans end-to-end solutions by outlining what to build, automate, and connect for a business goal

Diagram: Plan Designer - plans end-to-end solutions, Plan Designer guidance, Power Apps - build apps, Power Automate - automate processes, Shared data (Dataverse) + connectors, Power Pages - create websites, Copilot Studio + copilots - AI agents

1. Match each Power Platform area to the business task it is designed to support.
  • Power Apps
  • Power Automate
  • Power Pages
  • Dataverse
  • Copilot Studio
  • Connectors
  • Plan Designer
  • Automate processes
  • Build business applications
  • Build external websites
  • Connect to other services
  • Create AI agents
  • Organize business data
  • Plan complete solutions
Show answer and explanation
  • Power Apps: Build business applications
  • Power Automate: Automate processes
  • Power Pages: Build external websites
  • Dataverse: Organize business data
  • Copilot Studio: Create AI agents
  • Connectors: Connect to other services
  • Plan Designer: Plan complete solutions

Power Apps is for building custom business apps with forms and views.

Power Automate is for automating steps and moving information automatically.

Power Pages is for creating external websites.

Dataverse is for organizing shared business data in secure tables.

Copilot Studio is for creating custom AI agents.

Connectors are for linking to other Microsoft and third-party services.

Plan Designer is for planning a complete solution before building.

2. A university department tracks equipment loans on paper. Staff want a simple app where students submit loan requests and an automatic flow that notifies staff and updates the loan status. Power Apps builds apps, Power Automate automates processes, Power Pages builds websites, and Dataverse organizes data. Which combination fits this need?
  • Power Apps to build the loan-request app and Power Automate to send notifications and update status
  • Power Pages to build the internal loan-request app and Dataverse to send notifications automatically
  • Power Automate to build the loan-request screens and Power Apps to run the background notifications
  • Dataverse to build the loan-request screens and Power Pages to run the background notifications
Show answer and explanation
  • Power Apps to build the loan-request app and Power Automate to send notifications and update status

Power Apps creates the user-facing app for submitting and viewing requests, while Power Automate handles the automatic notifications and status updates. The other pairings assign app building, automation, website creation, and data organization to the wrong tools.

Business outcomes beyond individual tools

The larger value appears when tools are combined. A targeted app removes a paper form, automation removes waiting for manual emails, a website extends the same process to people outside the organization, and shared data keeps every step consistent without re-entering information.

  • Address specific operational needs by building focused apps and automations instead of relying only on generic software or long custom development projects

  • Serve people outside the organization by publishing selected information and services through websites while keeping the underlying data controlled

  • Improve consistency by organizing business data once and reusing it across apps, flows, assistants, and plans

  • Protect existing investments by integrating current email, file, and business systems rather than replacing every system

  • Stay coherent by planning end-to-end solutions that show how apps, data, automation, integration, and AI fit one business goal

3. Using completely separate tools for apps, automation, and websites with no shared data generally improves data consistency more than using a connected platform with shared data and integrations.
  • True
  • False
Show answer and explanation
  • False

Shared data and integrations improve consistency because one record is reused everywhere. Isolated tools without shared data tend to create duplicates and conflicting copies.

4. Why does the ability to integrate existing email, file-storage, and third-party systems through connectors provide business value to an organization that already pays for those systems?
  • It lets new apps and automations reuse those existing systems instead of replacing them
  • It requires the organization to replace all existing systems before building anything new
  • It prevents apps from using data that lives outside the new app
  • It removes the need to organize shared business data
Show answer and explanation
  • It lets new apps and automations reuse those existing systems instead of replacing them

Connectors let new apps and flows call into systems the organization already uses, so the organization gains new capabilities without discarding or rebuilding those systems.

5. A nonprofit publishes volunteer roles on a public site, collects applications in an app, and approves them with an automated flow. Which outcome best shows the value of combining tools with shared data rather than using one tool alone?
  • A customer record entered once appears consistently in the app, the automated approval, and the website
  • The same customer record is typed separately into three disconnected spreadsheets
  • Staff build three unrelated tools that each store their own copy of customer data
  • The website is launched with sample data that is never connected to internal work
Show answer and explanation
  • A customer record entered once appears consistently in the app, the automated approval, and the website

Entering the record once and reusing it in the app, the approval flow, and the website avoids retyping, reduces errors, and keeps everyone looking at the same information.

Data, integration, and intelligence as a foundation

Reliable apps and automation depend on trustworthy data and connections, and AI helpers depend on them even more. Dataverse provides the organized data layer, connectors provide the links to other services, and Copilot Studio, copilots, and generative AI provide assistants that can answer questions and act on that connected information.

  • Dataverse stores business information in defined, secured tables so every app, flow, and agent works from the same records and rules

  • Connectors link those apps, flows, and agents to common Microsoft services and third-party systems such as mail, calendars, file storage, and accounting

  • Copilot Studio lets an organization create its own AI agents, while copilots and generative AI add conversational help that summarizes content, drafts responses, and triggers actions

6. A campus bookstore keeps its inventory in ____ so that its stock app and its reorder workflow use the same records. It uses ____ to link those tools to its payment provider and email system. It then offers shoppers an AI helper created with ____ that can answer questions about availability.
  • connectors
  • Copilot Studio
  • Dataverse
  • Power Automate
  • Power Pages
Show answer
  • A campus bookstore keeps its inventory in Dataverse so that its stock app and its reorder workflow use the same records. It uses connectors to link those tools to its payment provider and email system. It then offers shoppers an AI helper created with Copilot Studio that can answer questions about availability.
7. What is the name of the Power Platform service that organizes shared business data into secure tables that apps, flows, and agents can reuse?
Show answer and explanation
  • Dataverse, Microsoft Dataverse

Dataverse is the shared data service that stores business information in secure tables for reuse by apps, flows, and agents.

8. A help desk wants an assistant that drafts answers from company knowledge and can trigger actions like logging a ticket. Copilots provide AI assistance and Copilot Studio is used to create custom AI agents. Which capability best describes this need?
  • A conversational agent that drafts an answer from company knowledge and logs a support ticket
  • A static FAQ page that cannot use company data or take any action
  • A website builder used only to change page colors with no access to data
  • A data table with no assistant or automation attached to it
Show answer and explanation
  • A conversational agent that drafts an answer from company knowledge and logs a support ticket

Generative AI can draft a relevant reply from company knowledge, and a Copilot Studio agent can be configured to answer in conversation and perform the follow-up action of logging the ticket.

Starting from a business goal

Technology projects fail when teams build disconnected pieces without a shared picture of success. Plan Designer supports the opposite habit: it helps an organization outline an end-to-end solution around a goal, clarifying which app to build, which process to automate, which data to organize, which services to integrate, and where an agent or website fits.

9. A student startup wants an orientation website for new members, a sign-up app, an automated welcome sequence, and consistent member data across all three. It is unsure where to start and what to build first. Plan Designer plans end-to-end solutions while the other tools build individual pieces. Which approach best reflects the role of Plan Designer?
  • Use Plan Designer to outline the goal and map the needed website, app, automation, and data
  • Skip planning and build four disconnected tools with separate copies of member data
  • Use Plan Designer only to change website colors after everything is built
  • Replace the app, automation, and website with a planning document and deliver no working pieces
Show answer and explanation
  • Use Plan Designer to outline the goal and map the needed website, app, automation, and data

Plan Designer is for planning the whole solution, mapping the website, app, automation, and data to the membership goal before detailed building begins.

10. Plan Designer replaces the need to build apps, automations, and websites because producing a plan alone delivers the finished working solution.
  • True
  • False
Show answer and explanation
  • False

Planning guides what to build, but the organization must still build the app, flow, website, and data model and connect them to deliver working value.

Extra questions

A company will build new apps to help employees work more efficiently.

11. Match each requirement to the Power Platform technology to recommend.
  • Build mobile apps that use cameras and location data
  • Build a feature that detects objects in images
  • AI Builder
  • canvas
  • model-driven
  • Power Pages
Show answer and explanation
  • Build mobile apps that use cameras and location data: canvas
  • Build a feature that detects objects in images: AI Builder

Canvas apps suit task-focused mobile use and can use device features such as camera control and location signals.

AI Builder object detection can be trained to find and count items in images for apps and flows. Model-driven apps focus on data-centric processes and Power Pages builds external websites.

12. A toy maker uses an AI Builder category classification model to scan customer comments for key terms. When comments about a toy are negative, the maker wants to start an engineering review of that toy and arrange extra training for production workers. Which two approaches can each deliver a complete solution?
  • Create a canvas app
  • Implement a Microsoft Copilot Studio agent
  • Build a Power Automate flow
  • Use the Common Data Model
Show answer and explanation
  • Create a canvas app
  • Build a Power Automate flow

AI Builder classification models are consumed from Power Apps and Power Automate. A canvas app can call the model with the Predict function, highlight negative feedback, and let staff launch reviews and book training. A flow can score each new feedback item and automatically create review tasks and schedule training when the result is negative. A Copilot Studio agent provides a conversational question-answering experience rather than acting on model output, and the Common Data Model is a shared data schema, not a tool that runs a process.

A company is adopting Power Platform to manage business processes and staff want to grasp each component purpose.

13. Match each tool to its benefit.
  • Easy data integration
  • Low code or no code across applications
  • Easy to customize front end
  • AI Builder
  • canvas apps
  • connectors
  • Power Automate
  • Power Pages
Show answer and explanation
  • Easy data integration: connectors
  • Low code or no code across applications: Power Automate
  • Easy to customize front end: canvas apps

Connectors wrap service APIs so apps and flows integrate data without custom code.

Power Automate builds low-code and no-code workflows spanning many apps and services.

Canvas apps start blank with full layout control, making the front end easy to tailor.

A business is reviewing what AI Builder offers.

14. Ready-made AI Builder models arrive already trained and can interpret business data immediately.
  • True
  • False
Show answer and explanation
  • True

Prebuilt models such as business card reader, invoice processing, sentiment analysis, and text recognition are trained by Microsoft and ready to use without collecting data or training a model.

15. Ready-made AI Builder models can be used in both Power Automate and Power Apps.
  • True
  • False
Show answer and explanation
  • True

The same prebuilt models are available to both flows and apps.

A company runs Microsoft 365 and Dynamics 365 Sales with no developers on staff. Executives want the advantages of Power Platform explained.

16. What are two benefits of using Power Platform applications?
  • Users can send emails from Dynamics 365 Sales to their personal email addresses.
  • Users can use Power Apps to create apps for different departments.
  • Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales.
  • The company can unify all the mobile devices to one vendor.
Show answer and explanation
  • Users can use Power Apps to create apps for different departments.
  • Users can use Power Automate to share information between Microsoft 365 and Dynamics 365 Sales.

Power Apps lets non-developers assemble low-code apps for each department, and Power Automate moves information automatically between Microsoft 365 and other systems through connectors. Forwarding mail to personal addresses and unifying device vendors are not Power Platform benefits.

A company runs sales in a model-driven app and states three needs that must be met with Microsoft Power Platform.

17. Match each need to the application to use.
  • Ask a manager for approval automatically when a deal exceeds the price threshold.
  • Offer a webpage agent that handles customer inquiries.
  • Supply an outside site where customers sign in to see and revise account details.
  • AI Builder
  • Microsoft Copilot Studio
  • Power Automate
  • Power Pages
Show answer and explanation
  • Ask a manager for approval automatically when a deal exceeds the price threshold.: Power Automate
  • Offer a webpage agent that handles customer inquiries.: Microsoft Copilot Studio
  • Supply an outside site where customers sign in to see and revise account details.: Power Pages

A cloud flow triggered by a Dataverse change can evaluate the price and launch a manager approval.

Copilot Studio creates conversational agents that respond to questions and can be published to a webpage.

Power Pages builds secure outside-facing sites where signed-in customers inspect and modify their Dataverse records. AI Builder only adds AI models.

Pair each everyday task with the appropriate Power Platform tool.

18. Match each task to its tool.
  • Streamline routine workflows.
  • Launch activity from an event.
  • Design a tailored mobile screen for typing data.
  • Power Apps
  • Power Automate
  • Power BI
Show answer and explanation
  • Streamline routine workflows.: Power Automate
  • Launch activity from an event.: Power Automate
  • Design a tailored mobile screen for typing data.: Power Apps

Flows created in Power Automate automate work across applications and services.

Each cloud flow begins with a trigger event, such as a new message or row, that launches its actions.

Power Apps creates tailored applications, including mobile entry screens. Power BI focuses on reporting.

A company must create workflows and applications to simplify selling.

19. Which applications fit each situation? Create code-free workflows that span separate systems: ____ Assemble a code-free mobile application: ____ Assemble a mobile application that uses Microsoft Dataverse: ____
  • Azure Logic Apps
  • Power Apps
  • Power Automate
Show answer
  • Which applications fit each situation? Create code-free workflows that span separate systems: Power Automate Assemble a code-free mobile application: Power Apps Assemble a mobile application that uses Microsoft Dataverse: Power Apps

A fast-expanding business licenses Microsoft 365 for all staff and wants people to build applications and automate routines themselves, without coding expertise and without increasing IT cost or dependence on IT.

20. Which tools should be suggested? Build self-running workflows that reach several data sources: ____ Create tailored applications for particular business needs: ____
  • AI Builder
  • Azure Functions
  • Power Apps
  • Power Automate
Show answer
  • Which tools should be suggested? Build self-running workflows that reach several data sources: Power Automate Create tailored applications for particular business needs: Power Apps

A firm wants a help desk setup that brings in Excel data daily and offers conversational help to customers.

21. Which applications meet each demand? Automatically load an Excel sheet once per day: ____ Supply a support assistant for customers: ____
  • Azure Data Lake
  • Custom connector
  • Microsoft Copilot Studio
  • Power Automate
  • Power BI
Show answer
  • Which applications meet each demand? Automatically load an Excel sheet once per day: Power Automate Supply a support assistant for customers: Microsoft Copilot Studio

Support technicians at a growing firm need smoother handling of support cases.

22. Match each need to the tool to suggest.
  • Let technicians file support requests through an app.
  • Keep customer records in a shared central platform used with other business apps.
  • Alert technicians whenever a fresh support request arrives.
  • Microsoft Dataverse
  • Power Apps
  • Power Automate
  • Power BI
Show answer and explanation
  • Let technicians file support requests through an app.: Power Apps
  • Keep customer records in a shared central platform used with other business apps.: Microsoft Dataverse
  • Alert technicians whenever a fresh support request arrives.: Power Automate

Power Apps builds the application technicians use to file support requests.

Dataverse is the secure shared store of standard and custom tables that business applications jointly use.

Power Automate can react to a new row trigger and dispatch a notice for each fresh request. Power BI serves analytics, not storage or alerts.

23. A firm intends to adopt Microsoft Power Platform. Which three Microsoft products belong to Power Platform?
  • Power Apps
  • Microsoft Entra ID
  • Power Automate
  • Azure Machine Learning
  • Power Pages
Show answer and explanation
  • Power Apps
  • Power Automate
  • Power Pages

Power Apps, Power Automate, and Power Pages are all members of Power Platform, along with Copilot Studio. Microsoft Entra ID supplies identity for sign-in but is not a Power Platform product, and Azure Machine Learning is an Azure modeling service, not part of Power Platform.

A firm operates customer support with a Dataverse-based model-driven application and intends to broaden the solution with additional Power Platform capabilities.

24. Pair each business need with the Power Platform technology that fulfills it.
  • Shoppers sign in to a protected portal to track their own support cases.
  • Costly reimbursement claims route by themselves for leader sign-off inside Teams.
  • Showcase a picture collection on a bespoke screen inside the model-driven support app.
  • Canvas apps
  • Power Automate
  • Power Pages
Show answer
  • Shoppers sign in to a protected portal to track their own support cases.: Power Pages
  • Costly reimbursement claims route by themselves for leader sign-off inside Teams.: Power Automate
  • Showcase a picture collection on a bespoke screen inside the model-driven support app.: Canvas apps

A company is exploring Power Platform capabilities and wants each service matched to what it does best.

25. Which service matches each capability?
  • Quickly create an app that can connect to multiple data sources.
  • Provision a scalable and highly secure data store.
  • Define common logic within the context of multiple apps.
  • Update a SharePoint list every weekday by using common logic.
  • Dataverse
  • Power Apps
  • Power Automate
  • Power Pages
Show answer and explanation
  • Quickly create an app that can connect to multiple data sources.: Power Apps
  • Provision a scalable and highly secure data store.: Dataverse
  • Define common logic within the context of multiple apps.: Dataverse
  • Update a SharePoint list every weekday by using common logic.: Power Automate

Power Apps quickly builds apps that reach many sources through connectors.

Dataverse is the secure, scalable cloud store for the platform.

Table-level logic in Dataverse, such as business rules and calculated columns, applies across every app using the table.

A weekday update of a SharePoint list is a scheduled cloud flow.