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

PL-100 practice questions

One question at a time. Build your PL-100 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 1Design and manage business solutions

A maker needs a canvas app that stores customer records in a table and lets users filter by city. Which Microsoft Power Platform component should hold the records so the app can query them with delegable filters?

  1. Power Automate flow variable
  2. Environment solution
  3. Microsoft Dataverse table Correct answer.
  4. Canvas app collection

Explanation

Dataverse is the platform's structured data service and supports delegation for many query operators, so filtering large tables in a canvas app returns complete results. Collections live only in the running app session and cannot back a delegable server-side query.

Question 2Design and manage business solutions

An architect wants role-based security enforced at the row level for Dataverse records, with different read and write rights per business unit. Which mechanism satisfies this requirement?

  1. SharePoint item-level permissions
  2. Power BI row-level security
  3. Canvas app screen visibility rules
  4. Dataverse security roles combined with business units Correct answer.

Explanation

Dataverse security roles define privileges and access levels, and business units scope which records a user can reach, which together deliver row-level control. App-level visibility rules only hide UI elements and do not protect the underlying data.

Question 3Design and manage business solutions

A team must ship the same app, flow, and custom table to development, test, and production environments. Which approach follows platform guidance?

  1. Copy component files directly between environment databases
  2. Package components in a solution and export/import it across environments Correct answer.
  3. Email the app package to makers in each environment
  4. Recreate each component manually in every environment

Explanation

Solutions are the supported unit for moving components between environments and for tracking dependencies and versions. Manual recreation and ad hoc file copying break dependency tracking and are not repeatable.

Question 4Design and manage business solutions

A canvas app needs a navigation pattern where users move between several screens without losing their place. Which built-in control or function is designed for this?

  1. Set function
  2. Patch function
  3. Navigate function with screen transitions Correct answer.
  4. Collect function

Explanation

The Navigate function changes the active screen and supports transition styles, which is the intended way to move between screens. Collect, Patch, and Set modify data or variables rather than changing screens.

Question 5Design and manage business solutions

A business analyst needs a model-driven app that presents accounts and related contacts. Which component defines the form layout users see when they open a record?

  1. Business process flow stage
  2. Dataverse table form Correct answer.
  3. Power Automate action
  4. Canvas app screen

Explanation

Model-driven apps render Dataverse table forms, and the form definition controls which fields and subgrids appear on a record. Business process flows guide stages but do not define the record form layout.

Question 6Design and manage business solutions

An organization wants to standardize reusable UI headers and colors across many canvas apps. Which feature is intended for this?

  1. Environment backup
  2. Dataverse calculated column
  3. Power Automate desktop flow
  4. Canvas app component library Correct answer.

Explanation

Component libraries let makers build reusable canvas controls and publish them so multiple apps can consume consistent UI elements. Calculated columns, desktop flows, and backups serve unrelated purposes.

Question 7Design and manage business solutions

A maker must ensure that a Dataverse table rejects records missing a required account number, even when records are created by an integration. Where should the constraint be enforced?

  1. Add a canvas app form validation rule
  2. Mark the column as required at the table level Correct answer.
  3. Add a Power Automate condition after creation
  4. Add a view filter on the table

Explanation

A required column is enforced by the Dataverse platform for all clients and integrations, not just one app. App-level validation and post-creation checks can be bypassed or run too late.

Question 8Design and manage business solutions

A team wants to automate approval routing when a Dataverse row is created. Which capability should the architect choose for a cloud-based, trigger-driven workflow?

  1. Power Automate cloud flow with a Dataverse trigger Correct answer.
  2. Canvas app timer control
  3. Model-driven app sitemap
  4. Dataverse business rule

Explanation

Power Automate cloud flows provide event-driven automation with connectors and a Dataverse trigger for row creation. Business rules run client-side logic on forms and cannot orchestrate multi-step approvals across services.

Question 9Design and manage business solutions

An architect is choosing between a canvas app and a model-driven app. The requirement is a pixel-precise kiosk interface with custom branding and no need for Dataverse forms. Which choice fits best?

  1. Power Pages site
  2. Canvas app Correct answer.
  3. Customer Insights journey
  4. Model-driven app

