Microsoft Power Platform Developer

Question 1

A logistics company uses a Dataverse-based model-driven app to manage thousands of daily shipment records. The finance department needs a nightly export of aggregated shipment data into an existing Azure SQL Database for their reporting warehouse. The export must run unattended, transform the data, and handle large batches reliably without requiring users to be signed in. As the Power Platform developer, which integration approach should you recommend?

Accepted Answer

Use an Azure Synapse Link for Dataverse to continuously replicate tables, then run an Azure Data Factory pipeline on a nightly schedule to aggregate into Azure SQL

Answer

Build a scheduled Power Automate cloud flow that queries Dataverse and inserts rows into Azure SQL using the SQL Server connector

Answer

Register a Dataverse plug-in on the shipment table's Create message to write each record to Azure SQL synchronously

Answer

Create a canvas app screen with a button that finance staff click each night to trigger the export via Power Fx Patch calls to a custom connector

Question 2

A developer defines a new alternate key on the Account table combining two columns to support an integration that uses UpsertRequest with that key. Immediately after saving the key definition in the maker portal, the integration begins sending upsert calls, but they fail with an error indicating the alternate key is not usable. What is the most likely cause?

Accepted Answer

Alternate keys require a supporting database index that is created by an asynchronous system job, and the key is not usable until that job completes and the key status becomes Active.

Answer

Alternate keys cannot be composed of more than one column, so the definition is invalid and must be reduced to a single column.

Answer

UpsertRequest does not support alternate keys and only works with the primary GUID, so the integration must be rewritten to query first.

Answer

The columns used in the alternate key must be of type Lookup, and text or number columns cannot participate in an alternate key.

Question 3

You are designing a custom connector that a Power Automate cloud flow will use to call a third-party payroll REST API. The API requires each request to include an OAuth 2.0 access token issued by the vendor's Microsoft Entra ID tenant, and the vendor wants the connector to prompt each user to sign in with their own vendor account so that per-user audit logs are maintained. Which authentication type should you configure on the custom connector?

Accepted Answer

OAuth 2.0 with the generic provider, configured with the vendor's authorization and token URLs

Answer

API Key authentication, storing the vendor's shared secret in the connector definition

Answer

Basic authentication using a single service account username and password

Answer

No authentication, and pass a static bearer token in a custom header policy

Question 4

A backend Azure Function runs on a nightly schedule with no user present. It must write records to Dataverse using the Web API. The security team requires that the integration authenticate without storing or using any interactive user credentials, and each API call must be attributed to a non-interactive identity. What authentication approach should you design?

Accepted Answer

Register an app in Microsoft Entra ID, configure it as an application user in the Power Platform environment, and use the OAuth 2.0 client credentials flow with a certificate.

Answer

Use the OAuth 2.0 authorization code flow with a dedicated service account mailbox and store the refresh token in Azure Key Vault.

Answer

Enable Windows integrated authentication on the Azure Function and pass the machine identity to Dataverse.

Answer

Use the resource owner password credentials (ROPC) flow with the credentials of a licensed named user assigned a system administrator role.

Question 5

A model-driven app form has a lookup to the Account table. When a user selects an account, the sales rep needs the account's phone number and preferred contact method copied into fields on the current record immediately, before the record is saved. The copied values do not need to be validated or persisted server-side until save. Company policy states you should minimize both server load and licensing costs by avoiding server-side processing for purely presentational, pre-save behavior. What is the most appropriate way to implement this?

Accepted Answer

Write a client-side JavaScript function registered on the OnChange event of the lookup that retrieves the account values via the Web API and sets the form fields.

Answer

Create a synchronous plug-in registered on the PreOperation stage of the Update message to copy the values.

Answer

Build a Power Automate cloud flow triggered when the record is modified to look up the account and update the fields.

Answer

Configure a Dataverse business rule that sets the fields based on the lookup value.

Question 6

Your Dataverse environment generates thousands of account update events per minute that must be streamed to a downstream analytics platform capable of ingesting large volumes of data with consumer groups for parallel processing. You use the Plug-in Registration Tool to register a service endpoint. Which endpoint contract type should you select to best match this high-throughput streaming requirement?

Accepted Answer

Azure Event Hub

Answer

Azure Service Bus Queue

Answer

Webhook (REST)

Answer

Azure Service Bus Topic

Question 7

A developer is building an Azure Function that must process a large batch of Dataverse records, calling an external API for each record. The total operation frequently exceeds 10 minutes and must survive host restarts, track progress across steps, and be triggered on demand from a Power Automate flow. The function currently runs on the Consumption plan and times out. Which approach best meets these requirements?

Accepted Answer

Refactor the logic into a Durable Functions orchestration with activity functions, keeping state in the Durable Task framework and exposing an HTTP-trigger starter.

Answer

Increase the functionTimeout setting in host.json to 60 minutes and keep the single HTTP-triggered function on the Consumption plan.

Answer

Move all record processing into a synchronous Dataverse plug-in registered on a custom API so it runs inside the platform transaction.

Answer

Split the work into multiple parallel HTTP requests from Power Automate using an Apply to each loop with concurrency enabled against the same function.

Question 8

You are building an Azure Function (running on an App Service plan) that must call the Dataverse Web API to update account records nightly. Security policy prohibits storing any client secrets or certificates in application settings or code. The Function should authenticate to Dataverse using its own identity. Which approach should you implement?

Accepted Answer

Enable a system-assigned managed identity on the Function, create an application user in Dataverse mapped to that identity, and acquire a token for the Dataverse resource using the managed identity.

Answer

Register an app in Microsoft Entra ID, generate a client secret, store it in the Function's application settings, and use the client credentials flow to authenticate.

Answer

Store an administrator's username and password in Azure Key Vault and use the resource owner password credentials (ROPC) flow to obtain a Dataverse token.

Answer

Use the Function's built-in App Service authentication (Easy Auth) with an interactive login to acquire a delegated Dataverse token at runtime.

Question 9

