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)
Sandbox → Integration → QA
Single shared environment for all stages
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 Power Apps, what is a 'collection'?

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

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 3: What does the LookUp() function return in Power Apps when no matching record is found?

Error
Empty string
Blank (Correct answer)
0

Correct answer: Blank

LookUp() returns Blank() when no record satisfies the search condition, which can be tested with the IsBlank() function.

Question 4: How can a maker embed a Power BI report inside a model-driven Power App?

By installing a Power BI connector in Dataverse
By adding an iframe with the report URL in a canvas app
By exporting the report to PDF and attaching it to a record
By adding a Power BI Embedded Dashboard or report as a dashboard component or using the Power BI tile in a form (Correct answer)

Correct answer: By adding a Power BI Embedded Dashboard or report as a dashboard component or using the Power BI tile in a form

Power BI reports and dashboards can be embedded in model-driven apps as personal or system dashboards, or as controls on forms, using the built-in Power BI integration.

Question 5: What is the correct way to filter a gallery in a Power Apps canvas app to show only records where the Status column equals 'Active'?

Set the gallery's Visible property to Status = "Active"
Use a search bar control only
Set the gallery's Items property to Filter(DataSource, Status = "Active") (Correct answer)
Add a business rule on the data source

Correct answer: Set the gallery's Items property to Filter(DataSource, Status = "Active")

The Filter() function in the gallery's Items property evaluates a condition for each row and returns only matching records from the data source.

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

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

Correct answer: Custom output properties

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

Question 7: In Power Automate, what does the 'Apply to each' action do?

Applies a condition to filter items
Iterates over each item in an array and executes actions for each (Correct answer)
Splits a string into an array
Merges multiple arrays into one

Correct answer: Iterates over each item in an array and executes actions for each

'Apply to each' loops through every item in an array output from a previous step and runs its child actions for each item.

Question 8: 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?

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

Correct answer: OpenAPI definition

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. <br> 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 9: In Dataverse, which security role privilege level grants a user access only to records they personally own?

Business unit level
Parent: Child business unit level
Organization level
User level (Correct answer)

Correct answer: User level

The 'User' privilege depth restricts a security role's access so the user can only read or modify records they personally own.

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

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

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 11: What is the purpose of a 'solution' in the Power Platform?

A type of Power Automate flow
A help documentation library
A security role template
A container that packages app components for transport between environments via ALM (Correct answer)

Correct answer: A container that packages app components for transport between environments via ALM

Solutions are containers that group Power Platform components (apps, flows, tables, etc.) to enable Application Lifecycle Management (ALM) by importing/exporting them between environments.

Question 12: In Dataverse, which table type stores data that rarely changes and is used to provide reference values, such as country codes?

Activity table
Standard table (Correct answer)
Elastic table
Virtual table

Correct answer: Standard table

Standard tables are the default Dataverse table type and are used for all persistent reference and transactional data.

Question 13: In Power Automate, what trigger type should you use to start a flow when a new item is added to a SharePoint list?

When an item is created (Correct answer)
HTTP request
When an item is modified
Recurrence

Correct answer: When an item is created

The 'When an item is created' trigger fires a flow automatically whenever a new item is added to a specified SharePoint list.

Question 14: What is the role of an environment in the Power Platform?

A deployment region for Azure resources only
A user group for assigning licenses
A version control system for Power Apps
An isolated container for apps, flows, and Dataverse data with its own security boundaries (Correct answer)

Correct answer: An isolated container for apps, flows, and Dataverse data with its own security boundaries

Environments are isolated containers that separate Power Platform resources, allowing organizations to manage dev, test, and production independently with distinct security and data boundaries.

Question 15: Which Power Platform tool is used to package solutions for ALM (Application Lifecycle Management) and move them between environments?

Azure DevOps only
Power Apps Studio
Power Automate export
Solution files (.zip) (Correct answer)

Correct answer: Solution files (.zip)

Solution files exported as .zip packages contain all components (apps, flows, tables, etc.) and can be imported into target environments for ALM.

