I85PREP
⌘ K
PL-900 study materials
PL-900 study resources

PL-900 practice questions

One question at a time. Build your PL-900 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Describe the business value of Microsoft Power Platform

A team needs to turn raw sales data from several systems into interactive charts and dashboards. Which Power Platform component is designed for this?

  1. Power Apps
  2. Power BI Correct answer.
  3. Power Pages
  4. Power Automate

Explanation

Power BI is the analytics component of the platform: it connects to data sources, shapes a model, and publishes interactive reports and dashboards. The other components are aimed at app creation, process automation, and external websites.

Question 2Describe the business value of Microsoft Power Platform

Which component is used to create a workflow that sends an approval request when a new item is added to a list?

  1. Power Apps
  2. Power Automate Correct answer.
  3. Copilot Studio
  4. Power BI

Explanation

Power Automate builds flows that start on a trigger such as a new list item and then perform actions including approvals and notifications. Reports, app interfaces, and conversational agents are produced by other components.

Question 3Describe the business value of Microsoft Power Platform

Which component lets a business analyst build a low-code app for capturing field inspection results on a phone?

  1. Power BI
  2. Power Apps Correct answer.
  3. Power Automate
  4. Power Pages

Explanation

Power Apps provides canvas and model-driven designers for creating business apps that run on phones and in browsers. The other components cover analytics, automation, or externally facing websites.

Question 4Describe the business value of Microsoft Power Platform

What is Microsoft Dataverse?

  1. A desktop tool that records automation scripts
  2. A connector library for third-party web services
  3. A cloud service that stores data in tables Correct answer.
  4. A report template used by Power BI dashboards

Explanation

Dataverse is a cloud data service where business data is held in tables with rich column types, relationships, and built-in security. It serves as the shared data layer for apps, flows, and reports.

Question 5Describe the business value of Microsoft Power Platform

What is a primary business benefit of low-code development with Power Platform?

  1. It reduces the amount of hand-written code Correct answer.
  2. It guarantees that no licensing costs will apply
  3. It removes the need for any testing before release
  4. It eliminates the need for data security controls

Explanation

Low-code tools provide visual designers and prebuilt components, so solutions are delivered faster with far less custom code. Testing, security configuration, and licensing remain necessary regardless of the tool.

Question 6Describe the business value of Microsoft Power Platform

A company wants to publish a public-facing website that lets external customers submit requests. Which component is intended for this?

  1. Dataverse
  2. Power Automate
  3. Power Pages Correct answer.
  4. Power BI

Explanation

Power Pages is the component for building secure, externally facing business websites, including forms for anonymous or authenticated visitors. Flows, reports, and the data service serve different purposes.

Question 7Describe the business value of Microsoft Power Platform

Which component is used to build a conversational agent that answers employee questions about HR policy?

  1. Power Automate
  2. Power Apps
  3. Copilot Studio Correct answer.
  4. Power BI

Explanation

Copilot Studio creates conversational agents that answer questions using authored topics and knowledge sources. Analytics, workflow automation, and app user interfaces are handled by the other components.

Question 8Describe the business value of Microsoft Power Platform

What does a connector provide in Power Platform?

  1. A prebuilt way to talk to a service such as SQL Correct answer.
  2. A template that generates data models
  3. A policy that blocks data from leaving the tenant
  4. A license that permits unlimited app usage

Explanation

Connectors wrap the APIs of external services so apps and flows can read and write data without writing integration code. Prebuilt connectors cover common services, and custom connectors cover your own APIs.

Question 9Describe the business value of Microsoft Power Platform

A warehouse team records inspections on paper forms and rekeys the data later. Which approach best modernizes this process?

  1. A desktop flow that prints the paper forms in bulk
  2. A Power Pages site used by internal staff on tablets
  3. A Power Apps app saving to Dataverse plus a flow Correct answer.
  4. A Power BI dashboard refreshed from the paper forms

Explanation

Capturing inspections in an app removes rekeying, Dataverse stores the records with security and relationships, and a flow can route results or raise alerts. Reporting alone leaves the manual data entry untouched.

