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

Question 1: In a model-driven app, which form type is used for creating a new record in a dialog without navigating away from the current page?

Card Form
Quick View Form
Main Form
Quick Create Form (Correct answer)

Correct answer: Quick Create Form

Quick Create Forms appear as lightweight popups when users click '+ New' in sub-grids or lookup searches, allowing fast record creation without a full navigation.

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

Holding environment-specific configuration values separate from app logic (Correct answer)
Storing user credentials for connector authentication
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 3: Which Power Apps formula function is used to navigate between screens in a canvas app?

Redirect()
Launch()
Navigate() (Correct answer)
GoTo()

Correct answer: Navigate()

The Navigate() function in Power Apps canvas apps moves the user to a specified screen with optional transition effects.

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

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

Correct answer: Microsoft Dataverse

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

Question 5: What is the purpose of 'Column Security Profiles' in Dataverse?

To audit who accesses a particular column
To enforce uniqueness on a column's values
To restrict read, create, or update access to specific sensitive columns for designated users or teams (Correct answer)
To configure column-level encryption keys

Correct answer: To restrict read, create, or update access to specific sensitive columns for designated users or teams

Column (field) security profiles allow admins to restrict which users or teams can see or modify specific sensitive columns, beyond standard table-level security roles.

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

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

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 7: In Power Automate, what is an 'Approval' action used for in a business app context?

Send an approval request to designated users and wait for their Approve or Reject decision (Correct answer)
Schedule a meeting for review
Automatically approve records matching criteria
Log a decision to Dataverse

Correct answer: Send an approval request to designated users and wait for their Approve or Reject decision

The Approval action sends a structured request to approvers and pauses the flow until a response is received.

Question 8: Which formula in Power Apps would correctly filter a Dataverse table called 'Orders' to show only records where the Status field equals 'Active'?

Filter(Orders, Status = 'Active')
LookUp(Orders, Status = "Active")
Filter(Orders, Status = "Active") (Correct answer)
Search(Orders, "Active", "Status")

Correct answer: Filter(Orders, Status = "Active")

In Power Apps formulas, string literals use double quotes, so Filter(Orders, Status = "Active") is the correct syntax.

Question 9: Which Power Automate feature allows a business user to trigger a flow manually from within a Power Apps canvas app?

Power Apps trigger (Correct answer)
Manual trigger
Instant cloud flow
Button trigger

Correct answer: Power Apps trigger

The Power Apps trigger allows a canvas app to call a Power Automate flow and pass parameters directly from the app to the flow.

Question 10: 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)
Lookup view
Quick Find 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 11: A company wants to give external customers a self-service portal to submit support tickets. Which Power Platform tool is most appropriate?

Power Pages (Correct answer)
Power BI
Power Apps canvas app
Power Automate

Correct answer: Power Pages

Power Pages (formerly Power Apps portals) is designed to create externally facing websites and self-service portals for external users.

Question 12: 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
Gateway (Correct answer)
Flow
App

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 13: In Power BI, what is 'incremental refresh'?

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

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 14: In Power BI service, what is a 'dataflow'?

A scheduled SQL stored procedure run in the cloud
A connection between Power BI and Azure Data Factory pipelines
A real-time data stream ingested via Azure Event Hubs
A reusable Power Query ETL process stored in the service that extracts and transforms data into Common Data Model entities for multiple datasets to consume (Correct answer)

Correct answer: A reusable Power Query ETL process stored in the service that extracts and transforms data into Common Data Model entities for multiple datasets to consume

Dataflows allow makers to centralize data preparation logic in Power BI service so multiple reports and datasets can reuse the same transformed tables without duplicating Power Query steps.

Question 15: What is the primary tool used to manage Power Platform environments, data policies, and security settings across a tenant?

Microsoft 365 Admin Center
Azure Active Directory Portal
Power Apps Studio
Power Platform Admin Center (Correct answer)

Correct answer: Power Platform Admin Center

The Power Platform Admin Center is the central hub for administrators to manage environments, DLP policies, capacity, and tenant-wide security settings.

Question 16: In Power BI, what is 'DAX'?

Data Aggregation XML — a schema for dataset definitions
Data Analysis Expressions — a formula language used to create calculated columns, measures, and tables (Correct answer)
Dashboard Analytics Extension — a Power BI add-in
Direct Access Exchange — a protocol for live database connections

Correct answer: Data Analysis Expressions — a formula language used to create calculated columns, measures, and tables

DAX is the formula language in Power BI (and Analysis Services/Excel Power Pivot) used to write calculated measures and columns that perform aggregation and business logic.