Explanation

Canvas apps give makers full control over layout and appearance, which suits pixel-precise branded interfaces. Model-driven apps generate UI from metadata and offer less layout control.

Question 10Design and manage business solutions

A solution contains a custom table, a cloud flow referencing it, and a canvas app. The team must deploy to production without the sample data used in development. What should the architect do?

  1. Copy the development environment database to production
  2. Export as unmanaged and delete records after import
  3. Export the solution as managed and exclude data when importing Correct answer.
  4. Recreate the flow manually in production

Explanation

Managed solutions protect components from unintended customization and support clean promotion, and configuration data can be handled separately from sample records. Unmanaged import into production leaves components editable and risks carrying unwanted data.

Question 11Design and manage business solutions

Users report they can see records from other business units in a Dataverse table. The security role grants Organization-level read on that table. What is the most likely cause?

  1. The app uses a view with a filter
  2. The table has auditing enabled
  3. The environment has a backup schedule
  4. The role's read privilege access level is set to Organization Correct answer.

Explanation

Access level on a privilege determines the scope of records a user can read, and Organization level grants read across the whole environment. Auditing, view filters, and backups do not widen record visibility.

Question 12Design and manage business solutions

A maker needs a canvas app to show a running total of expenses by category as users add items. Which approach is most appropriate?

  1. Use a collection with GroupBy and Sum in a gallery Correct answer.
  2. Create a new Dataverse table for each category
  3. Trigger a cloud flow on every keystroke
  4. Use a model-driven view grouped by owner

Explanation

Collections support in-memory aggregation functions such as GroupBy and Sum, which is efficient for live totals in the app. Creating tables per category or firing flows per keystroke adds unnecessary complexity and latency.

Question 13Design and manage business solutions

An architect must let external customers submit requests without a Microsoft 365 license, while data is stored in Dataverse. Which component should be used?

  1. Power Pages site with Dataverse as the data source Correct answer.
  2. Power Automate desktop flow
  3. Model-driven app in the internal environment
  4. Canvas app shared with external guests

Explanation

Power Pages provides external-facing websites with authentication options and can read and write Dataverse data for users without internal licenses. Sharing a canvas app with external guests typically still requires appropriate licensing and is not designed for anonymous public access.

Question 14Design and manage business solutions

A business rule on a Dataverse table must set a status field when another field changes, and it must apply in both model-driven and canvas apps. Which statement is accurate?

  1. Business rules can run on the server so they apply across clients Correct answer.
  2. Business rules require a Power Automate license
  3. Business rules only run inside model-driven forms
  4. Business rules only run inside canvas apps

Explanation

Dataverse business rules can be scoped to run on the server, which makes the logic apply regardless of the client. Client-only scope limits the rule to forms in model-driven apps.

Question 15Design and manage business solutions

A team wants to record who changed a sensitive field and when, and retain that history for audits. Which Dataverse capability should be enabled?

  1. Column-level security
  2. Duplicate detection rules
  3. Auditing on the table and column Correct answer.
  4. Alternate keys

Explanation

Dataverse auditing records create, update, and delete operations and can be scoped to specific tables and columns, providing an audit trail. Column-level security restricts access but does not record change history.

Question 16Design and manage business solutions

A canvas app must work offline for field technicians and sync records when connectivity returns. Which combination is the recommended pattern?

  1. SaveToLocalStorage or collections with explicit sync logic Correct answer.
  2. Direct Dataverse calls on every keystroke
  3. A model-driven app with server-side views
  4. A Power Automate scheduled flow only

Explanation

Offline scenarios require local storage of data plus explicit logic to reconcile changes when the connection returns. Direct server calls fail without connectivity, and server-only components cannot capture offline input.

Question 17Design and manage business solutions

An architect needs to enforce that a Dataverse column value is unique across all records. Which feature is designed for this?

  1. Rollup field
  2. Business rule
  3. Calculated column
  4. Alternate key Correct answer.

