Microsoft Certified: Power Platform App Maker Associate (PL-100) — Questions and Answers

Question 1: In Power Platform ALM, what is the recommended environment strategy for a production deployment pipeline?

Development → Test/UAT → Production environments (Correct answer)
Single shared environment for all stages
Sandbox → Integration → QA
Production → Development → Staging

Correct answer: Development → Test/UAT → Production environments

Microsoft recommends a minimum of three environments: Development for building, Test/UAT for validation, and Production for live use.

Question 2: In a Model-Driven app, which setting on a lookup column allows users to create a new related record inline without navigating away?

New Record Shortcut
Inline Create
Allow Quick Create (Correct answer)
Popup Create

Correct answer: Allow Quick Create

Enabling 'Allow Quick Create' on a lookup causes a Quick Create Form to open when users click 'New' in the lookup dialog.

Question 3: What is the difference between a Power BI 'report' and a Power BI 'dashboard'?

A report uses live data; a dashboard uses cached data only
A report has multiple pages with detailed visuals from one dataset; a dashboard is a single page of pinned tiles from multiple reports (Correct answer)
A report is shared with specific users; a dashboard is public
A report is created in Power BI Desktop; a dashboard is created in Excel

Correct answer: A report has multiple pages with detailed visuals from one dataset; a dashboard is a single page of pinned tiles from multiple reports

Reports provide detailed multi-page analysis tied to a single dataset, while dashboards consolidate key visuals (pinned tiles) from multiple reports into a single monitoring view.

Question 4: What is the key difference between a Managed and Unmanaged Solution in Power Platform?

Managed solutions cost more to deploy
Unmanaged solutions can only be used in development environments
Managed solutions lock components in the target environment; unmanaged solutions allow full customization (Correct answer)
Managed solutions auto-update from the publisher

Correct answer: Managed solutions lock components in the target environment; unmanaged solutions allow full customization

Importing a Managed Solution restricts editing its components in the target environment, while Unmanaged Solutions allow modification.

Question 5: In Power Apps, what does the 'Patch()' function do?

Deletes a record from a data source
Creates or modifies a record in a data source (Correct answer)
Refreshes a connected data source
Retrieves a single record by ID

Correct answer: Creates or modifies a record in a data source

Patch() either updates an existing record or creates a new one in the specified data source, depending on whether a matching record is found.

Question 6: A business has a program that offers API access. Using a unique connector, you want to use a canvas app to access the API. For the purpose of building a custom connector, you must ask the API developers for details. What are the two acceptable file types?

Postman collection (Correct answer)
OpenAPI definition (Correct answer)
YAML
WSDL

Correct answer: Postman collection

You can use either a Postman collection or an OpenAPI definition to communicate with the API developers when building a custom connector to connect to an API from a canvas app. Both alternatives are excellent tools for creating the custom connector, but they both offer a unique set of data in a different format. Depending on the relevant objectives and available resources, both Postman collections and OpenAPI specifications have advantages. It can be simple to import sample requests and test the API if you have a Postman collection on hand. A more structured and standardized approach to establishing the API is provided by an OpenAPI definition, though, which enables greater documentation and the automatic creation of unique connector components.

Question 7: In a Power Apps canvas app, which property of a Gallery control do you set to bind it to a data source?

DataSource
Records
Source
Items (Correct answer)

Correct answer: Items

The Items property of a Gallery control accepts a table, collection, or data source expression to populate the gallery.

Question 8: In Power Apps, what is a 'collection'?

A type of gallery control
A local in-memory table stored within the app (Correct answer)
A reusable component stored in the cloud
A SharePoint list connected to the app

Correct answer: A local in-memory table stored within the app

A collection is a temporary in-memory table created and manipulated with functions like Collect(), ClearCollect(), and Remove() within the app.

Question 9: What is the maximum number of rows that Power Apps retrieves by default when querying a non-delegable data source?

1000
100
2000
500 (Correct answer)

Correct answer: 500

By default, Power Apps retrieves up to 500 rows for non-delegable queries, though this can be increased to 2000 in app settings.

Question 10: What happens to all apps, flows, and data when a Power Platform environment is deleted?

They are automatically migrated to the default environment
They are exported to OneDrive for 30 days for recovery
They become read-only for 30 days before permanent deletion
They are permanently deleted along with all environment data (Correct answer)

Correct answer: They are permanently deleted along with all environment data

Deleting a Power Platform environment permanently and irreversibly removes all apps, flows, connections, and data contained within it.

Question 11: What is the purpose of a 'Virtual Table' in Dataverse?