Question 10Describe the business value of Microsoft Power Platform

An accounts team receives thousands of PDF invoices and wants the key fields read automatically. Which capability fits best?

  1. Power Apps component libraries
  2. Power BI row-level security
  3. AI Builder document processing Correct answer.
  4. Dataverse security roles

Explanation

AI Builder includes prebuilt document processing models that extract fields such as totals and dates from invoices and can be called from a flow. The other options are security or user-interface development features.

Question 11Describe the business value of Microsoft Power Platform

A legacy line-of-business system has no API and can only be operated through its Windows client. How can Power Automate interact with it?

  1. By using a custom connector for the system
  2. By using Dataverse virtual tables
  3. By using a Power BI data gateway
  4. By using a desktop flow that runs the UI Correct answer.

Explanation

Desktop flows record and replay interactions with an application's user interface, which is the supported path when no API exists. A custom connector requires an API to wrap, and gateways only move data.

Question 12Describe the business value of Microsoft Power Platform

A manager wants executives to see one always-current view of key metrics without opening several spreadsheets. What should be created and shared?

  1. A desktop flow with scheduled runs
  2. A canvas app with a gallery of records
  3. A model-driven app with a form
  4. A Power BI report and semantic model Correct answer.

Explanation

A Power BI report built on a semantic model gives consumers a single governed, refreshable view of KPIs. Apps and forms are for transactions, and flows execute processes rather than present analytics.

Question 13Describe the business value of Microsoft Power Platform

A company built an internal REST API and needs to call it from both apps and flows. What should they create?

  1. A data gateway
  2. A custom connector Correct answer.
  3. A managed solution
  4. A business unit

Explanation

Custom connectors describe a REST API's endpoints and authentication so it behaves like any built-in connector in apps and flows. Gateways, business units, and solutions serve connectivity, organizational structure, and deployment purposes.

Question 14Describe the business value of Microsoft Power Platform

A maker finished an app and several flows in a development environment and must move them to production together. What should be used?

  1. A shared mailbox as the transport
  2. A data loss prevention policy
  3. A solution exported and imported Correct answer.
  4. A Power BI deployment pipeline

Explanation

Solutions bundle apps, flows, tables, and related components into one deployable unit that can be exported from development and imported into production. DLP policies and mailboxes govern usage and messaging, not component transport.

Question 15Describe the business value of Microsoft Power Platform

What is the purpose of environments in Power Platform?

  1. They remove the need for user licensing
  2. They separate apps and data for different groups Correct answer.
  3. They store audit logs for compliance
  4. They define which connectors are allowed

Explanation

Environments are containers that isolate apps, flows, and Dataverse data, commonly split by workload or by stage such as development and production. Connector restrictions come from DLP policies, and licensing is unaffected.

Question 16Describe the business value of Microsoft Power Platform

What does a data loss prevention policy control in Power Platform?

  1. How often Dataverse data is backed up
  2. Which users may create new environments
  3. Which connectors can be combined in apps and flows Correct answer.
  4. Which reports can be shared outside the tenant

Explanation

A DLP policy assigns connectors to business, non-business, or blocked groups and prevents mixing connectors from different groups in one app or flow. Backups, environment creation, and report sharing are governed by other settings.

Question 17Describe the business value of Microsoft Power Platform

A team already works in Microsoft Teams and wants approvals handled where they already collaborate. What is the most appropriate approach?

  1. Email the app package to each user
  2. Export the solution as a managed zip file
  3. Build a separate external website
  4. Publish the app and flow into Teams Correct answer.

Explanation

Power Apps and Power Automate integrate with Teams, so apps can be added as tabs and flows can post messages and approval requests in the channel. Distributing packages or zip files does not give users a working solution.

Question 18Describe the business value of Microsoft Power Platform

An organization needs to inventory its apps, see which connectors are used, and govern maker activity at scale. What is designed for this?

  1. The Center of Excellence toolkit Correct answer.
  2. The Power BI usage metrics report
  3. The Microsoft 365 admin center
  4. One managed solution per maker

Explanation