Question 16: Which AI Builder model type would a maker use to automatically extract key information such as invoice number and total from uploaded invoice documents?

Object detection model
Prediction model
Text classification model
Document processing model (Correct answer)

Correct answer: Document processing model

The document processing model in AI Builder uses form recognition to extract structured fields like invoice numbers and totals from documents.

Question 17: Which type of view in a Model-Driven app is displayed automatically when a user opens a table from the navigation?

Associated view
Default public view (Correct answer)
Quick Find view
Lookup view

Correct answer: Default public view

The default public view is the grid that users see when navigating to a table in a Model-Driven app.

Question 18: Which control should you use in Power Apps when you need a user to pick one option from a predefined list?

Dropdown (Correct answer)
Toggle
Slider
Text Input

Correct answer: Dropdown

The Dropdown control presents a collapsed list of options from which the user selects exactly one value.

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

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

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 20: What does the 'OnStart' property of a Power Apps canvas app execute?

Formulas when the app is saved
Formulas when a screen is opened
Formulas when a button is clicked
Formulas when the app first loads (Correct answer)

Correct answer: Formulas when the app first loads

OnStart runs once when the app is launched, making it ideal for initializing variables and loading global data.

Question 21: In Power Automate, what is the purpose of the 'Compose' action?

Trigger a child flow
Store and transform data without writing to a data source (Correct answer)
Create a new Dataverse record
Send an email with a composed body

Correct answer: Store and transform data without writing to a data source

The Compose action stores any data expression or transformation result as a variable-like value reusable later in the flow.

Question 22: What does a Power BI 'KPI visual' display?

A metric value compared to a target goal with a trend indicator showing progress over time (Correct answer)
A geographical map colored by region values
A table comparing values across multiple measures
A funnel showing conversion rates between stages

Correct answer: A metric value compared to a target goal with a trend indicator showing progress over time

KPI visuals show an actual value, a target value, and a trend sparkline, making it easy to assess whether a metric is on track at a glance.

Question 23: In Power BI, what is 'incremental refresh'?

A policy that refreshes only new or changed data rows rather than the entire dataset, reducing refresh time and resource usage (Correct answer)
Refreshing data every minute via a streaming dataset
Manually triggering a partial refresh via the REST API
Refreshing data in small batches of 1,000 rows at a time

Correct answer: A policy that refreshes only new or changed data rows rather than the entire dataset, reducing refresh time and resource usage

Incremental refresh policies define a rolling window of data to update, archiving historical data while only re-querying recent changes, significantly improving refresh performance.

Question 24: What is the purpose of the Timeline control in a Model-Driven app form?

Display activities, notes, and posts related to a record in chronological order (Correct answer)
Visualize the Business Process Flow stages
Show a Gantt chart of tasks
Render a calendar of scheduled meetings

Correct answer: Display activities, notes, and posts related to a record in chronological order

The Timeline control aggregates emails, tasks, appointments, notes, and posts related to the record in a single feed.

Question 25: What Power Apps function would you use to add a record to an existing collection without replacing it?

Collect() (Correct answer)
Patch()
ClearCollect()
UpdateIf()

Correct answer: Collect()

Collect() appends one or more records to a collection, whereas ClearCollect() first clears the collection before adding records.

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

Whole Number
Currency (Correct answer)
Float
Decimal Number

Correct answer: Currency

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

Question 27: A business intends to develop an app for processing orders. The software will execute intricate business logic and interface with numerous external systems when an order is created. Large orders with several line items could take up to six minutes to process. <br> To avoid leaving records in an unfinished state, processing for each order must be finished in a single operation. You must suggest a solution to the business. What ought to you suggest?

an asynchronous workflow that uses a custom workflow activity
a real-time workflow that uses a custom action
a webhook that connects to an Azure Function (Correct answer)
an asynchronous plug-in

Correct answer: a webhook that connects to an Azure Function