Store temporary session data
Create a read-only copy of a table
Cache large datasets locally
Expose external data as if it were a native Dataverse table without storing it in Dataverse (Correct answer)

Correct answer: Expose external data as if it were a native Dataverse table without storing it in Dataverse

Virtual Tables use a data provider to proxy external data sources so apps can query them like regular Dataverse tables.

Question 12: In Power Platform, what is a 'Managed Environment'?

A premium environment tier with enhanced governance, monitoring, and admin controls (Correct answer)
An environment locked from all customizations
A production-only environment with no maker access
An environment managed by Microsoft Support

Correct answer: A premium environment tier with enhanced governance, monitoring, and admin controls

Managed Environments unlock premium governance features such as usage analytics, solution checker enforcement, and sharing limits.

Question 13: In a Power Automate cloud flow, what does the 'Apply to each' action do?

Runs parallel branches simultaneously
Applies a condition to filter array items
Sends the same email to each user in a list
Iterates over each item in an array and runs enclosed actions for every item (Correct answer)

Correct answer: Iterates over each item in an array and runs enclosed actions for every item

'Apply to each' loops through an array, executing the nested actions once for every element in the array.

Question 14: Which Dataverse column data type should you use to store a monetary value that automatically handles currency conversion?

Currency (Correct answer)
Decimal Number
Float
Whole Number

Correct answer: Currency

The Currency data type stores monetary values and links to the currency table for conversion rate support.

Question 15: For personal productivity, users of a corporation use Flow. Users frequently replace their functioning flows by modifying the definitions, and once a flow has been saved, changes cannot be undone. It must be possible for users to return a flow to its original condition. What are the possible two options?

Share
Export (Correct answer)
Save As (Correct answer)
Rename

Correct answer: Export

You can use Microsoft Power Automate's Export and Save As options to make sure users can restore a flow to its original condition after making modifications (formerly known as Flow). Both solutions offer various methods for preserving a flow's current state. Users can protect a flow's existing state and undo modifications if necessary by using the Export and Save As options. User preferences and the particular process requirements will determine which alternative is best.

Question 16: In Power Automate, what is the purpose of a 'Do Until' loop?

Run actions a fixed number of times
Loop through each item in a list
Repeat actions until a specified condition becomes true (Correct answer)
Retry failed actions automatically

Correct answer: Repeat actions until a specified condition becomes true

'Do Until' continuously executes enclosed actions until the exit condition evaluates to true.

Question 17: What is the recommended approach for deploying a Power Platform solution from a development environment to production?

Use connection references to link the development environment to production
Export the solution as a managed solution and import it into the production environment (Correct answer)
Manually recreate all apps and flows directly in the production environment
Copy the Dataverse database directly between environments using SQL tools

Correct answer: Export the solution as a managed solution and import it into the production environment

Best practice ALM dictates exporting solutions as managed solutions from lower environments and importing them into production, ensuring consistent deployments and preventing direct edits in production.

Question 18: Which Power Platform feature provides data loss prevention (DLP) policies to govern which connectors can be used together in flows and apps?

Connector allow-lists in Azure AD
Security roles in Dataverse
Managed Environments gateway rules
DLP Policies in Power Platform Admin Center (Correct answer)

Correct answer: DLP Policies in Power Platform Admin Center

DLP Policies classify connectors into Business, Non-Business, and Blocked groups to prevent data leakage between incompatible services.

Question 19: What does a Many-to-Many (N:N) relationship in Dataverse require behind the scenes?

A lookup column on each table
An auto-created intersect (junction) table to store the associations (Correct answer)
A calculated column linking both tables
A Power Automate flow to maintain the links

Correct answer: An auto-created intersect (junction) table to store the associations

Dataverse automatically creates a hidden intersect table to store the pairs of related records for N:N relationships.

Question 20: Which Power Automate feature allows a maker to package multiple actions as a reusable named unit that can be called from other flows?

Flow template
Child flow (Correct answer)
Action group
Shared action

Correct answer: Child flow

Child flows are separate cloud flows invoked by parent flows using the 'Run a Child Flow' action, enabling reuse of common logic.

Question 21: You must make sure Adventure Works Cycle can track data from attendees at bike shows. Which should you create?

A workflow in Dynamics 365 Sales Engagement for capabilities leads.
A flow to capture customer data from the bike fair Power Apps in SharePoint and create a lead in Microsoft Teams.
A Microsoft flow that generates a new customer record in SharePoint.
A flow that connects with the bike fair Power Apps to create a lead in Dynamic 365 Sales. (Correct answer)

Correct answer: A flow that connects with the bike fair Power Apps to create a lead in Dynamic 365 Sales.