The CoE toolkit provides apps and dashboards that inventory environments, apps, flows, and connectors, and supports governance of adoption at scale. Usage metrics and general admin portals cover much narrower scopes.

Question 19Describe the business value of Microsoft Power Platform

A team needs a complex, process-driven app over Dataverse data where forms and views come from the data model. Which app type fits best?

  1. A Power BI paginated report
  2. A canvas app with a blank screen
  3. A model-driven app Correct answer.
  4. A Power Pages site with anonymous access

Explanation

Model-driven apps generate the interface from the Dataverse data model and include forms, views, and business process flows suited to complex data-centric processes. Canvas apps are laid out pixel by pixel by the maker.

Question 20Describe the business value of Microsoft Power Platform

A support team wants customers to self-serve answers and be handed to a human when the agent is unsure. Which capability addresses this?

  1. A Dataverse table with views
  2. A Power BI dashboard with filters
  3. A Copilot Studio agent with handoff Correct answer.
  4. A Power Automate scheduled flow

Explanation

Copilot Studio agents handle conversational self-service and can transfer a conversation to a live representative when they cannot resolve the request. Dashboards, scheduled flows, and tables do not converse with customers.

Question 21Describe the business value of Microsoft Power Platform

A process touches a modern cloud service with an API and a decade-old ERP client with no API. Which design is most appropriate?

  1. A cloud flow plus a desktop flow for the ERP Correct answer.
  2. Two desktop flows, one for each of the two systems
  3. One Power BI dataflow that reads both systems
  4. A cloud flow that uses a data gateway for both

Explanation

Cloud flows call APIs directly and are more reliable and easier to maintain, while desktop flows are the fallback for applications that expose only a user interface. Using RPA against the API-enabled service adds unnecessary fragility.

Question 22Describe the business value of Microsoft Power Platform

Why are managed solutions preferred for production while unmanaged solutions are used during development?

  1. Managed solutions carry data rows with the schema
  2. Managed solutions can be edited after import
  3. Managed solutions need no target environment
  4. Managed solutions are locked and upgrade cleanly Correct answer.

Explanation

Managed solutions are read-only in the target environment, so changes ship as new versions layered over the existing one, which keeps production predictable. Unmanaged solutions stay editable and are intended for active development.

Question 23Describe the business value of Microsoft Power Platform

A DLP policy places SharePoint in the Business group and a personal social connector in the Non-business group. What happens to a flow that uses both connectors?

  1. The flow runs only for tenant administrators
  2. The flow runs after the maker asks for an exception
  3. The flow runs but logs a warning for the maker
  4. The flow is blocked because groups cannot mix Correct answer.

Explanation

Connectors classified as business and non-business cannot be combined in the same app or flow, so the flow is blocked at save or run time. Exceptions are handled by adjusting the policy, not by per-flow runtime requests.

Question 24Describe the business value of Microsoft Power Platform

An organization must let anonymous external users submit grant applications and later check status with an account. Which choice best fits?

  1. A model-driven app with a public web client
  2. A canvas app shared with the public internet
  3. A Power Pages site with a Dataverse backend Correct answer.
  4. A Power BI report published to the web

Explanation

Power Pages supports external-facing sites with both anonymous and authenticated experiences, storing submissions in Dataverse. Canvas and model-driven apps require authenticated licensed users, and publishing reports only displays data.

Question 25Describe the business value of Microsoft Power Platform

A maker stores project data in SharePoint lists but now needs relational tables, row-level security roles, and business rules shared by apps, flows, and reports. What should be recommended?

  1. Move the data to Dataverse tables Correct answer.
  2. Export the lists to CSV files nightly
  3. Add more columns to the SharePoint lists
  4. Create one list per department

Explanation

Dataverse provides relational tables, security roles at row and column level, and business rules that every Power Platform component can share. SharePoint lists lack these relational and granular security capabilities.

Question 26Describe the business value of Microsoft Power Platform

Business users want to type a question such as 'sales by region last quarter' and receive a visual answer in Power BI. Which feature provides this?

  1. Power BI Q&A Correct answer.
  2. Scorecards
  3. Dataflows
  4. Paginated reports