Your Dataverse environment must offload heavy order-processing logic to Azure. When an order record reaches the 'Approved' status, a message should be sent to an Azure resource that reliably queues the work, and an Azure Function must automatically process each message as it arrives without polling or a schedule. You need to choose the trigger type for the Azure Function and the mechanism to deliver Dataverse events to it. Which approach meets these requirements with the least custom code?

Accepted Answer

Register a Dataverse service endpoint (Azure Service Bus) via the Plug-in Registration Tool and use a Service Bus queue trigger on the Azure Function.

Answer

Create an Azure Function with a Timer trigger that queries Dataverse every minute for approved orders using the Web API.

Answer

Register a synchronous plug-in on Update that calls the Azure Function's HTTP endpoint directly during the Dataverse transaction.

Answer

Configure a Power Automate cloud flow with a recurrence trigger that reads approved orders and posts them to an HTTP-triggered Azure Function.

Question 10

You need to build an Azure Function that runs automatically every night at 2:00 AM to archive stale Dataverse records. The function must start on a fixed schedule without any external caller invoking it, and it should be inexpensive to host. Which trigger type should you use for the Azure Function?

Accepted Answer

A Timer trigger configured with a CRON expression

Answer

An HTTP trigger invoked by a Power Automate scheduled cloud flow

Answer

A Dataverse (Microsoft Dataverse) trigger bound to the record's update event

Answer

A Queue trigger listening to an Azure Storage queue

Question 11

A canvas app has an edit form bound to a Dataverse Account record. On the form you replaced the default data card control for the 'Primary Contact' lookup with a custom Combo box that shows contacts from the Contacts table. When a user opens an existing account, the Combo box appears empty even though the record already has a Primary Contact set. You need the Combo box to display the account's current Primary Contact when the form loads, while still allowing the user to change it. What should you do?

Accepted Answer

