PL-900: Microsoft Power Platform Fundamentals

PL-900 exam objectives and study guide

The skills measured on the PL-900 exam, by objective domain. Percentages are the share of the exam each domain carries.

PL-900 practice questions and answers

12 free sample questions from the PL-900 bank, with the correct answer and a full explanation for each. These are original questions written to the Microsoft objective domains — not real exam content.

1. Question 1Demonstrate the capabilities of Power Apps

   Tailwind Traders is replacing a paper dock-inspection checklist. Inspection records are already stored in a Microsoft Lists list in SharePoint Online, and the operations team cannot migrate the data to Dataverse this quarter. Inspectors need a standalone phone app with a highly customized screen layout, conditional fields, and the ability to update list items. Which approach should the maker use?

   • ACreate a canvas app connected to the SharePoint list and customize the screens in the app designer.
   • BCreate a model-driven app after moving the inspection records into Dataverse tables and forms.
   • CCustomize the SharePoint list form with Power Apps and require inspectors to open list items.
   • DCreate a Power Pages site backed by Dataverse and expose the inspection table to inspectors.

   Show answer and explanation

   Correct answer

   • Create a canvas app connected to the SharePoint list and customize the screens in the app designer.

   Explanation

   The maker should create a canvas app connected to the SharePoint list. Canvas apps are appropriate when a maker needs a tailored user interface and can connect directly to data sources such as SharePoint lists.

   • A model-driven app is built on Dataverse tables, so moving the inspection data into Dataverse would violate the stated constraint.
   • A customized SharePoint list form uses Power Apps, but it customizes the form experience for the list rather than creating a standalone app with a full phone-oriented screen flow.
   • Power Pages is for building external-facing business websites and uses Dataverse as its primary data platform, which does not match the no-Dataverse constraint.

   References:

   • Create a canvas app with data from a list
   • Integrate SharePoint Online into Power Apps overview
   • Overview of building a model-driven app with Power Apps
2. Question 2Demonstrate the capabilities of Power Apps

   Warehouse inspections must be completed on tablets by employees who need a guided, touch-friendly interface for capturing readings and photos. The solution should connect to Microsoft 365 data sources and be built without custom code. Which Power Platform app type best fits this requirement?

   • ABuild a canvas app so makers can design custom screens with controls, formulas, and connectors.
   • BBuild a model-driven app so Dataverse tables automatically define the navigation and forms.
   • CBuild a Power Pages site so external users can submit inspection information in a browser.
   • DBuild a Power BI report so employees can analyze inspection results in interactive visuals.

   Show answer and explanation

   Correct answer

   • Build a canvas app so makers can design custom screens with controls, formulas, and connectors.

   Explanation

   A canvas app is the best fit because makers design the user experience by placing controls on screens, writing Power Fx formulas, and connecting to data sources through connectors. Canvas apps are commonly used for task-specific tablet and phone experiences.

   • A model-driven app is centered on a Dataverse data model and generated forms, views, and navigation, not a highly tailored touch layout.
   • A Power Pages site is for external-facing or authenticated web sites, not primarily an internal mobile inspection app.
   • A Power BI report is for analytics and reporting, not transactional data capture with customized app screens.

   References:

   • Complete guide to building canvas applications
   • Overview of building a model-driven app with Power Apps
   • What is Power Pages?
3. Question 3Demonstrate the capabilities of Power Apps

   Alpine Ski House keeps equipment checkout records in an Excel table stored in OneDrive for Business. The operations manager wants an internal low-code app that displays rows in a gallery and lets staff edit records on customized screens. Which canvas app capability should they use first?

   • ACreate a canvas app from the Excel table through the OneDrive for Business connection, then customize the generated gallery and form screens.
   • BCreate a model-driven app and select the Excel workbook as the primary table for the site map.
   • CImport the workbook into Power BI and pin the report visuals to a workspace dashboard.
   • DCreate a Power Automate desktop flow to replay checkout edits in the workbook on behalf of users.

   Show answer and explanation

   Correct answer

   • Create a canvas app from the Excel table through the OneDrive for Business connection, then customize the generated gallery and form screens.

   Explanation

   The Excel Online (Business) connector can use a formatted Excel table in OneDrive for Business as a data source for a canvas app. The maker can then customize gallery and form screens with controls and formulas.

   • A model-driven app is built on Dataverse tables, not directly on an Excel workbook as the app data model.
   • A Power BI report is useful for analysis, but it is not the primary tool for transactional editing through custom app screens.
   • A Power Automate desktop flow automates user-interface actions on a machine; it does not provide an interactive canvas app for staff.

   References:

   • Add data connections to canvas apps
   • Excel Online (Business)
   • Gallery control in Power Apps
   • Edit form and Display form controls in Power Apps