Explanation

Power BI Q&A lets users ask questions in natural language and returns visual results, making analytics accessible without report authoring. It interprets the question against the dataset and chooses an appropriate visualization.

Question 27Describe the business value of Microsoft Power Platform

A flow must run every weekday at 7:00 AM to email a status report. Which type of cloud flow should be created?

  1. Scheduled cloud flow Correct answer.
  2. Instant cloud flow
  3. Desktop flow
  4. Automated cloud flow

Explanation

Scheduled cloud flows run on a recurrence you define, such as every weekday at a set time. They are the correct choice when the trigger is a timetable rather than an event or a manual action.

Question 28Describe the business value of Microsoft Power Platform

Which language is used to write formulas and expressions in canvas apps?

  1. M language
  2. JavaScript
  3. Power Fx Correct answer.
  4. DAX

Explanation

Power Fx is the Excel-like formula language used across Power Apps, including canvas apps. It is designed to be approachable for business users while supporting complex logic.

Question 29Describe the business value of Microsoft Power Platform

A customer service team wants to automatically classify survey comments as positive, negative, or neutral. Which AI Builder model type fits this requirement?

  1. Prediction for numerical outcomes
  2. Object detection for images
  3. Sentiment analysis Correct answer.
  4. Form processing for documents

Explanation

Sentiment analysis is a prebuilt AI Builder model that scores text as positive, negative, or neutral. It is suited to classifying free-text comments at scale.

Question 30Describe the business value of Microsoft Power Platform

An organization wants makers to promote solutions from development to test to production with automated checks and minimal manual steps. Which capability should they use?

  1. Power Platform pipelines Correct answer.
  2. Environments
  3. Data loss prevention policies
  4. Solutions

Explanation

Power Platform pipelines automate the deployment of solutions across environments, including pre-deployment checks and approvals. They reduce manual export and import steps.

Question 31Describe the business value of Microsoft Power Platform

A department wants to build apps and flows inside Microsoft Teams and store data in a Teams-owned relational datastore with minimal setup. Which option should they use?

  1. AI Builder
  2. Dataverse for Teams Correct answer.
  3. Power BI Premium capacity
  4. Power Pages

Explanation

Dataverse for Teams provides a Teams-native environment for building apps, flows, and chatbots with a relational datastore, without standing up a full Dataverse environment. It is designed for departmental scenarios inside Teams.

Question 32Describe the business value of Microsoft Power Platform

A department needs a simple equipment inspection app for phones, and the maker wants to arrange screens by dragging controls onto a canvas. Which Power Apps app type is most appropriate?

  1. Power Pages site
  2. Copilot Studio agent
  3. Model-driven app
  4. Canvas app Correct answer.

Explanation

Canvas apps give makers a blank canvas and full control over layout by dragging controls onto screens. They are well suited to task-specific mobile scenarios such as equipment inspections.

Question 33Describe the business value of Microsoft Power Platform

A subscription business wants to identify customers who are likely to cancel so the team can intervene. Which AI Builder model type should they use?

  1. Sentiment analysis
  2. Form processing
  3. Key phrase extraction
  4. Prediction Correct answer.

Explanation

AI Builder prediction models use historical data to forecast outcomes such as churn likelihood. The business can then target retention efforts at high-risk customers.

Question 34Describe the business value of Microsoft Power Platform

A software company wants to show interactive Power BI reports inside its own customer-facing web application without requiring customers to sign in to Power BI. Which capability fits?

  1. Power BI dataflows
  2. Power BI Embedded Correct answer.
  3. Power BI Q&A
  4. Power BI Desktop

Explanation

Power BI Embedded lets developers embed reports and dashboards in applications using APIs and capacity, so end users do not need Power BI accounts. It is intended for application-integrated analytics.

Question 35Describe the business value of Microsoft Power Platform

Which statement best describes the business value of a fusion team on a Power Platform project?

  1. It pairs business experts with professional developers to deliver faster. Correct answer.
  2. It restricts app building to full-time professional developers and excludes business users.
  3. It removes the need for governance, security review, and testing of the finished solution.
  4. It outsources all solution design and delivery to a single external vendor selected by IT.