Set the Combo box DefaultSelectedItems property to ThisItem.'Primary Contact' (the parent data card's Default), keeping Items pointed at the Contacts source.

Answer

Set the Combo box Items property to a filtered Contacts list equal to the current Primary Contact so only that record shows.

Answer

Add an OnVisible formula on the screen that runs Reset() against the Combo box each time the form opens.

Answer

Set the Combo box Default property to ThisItem.'Primary Contact'.'Full Name'.

Question 12

Your team maintains a canvas component library containing a branded header component that is consumed by six separate canvas apps across the environment. You publish a new version of the library that fixes a layout bug in the header component. Several app makers report that their apps still show the old buggy header even after you published the library. What must happen for the fix to appear in the consuming apps?

Accepted Answer

Each consuming app must be edited in Power Apps Studio, where the maker accepts the update notification for the component and then republishes the app.

Answer

The library must be exported and re-imported as a managed solution before consuming apps can detect the change.

Answer

Publishing the library automatically forces all consuming apps to rebuild at runtime, so the makers only need to clear their browser cache.

Answer

The component must be recreated from scratch in each app because component library updates only apply to newly created apps.

Question 13

A retail company has five separate canvas apps, each maintained by a different team. All five apps need to display a standardized product-search bar with identical layout, styling, and behavior. Leadership wants a single definition of this search bar that, when updated, can be propagated to every app with minimal manual effort, while still allowing each app to pass in its own data source. Which approach best meets these requirements?

Accepted Answer

Build the search bar as a canvas component published in a component library, then import that library into each of the five apps.

Answer

Develop the search bar as a PCF code component and add it to each canvas app's screen individually.

Answer

Recreate the search bar controls manually on a screen in each app and copy-paste the formulas between them.

Answer

Create a custom API in Dataverse that returns the search bar markup and call it from each app.

Question 14

A canvas app has a Dropdown control whose Items property must show the unique Region values from a Dataverse table named Accounts that contains 250,000 records. Makers report that only a subset of regions appears in the dropdown. You must ensure ALL distinct regions are available for selection while keeping the app performant. What should you do?

Accepted Answer

Create a Dataverse choice (option set) column for Region and bind the Dropdown Items to that choice column's options.

Answer

Set the Dropdown Items to Distinct(Accounts, Region), because Distinct is delegable to Dataverse and will return every unique value.

Answer

Increase the app's Data row limit for non-delegable queries setting to 2000 and keep using Distinct(Accounts, Region).

Answer

Use a Power Automate flow triggered on OnStart that returns all Accounts, then apply Distinct on the returned collection.

Question 15

A canvas app lets field technicians submit inspection records to a Dataverse table using a Patch call inside an OnSelect. Occasionally the Patch fails due to a required-field business rule violation or a transient network error, and the technician sees no feedback while the record is silently lost. You must ensure that any failure is caught, the technician is shown a friendly message, and successful saves navigate to a confirmation screen. Which approach should you implement?

Accepted Answer

Wrap the Patch in IfError(), inspecting FirstError.Message to display a Notify() on failure and navigating on success, and set Formula-level error management on in App settings.

Answer

Set the DetailForm's OnFailure and OnSuccess properties, then call SubmitForm() from OnSelect instead of Patch().

Answer

Add a Timer control that polls the record after Patch to verify it was written, then Notify() the technician based on the poll result.

Answer

Enable the Errors() function on the data source and bind a gallery to it so the technician can review any accumulated Dataverse errors after submitting.

Question 16

A canvas app displays outstanding purchase orders in a gallery bound to a collection named colOrders that was populated in App.OnStart using ClearCollect against a Dataverse table. Users report that when a colleague approves an order in a separate model-driven app, the canvas gallery continues to show the approved order as pending until the user closes and reopens the canvas app. The maker wants the gallery to reflect the latest server data whenever the user taps a 'Refresh' button, without rebuilding the collection logic in multiple places. Which approach should the maker implement?

Accepted Answer

Bind the gallery directly to the Dataverse table and call Refresh(Orders) in the button's OnSelect.

Answer

Add Refresh(colOrders) to the button's OnSelect so the collection re-queries the server.

Answer

Move the ClearCollect statement to the Screen.OnVisible instead of App.OnStart.

Answer

Call Set(varRefresh, Now()) in the button and reference varRefresh in the gallery's Items property.

Question 17

A canvas app displays a gallery bound to a Dataverse table named Orders that contains over 80,000 records. You configure the gallery's Items property to sort the orders by the OrderTotal column in descending order and show only orders where Status equals 'Open'. Testers report the gallery appears to only work with a small subset of the data, and a blue underline warning appears in the formula bar. You need to ensure all matching records are considered while keeping the query delegable to the server. Which approach should you use?

Accepted Answer

Use SortByColumns(Filter(Orders, Status = 'Status'.Open), "ordertotal", SortOrder.Descending) so both the filter and sort are delegated to Dataverse.

Answer

Wrap the expression in a ForAll loop over Orders and manually build a collection sorted in memory.

Answer

Increase the app's data row limit for non-delegable queries to 2,000 in the app settings and keep using Sort with a nested Filter that references a variable.

Answer

Load the entire Orders table into a collection with ClearCollect on OnStart, then apply Filter and Sort against the collection in the gallery.

Question 18

A canvas app displays a gallery of 400 product records from Dataverse. Each gallery item shows a product image stored as a URL in the record. Users report that the screen takes a long time to render when it first opens, and scrolling is sluggish. Delegation is already correctly configured and the query returns quickly. You need to improve the perceived load time and scrolling smoothness with the least redesign effort. What should you do?

Accepted Answer

Set the gallery's Image control to load images only when items become visible by leaving the default virtualization behavior and reducing the number of controls per gallery template.

Answer

Increase the app's Data row limit for non-delegable queries setting to 2000 so all records and images load at once during OnStart.

Answer

Move the entire product collection into a Collect() call inside OnStart so the gallery reads only from local memory.

Answer

Wrap the gallery's Items property in a ForAll() that pre-fetches every image URL into a variable before display.

Question 19

A canvas app lets warehouse staff submit an inventory count. When the user taps a button, the app must call a Power Automate cloud flow that validates the count against an external ERP system and returns a calculated variance value plus a status message. The app needs to display the returned variance and status on the same screen immediately after the flow finishes. Which approach correctly returns and consumes the flow's data in the canvas app?

Accepted Answer

In the flow, add a 'Respond to a PowerApps or flow' action that returns variance and status as outputs, then in the button OnSelect use Set(varResult, MyFlow.Run(InputCount)) and reference varResult.variance and varResult.status.

Answer

In the flow, write the variance and status to a Dataverse table, then in the button OnSelect call MyFlow.Run(InputCount) and immediately read the values with a LookUp against that table.

Answer

In the flow, use the 'Send an HTTP request' action to post results back, then in the app parse the response using ParseJSON(MyFlow.Run(InputCount).result).

Answer

In the flow, add a Compose action with the variance and status, then in the button OnSelect use MyFlow.Run(InputCount) and read MyFlow.Outputs.variance directly.

Question 20

A canvas app displays a gallery bound to a Dataverse table containing over 50,000 rows. Users report that when they type a supplier name into a text input used to filter the gallery, only some matching suppliers appear even though more exist. The formula uses Filter() with a comparison the app builder believes should work. You open Monitor while reproducing the issue. Which observation in Monitor most directly confirms the root cause?

Accepted Answer

A network event showing the Dataverse query returning exactly 500 rows before the client-side filter is applied, indicating non-delegable evaluation.

Answer

Multiple duplicate getRows events firing on every keystroke, indicating the gallery is refreshing too aggressively.

Answer

A warning event indicating the concurrent function partially failed to load one of the data sources at startup.

Answer

An HTTP 429 throttling response on the filter query, showing the environment is rate-limiting the requests.

Question 21

A model-driven app's main account form takes several seconds to load. Users report the delay happens before the form becomes interactive. You want to identify which OnLoad JavaScript handlers, business rules, and Web API retrieve calls consume the most time during the form load, without adding logging code to every script. Which tool and approach should you use to diagnose the bottleneck?

Accepted Answer

Open the Monitor tool from the model-driven app and play the session to inspect the timeline of form events, script execution, and network requests with their durations.

Answer

Enable Power Apps checker on the solution and review the analysis report for performance recommendations on the form.

Answer

Add console.time and console.timeEnd statements around every OnLoad handler and read the results in the browser console.

Answer

Export the form as a solution and inspect the customizations.xml to count the registered event handlers and business rules.

Question 22

A field technician canvas app connects to a Dataverse table of maintenance tasks. Technicians frequently work in areas with no network connectivity. The app must let them view previously loaded task data and record status updates while offline, then reconcile the changes when connectivity returns. Which approach should you implement to persist the task data locally and allow it to be reloaded when the device is offline?

Accepted Answer

Use SaveData to write a local collection to device storage after loading tasks, and LoadData to restore it in OnStart when the app opens offline.

Answer

Store the tasks in a global variable with Set in OnStart and rely on the variable persisting between sessions.

Answer

Enable the app's Delayed load setting and wrap all data calls in Concurrent so they cache automatically.

Answer

Create a Power Automate cloud flow that emails the technician a copy of the task list each morning.

Question 23

A canvas app's OnStart currently calls ClearCollect to load the current user's employee profile record from Dataverse into a collection named colProfile, and screens reference First(colProfile).Department. A senior developer asks you to reduce startup overhead and simplify formulas, since only a single record is ever needed and it should be cached in memory for the session. What is the most appropriate change?

Accepted Answer

Replace the ClearCollect with a Set that stores the LookUp result in a global variable, then reference the variable's Department field directly.

Answer

Keep the ClearCollect but wrap it in a Concurrent function to force parallel evaluation.

Answer

Move the ClearCollect to the App.OnVisible property so it only runs when a screen loads.

Answer

Replace ClearCollect with Collect so the record is appended rather than cleared and recreated each session.

Question 24

A canvas app displays an order-approval gallery bound to a Dataverse table. Managers report that approvals made by colleagues on other devices do not appear until they close and reopen the app. You must make new and changed records visible automatically while minimizing unnecessary server calls and preserving delegation. Which approach best meets these requirements?

Accepted Answer

Place a Timer control on the screen with Repeat set to true and an interval of 30 seconds, and call Refresh(Orders) in the timer's OnTimerEnd.

Answer

Load all records into a collection with ClearCollect in App.OnStart and bind the gallery to that collection.

Answer

Set the gallery's Items to Refresh(Orders) so the data source re-queries on every render.

Answer

Add a Refresh(Orders) call in the gallery's OnSelect so data updates when a manager taps a row.

Question 25

A canvas app has a Home screen with a gallery of customer records and a Details screen. When a user selects a customer in the gallery, you must open the Details screen and display that specific customer's data. The Details screen must continue to show the correct record even if the user navigates away and returns, and you want to avoid relying on the gallery's Selected property after navigation. Which approach best accomplishes this?

Accepted Answer

On the gallery item OnSelect, call Set(gblSelectedCustomer, ThisItem); Navigate(DetailsScreen, ScreenTransition.Cover), and bind the Details controls to gblSelectedCustomer.

Answer

On the gallery item OnSelect, call Navigate(DetailsScreen) only, and bind the Details controls to Gallery1.Selected.

Answer

On the DetailsScreen OnVisible, call Collect(colCustomer, Gallery1.Selected) and bind the controls to First(colCustomer).

Answer

On the gallery item OnSelect, call UpdateContext({locCustomer: ThisItem}); Navigate(DetailsScreen), and bind the Details controls to locCustomer.

Question 26

A canvas app screen calculates order totals in several controls. Each control repeatedly calls LookUp(Customers, CustomerID = varOrder.CustomerID) to fetch the same customer record, and then reads different fields (discount rate, region, credit limit) from the result. Users report the screen feels sluggish because the same Dataverse record is retrieved multiple times. You want to retrieve the record once and reference its fields across the calculations in a single, readable formula. Which Power Fx approach best achieves this?

Accepted Answer

Wrap the calculations in a With() function that binds the LookUp result to a named record, then reference the fields from that named record.

Answer

Wrap the calculations in a Concurrent() function so all the LookUp calls execute in parallel and finish faster.

Answer

Replace each LookUp with a Filter() call and use First() to grab the record in every control.

Answer

Move the LookUp into the screen's OnVisible and store the result in a collection with Collect().

Question 27

You are building a nightly integration that copies only the records that changed in the Dataverse 'account' table since the previous run into an external reporting database. You want the Dataverse Web API to return both created/updated records and information about deleted records without you having to manually compare snapshots. What must you do first to enable this approach?

Accepted Answer

Enable change tracking on the account table, then persist the delta link (deltatoken) returned by the query and pass it on the next run.

Answer

Create an alternate key on the account table and use it to filter records modified after the last run.

Answer

Register a webhook via the Plug-in Registration Tool so Dataverse pushes every account change to your integration in real time.

Answer

Query the audit history table on each run and reconcile the changes manually against your reporting database.

Question 28

You are building a nightly console application that synchronizes Account records from Dataverse to an external reporting database. Change tracking is enabled on the Account table. On the very first run, your code calls RetrieveEntityChangesRequest without supplying a DataVersion (delta token). What happens, and what should your code do to prepare for future incremental runs?

Accepted Answer

Dataverse returns a full snapshot of all Account records, and you should persist the returned EntityChangesResult.DataToken to pass as DataVersion on the next run.

Answer

The request fails because a DataVersion token is mandatory; you must first call a separate initialization API before any changes can be retrieved.

Answer

Dataverse returns only records modified in the last 24 hours, so you must run the sync repeatedly on the first day to capture older records.

Answer

The request returns no records until at least one Account is modified after change tracking is enabled, so the initial database load must be done manually.

Question 29

You are building a nightly integration that copies newly created and modified Account records from Dataverse into an external reporting database. The Account table contains several million rows, and a full extract each night is too slow and consumes excessive API capacity. You want each run to retrieve only the records that changed since the previous run, including deletions, with minimal custom code. Which Dataverse capability should you use?

Accepted Answer

Enable change tracking on the Account table and use the RetrieveEntityChanges message, persisting the returned data token between runs

Answer

Register a synchronous post-operation plug-in on Create and Update of Account that writes each change to the external database

Answer

Query Accounts each night with a FetchXML filter on the modifiedon field greater than the last run timestamp

Answer

Define an alternate key on the Account table and issue UpsertRequest calls for every record each night

Question 30

You are building a nightly synchronization process that copies new and updated Account records from Dataverse to an external reporting database. Change tracking is enabled on the Account table. On the first run you must retrieve all records and store a marker so that subsequent runs return only the records that changed since the previous run. Which Dataverse Web API request technique correctly retrieves the incremental changes on later runs?

Accepted Answer

Add the 'Prefer: odata.track-changes' header to the account query, persist the returned @odata.deltaLink, and call that delta link URL on subsequent runs.

Answer

Send a RetrieveMultiple query with an ORDER BY on the modifiedon column and store the highest modifiedon value to filter the next run.

Answer

Enable auditing on the Account table and read the audit history entities to determine which records changed.

Answer

Use the RetrieveRecordChangeHistoryRequest for each Account to detect field-level changes since the last sync.

Question 31

A field service team uses tablets to inspect equipment at remote sites with intermittent connectivity. Inspectors must capture data, photos, and a signature, and the app must reliably work offline and sync automatically when connectivity returns. The data is stored in Dataverse and technicians are already licensed for the Field Service and model-driven mobile experiences. As the developer, which approach best satisfies the offline-first requirement with the least custom code?

Accepted Answer

Build a model-driven app and configure a mobile offline profile so the Power Apps mobile app synchronizes Dataverse tables automatically

Answer

Build a canvas app and enable the built-in offline profile with explicit LoadData/SaveData calls to a local cache

Answer

Build a PCF code component that stores inspection data in the browser IndexedDB and posts it to the Web API when online

Answer

Build a Power Automate cloud flow triggered on record creation to queue and retry data submission from the device

Question 32

A developer must expose a complex business operation—'Recalculate Contract Pricing'—that is triggered from a model-driven form command button, from several Power Automate cloud flows, and from an external system via the Dataverse Web API. The operation must run server-side, participate in the same database transaction as other Dataverse writes, accept typed input parameters, and return a typed response. It should be callable as a single named message across all these consumers. Which Dataverse code component should the developer build?

Accepted Answer

A custom API (custom message) implemented with a plug-in registered on its main operation

Answer

A synchronous plug-in registered on the Update message of the Contract table

Answer

A custom connector wrapping an Azure Function that calls back into Dataverse

Answer

A Power Fx low-code plug-in invoked from a business rule

Question 33

You are designing a Dataverse solution for a conference-management app. During each event, the app writes millions of short-lived attendee session-scan records within a few hours, with unpredictable write bursts. The records are queried mainly by a single session key, require no complex relational joins or roll-up columns, and are purged shortly after each event. You must minimize write throttling during spikes and control storage cost. Which table type should you use?

Accepted Answer

An elastic table in Dataverse

Answer

A standard Dataverse table with a set of business rules for validation

Answer

A virtual table connected to an external data source

Answer

A standard Dataverse table with change tracking enabled

Question 34

Your team maintains a Dataverse solution called SalesCore in a dedicated Dev environment. You are building an Azure DevOps YAML pipeline using the Power Platform Build Tools to automate deployment to Test and Production. The goal is to ensure that the artifact deployed to downstream environments cannot be edited directly in those environments, while keeping the unmanaged source in Dev available for continued development. Which sequence of Build Tools tasks should the CI pipeline perform against the Dev environment?

Accepted Answer

Export the solution as managed from Dev and store the managed artifact, keeping the unmanaged solution in Dev for ongoing development.

Answer

Export the solution as unmanaged, then check it into source control and import the unmanaged solution into Test and Production.

Answer

Export the solution as managed from Dev, publish customizations, then import the managed solution directly into Dev before deploying.

Answer

Clone the solution as a patch, export the patch as unmanaged, and import it into Test and Production as the deployable artifact.

Question 35

You are developing client scripting for a model-driven app account form. Requirements: when the user changes the 'Primary Contact' lookup, you must immediately requery a related phone number and populate a text field, but this logic must NOT run when the form first loads with an existing record. You have written a JavaScript function that performs the requery. How should you register the handler so it meets the requirement using supported approaches?

Accepted Answer

Register the function on the OnChange event of the Primary Contact column, using the form event handler registration in the form designer.

Answer

Register the function on the form OnLoad event and inside it call formContext.data.entity.attributes for the lookup value.

Answer

Register the function on the form OnSave event so it fires whenever the record is committed.

Answer

Add addOnChange to the lookup inside the OnLoad handler, but also fire the handler manually during OnLoad using fireOnChange.

Question 36

You are registering a JavaScript function on the OnChange event of the 'creditlimit' field in a model-driven app account form. Inside your function, you need reliable access to the form's formContext so you can read and update other fields. Your function signature is defined as 'function validateCreditLimit(executionContext)'. What must you configure in the event handler registration to ensure formContext is available?

Accepted Answer

Enable the 'Pass execution context as first parameter' checkbox in the event handler properties

Answer

Add 'formContext' as a literal comma-separated parameter value in the event handler's parameter field

Answer

Call Xrm.Page.getFormContext() at the top of the function to obtain the context

Answer

Register the function on the form OnLoad event instead, since OnChange does not expose formContext

Question 37

You are writing a JavaScript function for a model-driven app's Account form OnLoad event. The function must read and update fields on the form. Your organization enforces current best practices for the Client API object model and prohibits deprecated globals. How should your function obtain the object needed to access form data?

Accepted Answer

Register the handler with 'Pass execution context as first parameter' enabled, then call executionContext.getFormContext() to obtain the form context.

Answer

Use the global Xrm.Page object directly inside the function to access form attributes and controls.

Answer

Call Xrm.WebApi.retrieveRecord in the function to fetch the record, then bind the returned values to the form manually.

Answer

Use Xrm.Utility.getGlobalContext() to obtain the context and read the form attributes from it.

Question 38

You are writing an OnChange event handler in a model-driven app form. When a user selects a value in the 'Primary Contact' lookup field, your JavaScript must read the selected record's GUID and entity logical name to pass into a subsequent Xrm.WebApi retrieve call. Which Client API expression correctly returns the data you need?

Accepted Answer

formContext.getAttribute("primarycontactid").getValue() returns an array of lookup objects that expose id, name, and entityType.

Answer

formContext.getControl("primarycontactid").getValue() returns a single string containing the GUID only.

Answer

formContext.getAttribute("primarycontactid").getText() returns an object with id and entityType properties.

Answer

Xrm.Page.data.entity.attributes.getValue("primarycontactid") returns the entityType but not the id.

Question 39

A developer writes a JavaScript function registered on the OnSave event of the Account form in a model-driven app. When a required credit-check field is missing, the function must display a modal error message with an OK button that the user must acknowledge, and it must prevent the save from completing. Which combination correctly meets these requirements using the Client API object model?

Accepted Answer

Call executionContext.getEventArgs().preventDefault() to stop the save, then call Xrm.Navigation.openAlertDialog() to show the modal message.

Answer

Call formContext.ui.setFormNotification() with a level of 'ERROR', which both blocks the save and displays a dismissible modal dialog.

Answer

Call Xrm.Navigation.openConfirmDialog() to display the message and rely on its return value to automatically cancel the save operation.

Answer

Call Xrm.Utility.alertDialog() to display the message; the save is blocked automatically whenever an alert dialog is shown on OnSave.

Question 40

In a model-driven app, a developer must display a persistent warning banner at the top of the Account form when the annual revenue exceeds a threshold, and the banner must automatically disappear when the value is corrected. The developer writes an OnChange handler for the revenue field. Which combination of Client API methods should be used to show and later remove the message?

Accepted Answer

formContext.ui.setFormNotification(message, level, uniqueId) to show it, and formContext.ui.clearFormNotification(uniqueId) when the value is valid

Answer

Xrm.Navigation.openAlertDialog(message) to show it, and Xrm.Navigation.openErrorDialog() to dismiss it

Answer

formContext.getControl('revenue').setNotification(message) to show it, with no clear call needed because it auto-expires

Answer

Xrm.App.addGlobalNotification(message, level, type) to show it, and there is no way to remove it programmatically

Question 41

On the Account form, you write a JavaScript function registered on the form OnLoad event that must retrieve the credit limit from a related parent account record and display it in a warning notification. The account record ID is available from the form context. Which Client API approach should you use to retrieve the related record data efficiently within the client script?

Accepted Answer

Call Xrm.WebApi.retrieveRecord with the parent account's ID and a $select query option specifying only the creditlimit column, then handle the returned promise.

Answer

Use formContext.getAttribute('creditlimit').getValue() to read the parent account's credit limit directly from the current form.

Answer

Call Xrm.WebApi.retrieveMultipleRecords against all account records and loop through the results to find the matching parent account.

Answer

Use a synchronous XMLHttpRequest to the Web API endpoint so the value is available before OnLoad completes.

Question 42

Your team ships a managed solution named 'SalesCore' to production. A critical bug requires an urgent field change, but the full development solution contains many in-progress, untested components you cannot release yet. You need to deploy only the single fixed component to production quickly, while preserving the ability to later roll the fix into the base solution. Which ALM action should you take?

Accepted Answer

Use 'Clone a Patch' to create a patch of SalesCore, add only the fixed component, then export and import it as a managed patch to production.

Answer

Use 'Clone Solution' to produce a new base version of SalesCore containing all current components and deploy it to production.

Answer

Manually edit the fixed component directly in the production environment through the maker portal.

Answer

Create a brand-new unmanaged solution containing only the fixed component and import it as unmanaged into production.

Question 43

A canvas app displays a gallery of customer records from Dataverse. Some records have a blank 'PreferredName' field, and users complain that those rows show an empty label. You need a single Power Fx expression bound to the label's Text property that shows the PreferredName when it exists, otherwise falls back to the 'FullName' field, and if both are empty shows the literal text 'Unknown'. Which expression should you use?

Accepted Answer

Coalesce(ThisItem.PreferredName, ThisItem.FullName, "Unknown")

Answer

If(IsBlank(ThisItem.PreferredName), ThisItem.FullName, "Unknown")

Answer

IfError(ThisItem.PreferredName, ThisItem.FullName, "Unknown")

Answer

Concatenate(ThisItem.PreferredName, ThisItem.FullName, "Unknown")

Question 44

You are building a command bar button in a model-driven app using the modern command designer with Power Fx. The button labeled 'Submit for Approval' should only be enabled when the current record's Status field (a choice column named 'statuscode') equals the 'Draft' value, and it should be hidden entirely for any other status. You need to configure both the button's visibility and its enabled behavior with the least amount of code and without writing a JavaScript web resource. Which approach should you use?

Accepted Answer

Set the button's Visible property to a Power Fx formula that evaluates Self.Selected.Item.Status = 'Status (statuscode)'.Draft, and use the OnSelect action to open a confirmation.

Answer

Set the Visible property to a Power Fx formula referencing Self.Selected.Item.Status and register a separate JavaScript enable rule for the disabled state.

Answer

Configure classic ribbon EnableRules and DisplayRules in the ribbon XML because Power Fx cannot evaluate choice column values.

Answer

Set the OnSelect property to check the status and cancel execution if it is not Draft, leaving Visible set to true so the button always appears.

Question 45

Your organization uses Power Platform Pipelines to move solutions from a development environment to test and then to production. The compliance team requires that a designated reviewer must explicitly approve every deployment into the production environment before the artifacts are imported, but deployments to the test environment should remain fully automated. As the maker responsible for the pipeline, what should you configure to meet this requirement?

Accepted Answer

Add a deployment stage pre-deployment approval on the production stage in the pipeline configuration, assigning the reviewer as the approver.

Answer

Export the solution as managed and manually import it into production only after the reviewer emails their approval.

Answer

Create a Dataverse security role that removes solution import privileges from all users except the reviewer in the production environment.

Answer

Configure a DLP policy on the production environment that blocks the pipeline connector until the reviewer grants an exception.

Question 46

A canvas app's OnStart property sequentially loads five independent Dataverse tables into collections using ClearCollect, then sets three global variables that do not depend on those collections. Users report that the app takes over 12 seconds to open. You must reduce startup time with minimal code changes while keeping all the same data loaded. What should you do?

Accepted Answer

Wrap the five ClearCollect calls and the three Set calls inside a single Concurrent function in OnStart.

Answer

Move all five ClearCollect calls to the OnVisible property of the first screen so they run after the app opens.

Answer

Replace each ClearCollect with a Collect call so the collections load incrementally as the user navigates.

Answer

Combine the five tables into one collection using a series of nested AddColumns and lookups.

Question 47

A canvas app screen has an OnVisible property that must load three independent collections from Dataverse (ClearCollect calls to Accounts, Contacts, and Opportunities) before the gallery renders. Users report the screen takes several seconds to appear. Each ClearCollect currently runs one after another on separate lines. You need to reduce the perceived load time with the least amount of formula rework. What should you do?

Accepted Answer

Wrap the three ClearCollect calls in a single Concurrent() function so they execute in parallel.

Answer

Move all three ClearCollect calls to the App.OnStart property instead of OnVisible.

Answer

Replace the three ClearCollect calls with a single With() function referencing all three tables.

Answer

Combine the three tables into one collection using AddColumns() and a single ClearCollect.

Question 48

You are building a custom API message named contoso_RecalculatePricing that must operate against a single account record. The logic reads and updates fields on that specific account and returns a computed total. You want the message to appear in the Dataverse Web API bound to the account table so callers invoke it as a function/action on a specific account instance. How should you configure the custom API definition?

Accepted Answer

Set the Binding Type to 'Entity' and specify 'account' as the Bound Entity Logical Name.

Answer

Set the Binding Type to 'Global' and add a request parameter of type EntityReference named Target.

Answer

Set the Binding Type to 'Entity Collection' and specify 'account' as the Bound Entity Logical Name.

Answer

Leave the Binding Type as 'Global' and register the plug-in step on the account table's Update message.

Question 49

You are building a reusable Custom API message called 'contoso_RecalculatePricing' in Dataverse. The main operation logic is implemented in a plug-in that must run when any code calls the message through the Organization service or Web API. You define the Custom API record, its request/response parameters, and write the plug-in class. When you register the plug-in through the Plug-in Registration Tool, how should the plug-in step be configured so the logic executes as the main operation of the Custom API?

Accepted Answer

Set the Custom API record's 'Plugin Type' to the plug-in's assembly type; do not register a separate SDK message processing step for the main operation.

Answer

Register an SDK message processing step on the 'Update' message of the target table in the PostOperation stage.

Answer

Register an SDK message processing step on the custom message in the PreValidation stage and leave the Custom API 'Plugin Type' empty.

Answer

Register the plug-in as an asynchronous step on the custom message so the main operation runs outside the transaction.

Question 50

You are building a custom API message named contoso_RecalculateInventory that performs a sensitive, long batch operation. Business requirements state that only users who hold a specific security privilege should be able to invoke it, and the operation must be callable both from the Web API and from within other plug-ins. When defining the Custom API record in Dataverse, which configuration correctly enforces the privilege requirement without writing extra authorization code?

Accepted Answer

Set the 'Execute Privilege Name' field on the Custom API to the required privilege so Dataverse checks the caller's privilege before running the plug-in.

Answer

Set 'Is Private' to Yes on the Custom API so that only privileged users appear in the Web API metadata.

Answer

Set 'Binding Type' to Entity and 'Is Function' to Yes so the message inherits table-level security roles automatically.

Answer

Add a check in the plug-in's pre-validation stage that queries the systemuserroles table and throws if the privilege is missing.

Question 51

You are building a custom connector for an internal REST API that expects each request to include a static API key in an HTTP header named 'X-Company-Key'. The key is issued per-user and must be entered by each maker when they create a connection. You want the connector to prompt users for the key at connection time and automatically attach it to every outbound request. Which authentication type should you configure on the custom connector?

Accepted Answer

API Key authentication, specifying the parameter label, parameter name 'X-Company-Key', and location 'Header'

Answer

OAuth 2.0 with the client credentials grant and a custom token endpoint

Answer

Basic authentication, mapping the username to the API key value

Answer

No authentication, adding the header value through a 'Set header' policy template

Question 52

Your team maintains a REST API whose OpenAPI (Swagger 2.0) definition is stored and versioned in a GitHub repository. You need to create a Power Platform custom connector that stays aligned with the API contract, and you want to minimize manual re-entry of endpoints and schemas whenever the API changes. Which approach should you use when initially building the connector?

Accepted Answer

Create the custom connector by choosing the 'Import an OpenAPI from URL' option and point it to the raw GitHub URL of the Swagger definition file.

Answer

Create the custom connector from blank and manually define each action, request, and response to match the GitHub documentation.

Answer

Import the API by selecting 'Import from Azure Service' and referencing the GitHub-hosted API.

Answer

Create an Azure API Management instance, publish the API there first, then export it as a Logic Apps connector only.

Question 53

Your organization exposes several REST endpoints through an existing Azure API Management (APIM) instance. Each API in APIM already has a published OpenAPI definition and defined security policies. You need to create a Power Platform custom connector that reuses these APIM APIs with the least manual configuration and keeps the connector aligned with the APIM-managed endpoints. What should you do?

Accepted Answer

In the custom connector wizard, choose 'Import from Azure Service' and select the Azure API Management instance and API.

Answer

Manually recreate each operation in the custom connector using the 'Create from blank' option and copy the request/response schemas.

Answer

Export the APIM API as a WSDL file and import it into the custom connector wizard.

Answer

Deploy an Azure Logic App in front of APIM and import the Logic App trigger into the custom connector.

Question 54

You are building a custom connector that calls an Azure Function protected by Microsoft Entra ID. The connector must let makers sign in with their own credentials so the Function receives an access token that identifies the calling user. In the custom connector's security configuration, which authentication type and setting must you configure to obtain a user-delegated token for the Function's app registration?

Accepted Answer

OAuth 2.0 with Microsoft Entra ID as the identity provider, specifying the Function app registration's Application ID URI as the Resource URL (audience)

Answer

API Key authentication, passing the Entra ID client secret in a custom header on every request

Answer

Basic authentication using the maker's Entra ID username and password stored in the connection

Answer

No authentication, relying on the Function's built-in Easy Auth to silently inject the user identity

Question 55

Your company uses a third-party SaaS expense system that exposes a REST API secured with OAuth 2.0. Users must sign in with their own SaaS account so that the API returns only their personal expense data. You are building a custom connector in Power Platform to let makers call this API from cloud flows on behalf of the signed-in user. Which authentication type should you configure for the custom connector?

Accepted Answer

OAuth 2.0 with the Authorization Code grant, providing the client ID, client secret, authorization URL, token URL, and scopes

Answer

API Key authentication, prompting each user to paste their personal API key

Answer

Basic authentication, collecting each user's SaaS username and password

Answer

OAuth 2.0 with the Client Credentials grant, using a single application client ID and secret

Question 56

You are building a custom connector from a manually authored OpenAPI 2.0 definition for a REST API. One GET operation accepts a repeated query parameter named 'status' that can appear multiple times in the URL (for example, ?status=open&status=pending) to filter by several statuses in a single call. How should you define this parameter in the OpenAPI definition so the connector generates the correct request?

Accepted Answer

Define an array-type parameter 'status' with 'in: query' and set 'collectionFormat: multi'.

Answer

Define a single string parameter 'status' and instruct users to pass a comma-separated list of values.

Answer

Define the parameter 'in: body' with an array schema so multiple values can be serialized.

Answer

Define an array-type parameter 'status' with 'collectionFormat: csv' so values are joined with commas.

Question 57

You are building a custom connector for an internal REST API that returns product inventory data. During testing, the flow that consumes your connector cannot reference individual fields (such as 'sku' and 'quantity') in the dynamic content picker — the entire response appears only as a single 'Body' output. You need makers to select individual fields when they use the connector action in a cloud flow. What should you do in the connector definition?

Accepted Answer

Define a response schema for the action by importing a sample JSON payload so the connector generates typed output properties.

Answer

Add an authentication policy of type 'API key' to expose the response fields.

Answer

Enable the connector's 'On-behalf-of' delegation setting so field metadata flows through.

Answer

Change the action's request verb from GET to POST so Power Automate can parse the payload.

Question 58

You built an Azure Function App that exposes several HTTP-triggered endpoints returning JSON. You need to make these operations available as actions inside Power Automate cloud flows with the least manual effort, while automatically generating accurate action metadata (operation IDs, parameters, and response schemas). What should you do first when creating the custom connector?

Accepted Answer

Enable the built-in OpenAPI (Swagger) definition on the Function App and import that OpenAPI definition when creating the custom connector.

Answer

Manually define each action in the custom connector wizard by typing the request URLs and adding sample responses one by one.

Answer

Register the Function App in the Plug-in Registration Tool and expose the endpoints as Dataverse custom API messages.

Answer

Publish the Function App to APIM and create a Logic App that proxies each endpoint before importing.

Question 59

You are building a custom connector for an internal REST API. The backend requires every request to include a static HTTP header 'x-api-version: 2.0'. You want to add this header to all operations without modifying the underlying API or requiring the flow maker to supply the value. What is the most appropriate way to configure the custom connector?

Accepted Answer

Apply the 'Set HTTP header' policy template in the connector's Definition, configuring it to set x-api-version to 2.0 on all operations.

Answer

Add a required header parameter named x-api-version to each operation and instruct makers to always enter 2.0.

Answer

Configure the header in the connector's Security tab as part of the authentication settings.

Answer

Create an Azure API Management policy and import the connector from Azure to inject the header.

Question 60

You are building a custom connector for an internal REST API. The API expects a flat JSON payload with fields like customerName and orderTotal at the root level. However, your Power Automate makers want to work with a nested object model where these fields appear under a 'customer' and 'order' object respectively. You need the connector to accept the maker-friendly nested schema in Power Automate but send the flattened structure the backend API requires, without modifying the backend API or writing external code. What should you do?

Accepted Answer

Define the operation request body with the nested schema, then use the connector's custom code (C# script) feature to transform the request into the flat structure before it is sent to the backend.

Answer

Define the operation with the nested schema and add a policy template of type 'Convert an object to an array' to reshape the request body.

Answer

Create an Azure API Management instance in front of the REST API and configure an inbound transformation policy, then import the connector from API Management.

Answer

Define the request body as raw string and instruct makers to manually build the flattened JSON in each flow using expressions.

Question 61

Your organization uses a custom order-management model-driven app. When an order reaches the 'Shipped' status, several downstream systems (a warehouse system, a customer notification service, and an analytics pipeline) need to react. These subscribers are added and removed frequently, and the developers do not want to modify or redeploy Dataverse code each time a new subscriber is introduced. You want to publish a well-defined, discoverable event from Dataverse that any authorized consumer can subscribe to independently. Which approach should you implement?

Accepted Answer

Define a custom API configured as a Dataverse business event and have consumers subscribe to it, raising the event from server-side logic when the order is shipped.

Answer

Register a synchronous plug-in on the Update of the order table that calls each downstream system's HTTP endpoint in sequence.

Answer

Create a cloud flow with a Dataverse trigger that hard-codes an HTTP action for each downstream subscriber.

Answer

Add a webhook step in the Plug-in Registration Tool for each subscriber on the order Update message.

Question 62

A Power Platform developer must implement logic that validates and, if needed, rejects an incoming Dataverse record write before the transaction is committed to the database. The validation depends on complex server-side calculations across multiple related tables, and the user must receive an immediate error message that cancels the save if validation fails. Which implementation approach should the developer choose?

Accepted Answer

A synchronous plug-in registered on the Pre-Operation stage of the Create and Update messages

Answer

An automated Power Automate cloud flow triggered when a row is added or modified

Answer

A Dataverse business rule scoped to the entity

Answer

A real-time workflow registered to run after the operation completes

Question 63

You are building an integration that must create an Account record and three related Contact records in a single Dataverse Web API call. If any one of the operations fails, none of the records should be persisted. Which Web API technique should you use to guarantee this behavior?

Accepted Answer

Send a $batch request that wraps all four operations inside a single changeset.

Answer

Send each operation as a separate PATCH request with an If-Match header for optimistic concurrency.

Answer

Send a $batch request placing each operation as an independent request outside any changeset.

Answer

Send the four operations in parallel using the Promise.all pattern to maximize throughput.

Question 64

You are building a nightly integration that must upsert approximately 8,000 account records into Dataverse from an external system using the Dataverse Web API. Early tests using one HTTP request per record are exceeding the maintenance window and triggering service protection API limits. You need to reduce the number of round trips while still allowing each individual upsert to be processed and to receive per-record results. Which approach should you use?

Accepted Answer

Group the upserts into $batch requests, placing multiple changeset operations per batch to reduce the number of HTTP round trips.

Answer

Send each upsert as a separate PATCH request but wrap them all in a single Power Automate cloud flow with a retry policy.

Answer

Call the CreateMultiple message with all 8,000 records serialized into one JSON payload in a single POST.

Answer

Increase the client timeout and continue sending one PATCH per record so each response can be validated individually.

Exam domain	Exam weight	Practice
Create a technical design	13%	Practice this topic
Build Power Platform solutions	13%	Practice this topic
Implement Power Apps improvements	13%	Practice this topic
Extend the user experience	13%	Practice this topic
Extend the platform	35%	Practice this topic
Develop integrations	13%	Practice this topic

Microsoft Power Platform Developer (PL-400) practice exam & study guide

Start studying PL-400

All PL-400 study resources

PL-400 exam domains

Sample PL-400 questions

Key PL-400 terms

PL-400 frequently asked questions

Create a technical design (13%)

Build Power Platform solutions (13%)

Implement Power Apps improvements (13%)

Extend the user experience (13%)

Extend the platform (35%)

Develop integrations (13%)