Explanation

Alternate keys define an alternate unique identifier for a table and enforce uniqueness on the specified columns. Calculated and rollup columns compute values, and business rules do not guarantee uniqueness across all records.

Question 18Design and manage business solutions

A maker is designing a model-driven app and needs users to follow a guided sequence of stages with required fields before advancing. Which component fits?

  1. Business process flow Correct answer.
  2. Dataverse view
  3. Canvas component library
  4. Power Automate approval

Explanation

Business process flows present a guided set of stages and can require fields before a user advances, which standardizes process adherence. Views and component libraries do not enforce staged progression.

Question 19Design and manage business solutions

A solution must be split so that a core set of tables is shared by several teams while each team adds its own apps. Which solution concept supports this?

  1. Segmented solutions with dependencies Correct answer.
  2. Environment variables
  3. A single unmanaged solution
  4. Connection references

Explanation

Segmented solutions let teams build on a shared foundation while managing dependencies between solution layers. A single unmanaged solution mixes ownership, and environment variables and connection references handle configuration rather than solution segmentation.

Question 20Design and manage business solutions

A canvas app uses a Dataverse table with 500,000 rows and filters by a text column. Users report missing results. What is the most likely cause?

  1. The app has too many screens
  2. The environment has auditing enabled
  3. The filter is not delegable and the app processes only a subset Correct answer.
  4. The table lacks an alternate key

Explanation

When a query is not delegable, the app processes only a limited number of records, which produces incomplete results on large tables. Adding keys, screens, or auditing does not change delegation behavior.

Question 21Design and manage business solutions

An architect must prevent makers from creating production flows that use a specific connector while allowing it in development. Which control achieves this?

  1. Solution checker
  2. Environment backup
  3. Connection reference
  4. Data loss prevention policy scoped to the production environment Correct answer.

Explanation

Data loss prevention policies classify connectors into groups and can be applied per environment to block or restrict connector use. Solution checker reviews solution quality and does not block connectors.

Question 22Design and manage business solutions

A company needs a single Dataverse environment strategy where developers can experiment but changes flow to production only after approval. Which pattern best meets this?

  1. Production-only environments with no development tier
  2. All makers working directly in production
  3. A single shared environment with no solution layering
  4. Developer environments feeding a managed solution pipeline to production Correct answer.

Explanation

Separate developer environments let makers experiment safely, and promoting managed solutions through an approval pipeline controls what reaches production. Direct production work or a single shared environment removes those safeguards.

Question 23Design and manage business solutions

Users in one business unit must read records owned by another business unit but must not update them. Which configuration achieves this with least privilege?

  1. Grant read at Business Unit level and no write privilege Correct answer.
  2. Grant read and write at Organization level
  3. Grant read at Organization level and write at User level
  4. Grant write at User level only

Explanation

Business Unit read access covers records within the business unit hierarchy as configured, and withholding write keeps the privilege minimal. Organization-level write or read grants broader access than required.

Question 24Design and manage business solutions

A solution includes a cloud flow that must connect to Dataverse in each environment with environment-specific credentials. Which feature should the architect use?

  1. Hard-coded credentials in the flow
  2. A canvas app collection
  3. A shared user account across environments
  4. Connection references with environment variables Correct answer.

Explanation

Connection references let a flow bind to a connection that is resolved per environment, and environment variables supply environment-specific values. Hard-coded credentials and shared accounts create security and maintenance risks.

Question 25Design and manage business solutions

An architect must ensure that a custom table's records are visible only to the owning user and their manager. Which Dataverse feature most directly supports this?

  1. Hierarchy security with a manager hierarchy Correct answer.
  2. Table auditing
  3. Alternate keys
  4. Rollup columns

Explanation

Hierarchy security models grant access along a defined manager hierarchy, which matches visibility for an owner and their manager. Auditing, rollups, and alternate keys do not grant record access.

Question 26Design and manage business solutions