Explanation

A fusion team pairs business subject-matter experts with professional developers and IT so that domain knowledge and technical skill are applied together. This typically shortens delivery time and improves fit to the business need.

Question 36Describe the business value of Microsoft Power Platform

Which outcome is the main business benefit of low-code development with Power Platform?

  1. It removes the need for any testing or quality checks before a solution is released to users.
  2. It requires every business user to learn a compiled programming language before building apps.
  3. It lets people close to the problem build solutions with less code. Correct answer.
  4. It guarantees that security risks and compliance issues no longer exist in business solutions.

Explanation

Low-code development provides visual designers and prebuilt connectors so business users can assemble solutions with less custom code. This can shorten delivery time and free professional developers for complex work.

Question 37Describe the business value of Microsoft Power Platform

Where does an administrator create environments and review capacity usage for Power Platform?

  1. Power Platform admin center Correct answer.
  2. Copilot Studio authoring canvas
  3. Power BI service workspace settings page
  4. Power Apps maker portal for each individual app

Explanation

The Power Platform admin center is the web portal where administrators manage environments, view capacity, and configure tenant-wide settings. It is the central place for administrative tasks rather than app authoring.

Question 38Describe the business value of Microsoft Power Platform

A company has 20 professional developers who build many apps and flows, and 1,000 workers who use one canvas app each. Which licensing approach is most appropriate?

  1. Power Apps per app licenses for every developer and every worker across the company.
  2. Microsoft 365 Business Premium licenses for all developers and all workers in the company.
  3. Free Power Automate licenses for every developer and every worker in the organization.
  4. Power Apps per user for the developers and Power Apps per app for the workers. Correct answer.

Explanation

Per-user licenses suit makers who need to build and use many apps and flows, while per-app licenses cover users who need only one app at lower cost. Matching the license to usage avoids paying for unused capacity.

Question 39Describe the business value of Microsoft Power Platform

An organization wants to reduce unsanctioned app building while still letting business units create solutions. Which approach best balances control and enablement?

  1. Require every app and flow to be built by the central IT department before any business unit can use it.
  2. Allow every connector with no restrictions so that makers are never blocked by governance controls.
  3. Block all Power Platform use for business units until the central IT team approves each individual request.
  4. Provide governed self-service with environments, DLP policies, and maker training. Correct answer.

Explanation

Governed self-service gives business units the ability to build while central IT sets guardrails such as environment strategy, DLP policies, and training. This reduces unsanctioned tools without blocking innovation.

Question 40Describe the business value of Microsoft Power Platform

Which statement best explains why Power Platform is considered a platform rather than a single product?

  1. It only builds mobile applications for field workers and nothing else.
  2. It requires custom code for every solution that an organization creates and deploys.
  3. It replaces Microsoft 365 with a completely separate productivity suite for every user.
  4. It combines apps, automation, analytics, agents, and shared data services. Correct answer.

Explanation

Power Platform is a platform because its components share connectors, Dataverse, identity, and governance, so solutions can combine apps, automation, analytics, and agents. The value comes from composing these services rather than from one standalone product.

Question 41Manage the Microsoft Power Platform environment

A team needs an isolated workspace to build and test a model-driven app before it is released to business users. Which environment type should the team use?

  1. Sandbox Correct answer.
  2. Production
  3. Default
  4. Trial (30-day)

Explanation

Sandbox environments are non-production environments used for development, testing, and staged deployments, so unfinished work does not affect live business data. Default and production environments hold live solutions and data and are not the place for pre-release testing.

Question 42Manage the Microsoft Power Platform environment

Which statement about the default environment in a Power Platform tenant is correct?

  1. It is provisioned automatically and cannot be deleted. Correct answer.
  2. It can be deleted after another environment is promoted.
  3. It is removed automatically after ninety days of inactivity.
  4. It must be deleted before a production environment is created.

Explanation

Every tenant receives one default environment that is created automatically, and the platform does not allow it to be deleted. Administrators can rename or restrict it, but it always remains present.