Establishing a connection with the bike fair through a flow Adventure Works Cycle can track visitor data from cycle fairs by using Power Apps to create a lead in Dynamics 365 Sales. You may automate processes and combine many services and apps using flows. In this situation, you can build a flow that associates with the bike fair Power Apps and activates when a visitor enters their data. After that, the flow can use this data to generate a lead in Dynamics 365 Sales.

Question 22: What is the purpose of a Rollup column in Dataverse?

Aggregate values from related child records into the parent record (Correct answer)
Sync data from an external source
Calculate a value from columns on the same record
Store a computed text value

Correct answer: Aggregate values from related child records into the parent record

Rollup columns summarize data (sum, count, avg, min, max) from related child records and store the result on the parent record.

Question 23: In a model-driven app, what is a 'Business Process Flow' stage?

A Power Automate flow triggered on stage change
A security role applied at each workflow phase
A record status value in a Dataverse column
A defined step in a guided workflow shown as a progress bar on the form, containing data entry steps (Correct answer)

Correct answer: A defined step in a guided workflow shown as a progress bar on the form, containing data entry steps

BPF stages represent discrete phases in a process (e.g., Qualify, Develop, Close) and each stage contains steps that prompt users to fill in required fields.

Question 24: What is the purpose of the Concurrent() function in Power Apps Canvas apps?

Merge two data collections
Create parallel approval branches
Run multiple formulas simultaneously to improve performance (Correct answer)
Lock records during editing

Correct answer: Run multiple formulas simultaneously to improve performance

Concurrent() executes multiple formulas at the same time, reducing total load time when retrieving data.

Question 25: Which Power Platform Admin Center capability allows administrators to copy a production environment to create a sandbox for testing?

Clone Environment
Snapshot Restore
Environment Copy (Correct answer)
Backup and Restore

Correct answer: Environment Copy

The 'Copy' feature in Power Platform Admin Center duplicates an environment's customizations and data into a new or existing target environment.

Question 26: Which property of a Canvas app Gallery control determines the data source that populates the gallery items?

Collection
DataSource
Records
Items (Correct answer)

Correct answer: Items

The Items property of a Gallery control is set to the data source or collection that populates its records.

Question 27: What are the advantages of putting Dynamics 365 and Microsoft 365 apps in the same tenant?

Both will use the same time zone
You can implement Single Sign-On (SSO) (Correct answer)
You can use Power BI to display data that comes from both environments
You do not need to manually back up data

Correct answer: You can implement Single Sign-On (SSO)

The ability to establish Single Sign-On (SSO) is a key benefit of putting Dynamics 365 and Microsoft 365 apps in the same tenant. The same authentication infrastructure can be used by the Dynamics 365 and Microsoft 365 apps when they are both deployed in the same tenant, providing users with seamless SSO.

Question 28: In Power Apps, what is the result of the formula: Filter(Orders, Status = "Open")?

A single record matching the first open order
A Boolean indicating whether open orders exist
An error because strings need single quotes
A table containing only orders where Status equals 'Open' (Correct answer)

Correct answer: A table containing only orders where Status equals 'Open'

Filter() returns a table of all records matching the specified condition from the source table.

Question 29: Which formula would you use in Power Apps to navigate from one screen to another?

Navigate(ScreenName, ScreenTransition.Fade) (Correct answer)
Open(ScreenName)
GoTo(ScreenName)
Launch(ScreenName)

Correct answer: Navigate(ScreenName, ScreenTransition.Fade)

The Navigate() function moves the user to a specified screen and accepts an optional screen transition animation.

Question 30: In order to fix CustomerC's problem, Microsoft flow needs to be modified. What ought you to do?

Add b condition containing approval hierarchy
Add a configure run that is set to Is successful
Add a timeout setting to the approval flow (Correct answer)
Add a data operation that specifies the false conditions

Correct answer: Add a timeout setting to the approval flow

Depending on the precise issue being experienced, adding a timeout setting to the approval flow can be a feasible option to changing a Microsoft Power Automate flow to address a difficulty observed by CustomerC.

Question 31: What is the purpose of a Business Process Flow (BPF) in a Model-Driven app?

Guide users through multi-stage data entry processes with defined steps (Correct answer)
Restrict user access to specific forms
Generate charts based on record counts
Automate background data calculations

Correct answer: Guide users through multi-stage data entry processes with defined steps

Business Process Flows display a visual stage-by-stage guide at the top of a form to lead users through a defined process.

Question 32: Which Canvas app control should you use to allow users to sign and capture their signature digitally?

