Microsoft · Free Practice Questions · Last reviewed May 2026
30real exam-style questions organised by domain, each with the correct answer highlighted and a plain-English explanation of why it's right — and why the others are wrong.
23% of exam · 6 sample questions below
A company wants to automate sending a welcome email to new employees after they are added to a SharePoint list. Which type of trigger should be used in the Power Automate flow?
For a selected item - SharePoint
Recurrence
Start and wait for an approval
When an item is created - SharePoint
Correct. This trigger initiates the flow when a new item is added to the list.
You have a Power Automate flow that sends an email notification when a new file is added to a SharePoint document library. Users report that emails are not being sent for some files. What is the most likely cause?
The flow uses a premium connector that requires a license
The file is being co-authored by multiple users
A trigger condition is filtering out some files
Correct. Trigger conditions may exclude files based on metadata.
The file content contains sensitive information
You are designing a Power Automate flow to approve expense reports. The flow must allow managers to approve or reject directly from the email notification without signing in. Which action should you use?
Create a file
Send an email (V2)
Start and wait for an approval
Correct. This creates an approval request that can be acted upon from email.
Send an HTTP request
A flow fails with the error: 'GatewayTimeout'. The flow connects to an on-premises SQL Server via a data gateway. What is the most likely cause?
The SQL login credentials are incorrect
The on-premises data gateway is not running or unreachable
Correct. Gateway timeout typically indicates connectivity issues to the on-premises resource.
The SQL table does not exist
The flow trigger did not fire
You need to design a Power Automate flow that processes orders from a CSV file in SharePoint. The flow should read each row and create a record in a SQL database. If a row contains invalid data, the flow should continue with the next row. Which configuration should you use?
Use parallel branches for each row
Use an apply to each loop with default settings
Use an apply to each loop and configure 'Configure run after' for the SQL insert action to include 'is successful', 'has timed out', 'is skipped', 'has failed'
Correct. This allows the loop to continue even after a failed insert.
Use a scope with sequential actions and set 'Configure run after' to 'is successful' only
Which TWO components are required to create a Power Automate flow that sends an email when a new item is added to a SharePoint list? (Choose two.)
A trigger
Correct. Every flow needs a trigger.
An approval action
A variable
A condition
A Send an email action
Correct. This sends the email notification.
Want more Demonstrate the capabilities of Power Automate practice?
Practice this domain8% of exam · 6 sample questions below
A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?
Power BI
Power Apps
Power Virtual Agents
Power Automate
Power Automate enables workflow automation, including sending follow-up emails based on triggers like new customer interactions.
A logistics company uses Power Apps to build a fleet management app. They need to integrate real-time GPS data from IoT devices. Which connector should they use?
SharePoint connector
IoT connector
Enables integration with IoT devices and telemetry data.
Dynamics 365 connector
Office 365 Users connector
A hospital uses Power BI to monitor patient wait times. The data source is an on-premises SQL Server database. To ensure real-time reporting, what should the hospital deploy?
Azure Data Factory
Power BI Report Server
On-premises data gateway
Enables secure data transfer between on-premises data sources and Power BI for live dashboards.
Power BI Desktop
A non-profit organization wants to automate donation receipt emails and track donor engagement. Which Microsoft Power Platform tool should they use?
Power Automate
Power Automate can automate sending donation receipts and update donor records.
Power Virtual Agents
Power BI
Power Apps
A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?
The app has too many controls per screen
The app uses a non-delegable query on a large data source
Non-delegable queries retrieve all data before filtering, causing slow performance.
The app uses too many screens
The app has complex formulas in OnStart
Which TWO are benefits of using Microsoft Power Platform for business process automation?
Reduces need for custom coding
Low-code tools allow business users to create solutions without extensive coding.
Integrates seamlessly with Microsoft 365 and Dynamics 365
Native connectors enable easy integration with Microsoft ecosystem.
Requires dedicated IT team for every automation
Only works on-premises
Requires deep knowledge of programming languages
Want more Describe the business value of Microsoft Power Platform practice?
Practice this domain23% of exam · 6 sample questions below
You are the Power Platform administrator for your organization. A user reports that they cannot create a new environment. What is the most likely cause?
The environment creation feature is disabled in the tenant settings.
The user is trying to create a production environment without a valid default environment.
The tenant has reached its maximum number of environments.
The user does not have the appropriate license or role to create environments.
Users need the Power Platform admin role or appropriate license to create environments.
Your organization has a Power Platform environment that contains several canvas apps and flows. You need to ensure that only users from your Microsoft Entra ID tenant can access the environment. What should you configure?
Assign a security group to the environment in the Power Platform admin center.
Security group assignment restricts environment access to group members.
Change the environment URL to include the tenant name.
Modify the tenant-level environment creation settings.
Configure a data loss prevention (DLP) policy for the environment.
Your organization uses Power Platform environments for development, test, and production. A developer accidentally deleted a managed solution from the production environment. You need to restore the solution without affecting other components. What should you do?
Reimport the solution from the source-controlled repository using Azure DevOps.
Use the Power Platform admin center to recover the solution from the recycle bin.
Restore the environment from a backup taken before the deletion.
Environment restore brings back the entire environment to a previous state.
Reimport the managed solution from a backup file.
You are a Power Platform administrator. A user reports that they are unable to share a canvas app with external users. What is the most likely cause?
The environment is not enabled for external sharing.
External sharing must be enabled in the environment settings.
The environment is a sandbox environment, which does not support external sharing.
The environment has a data loss prevention (DLP) policy that blocks sharing.
External users must have a Power Apps license to access the app.
Your organization uses Power Automate to automate business processes. A flow that runs daily fails intermittently with 'HTTP 429 - Too Many Requests' errors. What should you do to resolve this issue?
Increase the frequency of the flow to run more often.
Change the flow trigger from a schedule to an instant trigger.
Set up an on-premises data gateway to bypass the throttling limits.
Configure retry policies with exponential backoff in the flow actions.
Retry policies with backoff help manage throttling by spacing out retries.
Your organization has a Power Apps portal that allows external users to submit support tickets. You need to ensure that only authenticated external users from specific domains can access the portal. What should you configure?
Create a data loss prevention (DLP) policy that blocks external users.
Restrict access to the portal by IP address using a web application firewall.
Share the portal URL only with users from the allowed domains.
Configure the portal to use Microsoft Entra ID authentication and set up domain restrictions.
Microsoft Entra ID allows domain-based access restrictions.
Want more Manage the Microsoft Power Platform environment practice?
Practice this domain23% of exam · 6 sample questions below
A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?
Portal
Model-driven app
Canvas app
Canvas apps can be built to work offline with the Power Apps mobile player.
Power Automate
A healthcare organization needs a Power Apps app to track patient visit data. The data must be stored in Microsoft Dataverse, and the app should automatically generate a timeline of visits for each patient. Which app type is most suitable?
Portal
Model-driven app
Model-driven apps provide built-in timeline and Dataverse integration.
Power Automate
Canvas app
A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?
The connection reference is not shared with the users.
The SharePoint list has exceeded its item limit.
The users lack write permissions on the SharePoint list.
Power Apps uses the user's credentials to access SharePoint; they need write permission on the list.
The app is shared with 'Can edit' permission but not 'Can view'.
A company wants to build a Power Apps app that uses a SQL Server database as its data source and requires complex business logic validation before saving data. Which type of app should they use?
Model-driven app
Canvas app
Canvas apps allow complex formulas and custom validation.
Power Automate
Portal
A company has a model-driven app with a custom table 'Issue' that has a choice column 'Status' with values: New, In Progress, Resolved, Closed. The app uses a business rule to set 'Resolved By' (lookup to User) when status changes to Resolved. Users report that the 'Resolved By' field is not being populated. What is the most likely cause?
The 'Resolved By' lookup column is not added to the form.
The 'Resolved By' column is required and users don't fill it.
The business rule is scoped to the form but the status change happens via a quick create form.
Business rules only apply to the form they are scoped to.
The business rule is deactivated.
A company is planning to build a Power Apps app for field service technicians to view and update work orders. The app must work offline and sync data when connected. Which TWO components are required to achieve offline capability?
Power Automate flow triggered on data change
Offline profile in Microsoft Dataverse
An offline profile defines which tables and data are available offline.
SharePoint list as data source
Power Apps mobile player
The mobile player enables offline app usage.
Common Data Service (Dataverse) database
Want more Demonstrate the capabilities of Power Apps practice?
Practice this domain23% of exam · 6 sample questions below
A company wants to create a custom copilot that answers employee questions about IT policies. The copilot must use existing SharePoint documents as a knowledge source. Which feature of Microsoft Copilot Studio should the company use?
Generative AI feature
Power Automate cloud flow
Copilot for Microsoft 365
Add a knowledge source
Copilot Studio allows adding SharePoint as a knowledge source to ground responses.
A company has deployed a custom copilot built with Microsoft Copilot Studio. Users report that the copilot sometimes provides outdated information. The knowledge sources are SharePoint sites and public websites. The copilot uses Generative AI to formulate answers. What should the administrator do to improve the accuracy of the copilot's responses?
Enable the 'Show citations' option
Reduce the number of topics
Refresh the knowledge sources periodically
Refreshing knowledge sources ensures the copilot uses current data.
Turn off Generative AI for responses
A company is using Microsoft Copilot Studio to build a copilot for employee onboarding. The copilot must authenticate users to provide personalized information. The company uses Azure AD (now Microsoft Entra ID) for identity management. Which authentication method should the administrator configure in Copilot Studio?
Anonymous access
Manual authentication
Microsoft Entra ID (Azure AD) authentication
Microsoft Entra ID provides SSO and user identity for personalization.
SharePoint authentication
A company wants to extend their existing copilot built with Copilot Studio to trigger a workflow when an employee requests time off. The workflow must create a record in a Dataverse table and send an approval email. What should the copilot developer use?
Embed a Power Apps canvas app
Use AI Builder to create a model
Configure the Dataverse connector directly
Add a Power Automate flow as a plugin
Power Automate flows can be called from Copilot Studio to automate workflows.
A company is designing a copilot using Microsoft Copilot Studio. The copilot must handle sensitive employee data. Which TWO actions should the administrator take to ensure data security and compliance?
Enable anonymous access to allow external users
Configure data loss prevention (DLP) policies to restrict data movement
DLP policies help secure sensitive data.
Disable authentication to simplify access
Enable the 'Data for training' option to be turned off
Turning off data for training ensures organizational data isn't used for model improvement.
Add public websites as knowledge sources
A company has configured the copilot as shown in the exhibit. Users report that the copilot is not answering questions about HR policies that were updated in the SharePoint site today. What is the most likely cause?
The public website refresh is set to daily
Authentication is not properly configured
The knowledge source refresh interval is set to weekly
Weekly refresh means changes today aren't reflected.
Generative AI is disabled
Want more Demonstrate the capabilities of Microsoft Copilot Studio practice?
Practice this domainThe PL-900 exam has 50 questions and must be completed in 60 minutes. The passing score is 700/1000.
Business and platform scenario questions covering Power Apps, Power Automate, Power BI, Power Virtual Agents, Dataverse, connectors, governance, and security.
The exam covers 5 domains: Demonstrate the capabilities of Power Automate, Describe the business value of Microsoft Power Platform, Manage the Microsoft Power Platform environment, Demonstrate the capabilities of Power Apps, Demonstrate the capabilities of Microsoft Copilot Studio. Questions are weighted by domain — higher-weight domains appear more on your actual exam.
No. These are original exam-style practice questions written against the official Microsoft PL-900 exam objectives. They are not copied from the real exam. Courseiva focuses on genuine understanding, not memorisation of braindumps.
Courseiva tracks your accuracy per domain and routes you toward weak areas automatically. Free, no account required.