Question 17: 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
Automate background data calculations
Generate charts based on record counts

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 18: A developer needs to run a Power Automate cloud flow on a recurring schedule every weekday at 8 AM EST. Which trigger should they use?

Recurrence trigger (Correct answer)
When a new email arrives trigger
When a file is created trigger
HTTP trigger

Correct answer: Recurrence trigger

The Recurrence trigger lets you schedule a flow to run at specific intervals and times, including weekday-only schedules.

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

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

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 20: In Model-Driven app forms, what is a 'Quick View Form' used for?

Rendering a card view in the mobile app
Showing a record summary in the activity feed
Providing a condensed edit form in a dialog
Displaying read-only fields from a related record within the current form (Correct answer)

Correct answer: Displaying read-only fields from a related record within the current form

Quick View Forms embed read-only information from a related record directly within the parent record's main form.

Question 21: Which Power Platform admin center feature allows administrators to control which connectors users can use in Power Automate flows?

Capacity add-ons
Audit log settings
Gateway clusters
Data loss prevention (DLP) policies (Correct answer)

Correct answer: Data loss prevention (DLP) policies

Data loss prevention (DLP) policies let admins classify connectors as Business, Non-Business, or Blocked to prevent unauthorized data sharing.

Question 22: Which control in Power Apps canvas apps is best suited for displaying a scrollable list of records with custom formatting?

List Box
Gallery (Correct answer)
Combo Box
Data Table

Correct answer: Gallery

The Gallery control allows custom layouts and formatting for each record and supports vertical or horizontal scrolling.

Question 23: In Power Automate, which expression function would you use to get the current UTC date and time?

getCurrentTime()
utcNow() (Correct answer)
now()
dateTime()

Correct answer: utcNow()

utcNow() returns the current UTC timestamp as a string, commonly used for setting date fields or calculating durations.

Question 24: Which property controls whether a Canvas app control is visible to users at runtime?

Hidden
Visible (Correct answer)
DisplayMode
Active

Correct answer: Visible

The Visible property accepts a Boolean expression and shows or hides the control based on its value.

Question 25: Which Power Pages feature allows makers to control which site pages authenticated users can access?

Site settings
Entity lists
Content snippets
Table permissions and web roles (Correct answer)

Correct answer: Table permissions and web roles

Table permissions combined with web roles in Power Pages govern what data and pages authenticated users can read, write, or delete.

Question 26: 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 funnel showing conversion rates between stages
A geographical map colored by region values
A table comparing values across multiple measures

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 27: Which Power Apps formula function would check whether a required text input is empty before submitting a form?

IsEmpty(TextInput.Text)
IsNone(TextInput.Text)
IsNull(TextInput.Text)
IsBlank(TextInput.Text) (Correct answer)

Correct answer: IsBlank(TextInput.Text)

IsBlank() returns true if the value is blank (empty string or null), making it the correct function for validating required text fields.

Question 28: What does a Model-Driven app 'Quick Create Form' allow users to do?

Create a form with minimal fields for mobile use
Quickly duplicate an existing record
Create a new record from a side panel without leaving the current page (Correct answer)
Import records in bulk via CSV

Correct answer: Create a new record from a side panel without leaving the current page

Quick Create Forms open in a slide-out panel so users can add a new record without navigating away from their current view.

Question 29: Which security concept in Dataverse restricts which rows a user can read, based on their business unit?

App-level permissions
Record-level security using security roles and business units (Correct answer)
Column-level security
Table permissions

Correct answer: Record-level security using security roles and business units

Record-level access in Dataverse is controlled by the access level (User, Business Unit, Parent/Child, Organization) defined in security roles combined with the user's business unit membership.

Question 30: Which Dataverse security concept restricts which rows a user can read or modify based on their relationship to the record owner?

Record-level security through business units and sharing (Correct answer)
Access teams
Column-level security
Table permissions

Correct answer: Record-level security through business units and sharing

Dataverse uses business unit hierarchy, owner teams, and record sharing to enforce row-level access control.

Question 31: What is 'Managed Environments' in Power Platform?

Environments provisioned via Azure Resource Manager templates
Environments with automatic daily data backup enabled by default
A premium governance feature giving administrators enhanced control over environment policies and insights (Correct answer)
Environments fully operated and maintained by Microsoft support

Correct answer: A premium governance feature giving administrators enhanced control over environment policies and insights

Managed Environments is a premium Power Platform feature that enables admins to enforce sharing limits, solution checker policies, usage insights, and other advanced governance controls.

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

35 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