Pen Input (Correct answer)
Rich Text Editor
Ink Answer
Camera

Correct answer: Pen Input

The Pen Input control lets users draw or sign with a stylus or finger directly in the app.

Question 33: What is the Power BI 'On-premises data gateway' used for?

Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers (Correct answer)
Encrypting data in transit between Power BI and Azure
Deploying Power BI reports to on-premises servers
Caching Power BI reports locally on desktop machines

Correct answer: Connecting Power BI service to data sources that are behind a corporate firewall or on-premises servers

The on-premises data gateway acts as a secure bridge that allows Power BI service (cloud) to query on-premises data sources like SQL Server or Oracle databases.

Question 34: Which repository integration does Microsoft officially support for source-controlling Power Platform solutions?

Azure DevOps and GitHub via Power Platform Build Tools and GitHub Actions (Correct answer)
SVN repositories
GitLab Enterprise
Bitbucket only

Correct answer: Azure DevOps and GitHub via Power Platform Build Tools and GitHub Actions

Microsoft provides Power Platform Build Tools for Azure DevOps and GitHub Actions for Power Platform to enable source-controlled ALM.

Question 35: In Power Automate, what does the 'Scope' action provide?

Group a set of actions together so error handling can be applied to the whole group (Correct answer)
Define security boundaries for connector calls
Set environment-level permissions
Limit variable scope to a section of the flow

Correct answer: Group a set of actions together so error handling can be applied to the whole group

Scope groups actions and enables 'Run after' conditions on the scope itself, making try-catch error handling patterns possible.

Question 36: Which Power Apps feature allows a Canvas app to work without an internet connection and sync changes when connectivity is restored?

Cached query mode
Power Automate offline trigger
Offline capability with local data collections (Correct answer)
Progressive Web App hosting

Correct answer: Offline capability with local data collections

Canvas apps can store data in local collections and use SaveData()/LoadData() to persist data offline and sync later.

Question 37: What is the purpose of the 'Form' control in a Power Apps canvas app?

To display and edit a single record from a data source (Correct answer)
To show a collection of records in rows
To capture free-text input from users
To generate PDF output from data

Correct answer: To display and edit a single record from a data source

The Form control (Edit Form and Display Form) binds to a data source item and renders its fields for viewing or editing a single record.

Question 38: What is the purpose of Azure AD Conditional Access in relation to Power Apps access?

To enforce conditions such as MFA or device compliance before users can access Power Apps (Correct answer)
To automatically generate Dataverse security roles for new users
To manage API call rate limits for premium connectors
To block all non-Business connector access by default

Correct answer: To enforce conditions such as MFA or device compliance before users can access Power Apps

Azure AD Conditional Access policies can require multi-factor authentication, compliant devices, or trusted locations before a user is granted access to Power Apps.

Question 39: What is the purpose of a Security Role in Microsoft Dataverse?

To manage API rate limits for external connectors
To automatically assign licenses to new users
To define a set of privileges that control user access to tables and operations (Correct answer)
To encrypt sensitive columns in a table

Correct answer: To define a set of privileges that control user access to tables and operations

Security Roles define the Create, Read, Update, Delete, and Append privileges users have on Dataverse tables, and are assigned to users or teams.

Question 40: What is the maximum number of screens recommended in a single Canvas app for optimal performance?

100 screens
There is no official max but fewer than 30-40 screens is a best practice (Correct answer)
5 screens
Exactly 10 screens

Correct answer: There is no official max but fewer than 30-40 screens is a best practice

Microsoft recommends keeping Canvas apps under roughly 30-40 screens to maintain acceptable load and navigation performance.

Question 41: What is the primary data source for Model-Driven apps in Power Platform?

SQL Server
SharePoint Lists
Microsoft Dataverse (Correct answer)
Excel Online

Correct answer: Microsoft Dataverse

Model-Driven apps are built entirely on Dataverse tables and metadata, making Dataverse the required underlying data platform.

Question 42: How do you control which users can see a specific Model-Driven app within an environment?

Set the app to private in app settings
Create a separate environment per user group
Assign security roles to the app (Correct answer)
Use row-level security on all tables

Correct answer: Assign security roles to the app

Security roles are assigned to Model-Driven apps so only users with those roles see the app in their app list.

Question 43: Which minimum role is required at the tenant level to create a new Power Platform environment?

Global Administrator or Power Platform Administrator (Correct answer)
Dataverse Database Administrator
Any Microsoft 365 licensed user
Power Apps per-user plan holder

Correct answer: Global Administrator or Power Platform Administrator