4. Question 4Demonstrate the capabilities of Power Apps

   You are configuring the OnSelect property of a button in a canvas app. When selected, the button should open an existing review screen in the same app by using a fade transition. Complete the formula.

   1(scrReview, ScreenTransition.Fade)

   Blank 1

   • ANavigate
   • BBack
   • CLaunch
   • DSubmitForm

   Show answer and explanation

   Correct answer

   • Blank 1: Navigate

   Explanation

   Navigate changes the current screen to another screen in the same canvas app and can specify a ScreenTransition value such as ScreenTransition.Fade.

   • Back returns to the previous screen rather than targeting scrReview.
   • Launch opens a web page or app outside the canvas app by using an address.
   • SubmitForm saves data from an edit form; it does not navigate to a screen by itself.

   References:

   • Back and Navigate functions
   • Get started with formulas in canvas apps
5. Question 5Demonstrate the capabilities of Power Automate

   You want to automate repetitive data entry in a legacy Windows invoicing application that has no connector. You want AI to draft the automation from a plain-language description instead of recording every click manually. Which Power Automate capability should you use?

   • AUse Copilot in Power Automate for desktop to create a desktop flow from a natural-language prompt.
   • BUse AI Builder document processing to create a model from screenshots of the invoicing application.
   • CUse Copilot Studio to create a topic that enters the invoice data in the Windows application.
   • DUse Power Automate Process Mining to generate the UI automation actions from process analytics.

   Show answer and explanation

   Correct answer

   • Use Copilot in Power Automate for desktop to create a desktop flow from a natural-language prompt.

   Explanation

   The correct choice is to use Copilot in Power Automate for desktop. Copilot can help makers create a desktop flow draft from a natural-language description, which is appropriate when the automation must interact with a local Windows application UI.

   • AI Builder document processing extracts structured data from documents; it does not create desktop UI automation steps.
   • Copilot Studio is used to build conversational copilots and agents, not to author Power Automate for desktop actions.
   • Power Automate Process Mining analyzes business processes and identifies improvement opportunities; it does not draft a desktop flow that clicks through a Windows application.

   References:

   • Overview of AI Builder
6. Question 6Demonstrate the capabilities of Power Automate

   A governed Power Platform environment has a data loss prevention (DLP) policy that separates SharePoint and Dropbox into different connector data groups. A maker asks Copilot to create a cloud flow that copies files from SharePoint to Dropbox. What should you tell the maker?

   • AHave Copilot revise the design to use allowed connectors, or request a DLP policy change before the flow is used.
   • BGenerate the flow inside an unmanaged solution because solution-aware cloud flows are exempt from DLP grouping.
   • CSwitch the generated flow to the classic designer because DLP grouping is enforced only in the new designer.
   • DPlace an AI Builder action between the connectors because AI Builder separates Business and Non-business data.

   Show answer and explanation

   Correct answer

   • Have Copilot revise the design to use allowed connectors, or request a DLP policy change before the flow is used.

   Explanation

   Copilot can help draft or revise the flow, but it does not bypass Power Platform DLP policies. If two connectors are placed in incompatible DLP data groups, the flow design must be changed to use allowed connectors or an administrator must update the policy.

   • Solution-aware flows are still subject to DLP policies; putting the flow in an unmanaged solution does not exempt it.
   • DLP enforcement is not limited to the new designer. It applies to cloud flows regardless of whether AI helped create the design.
   • AI Builder actions do not separate or neutralize connector data groups in a DLP policy.

   References:

   • Create your first cloud flow using Copilot
   • Data policies