A maker is planning the lifecycle of a Power Platform solution that will be promoted from development through test to production. Which Microsoft-recommended approach should the architect choose?

  1. Export unmanaged solutions to every environment and customize them there
  2. Store all components in a single default solution shared by every environment
  3. Build everything in the production environment and edit it in place
  4. Use managed solutions for downstream environments and unmanaged solutions only in development Correct answer.

Explanation

Microsoft's application lifecycle guidance keeps unmanaged solutions in the development environment and ships managed solutions to test and production so that downstream customizations are blocked and upgrades stay predictable. Managed solutions also support clean deletion and patching.

Question 27Design and manage business solutions

An architect needs a reusable component that bundles a custom table, its forms, views, and a related security role so it can be moved between environments as a unit. Which Power Platform construct should be used?

  1. A business process flow
  2. An environment variable
  3. A solution Correct answer.
  4. A model-driven app

Explanation

A solution is the container that packages components such as tables, forms, views, apps, flows, and security roles for transport between environments. It is the unit of ALM for Power Platform assets.

Question 28Design and manage business solutions

A maker wants to add a canvas app and a cloud flow to an existing unmanaged solution in the development environment. Which action accomplishes this?

  1. Export the app and flow as separate zip files and merge them manually
  2. Create a new publisher and delete the original app and flow
  3. Add the existing app and flow to the solution from the solution explorer Correct answer.
  4. Recreate the app and flow directly inside the target managed solution

Explanation

The solution explorer lets a maker add existing components, such as canvas apps and cloud flows, to a solution so they are tracked as part of that solution. Components created outside a solution otherwise live in the default solution and are easy to miss during export.

Question 29Design and manage business solutions

An architect is defining a publisher for a new solution. Which property of the publisher determines the prefix applied to newly created custom columns?

  1. The customization prefix Correct answer.
  2. The display name
  3. The version number
  4. The option value prefix

Explanation

The customization prefix set on the publisher is prepended to schema names of custom components created within solutions from that publisher. A stable, meaningful prefix avoids naming collisions when solutions from multiple publishers coexist.

Question 30Design and manage business solutions

A team needs distinct development, test, and production environments, each with its own Dataverse data and its own app configuration values. Which approach best supports this?

  1. Create separate environments and use environment variables with per-environment values Correct answer.
  2. Hardcode configuration values in the app and rebuild for each environment
  3. Use one environment and swap configuration values manually before each release
  4. Store configuration in a shared SharePoint list read by all environments

Explanation

Separate environments isolate data and configuration, and environment variables let the same solution carry different values per environment without code changes. This is the standard pattern for configuration that differs between stages.

Question 31Design and manage business solutions

An architect must ensure that a specific custom table and its components are removed cleanly from production if the project is cancelled. Which solution type makes this possible?

  1. Managed solution Correct answer.
  2. Default solution
  3. Unmanaged solution
  4. Patch solution

Explanation

Deleting a managed solution removes the components it introduced, provided no other solution depends on them. Unmanaged solutions leave components behind when deleted, so they do not support clean removal.

Question 32Design and manage business solutions

A maker needs to move a solution between two environments but must exclude sample data used during development. Which practice should the architect recommend?

  1. Export only the default solution to avoid including data
  2. Export the solution with all data and delete records after import
  3. Keep sample data out of the solution and use a separate data migration for required reference data Correct answer.
  4. Delete the sample data before every export and recreate it afterward

Explanation

Solutions should carry schema and configuration, while data is handled separately through tools such as the data migration utility or configuration migration. Keeping sample data out of the solution prevents it from reaching downstream environments.

Question 33Design and manage business solutions

An architect wants to prevent makers from creating new environments outside an approved set while still allowing them to build apps inside assigned environments. Which control should be used?

  1. Environment security roles
  2. Tenant environment creation governance in the admin center Correct answer.
  3. Business unit hierarchy
  4. Column-level security

Explanation

Power Platform admin center governance settings let administrators restrict who can create environments and which environment types are allowed. This controls environment sprawl without blocking app building inside approved environments.

Question 34Design and manage business solutions