Creating environments requires either the Global Administrator or Power Platform Administrator role, as it is a tenant-level administrative action.

Question 44: To determine insurance exposure and risk profiles for customers, a corporation employs Common Data Service rollup fields. When new insurance policies are written, users claim that the system does not update values for the rollup fields. After a policy is produced, you must immediately recalculate the value of the rollup fields. What are your options?

Create a plug-in that uses the update method for the rollup field. Configure a step on the Create event for the policy entity for this plug-in. (Correct answer)
Update the Mass Calculate Rollup Field job to trigger when a new policy record is created.
Change the frequency of the Calculate Rollup Field recurring job from every hour to every five minutes.
On the customer entity, add additional fields for insurance exposure and risk. Construct a plug-in that runs each time a new policy record is added.

Correct answer: Create a plug-in that uses the update method for the rollup field. Configure a step on the Create event for the policy entity for this plug-in.

A workable technique to recalculate the value of the rollup fields right away when a policy is established is to write a plugin that uses the update method for the rollup field and configure a step on the Create event for the policy object. By developing a plugin, you can alter the system's behavior and have it take particular actions each time a policy is produced. In this situation, you would need to write a plugin that reacts to the policy entity's Create event. You can use the update method in the plugin code to have the rollup fields' values updated in accordance with the most recent policy.

Question 45: In Power BI, what does the 'Analyze in Excel' feature do?

Converts Power Query steps into Excel formulas
Exports the Power BI report as an Excel workbook
Allows users to connect a Power BI dataset to Excel as a live PivotTable data source for ad-hoc analysis (Correct answer)
Runs Excel macros against the Power BI dataset

Correct answer: Allows users to connect a Power BI dataset to Excel as a live PivotTable data source for ad-hoc analysis

'Analyze in Excel' opens a live connection to the Power BI dataset in Excel, enabling users to create PivotTables and PivotCharts against the Power BI data model.

Question 46: In a Canvas app, which data type would you use to store a list of records that only exists in memory during the app session?

Gallery
Variable
Collection (Correct answer)
Table

Correct answer: Collection

Collections are in-memory tables created with Collect() or ClearCollect() that persist only for the app session.

Question 47: Your Power App portal is created. This problem appears when a user logs into the portal: No users found You verify that the user's sign-in details are accurate. You must identify the error's root cause. What ought you to do?

Enable diagnostic tools in Lifecycle Services
Disable custom error messages (Correct answer)
Enable Maintenance mode
Create a custom error message

Correct answer: Disable custom error messages

If the error message is inaccurate or offers insufficient information, disabling custom error messages should only be thought of as a temporary solution. Instead of covering up the problem with generic error messages, it is typically preferable to identify and fix the underlying problem.

Question 48: Which Canvas app component feature allows you to define output properties that can pass values back to the hosting screen?

Component events
Custom output properties (Correct answer)
Global variables
Return variables

Correct answer: Custom output properties

Components support custom output properties that expose internal values to the parent screen or app.

Question 49: Which Power Apps feature allows makers to add client-side logic to Model-Driven app forms without writing JavaScript?

Calculated columns
Business Rules (Correct answer)
Power Automate cloud flows
PCF controls

Correct answer: Business Rules

Business Rules apply logic such as show/hide, set field values, and validate data directly on forms using a no-code interface.

Question 50: What happens when you set a column as 'Required' on a model-driven app form?

The column only becomes visible on mobile devices
The form prevents saving the record until the user provides a value for that column (Correct answer)
The column syncs its value to SharePoint automatically
The column is hidden unless the user requests it

Correct answer: The form prevents saving the record until the user provides a value for that column

Marking a column as required on a form adds a red asterisk indicator and blocks form submission with a validation error if the field is left empty.

Question 51: What does the Least Privilege principle mean in the context of Power Platform security?

Blocking all external connector access until explicitly approved
Granting users maximum permissions to minimize support requests
Granting users only the minimum permissions required to complete their job tasks (Correct answer)
Only using built-in security roles without any customization

Correct answer: Granting users only the minimum permissions required to complete their job tasks

The Least Privilege principle means users receive only the permissions absolutely necessary for their role, reducing the potential impact of compromised accounts.

Microsoft Certified: Power Platform App Maker Associate (PL-100)

This exam tests candidates' ability to design, build, and deploy Power Platform solutions including canvas apps, model-driven apps, Power Automate flows, and Power BI reports to solve business problems without deep developer expertise.

Questions

100 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

learn.microsoft.com — Passing score, score release, renewal, eligibility, retake policy, time limit · verified Oct 2026
home.pearsonvue.com — Test delivery · verified Oct 2026