7. Question 7Describe features and capabilities of agents in Microsoft Copilot Studio

   Litware’s help desk keeps a simple CSV of scenarios that reviewers enter into Copilot Studio evaluations. Complete the row so it contains a user request and the expected result for that request.

   testCase,input,expectedOutcome
   "Password reset",1,2

   Blank 1

   • A"How do I reset my password?"
   • B"The answer directs the user to the approved password reset process."
   • C"No citation returned"

   Blank 2

   • A"The answer directs the user to the approved password reset process."
   • B"How do I reset my password?"
   • C"Microsoft Teams"

   Show answer and explanation

   Correct answers

   • Blank 1: "How do I reset my password?"
   • Blank 2: "The answer directs the user to the approved password reset process."

   Explanation

   Blank 1 should contain the user request that the agent receives. Blank 2 should contain the expected result or answer used to judge whether the agent response is acceptable.

   The incorrect options confuse evaluation input with the expected result, a distribution channel, or a failure reason. Those values might be useful elsewhere, but they do not complete this basic evaluation case correctly.

   References:

   • Test your agent
8. Question 8Describe the business value of Microsoft Power Platform

   Samira, an operations analyst, is sketching a permit management solution that will include a canvas app, a model-driven app, and cloud flows. All components must share record definitions, keep permit status values consistent, and relate applicants, sites, and inspections. Which two Dataverse capabilities provide this value?

   • ATables with typed columns and relationships to model applicants, sites, permits, and inspections.
   • BChoice columns that store approved permit status values for use by apps and cloud flows.
   • CPower Automate desktop recorder steps that save permit rows in a user’s local session.
   • DPower BI workspaces that replace the operational data store for permit transactions.
   • ESharePoint document libraries that store permit files without Dataverse table relationships.

   Show answer and explanation

   Correct answers

   • Tables with typed columns and relationships to model applicants, sites, permits, and inspections.
   • Choice columns that store approved permit status values for use by apps and cloud flows.

   Explanation

   Dataverse organizes business data by using tables with typed columns and relationships, and it can use choice columns to keep approved values consistent across apps and automation.

   • Tables, columns, and relationships model the business entities and how their records connect.
   • Choice columns help makers use a consistent set of permitted values, such as permit statuses.
   • Power Automate desktop flows automate UI actions; they do not define the shared Dataverse data model.
   • Power BI workspaces organize reports and semantic models, not transactional business records for apps and flows.
   • SharePoint document libraries are useful for files and collaboration, but they are not the Dataverse relational data model.

   References:

   • What is Microsoft Dataverse?
   • Create and edit tables using Power Apps
   • Column data types in Microsoft Dataverse
   • About table relationships for Microsoft Dataverse
9. Question 9Describe the business value of Microsoft Power Platform

   A customer-service team needs a Power Platform data store for structured business records. Makers must be able to define tables, columns, relationships, and business rules that are used by apps and flows. Which component should they choose?

   • AMicrosoft Dataverse
   • BMicrosoft Power BI
   • CMicrosoft Power Automate
   • DMicrosoft Power Pages

   Show answer and explanation

   Correct answer

   • Microsoft Dataverse

   Explanation

   Microsoft Dataverse is the Power Platform data platform for structured business data. It lets makers define tables, columns, relationships, and business logic for use across Power Apps, Power Automate, and other Power Platform components.

   • Power BI is for analytics and reporting, not for defining the primary transactional data model for apps and flows.
   • Power Automate is for workflow automation; it can use Dataverse but is not the data store itself.
   • Power Pages is for building external business websites; it can expose Dataverse data but does not replace Dataverse as the data platform.

   References:

   • What is Microsoft Dataverse?
   • Create and edit tables using Power Apps
   • Security concepts in Microsoft Dataverse
10. Question 10Manage the Microsoft Power Platform environment

    Woodgrove Bank's compliance team must determine who shared a canvas app and who modified a cloud flow. The evidence must be searchable with Microsoft 365 compliance audit tooling and retained according to audit retention policies. Which capability should be used?

    • ASearch Microsoft Purview audit logs for Power Apps and Power Automate activities.
    • BReview Power Apps analytics for app launches, active users, and performance trends.
    • CEnable Dataverse auditing on the business tables and review table audit history.
    • DStart Power Apps Monitor for the app and export the trace events from the session.

    Show answer and explanation

    Correct answer

    • Search Microsoft Purview audit logs for Power Apps and Power Automate activities.

    Explanation

    Microsoft Power Platform activities can be audited in Microsoft Purview. Purview audit search is the appropriate capability when compliance staff need searchable activity records for actions such as Power Apps and Power Automate administration or sharing events.

    • Power Apps analytics shows adoption, usage, performance, and errors; it is not a compliance audit log.
    • Dataverse auditing records Dataverse data changes and related audit history, not app-sharing and flow-modification events across Power Platform.
    • Power Apps Monitor captures a live app session for troubleshooting; it is not designed for Microsoft 365 audit retention or legal search.

    References:

    • View Power Apps activity logs in Microsoft Purview
    • View Power Automate activity logs in Microsoft Purview
    • Search the audit log