You may accomplish the desired capability of processing orders with intricate business logic and integrating with external systems while making sure that each order's processing is finished in a single operation by using a webhook that links to an Azure Function. This method offers control, scalability, and flexibility over the order processing flow.

Question 28: What is an Environment Variable used for in Power Platform solutions?

Storing user credentials for connector authentication
Holding environment-specific configuration values separate from app logic (Correct answer)
Managing DLP policy parameters dynamically
Defining system administrator email addresses per environment

Correct answer: Holding environment-specific configuration values separate from app logic

Environment variables store configuration values like URLs, keys, or settings that differ between environments, enabling solutions to move between environments without code changes.

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

Navigate(ScreenName, ScreenTransition.Fade) (Correct answer)
Launch(ScreenName)
Open(ScreenName)
GoTo(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 Power Platform, what is a 'Managed Environment'?

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

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 31: What is the purpose of the 'Form' control in a Power Apps canvas app?

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

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 32: What does the 'LookUp()' function return in Power Apps?

The first record from a table that matches a condition (Correct answer)
All records matching a condition
The count of matching records
A boolean indicating if a match exists

Correct answer: The first record from a table that matches a condition

LookUp() scans a table and returns the first single record that satisfies the specified condition, or blank if none is found.

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

To manage API call rate limits for premium connectors
To block all non-Business connector access by default
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

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 34: Which formula would you use in a Canvas app to navigate to a screen called 'DetailScreen' with a fade transition?

Navigate('DetailScreen', 'Fade')
Navigate(DetailScreen, ScreenTransition.Fade) (Correct answer)
GoTo(DetailScreen, Fade)
Screen.Navigate(DetailScreen)

Correct answer: Navigate(DetailScreen, ScreenTransition.Fade)

Navigate() accepts the target screen reference and a ScreenTransition enum value such as ScreenTransition.Fade.

Question 35: Which connector type in Canvas apps allows makers to interact with on-premises data without exposing it directly to the internet?

Hybrid tunnel
VPN connector
Direct query bridge
On-premises data gateway (Correct answer)

Correct answer: On-premises data gateway

The on-premises data gateway acts as a secure bridge so Power Apps can query on-premises sources without opening firewall ports.

Question 36: Which built-in Dataverse security role grants full unrestricted access to all data and customizations in an environment?

Delegate
Basic User
System Administrator (Correct answer)
System Customizer

Correct answer: System Administrator

The System Administrator role provides complete access to all Dataverse data, customizations, and administrative functions within the environment.

Question 37: Which Power Platform tool would you use to build a Copilot (chatbot) that answers HR policy questions from employees?

Microsoft Copilot Studio (Correct answer)
Power BI
Power Automate
Power Apps

Correct answer: Microsoft Copilot Studio

Microsoft Copilot Studio (formerly Power Virtual Agents) is the Power Platform tool for building intelligent chatbots and copilots.

Question 38: Which Power Automate flow type can be manually triggered by a user from within a Power Apps application?

Instant flow (Correct answer)
Automated flow
Scheduled flow
Business process flow

Correct answer: Instant flow

Instant flows are triggered manually and can be called directly from Power Apps using a button or trigger action.

Question 39: Which function clears all records from a collection and then fills it with new data in one step?

ClearCollect() (Correct answer)
Clear()
Collect()
Reset()

Correct answer: ClearCollect()

ClearCollect() first removes all existing records from the named collection, then populates it with the supplied data.

Question 40: In model-driven apps, what is a 'Quick View Form'?

A simplified form with fewer fields for mobile use
A popup form shown when hovering over a record
A read-only form embedded inside another form to display fields from a related record (Correct answer)
A form that loads faster by hiding optional fields

Correct answer: A read-only form embedded inside another form to display fields from a related record

Quick View Forms display selected fields from a related (lookup) record directly on the main record's form without navigating away.

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

A Power Automate flow triggered on stage change
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)
A security role applied at each workflow phase

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 42: An internal Microsoft SQL Server database at your organization houses historical sales information. A new Power Apps app must display data from the database. Between the database and the app, a secure connection must be established. Which should you employ?