A solution must be deployed to production with minimal downtime, and a small fix is needed to an already deployed managed solution. Which approach should the architect use?

  1. Re-export the entire unmanaged solution and overwrite production
  2. Edit the managed solution directly in production
  3. Create a patch solution, then clone it to a full solution at the next major release Correct answer.
  4. Delete the managed solution and reinstall the updated version

Explanation

A patch solution delivers incremental updates to a deployed managed solution without a full reinstall, and Microsoft recommends cloning patches into a new full solution at a major version. This supports low-downtime, incremental deployment.

Question 35Design and manage business solutions

An architect is choosing between a canvas app and a model-driven app for a scenario requiring pixel-precise branding and integration with a custom web API. Which choice fits best?

  1. Canvas app because it offers full control over layout and connectors Correct answer.
  2. Model-driven app because it auto-generates forms from Dataverse
  3. Power BI because it visualizes data
  4. Power Pages because it exposes data externally

Explanation

Canvas apps give makers pixel-level control over the interface and broad connector support, which suits custom branding and web API integration. Model-driven apps generate UI from metadata and offer less layout control.

Question 36Design and manage business solutions

A maker wants to reuse a consistent header and navigation across many canvas apps in the same solution. Which feature is designed for this?

  1. Business rule
  2. Component library Correct answer.
  3. Environment variable
  4. Security role

Explanation

Component libraries let makers build reusable canvas components, such as headers and navigation, and consume them across multiple canvas apps. Updates to the library propagate to consuming apps.

Question 37Design and manage business solutions

An architect needs to enforce that a Dataverse table rejects records missing a required account number, even when records are created through the Web API. Which approach is most reliable?

  1. A canvas app form with a required field
  2. A client-side JavaScript validation on the main form
  3. A Dataverse column marked as required at the table level Correct answer.
  4. A view filter that hides incomplete records

Explanation

Marking a column as required at the table level enforces the constraint at the platform layer, so it applies to all entry paths including the Web API and imports. Client-side or app-level validation only covers specific interfaces.

Question 38Design and manage business solutions

A team wants to automate an approval routing whenever a Dataverse row is created. Which capability should the architect choose?

  1. A Power BI dataflow
  2. A calculated column
  3. A Power Automate cloud flow with a Dataverse trigger Correct answer.
  4. A model-driven app business process flow

Explanation

Power Automate cloud flows can trigger on Dataverse row creation and then run approval actions. This is the standard automation path for event-driven approval routing.

Question 39Design and manage business solutions

An architect must let external customers submit requests without a Microsoft 365 license while storing the data in Dataverse. Which approach should be used?

  1. Canvas app shared with external users
  2. Model-driven app with guest access
  3. Power Apps per-user license for each customer
  4. Power Pages site with Dataverse integration Correct answer.

Explanation

Power Pages provides external-facing websites that authenticate external users and integrate with Dataverse without requiring Microsoft 365 licenses. It is the intended choice for external submission scenarios.

Question 40Design and manage business solutions

A business rule on a Dataverse table must set a status field when another field changes, and it must apply in both model-driven and canvas apps. Which statement about business rules is correct?

  1. Business rules run on the server and apply across clients Correct answer.
  2. Business rules run only in model-driven apps
  3. Business rules run only when a form is opened
  4. Business rules require a plugin to execute

Explanation

Table-level business rules execute on the server, so they apply consistently across model-driven apps, canvas apps, and API operations. This makes them suitable for logic that must hold everywhere.

Question 41Design and manage business solutions

A team wants to record who changed a sensitive field and when, and retain that history for audits. Which Dataverse capability should be used?

  1. Change tracking
  2. Rollup columns
  3. Auditing Correct answer.
  4. Calculated columns

Explanation

Dataverse auditing records changes to records and fields, including who made the change and when, and retains the history for review. It is the feature designed for audit trails.

Question 42Design and manage business solutions

Users in one business unit must read records owned by another business unit but must not update them. Which configuration achieves this?

  1. Move the records to the users' business unit
  2. Grant the users a security role with Write privilege at organization level
  3. Grant the users a security role with Read privilege at business unit level Correct answer.
  4. Assign the users the System Administrator role