11. Question 11Manage the Microsoft Power Platform environment

    You are preparing a monthly operations review for one production environment and can use only the built-in analytics pages in the Power Platform admin center. Which two questions can those pages help answer?

    • AWhich apps in the environment have usage, performance, or error trends that require attention.
    • BWhat cloud flow run volumes and failure trends occurred in the environment during the review period.
    • CWhich administrator changed a data loss prevention policy last month for legal discovery.
    • DWhich individual connector call is slow inside a reproduced canvas app session.
    • EWhich Dataverse column values were changed by a specific user on a business record.

    Show answer and explanation

    Correct answers

    • Which apps in the environment have usage, performance, or error trends that require attention.
    • What cloud flow run volumes and failure trends occurred in the environment during the review period.

    Explanation

    The built-in analytics pages in the Power Platform admin center include reporting areas such as Power Apps analytics and Power Automate analytics. These reports can help administrators review usage, performance or errors for apps, and run or failure trends for cloud flows in an environment.

    • DLP policy changes and other compliance activity searches belong in Microsoft Purview audit, not the Power Platform admin center analytics pages.
    • A slow individual connector call inside a reproduced app session is investigated with Power Apps Monitor.
    • Dataverse row-level change history is provided by Dataverse auditing, not the aggregate admin analytics pages.

    References:

    • Administrator analytics and reports for Microsoft Power Apps
    • View analytics for Power Automate cloud flows
    • Live monitor overview
    • Manage Dataverse auditing
12. Question 12Manage the Microsoft Power Platform environment

    Several database developers are reviewing a Power Platform proposal and ask how a Dataverse table differs from a table in a traditional relational database. Which statement is accurate?

    • AA Dataverse table stores rows and columns, and its metadata can also be used by Power Apps for relationships, forms, views, security, and business logic.
    • BA Dataverse table must be created by running T-SQL CREATE TABLE statements from SQL Server Management Studio before apps can use it.
    • CA Dataverse table is an Azure Cosmos DB for NoSQL container that stores only JSON documents and cannot define relationships.
    • DA Dataverse table is accessed by assigning SQL Server logins to db_datareader and db_datawriter roles in the underlying database.

    Show answer and explanation

    Correct answer

    • A Dataverse table stores rows and columns, and its metadata can also be used by Power Apps for relationships, forms, views, security, and business logic.

    Explanation

    Dataverse uses familiar table, row, column, and relationship concepts, but it adds metadata and Power Platform capabilities that apps, security, automation, and solutions can use.

    • Running T-SQL DDL in SQL Server Management Studio is how a SQL Server schema is commonly changed, not how Dataverse schema is created by makers.
    • Treating Dataverse as an Azure Cosmos DB for NoSQL document container confuses Dataverse with a different Azure data service.
    • Assigning SQL Server logins and database roles is a SQL Server access pattern; Dataverse uses Microsoft Entra identity with Dataverse security roles and privileges.

    References:

    • What is Microsoft Dataverse?
    • Create and edit tables using Power Apps
    • Overview of building a model-driven app with Power Apps

Membership includes 236 questions and explanations aligned to the PL-900 curriculum.

Other Microsoft certifications

Every one of these is included with the same membership as PL-900.

AB-900Microsoft

Microsoft 365 Copilot and Agent Administration Fundamentals

This exam is intended for candidates who are familiar with Microsoft 365, including core services, security, identity and access, data…

161 practice questionsView

AI-900Microsoft

Microsoft Azure AI Fundamentals

This exam measures knowledge of machine learning and AI concepts and related Microsoft Azure services. It is intended for candidates…

193 practice questionsView

AZ-900Microsoft

Microsoft Azure Fundamentals

This exam is intended for technology professionals who want to demonstrate foundational knowledge of cloud concepts and Microsoft Azure.…

170 practice questionsView

PL-900 exam FAQ