Data source
App
Flow
Gateway (Correct answer)

Correct answer: Gateway

The Power Apps app and the on-premises Microsoft SQL Server database should be connected securely using a Gateway. <br> A gateway serves as a link between on-premises data sources and cloud-based services like Power Apps. It permits safe and dependable data transport while guaranteeing data security between cloud and on-premises systems.

Question 43: What is column-level security used for in Dataverse?

Controlling which users can read, create, or update data in specific sensitive columns (Correct answer)
Encrypting column data at rest
Defining required fields on model-driven app forms
Setting which columns appear in the default view

Correct answer: Controlling which users can read, create, or update data in specific sensitive columns

Column-level security allows administrators to restrict access to specific sensitive columns (fields) so only authorized users with the correct column security profile can view or edit them.

Question 44: In Power BI Desktop, what is 'Power Query' used for?

Publishing reports to the Power BI service
Designing report layouts and themes
Writing DAX measures and calculated columns
Connecting to, transforming, and loading data from multiple sources into the data model before building visuals (Correct answer)

Correct answer: Connecting to, transforming, and loading data from multiple sources into the data model before building visuals

Power Query (the Get Data / Transform Data experience) provides an M-language-based ETL environment for shaping and combining data before it enters the report's data model.

Question 45: Which Power Platform tool provides a low-code way to create chatbots that can answer questions and perform actions through conversation?

Power Apps
Copilot Studio (formerly Power Virtual Agents) (Correct answer)
Power Automate
Power BI

Correct answer: Copilot Studio (formerly Power Virtual Agents)

Copilot Studio (formerly Power Virtual Agents) is the Power Platform tool for building conversational AI chatbots with a low-code interface.

Question 46: What does 'Column Security Profile' in Dataverse control?

Encryption of column values at rest
Access to specific sensitive columns, independent of the table-level security role (Correct answer)
Which columns appear in views
The order of columns in a form

Correct answer: Access to specific sensitive columns, independent of the table-level security role

Column Security Profiles define which users or teams can read or write specific secured columns, adding field-level access control.

Question 47: Which Power Platform Admin Center report helps makers and admins identify apps and flows that have not been used recently?

DLP violation log
Dataverse audit logs
Solution Checker report
Power Platform Analytics and the inactive resources report in Managed Environments (Correct answer)

Correct answer: Power Platform Analytics and the inactive resources report in Managed Environments

Managed Environments provide usage analytics and can flag or notify about inactive apps and flows to help admins clean up resources.

Question 48: What is the purpose of the Dataverse 'Choices' column type?

Stores numeric ranges
Stores free-text values only
Stores multiple selected values from a predefined list (Correct answer)
Stores a single selected value from a predefined list

Correct answer: Stores multiple selected values from a predefined list

The Choices column type in Dataverse allows users to select multiple values from a predefined option set, unlike Choice which allows only one selection.

Question 49: Which sitemap element in a Model-Driven app represents a clickable navigation item that links to a table, dashboard, or URL?

Group
Page
Area
SubArea (Correct answer)

Correct answer: SubArea

A SubArea is the clickable leaf-level navigation item in the sitemap that points to a table, dashboard, or external URL.

Question 50: A Power Platform developer needs to call an external REST API that is not available as a standard connector. What is the best approach?

Create a Power Pages API endpoint
Use the HTTP action in Power Automate Premium (Correct answer)
Use Power BI dataflow
Write a C# plugin in Dataverse

Correct answer: Use the HTTP action in Power Automate Premium

The HTTP action (available in Premium Power Automate plans) allows flows to call any external REST API directly without a pre-built connector.

Question 51: Which connector in Power Automate allows flows to create, update, read, and delete records in Microsoft Dataverse?

Microsoft Dataverse connector (Correct answer)
SharePoint connector
Dynamics 365 connector
Common Data Service connector

Correct answer: Microsoft Dataverse connector

The Microsoft Dataverse connector provides actions to perform full CRUD operations on any Dataverse table.

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

120 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