Question 43Manage the Microsoft Power Platform environment

How does Microsoft Dataverse control which records a user can read, create, and delete?

  1. Through the app's screen-level visibility rules only.
  2. Through the environment's region and language settings.
  3. Through security roles assigned to users or teams. Correct answer.
  4. Through the license assigned to the user in Microsoft 365.

Explanation

Access to Dataverse tables and records is granted through security roles, which define privileges at the create, read, update, delete, and append levels and are scoped by business unit. Users gain privileges through roles assigned directly to them or to the teams they belong to.

Question 44Manage the Microsoft Power Platform environment

An administrator must create a new environment, review tenant capacity, and manage data policies across the organization. Which portal provides these capabilities?

  1. The Azure portal
  2. The Power Apps maker portal
  3. The Microsoft 365 admin center for the tenant
  4. The Power Platform admin center Correct answer.

Explanation

The Power Platform admin center is the central administrative surface for creating and managing environments, monitoring capacity consumption, and configuring tenant and environment data policies. The maker portal is for building apps, not for tenant-wide governance.

Question 45Manage the Microsoft Power Platform environment

Which item is used to package apps, flows, tables, and other components so they can be transported between environments?

  1. A publisher
  2. A connection
  3. An environment
  4. A solution Correct answer.

Explanation

A solution is the container that holds Power Platform components so they can be exported from one environment and imported into another as a unit. This is the basis of application lifecycle management across development, test, and production.

Question 46Manage the Microsoft Power Platform environment

How does a managed solution differ from an unmanaged solution once it is imported into a production environment?

  1. A managed solution can be edited freely by any maker.
  2. A managed solution cannot be edited directly by makers. Correct answer.
  3. A managed solution is stored only in the default environment.
  4. A managed solution has no publisher and no version number.

Explanation

Managed solutions are locked after import, so makers cannot change their components directly in the target environment; changes must be made in the source and shipped as a new version. Unmanaged solutions remain fully editable, which is why they are used only in development environments.

Question 47Manage the Microsoft Power Platform environment

Which description best matches Microsoft Dataverse?

  1. A visualization layer that renders charts and dashboards on top of data.
  2. A file share used to store exported reports.
  3. A message queue that carries integration events.
  4. A cloud data service that stores business data in tables. Correct answer.

Explanation

Dataverse is a cloud-based data service that stores business data in tables with rich metadata, relationships, and built-in security. It is the standard data platform for model-driven apps and many Power Platform components.

Question 48Manage the Microsoft Power Platform environment

When you create a publisher for your solutions, what is the purpose of the customization prefix?

  1. It controls which users can import the solution.
  2. It makes component names unique across solutions. Correct answer.
  3. It sets the geographic region where the environment is hosted.
  4. It defines the license tier needed to use the app.

Explanation

The prefix chosen for a publisher is prepended to the schema names of components you create, which keeps names unique and identifies which publisher owns them. This reduces conflicts when solutions from different sources are installed together.

Question 49Manage the Microsoft Power Platform environment

How are business units used in a Dataverse environment?

  1. They group users and define a boundary for record ownership. Correct answer.
  2. They control which connectors a maker is allowed to use in a cloud flow.
  3. They set the currency and language of the organization.
  4. They group apps into a single solution for deployment.

Explanation

Business units partition users into groups and act as a security boundary that determines which records a user can reach when a role grants business-unit-level access. They also form the hierarchy used to model the organization's reporting structure.

Question 50Manage the Microsoft Power Platform environment

What is the primary purpose of a data loss prevention (DLP) policy in Power Platform?

  1. It limits how many flows each user can create per day.
  2. It backs up environment data to a secondary region nightly.
  3. It encrypts Dataverse data at rest within the environment's hosting region.
  4. It groups connectors and prevents mixing business with non-business ones. Correct answer.

Explanation

A DLP policy classifies connectors into business, non-business, and blocked groups so that data cannot move between connectors from different groups in the same app or flow. Administrators use it to control which services makers can combine and which are prohibited entirely.