Explanation

Privilege depth determines the scope at which an operation is allowed. Granting Read at business unit level lets users read records owned by that business unit while withholding Write prevents updates.

Question 43Design and manage business solutions

An architect must ensure that a custom table's records are visible only to the owning user and their manager. Which Dataverse feature should be used?

  1. Column-level security
  2. Field-level auditing
  3. Organization-owned table
  4. Manager hierarchy with a hierarchy security model Correct answer.

Explanation

Hierarchy security models, combined with the manager hierarchy, extend record access to managers over their reports' records. This provides the required owner-and-manager visibility.

Question 44Design and manage business solutions

A solution includes a cloud flow that must connect to Dataverse in each environment with environment-specific credentials. Which approach should the architect use?

  1. Use a connection reference so each environment supplies its own connection Correct answer.
  2. Create a separate flow for each environment outside the solution
  3. Hardcode credentials in the flow definition
  4. Store credentials in a Dataverse table read by the flow

Explanation

Connection references decouple a flow from a specific connection so that each environment can bind its own connection during deployment. This is the supported ALM pattern for environment-specific credentials.

Question 45Design and manage business solutions

An architect must prevent makers from creating production flows that use a specific connector while allowing it in development. Which control should be used?

  1. Environment variables
  2. Business unit security roles
  3. Data loss prevention policies scoped by environment Correct answer.
  4. Conditional access policies

Explanation

Data loss prevention policies define connector classification and can be applied per environment, blocking a connector in production while permitting it in development. This provides connector-level governance.

Question 46Design and manage business solutions

A company needs a single Dataverse environment strategy where developers can experiment but changes flow to production only after approval. Which approach aligns with Microsoft guidance?

  1. Use a development environment with source control and a gated release pipeline to production Correct answer.
  2. Give every developer a personal production environment
  3. Use one shared environment for all stages and rely on manual testing
  4. Developers work directly in production with change approval afterward

Explanation

Microsoft's ALM guidance separates development from production and uses source control and automated, gated pipelines to promote solutions. This lets developers experiment safely while production changes require approval.

Question 47Design and manage business solutions

An architect must ensure that a canvas app works offline for field technicians and syncs records when connectivity returns. Which combination is the intended approach?

  1. Use the canvas app offline profile with Dataverse and a sync-on-reconnect pattern Correct answer.
  2. Use a model-driven app with no offline configuration
  3. Use a SharePoint list accessed through a browser
  4. Use Power BI offline caching

Explanation

Canvas apps support an offline profile that caches Dataverse data on the device and syncs changes when connectivity returns. This is the intended pattern for field scenarios with intermittent connectivity.

Question 48Design and manage business solutions

A team wants to split a solution so that a core set of tables is shared by several teams while each team adds its own apps. Which approach supports this?

  1. Separate unrelated environments per team with no shared tables
  2. One large unmanaged solution edited by all teams
  3. A base managed solution with dependent solutions that add team-specific components Correct answer.
  4. A single default solution for all teams

Explanation

Layering a base managed solution with dependent solutions lets teams extend shared tables with their own apps without conflicting edits. It preserves a single source of truth for core components.

Question 49Design and manage business solutions

An architect needs a model-driven app where users follow a guided sequence of stages with required fields before advancing. Which feature should be used?

  1. A dashboard
  2. A Power Automate approval
  3. A business process flow Correct answer.
  4. A canvas app screen

Explanation

Business process flows guide users through defined stages and can require fields before advancing to the next stage. They are the model-driven feature for structured, stage-based processes.

Question 50Design and manage business solutions

A maker is building a Power Apps solution and wants to package a canvas app, a custom table, and a cloud flow so they can be transported together to another environment. Which concept describes this container?

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

Explanation

A solution is the packaging mechanism that groups apps, tables, flows, and other components so they can be exported and imported between environments as a single unit. Environments are the hosting containers, publishers set a customization prefix, and connection references decouple flows from specific credentials.