Hard PL-400 practice questions

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?

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?

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?

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?

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?

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?

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?

Your team uses Azure DevOps with the Power Platform Build Tools to automate deployment of a managed solution from a build environment to a QA environment. After a release, testers report that a recently removed workflow is still active in QA. Investigation shows the solution export/import pipeline succeeded, but the workflow persists across releases. You need to ensure that components deleted from the solution in the source environment are also removed from the target during automated import. Which action should you take in the pipeline configuration?

You are registering a service endpoint with the Plug-in Registration Tool to stream Dataverse account creation and update events to Azure for downstream analytics. The consuming system must process a very high volume of events, replay events from a past point in time if the analytics pipeline fails, and support multiple independent consumer groups reading the same stream. Which destination type should you register?

You are building a PCF code component that renders a complex, interactive chart with heavy state management. Your team already uses React extensively and wants to avoid bundling React separately in every component to reduce load times, taking advantage of the platform-provided React and Fluent libraries. Which action should you take when authoring the component's manifest and class to achieve this?

You are building a PCF field component that must open a full-page HTML dialog (a custom lookup UI) when the user clicks a button inside the control. The dialog needs to be rendered as a centered modal using the host framework rather than your own DOM, and it should return the selected value back to the component. Which member of the PCF context should you use to launch this dialog?

A developer registers a plug-in on the Update message of the Account table. The plug-in creates a related Task record using the IOrganizationService obtained from the execution context, then throws an InvalidPluginExecutionException later in the same code path if a validation rule fails. The developer needs the Task creation to be automatically undone whenever the exception is thrown. On which pipeline stage must the plug-in be registered synchronously to guarantee this behavior?

A cloud flow is triggered when a Dataverse 'Order' row is created. The flow updates a shared 'Daily Totals' row by reading its current value, adding the order amount, and writing the result back. During peak hours, hundreds of orders are created within seconds, and users report that the daily total is frequently lower than expected because concurrent flow runs overwrite each other's updates. You must ensure updates are applied accurately without dropping any order amounts. What should you configure?

You build a Power Automate cloud flow that calls a partner's REST API through an HTTP action. The API occasionally returns HTTP 429 (Too Many Requests) with a Retry-After header, and the vendor asks that you honor that header rather than retrying immediately. The flow must attempt the call up to five times, waiting the number of seconds specified in Retry-After between attempts, and only fail the run if all five attempts return a throttling response. Which approach best meets these requirements?

Your team ships a managed solution named ContosoSales to a production environment. A support engineer, working directly in production, unmanaged-layered several form and column changes to hotfix an urgent issue. Now the next managed solution import is not showing your intended field label change because the production unmanaged layer sits on top. You want to permanently move that emergency fix back into your development ALM process and remove the unmanaged override in production so the managed layer takes effect again. What should you do?

A logistics company has complex freight-cost calculation logic that must be invoked in three ways: synchronously from a model-driven form when a user clicks a button, from a Power Automate cloud flow that runs nightly, and from a plug-in that fires when an order is created. The business requires that all three callers execute the exact same server-side logic and that the logic is transactional and reusable without duplicating code. What is the best design approach?

You are registering an Azure Service Bus service endpoint using the Plug-in Registration Tool to publish Dataverse Account events to a downstream integration. Testing reveals that some messages containing large custom entity payloads fail to post while smaller ones succeed. The team confirms the Service Bus queue and credentials are correct. Which explanation and remediation should you present?

Your team ships a managed solution named 'FieldServiceCore' (version 2.0) to a customer's production environment. The customer reports a critical bug in a plugin. You must deliver a fix that patches only the affected plugin assembly, can be quickly applied on top of the currently installed managed solution, and can later be rolled up cleanly when version 3.0 ships. Which approach should you use?

A managed solution from your vendor sets a form field to 'Business Recommended'. After a recent import, users report the field is now displaying as 'Optional' instead. You open the field's solution layers in the target environment and see two layers: the vendor's managed layer at the bottom, and an unmanaged layer on top that was created by a developer directly customizing the field in the environment. You need the field to honor the vendor's managed configuration going forward without losing any other legitimate unmanaged customizations. What should you do?

A logistics company uses model-driven apps on Dataverse. A group of 12 dispatchers needs collaborative ownership of a set of 'Route' records so that any dispatcher can edit records the others create, and so that reassigning work between dispatchers requires no manual record re-sharing. Managers outside the group should have read-only access. The developer wants the lowest-maintenance approach that survives staff joining and leaving the group. Which design should the developer implement?