Microsoft Power Platform Functional Consultant (PL-200)

Correct answer: B. B) Include Office 365 Outlook and OneDrive for Business in the Business data group, with all remaining connectors in the Non-business data group

Connectors must be in the same data group for data to flow between them, so Outlook and OneDrive for Business both go in the Business group. Separating the connectors in different groups would block the attachment automation entirely.

Correct answer: C. C) To adhere to compliance requirements by tracking who made changes and what changed

Dataverse auditing records who changed what data and when, which directly satisfies compliance and regulatory traceability requirements. Auditing does not revert changes or improve performance; it simply provides an attributable change history.

Correct answer: A. A) Foreign key

A lookup column in Dataverse functions like a foreign key, storing a reference to a record in another table. The primary key uniquely identifies records within one table, while the lookup creates the cross-table link.

Correct answer: C. C) User().FullName

User() is a function returning a record with FullName, Email, and Image fields, so User().FullName is correct syntax. Options like User.FullName or User().Name fail because User is not an object and Name is not a valid field.

Correct answer: C. C) Sentiment analysis model to determine the emotional tone

Sentiment analysis is the AI Builder model that scores text as positive, negative, or neutral, directly answering whether an email will be perceived well. Category classification only tags topics, so it fails to measure tone, making it the strongest distractor.

Correct answer: C. C) A flow that defines the automation steps

In Power Automate the workflow logic lives in a flow, which combines a trigger with actions, conditions, and loops. An environment merely hosts resources and connectors only link data sources, so neither defines the automation steps.

Correct answer: C. C) All aspects of the app can be modified including screens, layouts, and formulas

An app generated from data is fully editable in Power Apps Studio, so you can change screens, layouts, controls, and Power Fx formulas. Options claiming screens are fixed or the app is read-only contradict the platform's design as a customizable starting point.

Correct answer: C. C) App Audit

App Audit is the CoE Starter Kit component built to flag overshared or heavily used apps and collect business justification plus outage impact details from owners. The App Catalogue is for discovery, and DLP Editor handles data loss prevention policies, not owner outreach.

Correct answer: C. C) System Administrator

The System Administrator role grants full permission to customize and administer the environment, manage security roles, and view all data. System Customizer is the classic distractor; it customizes apps and entities but cannot administer security roles or see all records.

Correct answer: D. D. In the Power Platform admin center, create a new tenant-level DLP policy, set the default data group to "Blocked", and publish it. All existing and future custom connectors will automatically be placed in this group.

A tenant-level DLP policy with the default group set to Blocked classifies every connector, including future custom connectors, automatically with no ongoing manual work. The other options rely on scripts, maker discipline, or unsupported trigger patterns, which are unreliable for tenant-wide governance.

Correct answer: B. B. Develop the app in a development environment using environment variables for all data source connections. Export the solution and import it as a managed solution into the European and North American production environments, setting the environment variable values to point to the correct regional Dataverse instances.

Environment variables let a single managed solution deploy to both regions while only the variable values differ, keeping data residency intact with one artifact to maintain. Duplicating apps or manually editing connections after import increases drift and long-term maintenance burden.

Correct answer: D. D. The Filter(Products, Selected = true) expression is evaluating against all 10,000 rows in the data source each time, and Collect is storing all filtered rows, overwhelming the app's memory.

The Collect function is pulling every row matching the filter into an in-memory collection, so a 10,000-row result overwhelms the app even though the gallery shows only 50. On the exam, watch for delegation and volume traps: collecting large data sets client-side is a classic performance killer.

Correct answer: B. B. The condition is comparing the text string "Completed" to the numeric value of the choice column, which is the underlying integer.

Dataverse choice columns return an underlying integer value in flow trigger outputs, so comparing against the text label "Completed" fails. Remember to compare choice values by their numeric option value or use the display-name dynamic content instead.

Correct answer: B. B. Use the SQL Server connector in Power Apps and select "Connect via on-premises data gateway" when creating the connection.

The built-in SQL Server connector with the on-premises data gateway provides real-time read-write access while data stays on-premises. Options A and C add unnecessary complexity, and D copies data to the cloud, breaking the residency requirement.

Correct answer: A. A. Business rules defined on a Dataverse table are only enforced when data is submitted through model-driven app forms, not through canvas apps.

Table business rules execute in the model-driven app form context, so a canvas app submission can bypass that validation entirely. Security roles never bypass business rules, and the form's Valid property has nothing to do with server-side Dataverse validation.

Correct answer: A. A. Move the Outlook connector to the "Business data only" group in the DLP policy.

A flow is suspended when its connectors span both the business and non-business DLP groups, so moving Outlook into the business group resolves the conflict without redesign. Splitting the flow or swapping connectors adds complexity, and requesting an exception breaks the compliance requirement.

Correct answer: C. C. The "Salary" column was not correctly enabled for field security in the table's configuration.

Field security only takes effect when the column itself is enabled for field security in the table definition; a profile alone does nothing otherwise. Ownership never bypasses field-level security, and Dataverse enforces it server-side regardless of whether the client is canvas or model-driven.

Correct answer: D. D. Rollup fields are calculated asynchronously, and there is a processing backlog in the system.

Dataverse rollup fields are recalculated by asynchronous system jobs, so frequent task updates can create a processing backlog and lag hours behind. Remember rollups are never real-time; the once-per-day claim is wrong because recalculation is event-driven.

Correct answer: C. C. Configure the approval action to have a "Timeout" of 5 days and specify a "Timeout action" that rejects the request.

The Start and wait for an approval action supports a native Timeout setting with a Timeout Action such as Reject, handling overdue approvals cleanly. Parallel delay branches and separate scheduled flows add race conditions and maintenance burden the built-in option avoids.

Correct answer: A. A. The custom API is updating the records with the "Bypass Custom Logic" option, which suppresses the real-time workflow.

Passing the bypass custom logic option in API updates suppresses real-time workflows, so status changes to Shipped without the email firing. Classic workflows trigger on any data change regardless of source, so manual-save-only triggering isn't the cause.

Correct answer: D. D. Add a pre-validation plugin on the "Create" message of the "Course Enrollment" entity that checks for previous failures and throws an invalid operation exception.

A pre-validation plugin on Create runs server-side on every create operation and can query prior enrollment records to block the save with an error. Business rules can't do cross-record aggregation, and flows or client scripts fire after the fact or can be bypassed.

Correct answer: B. B. Modify the flow to run asynchronously: have the flow immediately return an "Accepted" response, process the work order creation, and then send a separate notification (e.g., email) to the user when complete.

Returning an immediate acknowledgement and finishing the work asynchronously keeps the custom page responsive and avoids the two-minute timeout, with a notification delivering the final result. Extending a client timeout is brittle since flow duration can exceed any fixed window.

Correct answer: B. B. Replace the custom visual with a built-in Power BI visual that has better performance characteristics.

Replacing the slow custom visual with a native built-in visual is the most direct fix because built-in visuals render far faster and eliminate the 30-second bottleneck. Sequential loading isn't a supported Power BI setting, and adding Premium capacity doesn't target a single visual's rendering problem.

Correct answer: A. A. The SharePoint list item being processed sometimes has missing or null values for the fields being referenced in the compose actions.

The 'property does not exist' template error occurs when Compose expressions reference fields that are missing or null on some SharePoint items, which explains the intermittent pattern. Concurrency throttling would surface quota errors, not property evaluation failures, so that option doesn't fit.

Correct answer: C. C. Use Power Automate to create a flow that triggers when a phone call is completed, retrieves the donor record, and updates the BPF stage using the "Set business process flow stage" action.

Power Automate with the dedicated Set business process flow stage action is the supported way to advance a donor's BPF stage when a phone call completes. Business rules can't cross records to change BPF stages, and client-side JavaScript is brittle and unsupported for this scenario.

Correct answer: C. C) In the Templates section of Power Automate filtered by AI Builder

The Power Automate Templates gallery, filtered for AI Builder, is the central catalog of ready-to-use AI-powered flow templates. The model details page's Use model option helps you consume one specific model, but it isn't a template library for jumpstarting new automations.

Correct answer: C. C) Bring data into Power BI Desktop and create a report → Share to Power BI service → View and interact in the service and Power BI mobile

The canonical Power BI workflow is author in Desktop, publish to the service, then consume in the service and mobile apps. Remember Desktop is the authoring source, never a publishing target; every option that pushes content backward from service or mobile to Desktop is wrong.

Correct answer: B. B) The relationship must be defined from the shipment entity to the delivery attempt entity as one-to-many

A rollup field that counts child records requires a one-to-many relationship from the parent shipment table to the child delivery attempt table. Option E describes the same relationship from the child's perspective, but the rollup configuration is defined from the parent side as one-to-many.

Correct answer: C. C) Business rules can validate data and show error messages in both canvas and model-driven apps

Dataverse business rules defined at the table level run in both canvas and model-driven apps, so validation and error messages apply consistently. Options claiming full parity of all actions or per-app rules are wrong because not every action is supported in canvas apps.

Correct answer: B. B) Using Dataverse, you can break your data into various environments to better manage and secure important information · C. C) Microsoft Dataverse uses standard tables, columns, and relationships to help you build powerful scalable data solutions · D. D) Make your data work for you by splitting it up into logical chunks

Dataverse supports separate environments for managing and securing data, uses a relational model of tables, columns, and relationships, and benefits from splitting data into logical units. The JSON-tables and Cosmos DB options are false because Dataverse uses its own relational Azure-backed storage.

Correct answer: B. B) Azure Active Directory for tenant-level authentication and access control

Dataverse authentication and tenant boundaries rely on Azure Active Directory, now called Microsoft Entra ID, which issues tenant-scoped tokens. MSA is for consumer accounts, and ADFS only federates on-premises identity, so neither enforces the tenant boundary.

Correct answer: A. A) True

The statement is true because Power BI's default auto date/time feature creates hidden date tables that provide year, quarter, month, and day drill-down hierarchies for date fields. The caveat is that disabling auto date/time or using a custom calendar table removes that automatic hierarchy.

Correct answer: C. C) A Postman collection and either a Power Apps or Power Automate subscription

A Postman collection supplies the API definition, and either a Power Apps or Power Automate subscription provides the environment and licensing to build the custom connector. Options that add Azure or API Management requirements introduce components that are not needed for this workflow.

Correct answer: B. B) Solutions

Solutions are the application lifecycle management container that packages apps, flows, tables, and connectors with their metadata for transport between environments without business data. Deployment profiles and packages are either unrelated or not the supported terminology for environment-to-environment transport.

Correct answer: C. C) Click, double-click, and hold

Flic buttons expose three trigger actions in Power Automate: click, double-click, and hold, which is why option C is correct. Triple-click is not a supported trigger, so option D overreaches and is the main distractor to avoid on the exam.

Correct answer: C. C) Power Platform Admin Portal

The Power Platform admin center is the single centralized hub for managing Dataverse environments, users, security roles, and data policies. The Microsoft 365 admin center is the tempting distractor, but it handles tenant licensing rather than environment-level Power Platform governance.

Correct answer: B. B) Business rules can be created to enforce logic and data values regardless of how data is entered into a Microsoft Dataverse entity

Business rules are defined at the table level and enforce logic regardless of how data enters the table, including imports and API calls. Option A is the common trap; remember the scope setting, not the client, determines where the rule runs.

Correct answer: C. C. The cloud flow's "Update a row" action is configured with the "Bypass custom logic" option selected, preventing any business rules from being evaluated.

The Bypass custom logic option on the Dataverse Update a row action skips business rules, plugins, and workflows, which explains why the update succeeds silently while Priority never changes. Security roles like System Customizer have nothing to do with whether business rules fire.

Correct answer: B. B. Extend the existing "App Audit" process by configuring it to check the last access date and automatically trigger the archival workflow for apps that meet the 90-day threshold.

The CoE Starter Kit ships an App Audit process built exactly for inactivity review, so extending it to act on the 90-day threshold meets the requirement with the least custom development. Building brand-new flows or manual Power BI exports duplicates what the kit already provides.

Correct answer: B. B. In the gallery's template, add a label and set its Text property to Office365Users.ManagerV2(ThisItem.Id).displayName. This will query the manager for each user directly within the gallery.

Calling Office365Users.ManagerV2(ThisItem.Id).displayName inside the gallery template resolves the manager per row using row context, which is the standard pattern. AddColumns cannot evaluate a per-row connector call like this reliably, and nested galleries add needless complexity.

Correct answer: D. D. Create a child flow specifically for the credit check process. Call it from the parent flow and configure the child flow with its own error handling and retry logic, returning a success or failure status to the parent.

A dedicated child flow encapsulates the credit check with its own retry and error handling, then returns a clear success or failure status the parent can branch on. Looping the whole flow risks duplicate updates and emails, and retry policies alone don't gate downstream actions.

Correct answer: C. C. Create a DLP policy that allows both connectors. Develop an administrative flow that runs hourly, lists all flows, checks their trigger and action types, and disables any flow that uses a Teams trigger with a SharePoint action.

Since DLP policies classify connectors but cannot enforce direction, you allow both connectors and add an automated governance flow that disables prohibited patterns. Option D fails because splitting the connectors into different groups blocks even the allowed SharePoint-to-Teams flows.

Correct answer: C. C. Publish the report to a workspace and then create and publish a Power BI app from that workspace, granting the sales team access to the app.

Publishing to a workspace and distributing through a Power BI app gives consumers an interactive but non-editing experience. Option A fails because Member role grants edit rights, which violates the requirement that the team not modify the report.

Correct answer: D. D. Configure a SLA (Service Level Agreement) on the "Shipment" table with a KPI for the "Pickup" stage, and set it to apply only when "Priority" is "Express."

An SLA with a KPI scoped to Express shipments natively tracks the two-hour window and fires alerts on breach with no custom code. Business rules run client-side and cannot monitor elapsed time, and a polling flow adds latency and load, so both fail the minimal-development requirement.

Correct answer: B. B. Configure a "Scope" with a "Configure run after" setting to check the HTTP response. If a 429 occurs, add the failed record to a separate queue table in Dataverse and have a separate scheduled flow process the queue.

Using configure-run-after to catch the 429 and writing failures to a queue table guarantees no data loss, and a scheduled flow can pace retries within the rate limit. A retry loop compounds throttling, and setting concurrency to one creates a backlog without respecting the per-minute cap.

Correct answer: A. A. Implement incremental refresh in Power BI for the fact table, partitioning the data by date.

Incremental refresh with date-based partitions means each refresh loads only new or changed rows, cutting a full hour-long load to minutes and avoiding timeouts. DAX simplification affects query speed, not refresh, and the large dataset storage format does not reduce refresh duration.

Correct answer: A. A. The JavaScript function does not have the correct parameters to handle the asynchronous response from the custom API call.

The custom API call is asynchronous, so if the JavaScript does not handle the promise or callback correctly, the dialog code runs before the response arrives and never displays. Browser pop-up blockers rarely affect Xrm.Navigation dialogs, and enable rules would prevent the button entirely, not just the dialog.

Correct answer: A. A. Modify the SQL query in Power Query to filter out rows where the timestamp is greater than the current time at the time of refresh.

Filtering future-dated rows in Power Query at refresh time removes bad data before it enters the model, so every measure stays correct. Using NOW in DAX compares against view time instead of refresh time, which still lets skewed future timestamps slip into the average.

Correct answer: D. D. Develop a governance flow that triggers when a new app is published, checks its properties, and sends a reminder email to the maker if the theme and support link are missing.

A publish-triggered governance flow that checks apps and emails the maker enforces branding with minimal disruption. DLP policies govern connectors and data sources, not UI components, so the component library option cannot enforce theme usage.

Correct answer: B. B. Update the connection in the Power Apps maker portal by editing the connection and providing the new server name in the connection settings.

Editing the connection in the maker portal updates the server name the gateway-backed connection uses, restoring routing to the renamed SQL instance. Gateway restarts or reinstalls don't rewrite stored connection settings, and credential changes alone won't fix a wrong server name.

Correct answer: B. B. Configure the BPF stage to require the blood pressure field, and add a client-side JavaScript that validates the value on stage exit.

Making the field required in the BPF stage plus JavaScript on stage change blocks progression until the blood pressure value is corrected in real time. Business rules can show errors but don't reliably stop BPF stage advancement, and flows only react after the change.

Correct answer: B. B. Custom connector host URLs are hard-coded in the connector definition and cannot be changed during solution import; they must be updated manually in each environment after import.

Custom connector host URLs are stored in the connector definition, so a managed import carries the Dev URL into Prod unless environment variables are used. The connector works after import, proving it was included, and no standard pipeline task rewrites the host.

Correct answer: B. B. The date hierarchy must be explicitly added to the Columns bucket, not just the "Year" field, for drill-down to work.

Drill-down requires a hierarchy placed on the visual's axis; adding only the Year field leaves no lower levels to drill into, so the option is greyed out. Matrix visuals do support drill-down, and measures plus permissions don't control this behavior.

Correct answer: B. B. Develop a Power Automate flow that triggers whenever a "Training Record" is created or modified, checks all related records for the employee, and updates the "Employee" record.

A Power Automate flow triggered on Training Record changes can evaluate every related record and immediately set the Employee status. A rollup field plus business rule is tempting, but rollups recalculate on a delayed schedule and can't reliably honor a rolling 'today' date condition.

Correct answer: B. B) The date field is automatically separated into year, quarter, month, and day hierarchies

With auto date/time enabled, Power BI automatically builds a year, quarter, month, day hierarchy when you add a date field to a visual. No manual calculated columns or Visualizations pane toggle is needed; converting to text would destroy chronological ordering entirely.

Correct answer: B. B) Taking a picture with the device camera or uploading from local storage

The Business card reader component accepts images from the device camera or from a local file upload. SharePoint, OneDrive, email attachments, and cloud URLs require extra workflow plumbing, so they aren't native input methods for the component itself.

Correct answer: B. B) Governance must be enforced through established rules and constraints

Effective governance relies on enforceable rules and constraints such as DLP policies and environment boundaries rather than manual oversight. Real-time surveillance or mandatory training alone cannot guarantee consistent compliance at scale.

Correct answer: C. C) On the Insert tab of the form editor using the Bing Maps button

The Bing Maps control is added from the Insert tab of the classic form editor when customizing account, contact, or lead forms. Exam cue: insertion of controls like maps, timelines, and forms always happens on the Insert tab, while the Properties pane only configures an already placed control.

Correct answer: D. D) Using custom code with the Power Platform SDK

Custom connectors are created through the wizard, an OpenAPI definition, a Postman collection, or by importing from Azure API Management, not by writing code with an SDK. The connector definition is declarative; there is no SDK-based code path for authoring one.

Correct answer: B. B) Resubmit the flow to try running it again

A 502 Bad Gateway is typically a transient upstream issue, so the first step is to resubmit the flow run and see if it succeeds. Options like clearing a cache or deleting the flow are not supported actions and only add risk and downtime.

Correct answer: C. C) Power Platform Admin Centre → Environments → Add database → Configure settings → Add

Dataverse databases are provisioned in the Power Platform admin center by selecting an environment, choosing Add database, configuring settings, and confirming. Remember the admin center, not the maker portal, is where environment-level database provisioning happens.

Correct answer: C. C) New workspaces

The new workspace experience is the default in Power BI, offering granular role-based permissions and creation without Microsoft 365 groups. Classic workspaces are the strongest distractor because they existed first, but they are tied to M365 groups and lack the modern roles.

Correct answer: B. B) The users were added to a non-default environment

The Basic User role is only provisioned automatically in the default environment; in non-default environments an admin must assign security roles explicitly. Licensing and SSO distractors affect access generally, but they do not explain the missing automatic role assignment.

Correct answer: C. C. The "Update" option was not selected during import, so the existing connector settings in the test environment were preserved.

Importing without the Update option leaves existing connector configurations in the target environment untouched, so the connectors keep their development endpoints even though the environment variables show the correct test values. Re-importing with Update refreshes the connector definitions.

Correct answer: A. A. Calculated columns only evaluate when the record is created, not when related columns are updated, unless the record is explicitly saved again.

Calculated columns re-evaluate when the record is saved after dependent fields change, so existing records go stale until a save commits the change. DateDiff is fully supported in calculated columns, ruling out option B.

Correct answer: C. C. The custom page is submitting the data without loading the model-driven form, so the form-level business rule is not triggered.

The custom page commits data directly to Dataverse without the model-driven form context, so the form-level rule that sets Location never runs until the record opens in the main form. Option A overstates the limit, since business rules can apply across client types.

Correct answer: A. A. Connection references in a managed solution are read-only and cannot be updated after import; they must be manually recreated in the target environment.

Connection references imported in a managed solution need their connections set or recreated in the target environment after import; they do not repoint automatically. Option C confuses environment variables with connection references, which serve different purposes in deployments.

Correct answer: A. A. When Maria's account was disabled, all sharing assignments she had performed were automatically revoked, including the individual share with David.

The intended answer is that disabling Maria's account revokes the individual share she granted, so David loses the explicitly shared access. For the exam, remember that record sharing is tied to the user who granted it, while organization-level role access does not depend on who created the record.

Correct answer: D. D. The Projects table does not have a non-relational index on the Title column, preventing efficient server-side searching.

Without an index on the Title column, the server must scan many rows even though StartsWith delegates, so search slows as the table grows. Delegation moves work server-side but doesn't guarantee performance; exam tip: check column indexes for slow delegable filters.

Correct answer: C. C. The label's Text property is bound to a context variable that is not being updated by the flow's response.

The label's Text property is bound to a context variable that never receives the flow's returned value, so the UI stays stale despite successful runs. The fix is capturing Run's output into the variable with UpdateContext or Set before binding the label.

Correct answer: D. D. The business rule is configured with a scope of "Per form" rather than "Per table," limiting its evaluation to form interactions.

Business rules scoped to forms only execute during form interactions; setting the scope to the entity makes the rule run server-side for API and flow updates too. Exam cue: entity scope is the only scope that applies outside the user interface.

Correct answer: A. A. The principle of least privilege, as the vendors had more access than necessary.

Mapping two vendors to one Dataverse user gave each vendor access to data beyond what their job requires, which violates least privilege. Separation of duties is about splitting critical responsibilities across roles, which is not the root failure here.

Correct answer: B. B. The AI Builder model has reached its monthly processing limit and has been temporarily disabled.

Exhausting the AI Builder capacity for the environment makes the model appear unavailable even though it still exists and is listed, which matches the sudden failure after prior success. A corrupted file would produce a file-specific error, not a model-availability message.

Correct answer: B. B. The ClearCollect function is completing successfully, but the gallery's Items property is not bound to the correct collection name after loading.

If the collection holds data but the gallery shows nothing, the Items property is bound to the wrong collection name after the load. Mismatched column names would still render blank rows rather than a completely empty gallery, so that distractor doesn't match the symptom.

Correct answer: D. D) 90 days

The CoE Starter Kit's audit and telemetry analytics are built around a 90-day retention window, which supports quarterly trend analysis without heavy storage overhead. Watch for distractors like 28 or 180 days; remember the kit aligns with roughly quarterly governance reporting cycles.

Correct answer: C. C. The date table does not contain dates for the previous year relative to the selected range.

Time intelligence functions return blank when the date table doesn't span the prior-year period, since SAMEPERIODLASTYEAR needs those shifted dates to exist in the marked date table. The keyed answer about contiguous filters is not how the function actually behaves, so the marked answer is wrong.

Correct answer: B. B) Only English is fully supported, with Spanish available as a preview feature

Power BI Q&A historically had full support only in English, which matches the expected exam answer. Be aware Microsoft has since expanded language support, so verify current documentation, but for exam purposes only English was fully supported.

Correct answer: B. B) Classic workspaces

Classic workspaces are the ones tied to Microsoft 365 groups; provisioning a classic workspace creates an M365 group that governs membership. New workspaces deliberately decoupled from M365 groups to allow direct security group and user role assignment, so that option reverses the relationship.

Correct answer: A. A) Set the button's OnSelect property to: Collect(colShoppingCart, ThisItem)

Collect appends the gallery's ThisItem record to the collection, and collections persist across screen navigation. Set and UpdateContext only hold a single value scoped globally or per screen, so they would overwrite the cart each press.

Correct answer: D. D) Set the field's security to "Secured" and create a field-level security profile to grant read permission only to managers.

Field-level security with a secured field and a security profile granting read only to Managers enforces invisibility at the server, on every form and view. Client-side scripts and business rules only hide the UI and can be bypassed or unreliable.

Correct answer: C. C) Create a scheduled Power Automate cloud flow that runs daily, queries for qualifying records, and updates them.

A scheduled Power Automate cloud flow with a recurrence trigger can run daily and query only the qualifying records, then update their status. Business rules and workflows only fire on create, update, or form load, so untouched records older than five years would never be caught.

Correct answer: C. C) The developer must go to the app's "Components" pane and select "Check for updates" or "Import updates" for the library.

Component library updates are not pushed automatically; the maker must open the app and use the Components pane to check for and import library updates. Automatic sync and full rebuild are wrong, and deleting or re-adding instances is unnecessary.

Correct answer: C. C) Use a "Filter query" in the "Get items" action to only retrieve items that need processing, reducing the number of items returned.

Filtering at the source with an OData filter query reduces the number of items retrieved and looped, which directly attacks the timeout. Batching and child flows add complexity, and Dataverse migration is a heavy structural change for a performance fix.

Correct answer: C. C) Create a Power Automate flow triggered when a contact is modified, check if the status changed to inactive, query for related audit findings, and update them.

A Power Automate flow triggered on contact modification can detect the status change, list related open audit findings, and reassign them to the manager. Business rules cannot update related records, and classic real-time workflows are deprecated.

Correct answer: A. A) An administrator changed the DLP policy, moving one of the connectors to a different data group, breaking the flow.

DLP policy changes by an admin, such as moving a connector to a different data group, retroactively break existing flows that combine now-separated groups. License or quota issues produce different error messages, not an explicit DLP violation.

Correct answer: B. B) Set the "Serial Number" column as an alternate key.

An alternate key in Dataverse enforces uniqueness at the data layer, so duplicate Serial Number values fail on create or update, and the key can also be used by external API upserts. Required only ensures a value exists, and business rules can't reliably enforce uniqueness.

Correct answer: C. C) Create and use connection references within the solution for the Outlook and SharePoint connectors.

Connection references decouple the flow from specific connections so administrators can map them to their own connections during import. Hardcoding the developer's credentials is insecure, and editing every action manually defeats a seamless deployment.

Correct answer: B. B) Create a separate environment-level DLP policy for the Marketing BU's environment that overrides the tenant policy, allowing the two connectors to coexist.

Environment-level DLP policies can override tenant policies for specific environments, giving Marketing a controlled exception while the tenant baseline stays intact for everyone else. Editing the tenant policy to move Gmail into the Business group would weaken the mandate for all business units.

Correct answer: C. C) A "Recurrence" trigger that runs daily and queries the Dataverse for all active vendors in the "Due Diligence" stage for more than 5 days.

A daily recurrence trigger with a Dataverse query catches records that sit idle in a stage, which event-based triggers miss entirely. The stage-change trigger fails because nothing fires when a vendor stays in Due Diligence past five days without any update.

Correct answer: B. B) Create a global choice in the Dataverse solution and reference it from the columns on all the required tables.

A global choice is defined once and referenced by columns on many tables, so adding a new option propagates everywhere automatically. Local choices require manual recreation on each table and drift over time, which defeats the reuse requirement.

Correct answer: B. B) Navigate(DetailScreen, ScreenTransition.Cover, {CustomerID: ThisItem.ID})

Navigate's third argument must be a record of update context variables, so wrapping the ID as a named field passes it cleanly to the detail screen. Passing a raw value breaks the syntax, and reading the gallery in OnVisible is brittle if the screen is reached from elsewhere.

Correct answer: B. B) Enable auditing for the Account table and the Credit Limit field in Dataverse, and use the built-in audit log functionality.

Dataverse auditing is server side, so it captures old and new values, the user, and the timestamp for changes from any source, including API and bulk updates. Form JavaScript only fires in the UI, and flows or plugins add reliability and maintenance overhead the native feature avoids.

Correct answer: C. C) Create a custom plugin that validates the dates before the record is written to the database.

A pre-operation plugin queries other sessions and blocks the save before commit, enforcing the no-overlap rule at the data layer for every input path. Business rules can't do cross-record validation, and flows run after the record is saved, so overlaps can slip through.

Correct answer: A. A) In the Power Apps connection settings for SQL Server, select the specific gateway cluster from the list of available gateways.

When creating or editing a SQL Server connection in Power Apps, you explicitly choose which gateway cluster to use from the available list. There is no automatic closest-gateway routing, and custom connector endpoint URLs do not control gateway selection. Know that gateway choice is a per-connection setting.

Correct answer: B. B) In the "Security" tab, under "OAuth 2.0" settings, in the "Scope" field.

The Security tab of the custom connector wizard holds the OAuth 2.0 configuration, including the Scope field where required API scopes are entered. The Definition tab defines action operations and parameters, not authentication. Memorize the custom connector tabs: General, Security, Definition, and Test.

Correct answer: C. C) Use the "AND" operator by adding multiple condition clauses within the same condition block, which is interpreted as an "AND" operation.

Multiple condition clauses inside a single condition block in a Dataverse business rule are evaluated together as an AND, so both Order Total greater than 10,000 and Customer Type equal to VIP must be true. Option D fails because business rules do support AND logic without needing a flow.

Correct answer: A. A) Publish the Power BI report to a workspace, and then use the "Power BI" subgrid control on the form, configured with a filter based on the record's ID.

Publishing the report to a workspace and embedding it with the Power BI tile control on the form, filtered by the record ID, delivers contextual per-record data. Option D fails because dynamic filtering by the current record is a supported capability.

Correct answer: B. B) Create separate environment-level DLP policies for each department's environment. For the Sales environment, place the premium connectors in the "Business" group. For all other environments, place them in the "Blocked" group.

Environment-level DLP policies align with the per-department environment structure, allowing premium connectors as Business in Sales and Blocked elsewhere. Option A fails because per-user exceptions are inefficient and hard to maintain.

Correct answer: B. B) Create a new unmanaged solution, add the flow to it, and make the changes in the unmanaged layer. This will create a layer on top of the managed solution that will persist through updates.

Adding the flow to an unmanaged solution and editing it creates an unmanaged layer on top of the managed CoE solution that survives updates. Option A fails because direct edits to managed components get overwritten on upgrade.

Correct answer: D. D) A synchronous plugin registered on the Update message of the entity.

A synchronous plugin registered on the Update message runs inside the same database transaction, so an exception rolls back the entire operation. Power Automate flows and workflows run asynchronously outside the transaction, so they cannot guarantee rollback.

Correct answer: A. A) Create guest user accounts for the consultants in Azure AD and assign them the appropriate security roles in Dataverse. Share the app with these guest users.

Azure AD B2B guest accounts place external consultants inside the tenant's identity system, so you can assign Dataverse security roles and share the app securely. Direct sharing to outside emails does not auto-provision governed accounts with data access.

Correct answer: B. B) Create separate development and test environments for each subsidiary. When ready for production, export managed solutions from each subsidiary's test environment and import them into the shared production environment.

Separate dev and test environments per subsidiary with managed solutions deployed to shared production gives isolated lifecycle management and protected components. A single shared dev environment or separate tenants fails the isolation or adds excessive complexity.

Correct answer: A. A) Create a component library in Power Apps that contains all the shared design elements (e.g., header component, button styles). Import this library into each app.

A Power Apps component library is the single source of truth for shared UI elements, and consuming apps pick up updates when the library is published. Canvas apps have no design inheritance from a master app, and per-app variables or manual theming cause drift over time.

Correct answer: C. C) The redirect URL configured in the custom connector settings does not match the redirect URL registered for the application in the API's system.

A redirect_uri_mismatch error means the redirect URL in the custom connector differs from the one registered with the API's application. Wrong secrets or scopes produce invalid_client or invalid_scope errors instead, so match the URLs exactly.

Correct answer: B. B) Use a "Compose" action with an expression that uses bracket notation to access the nested property, e.g., body('Parse_JSON')?['level1']?['level2']?['targetProperty']

A single Parse JSON followed by a Compose with bracket-notation expressions reaches any nested property efficiently. Reparsing each level is redundant, and Select or Dataverse storage adds unnecessary steps when you only need one value. Remember the question-mark operator for safe navigation.

Correct answer: B. B) Add an "Action Step" to the business process flow that calls a Power Automate flow. The Power Automate flow can use a custom connector to call the background check service.

Business process flow action steps can invoke Power Automate flows, and the flow can call the third-party service through a custom connector. Option A fails because connectors cannot be embedded directly as business process flow steps. This BPF plus flow plus custom connector pattern is a classic integration answer.

Correct answer: A. A) Assign the System Customizer role to the Sales team and the Environment Maker role to the Service team.

System Customizer lets Sales create and edit business process flows while Environment Maker lets Service build canvas apps without touching the schema. System Administrator violates least privilege, and Basic User cannot create apps. Memorize the maker-versus-customizer-versus-admin permission boundaries.

Correct answer: C. C) Edit the tenant-level DLP policy to add the custom connector to the "Business Data" group, as tenant-level policies apply to all environments.

Tenant-level DLP policies take precedence, so allowing the custom connector requires editing the tenant policy to move it into Business. An environment policy cannot override tenant restrictions, and replacing the connector defeats the integration need.

Correct answer: C. C) Configure a calculated column in Dataverse that uses the DIFFINMINUTES function between the "Start Time" and "End Time" columns.

A Dataverse calculated column computes the duration server-side automatically, keeping the value consistent across every app and API. Power Fx in the canvas app only displays the result in that app, and a flow adds unnecessary latency.

Correct answer: A. A) The BPFs were not activated in the target environment after the solution import.

Business process flows imported in a managed solution often arrive in a draft state and must be activated in the target environment before users can progress stages. Permission or connection issues would normally raise visible errors rather than failing silently.

Correct answer: B. B) Configure customer-managed key (CMK) for the Dataverse environment, linking to the Azure Key Vault where the key is stored.

Customer-managed key encryption for a Dataverse environment links to an Azure Key Vault key, satisfying the security policy with minimal ongoing administration. Microsoft-managed keys don't meet the customer-controlled rotation requirement, and client-side encryption adds heavy custom overhead.

Correct answer: A. A) Configure the "App Audit" process to identify apps shared with more than 10 users and initiate a compliance review workflow.

The CoE Starter Kit's App Audit process inventories apps and their sharing, so it can flag anything shared beyond the threshold and drive a review workflow. DLP policies govern connector groups, not user counts, so that distractor addresses the wrong control.

Correct answer: B. B) Use the SaveData and LoadData functions in Power Apps to store the data and photos locally as collections, and create a Power Automate flow to sync them when a connection is detected.

SaveData and LoadData persist collections locally on the device, then a sync process pushes data and photos to Dataverse once connectivity returns. The Dataverse connector alone does not handle offline scenarios automatically, so relying on it risks losing data.

Correct answer: C. C) By opening the "Developer Compliance Centre" app from the CoE solution and copying its URL from the browser's address bar after it runs for the first time.

The Developer Compliance Centre URL is environment specific, so you get it by opening the app in your CoE environment and copying the browser address. Generic GitHub docs or the admin center can't supply a live app URL, and PowerShell returns environment metadata, not app links.

Correct answer: B. B) Filter(Shifts, 'Volunteer (Volunteers)'.Email = User().Email)

Filter returns a table for the gallery, and dot notation through the lookup column reaches the related volunteer's email to compare with User().Email. LookUp returns only one record, and Search does text matching rather than exact lookup filtering.

Correct answer: B. B) The flow was imported as a managed solution, and the connection references were not updated to use valid connections in the target environment.

The keyed answer A is wrong; the correct cause is B. When a managed solution like the CoE Starter Kit is imported, connection references must be mapped to valid connections in the target environment before enabling flows. Licensing, roles, or storage limits do not produce a missing connection reference error. Set connection references at import time to avoid this.

Correct answer: B. B) Create a new Dataverse environment hosted in an EU datacenter and migrate all EU-related data to that environment. Use separate apps and integrations for each region.

Dataverse data resides in the region where the environment is provisioned, so meeting EU residency requires a new EU-hosted environment with the EU data migrated to it. Customer-managed keys control encryption, not storage location, and DLP governs connectors, not residency. Remember: environment region equals data region.

Correct answer: B. B) Navigate to the Office 365 Security & Compliance Center and search the audit logs for "Share app" activities.

The Microsoft Purview compliance portal audit log search captures canvas app sharing events like who, with whom, and when, well beyond the 28-day analytics window. The PowerShell cmdlet covers connection role assignments, not app sharing. For historical audit questions, think Unified Audit Log first.

Correct answer: A. A) Use a series of "Compose" actions with string manipulation expressions like split(), first(), and last() to extract the name parts, with conditions to handle cases where the name is missing.

Compose actions with split, first, and last expressions plus conditions let the flow parse the From field and handle missing display names. Option B fails because the Get user profile action cannot reliably resolve external senders.

Correct answer: B. B) Two separate "Start and wait for an approval" actions running in parallel branches within the same flow, with a condition at the end to check both outcomes.

Two Start and wait for an approval actions in parallel branches run the approvals simultaneously, and a final condition checks both outcomes before proceeding. Option A is arguably defensible since a single approval with multiple assignees can require all approvals, creating some ambiguity.

Correct answer: A. A) Use the "Pen input" control to capture the signature, convert the control's output to a base64 string using the JSON function, and pass this string to a Power Automate flow to decode and save as a file attachment.

The Pen input control captures the signature, and passing its base64 image output through a Power Automate flow reliably decodes and saves the file with metadata. Option C is brittle because directly patching binary data to a file column is error-prone.

Correct answer: A. A) Create a branch directly from the "Underwriting" stage with two paths: one to "Final Approval" and one to "Senior Underwriter Review." Then connect "Senior Underwriter Review" to "Final Approval."

Business process flows support branching from a stage, with paths that can rejoin at a later stage like Final Approval. The claim that branches must immediately resolve to the same stage is wrong; conditional branching is a core BPF feature.

Correct answer: B. B) Store the API key as an environment variable in the solution and reference it in the custom connector's policy.

Storing the key in an environment variable keeps it out of the connector definition and supports per-environment values, which is the intended ALM pattern. Hardcoding is insecure, and manual entry or table lookups add risk and friction.

Correct answer: B. B) The analyst can add new options to the standard choice, but cannot delete or modify the default options provided by Microsoft.

You can extend a Microsoft global choice by adding organization-specific options, but the built-in Microsoft options cannot be deleted or modified. Custom additions persist through updates and do not require replacing the entire choice.

Correct answer: D. D) "No Business Data Allowed" group, because new connectors are added to the default data group of the most restrictive policy applied to the environment.

When tenant and environment DLP policies both apply, the most restrictive policy wins, so the new connector lands in the No Business Data Allowed group. Remember environment policies can't loosen what the tenant policy restricts; only merging into the tenant policy can.

Correct answer: A. A) Use a Power Automate flow triggered when the job status changes to "Complete." Use the "Word Online (Business)" connector to populate a Word template and convert to PDF.

A Power Automate flow triggered on the Dataverse status change, populating a Word template and converting to PDF, is fully low-code and maintainable. Manual print-to-PDF is error-prone, custom JavaScript breaks the low-code requirement, and third-party connectors add licensing dependencies.

Correct answer: B. B) Use the Power BI dashboard provided by the CoE Starter Kit, which includes a "Connectors" report showing all flows grouped by connector type.

The CoE Starter Kit's Power BI dashboard aggregates flows by connector across all environments, making tenant-wide compliance reviews efficient. Manual admin center checks and CSV exports don't scale across 50-plus environments, and self-reporting by makers is unreliable.

Correct answer: D. D) The user viewing the dashboard does not have read permissions on the CoE Dataverse tables.

Power BI respectes Dataverse security, so a viewer without read permission on the CoE tables sees an empty Apps tab even though the data exists. Since flows run, tables have data, and the connection is correct, permissions are the remaining cause; expired trials block everything.

Correct answer: D. D) The Business Card Reader model may have limited support for special characters, and the image quality is insufficient for accurate OCR.

Garbled characters from OCR typically stem from the model's limited character support plus poor image quality, which option D captures. Option C fails because Dataverse stores Unicode natively, so garbling would appear at extraction time, not at the write step. Keep OCR questions focused on the extraction stage.

Correct answer: B. Create a separate environment-scoped DLP policy for the Finance environment that blocks the social media connectors, and ensure no tenant-wide policy overrides it.

An environment-scoped DLP policy blocks the connectors only in Finance while Sales and Marketing keep access. Tenant-wide policies affect every environment, contradicting the requirement. For exam purposes, environment-level DLP policies are the tool for per-environment connector restrictions.

Correct answer: C. C) Create a calculated column on the feedback table that uses a formula referencing the region and sentiment columns.

A calculated column computes the value in real time from region and sentiment, so views can sort and filter it immediately. A flow introduces latency, and rollup columns aggregate related records rather than derive a single record's score. Calculated columns are the go-to for real-time derived values.

Correct answer: B. B) It collects audit log data from Office 365 Security and Compliance logs and stores it in Dataverse tables.

The Audit Components flow ingests activity data from the Microsoft 365 Security and Compliance logs into Dataverse tables for reporting. Dashboards and welcome emails are downstream or separate components. For CoE kit questions, remember each solution maps to a distinct governance function.

Correct answer: A. A) A 'Parse JSON' action followed by a 'Condition' control to evaluate the property and a 'Post message in a chat or channel' action.

Parse JSON validates the complex structure, then a Condition routes to the right Teams channel action for posting the message. Compose does not validate JSON, and loops add needless complexity. The pattern is always parse first, then branch, then act.

Correct answer: C. C) Basic User · D. D) Environment Maker

Environment Maker lets users create canvas apps and cloud flows, while Basic User grants the runtime access needed to work with data in the environment. System Customizer would allow schema changes to tables and columns, which the requirement explicitly excludes.

Correct answer: A. A) Configure the default data group for all tenant-level DLP policies to be "No Business Data Allowed." All new custom connectors will be added to this group by default.

DLP policies let admins set the default connector group for new connectors, so routing them to No Business Allowed enforces the restriction automatically at creation. The other options rely on maker behavior or after-the-fact cleanup rather than automatic policy enforcement.

Correct answer: A. A) A Power BI report with a bar chart visual and drill-through functionality, embedded in a model-driven app dashboard.

Power BI embedded in a model-driven app dashboard delivers the aggregation, drill-through to detail, and near real-time refresh the scenario needs. Native charts and subgrids are simpler but lack true drill-through, and a custom canvas app adds unnecessary build and maintenance effort.

Correct answer: B. B) Export Solution → Unpack Solution → Pack Solution → Import Solution

The standard ALM pipeline is Export Solution, then unpack to source control, pack as managed, and import to target environments. Export as Managed skips source control, and option A mixes non-existent task names. Remember the export-unpack-pack-import mantra for CI/CD questions.

Correct answer: B. B) A public view in the model-driven app designer, saved with the opportunity table.

A public view created on the Opportunity table in the model-driven app designer is available to everyone with access, satisfying the requirement. Personal views and Advanced Find only reach users they are shared with, and the classic solution explorer is the legacy path. Public views are the exam answer for all-user visibility.

Correct answer: D. D) Azure Data Factory to orchestrate the pipeline, using a lookup activity to get the file, a data flow for transformations, and a copy activity to load into Dataverse.

Azure Data Factory is the recommended tool for scheduled, low-touch ETL with transformations, orchestrating FTP extraction, data flow transformations, and Dataverse loading. Power Automate is limited in throughput and transformation power for nightly bulk loads. Note PL-200 leans functional, so heavy ADF is at the edge of scope.

Correct answer: B. B) Add the field to the second stage and configure a business rule on the underlying table to make it mandatory based on the value from the first stage.

Business rules can show or hide the field and set its requirement level based on the first-stage value, giving declarative conditional logic in the BPF stage. Branching changes which stages run rather than fields within a stage, and JavaScript is unnecessary here. Prefer business rules for no-code field logic.

Correct answer: B. B) xml <fetch> <entity name="account"> <filter> <condition attribute="address1_stateorprovince" operator="eq" value="Washington" /> </filter> <link-entity name="contact" from="contactid" to="primarycontactid" link-type="inner" alias="pc"> <attribute name="fullname" /> </link-entity> </entity> </fetch>

Starting from account, filtering on state, and linking contact with from contactid to primarycontactid correctly joins the primary contact for Washington accounts. Option C is close but the link-entity direction and filter placement make it incorrect.

Correct answer: B. B) High database storage usage, especially due to audit logs, can impact write performance as the system manages index maintenance and log writes.

High storage usage combined with heavy audit logging is the most likely culprit, since writes must maintain indexes and audit entries under storage pressure. API throttling would show as intermittent request failures, not sustained slow saves tied to a nearly full database.

Correct answer: D. D) Any of the above approaches are technically valid, but using a custom connector provides the best reusability and management experience.

All three approaches can technically call the REST API, but a custom connector centralizes authentication, schemas, and error handling for reuse across flows and apps. On the exam, look for the option emphasizing reusability and centralized governance when integrating external APIs repeatedly.

Correct answer: B. B) "John " (John followed by a trailing space)

The concatenation treats a blank last name as an empty string, so John plus a space plus nothing yields John with a trailing space. Dataverse doesn't null the result or throw an error; the formula evaluates cleanly with an empty operand.

Correct answer: B. B) Use Power Query in Power BI Desktop to combine the data from all three sources, build a single report, and publish it to the Power BI service. Embed this report in a model-driven app dashboard.

Combining all three sources with Power Query into one Power BI report and embedding it in a model-driven app gives a unified, cross-device view with one refresh schedule. Splitting reports or building ETL into Dataverse fragments the experience and adds maintenance overhead.

Correct answer: A. A) Add a branching condition after the "Credit Check" stage based on the credit score. For the "below 600" branch, do not add any subsequent stages.

BPF branching lets you route based on the credit score field, and leaving the below-600 branch with no further stages stops progression. JavaScript on BPF navigation is brittle, and the claim that a flow is required is false since branching is built in.

Correct answer: A. A. Average line

The Average line in the Analytics pane recalculates from whatever data the visual currently shows, so it follows slicer and filter context. A Constant line stays at one fixed value regardless of the selected date range, which is why it fails here.

Correct answer: A. A. Create a custom intersect table with the additional fields

A custom intersect table with lookups to both tables and extra columns like Role and Start Date is the right pattern, since native many-to-many relationships cannot hold attributes on the link. On the exam, remember that as soon as you need data about the relationship itself, model it as an intermediary table with two one-to-many relationships.

Correct answer: B. B. Solution packages

Solutions are the standard container for packaging apps, flows, tables, and other components so they can be exported and imported between dev, test, and production environments. Build Tools and DevOps pipelines automate moving solutions but aren't the unit of deployment itself; environment variables only parameterize configuration.

Correct answer: D. Branching rules within a single business process flow

Branching rules inside a single business process flow let stage paths diverge based on field values like Account Type. Business rules control field behavior, not stage navigation, and maintaining separate flows or workflow-driven switching adds unnecessary complexity.

Correct answer: B. B) An Editable Grid custom control on the sub-grid.

The Editable Grid custom control is the built-in way to enable in-line editing of related records directly in a sub-grid on a model-driven app form. Quick View forms are read-only, and business rules or JavaScript are not required to enable grid editing on the exam.

Correct answer: A. A) Many-to-One (N:1)

A lookup field lives on the Account table, so from Account's perspective many accounts point to one user, which is an N:1 relationship. The exam cue is to name the relationship from the table holding the lookup, not the referenced table.

Correct answer: B. B. A rollup field that uses the SUM aggregate function on the "Line Amount" from the child records.

A rollup field with SUM aggregates related child records and stores the value, making it sortable, filterable, and report-friendly without real-time computation. The strongest distractor, a calculated field, cannot aggregate across a one-to-many relationship in Dataverse.

Correct answer: C. C. Customize the standard "Campaign" table by editing the display name and adding the new column.

Dataverse fully supports customizing standard tables, so renaming the Name column's display label and adding a Campaign Theme column is the recommended, lowest-friction approach. Creating a duplicate custom table invites data migration and integration issues, making it a poor distractor choice.

Correct answer: C. C. Use the trigger's "Filter Attributes" option to specify which column changes should start the flow.

Filter Attributes on the Dataverse trigger restricts firing to changes in specific columns, cutting unnecessary runs at the source. A first-step condition still consumes a run every time any column changes, so it saves downstream work but not triggers or licensing consumption.

Correct answer: A. A. Use the Order By field in the action's advanced options and enter accountname desc.

The Dataverse List records action exposes an Order By field under advanced options that accepts a field name plus direction, so accountname desc returns records from Z to A. Filter Query is only for WHERE-style conditions, not sorting.

Correct answer: B. B. Get-AdminFlow

Get-AdminFlow is the admin-scoped cmdlet that enumerates flows across environments with owner and environment metadata for audits. Get-FlowEnvironment returns environment details only, while Get-FlowRun covers execution history of a single flow.

Correct answer: C. C. Use the Filter function in the Items property to reduce the number of choices.

Filtering the Items property limits how many records the dropdown retrieves from Dataverse, which directly cuts loading time, especially with a delegable predicate. Swapping controls or toggling DelayOutput changes interaction behavior without reducing the dataset.

Correct answer: B. B. Environment Variables

Environment variables store per-environment values, so the API URL can be set differently in Dev, Test, and Prod and referenced at deployment time. Connection references manage authentication to a connector, not variable endpoint addresses.

Correct answer: A. A. A Drillthrough action.

A drillthrough page lets the consumer right-click or click a bar and land on a detail page already filtered to that category. Bookmarks save page state but don't pass the clicked category's filter context to another page automatically.

Correct answer: B. B) A synchronous plugin registered on the Update message of the Project entity that performs the calculations and, if needed, creates an approval request record.

A synchronous plugin on the Update message runs inside the Dataverse transaction, so the calculation and approval record either commit together or roll back together. Power Automate flows always execute outside the transaction, which is why options A and C fail the atomicity requirement.

Correct answer: A. A) The flow is exceeding the Power Platform service protection API limits. Implement retry policies with exponential backoff and consider batching multiple operations per API call.

A 429 error is the classic sign of Dataverse service protection limits being exceeded at high call volume. The fix is retry with exponential backoff plus batching to reduce call count. Storage limits or connection identity do not produce throttling errors.

Correct answer: D. D. Implementing an aggregation on a CustomerComments text column for distinct count.

Aggregations work best on numeric measures at a lower grain, and options A, B, and C all fit that pattern. A distinct count over a free-text comment column cannot be pre-summarized effectively, so D delivers essentially no performance gain.

Correct answer: D. D. ISMEMBEROF()

ISMEMBEROF checks at query time whether the current user belongs to a specified Microsoft Entra security group, which is exactly what dynamic RLS needs when group membership is not stored in the model. USERPRINCIPALNAME only identifies the user and still requires a lookup table.

Correct answer: C. C. Cause: The TOTALYTD function defaults to the calendar year. Solution: Use the optional year_end_date parameter to specify the fiscal year end.

TOTALYTD defaults to a calendar year ending December 31, so a fiscal year starting April 1 needs the optional year_end_date argument set to March 31. Marking the table as a date table is good practice but does not fix the fiscal boundary, which makes option A the tempting but wrong distractor.

Correct answer: A. A. One-to-many (1:*) from DimDate to FactInventory on the DateKey.

One date relates to many snapshot rows, one per product per day, so DimDate to FactInventory on DateKey is a standard one-to-many relationship. Composite keys or many-to-many cardinality add needless complexity and can break filter propagation in the star schema.

Correct answer: C. C. Use the Q&A setup tool to add "profit" and "margin" as synonyms for the [Gross Profit Margin] measure.

Adding synonyms through the Q&A setup tool maps natural terms like profit and margin to the intended measure across many phrasings. A predefined question only covers one exact phrase, so it fails when users word the question differently.

Correct answer: A. A. SELECTEDVALUE('Discount Rate'[Discount Rate])

SELECTEDVALUE returns the single slicer choice from the parameter table, or a default when nothing is selected, making it the standard pattern for What-If measures. MAX could return a value the user did not pick, and VALUES returns a table, not a scalar.

Correct answer: B. B. DISTINCTCOUNT('Sales'[CustomerID])

DISTINCTCOUNT on the Sales foreign key counts each customer once within the current period's filter context, which is exactly the buying-customers pattern. COUNTROWS on Customer ignores purchases entirely, and ALL would strip useful user filters.

Correct answer: A. A. Create a hierarchy in the Geography table with levels Country, State, City.

Building a Country, State, City hierarchy and placing it in the map's location well enables native drill-down with the drill controls. Drillthrough pages navigate to detail pages instead, and maps do support hierarchies, so the other options don't apply.

Correct answer: A. A. Use the "Get tables" action first to dynamically identify the table name

The Get tables action enumerates tables at runtime, letting you pass the discovered name into List rows present in a table. A hardcoded table name fails the moment the file uses a different suffix like Feb instead of Jan.

Correct answer: B. B. Add more training images specifically showing the differences between washers and nuts

Adding targeted training images that highlight the visual differences between confused classes directly fixes inter-class confusion in AI Builder object detection. Augmentation can help generalization but doesn't specifically teach the model to distinguish washers from nuts, so it's the weaker distractor.

Correct answer: C. C. Custom PCF control

A Power Apps Component Framework control can be configured for both form fields and grid columns, giving a consistent indicator in both places. HTML web resources and JavaScript only work on forms, so they can't cover the grid view.

Correct answer: B. Add Refresh(DataSource) to the OnSuccess property of the patch operation

Calling Refresh on the data source right after a successful Patch forces the gallery to re-query and drop the now-inactive record. Galleries have no AutoRefresh property, and switching to Search() or a collection doesn't address stale data after a write.

Correct answer: A. A. Power Automate flow triggered when a case is updated

A Power Automate flow triggered when the case is resolved can delay seven days and then create the follow-up activity reliably on the server. Classic workflow wait conditions technically work but are deprecated for new automation, so exam answers favor Power Automate for time-based follow-ups.

Correct answer: B. B. Convert the CSV to JSON and use the "Compose" action to access properties

Converting the CSV to JSON lets the flow access whatever columns exist at runtime by name, so no fixed schema is required. Parse CSV with a predefined schema fails when columns vary, and Excel tables or Dataverse imports both demand a stable structure.

Correct answer: C. C. Create an alternate key using the three fields

A Dataverse alternate key on the three fields enforces a server-side unique constraint across imports, APIs, and the UI. Business rules and workflows only run client-side or after save and can be bypassed, while an index speeds queries without preventing duplicates.

Correct answer: A. A) A Rollup Field

A rollup field is the standard Dataverse mechanism for aggregating child record values, such as a sum, onto a parent table, and it is read-only by design. Calculated fields cannot aggregate across related child records, so they fail the core requirement despite being real-time.

Correct answer: B. B) Use the Delegable functions within the Filter criteria and ensure the filter is applied on indexed columns in SharePoint.

Using delegable filter functions on indexed columns pushes the query to SharePoint so only matching rows cross the wire, which is the biggest performance lever on large lists. Collecting the whole list up front just moves the slowdown to app start and risks hitting row limits.

Correct answer: B. B) Create a Power Automate cloud flow that is triggered when the BPF stage changes, checks for the final stage, sends a Teams approval, and uses a Dataverse action to set the record's status to "Locked."

A cloud flow triggered on the stage change can detect the final stage, send the Teams approval, and update the record state to enforce the lock. On-demand workflows need manual runs, and business rules only affect the form UI, so neither enforces the requirement reliably.

Correct answer: C. C) Use the Centre of Excellence (CoE) Starter Kit's Power BI dashboard and look at the "Connections" report.

The CoE Starter Kit's Power BI dashboard aggregates connector usage across flows and environments, so the Connections report surfaces the legacy connector instantly. PowerShell or CSV exports require per-flow parsing and manual filtering that do not scale across a default environment.

Correct answer: C. C) Use the "Find Element" action with the element's underlying accessibility properties (like Name or AutomationId) via the UI Element's "Advanced" options.

Targeting stable accessibility properties like Name or AutomationId anchors the automation to the control itself, immune to position and resolution changes. Tab counts and hardcoded coordinates break with any layout change, and OCR offsets are fragile in legacy apps.

Correct answer: A. A) The Dataverse table's "Create" privilege was not included in the security roles assigned to production users.

Opening the app but failing on submit points to a missing Create privilege on the target table in the users' production security roles. Connection reference or DLP problems surface as connection or policy errors, not a per-record permission failure at save time.

Correct answer: A. A) Create an Auto-number column with the required format and set it to be "Server-based".

An Autonumber column with a format like DOC-{SEQNUM} generates unique, sequential, org-wide values atomically at creation time. Flows and business rules risk race conditions with concurrent record creation, and calculated fields cannot generate sequences.

Correct answer: B. B) A Web Role must be created and assigned the necessary permissions on the "Case" table.

Anonymous portal users act under a web role, so a web role with create permission on the Case table must be configured and assigned for anonymous form submissions. Remember that Power Apps portals use table permissions tied to web roles; offline, environment isolation, or multiple-forms settings never grant Dataverse access.

Correct answer: A. A) Scale to fit: On, Lock aspect ratio: Off, Lock orientation: Off

Scale to fit On with aspect ratio and orientation unlocked lets the app scale independently in both dimensions and rotate freely, filling any screen without letterboxing. Locking the aspect ratio produces empty bars on mismatched screens, and locking orientation breaks support for both phone and tablet postures.

Correct answer: C. C) Ensure the column used in the OData filter is an indexed column in the Dataverse table.

Filtering on an indexed column lets Dataverse resolve the OData query server-side quickly instead of scanning thousands of rows, which prevents slow runs and timeouts. Filtering in the flow with Filter array pulls all records across the connector first, which is slower and worsens timeouts.

Correct answer: A. A) The rollup field's calculation job has failed or has not yet run.

Rollup fields are computed by an asynchronous system job that runs on a recurring schedule, so a failed or not-yet-run job leaves the value at zero regardless of qualifying child records. Remember rollups also cannot aggregate calculated or rollup fields, and recalculations can be triggered manually per record.

Correct answer: B. B) Use JavaScript form scripting to monitor the BPF stage and set the visibility of the section.

JavaScript responding to the BPF stage change event can set section visibility on the form in real time when the final stage is reached. Business rules cannot detect stage changes and only show or hide fields, not sections, while a flow updating a field would require a form refresh to take effect.

Correct answer: A. A) A Tenant-wide DLP policy that places social media connectors in the "Blocked" data group.

A tenant-wide DLP policy in the Power Platform admin center can classify connectors like Twitter and Facebook as Blocked, preventing their use in any flow across all environments. Environment-level policies leave gaps, and scripts only clean up after the fact.

Correct answer: B. B) The condition for the Do Until loop is never met, creating an infinite loop.

If the exit condition is never satisfied, Do Until loops indefinitely until the flow times out, which matches the symptom. Slow or complex actions would extend duration but not alone cause a timeout without an exit failure.

Correct answer: A. A. Conditional branching logic based on the defect severity field.

Business process flows support conditional branching on field values, which routes users down the correct stage path automatically. A business rule can hide stages, but it does not steer users through the proper sequence the way branching does.

Correct answer: C. C. The flow actions are not configured to handle concurrency issues and race conditions.

The correct answer works because parallel flow runs triggered by rapid Task updates can read stale sums and overwrite each other, producing intermittent incorrect totals — a classic race condition. An incorrect aggregate function would cause consistently wrong totals, not errors tied to rapid successive updates.

Correct answer: B. B. Use the "Sort by Column" feature to sort the "MonthName" column by the "MonthNumber" column.

The Sort by Column feature tells Power BI to order the text MonthName column using the numeric MonthNumber column, fixing alphabetical sorting automatically on every refresh. Manual reordering in the source query is the tempting distractor but is not sustainable.

Correct answer: D. D. Enable trigger conditions to filter the events that start the flow.

Trigger conditions filter which events actually start the flow, so only meaningful changes fire the approval and duplicates disappear without losing update coverage. Switching to create-only would stop the duplicates but breaks approvals for edits to existing items.

Correct answer: B. B. The connection used by the flow, not the user's current login, has invalid or expired credentials.

Flows authenticate through stored connections, which hold their own credentials independent of the user's current login. If the password changed or the token expired, re-authenticate the connection under Data > Connections. A missing license would block flow use entirely, not cause a single Unauthorized error.

Correct answer: B. B. Sentiment Analysis and Key Phrase Extraction.

Sentiment Analysis evaluates the tone of each ticket, and Key Phrase Extraction pulls out terms that drive routing to the right department. Business card and object detection models are image-based, and form processing targets structured forms, not free-text email bodies.

Correct answer: D. D. Create a separate environment for each team.

Environments are the strongest security boundary in Power Platform, so one environment per team isolates apps, flows, and data completely. Environment Maker grants creation rights but not isolation, and business units segment Dataverse records without hiding other teams' apps or flows.

Correct answer: C. C. Error Message

The Error Message action in a business rule displays the error and blocks the save, which matches the requirement. Condition only evaluates the logic, Recommendation just suggests, and Lock disables fields without preventing the record save.

Correct answer: B. B. The connections used in the flow are set to use the member's connections, which are not configured. · C. C. The flow uses a premium connector and the group member does not have a Per User plan.

When a shared button flow runs as another user, unconfigured connections and missing premium licensing are the classic failure causes. Storing the flow in My flows is a distractor because the scenario already states it was shared with the group.

Correct answer: B. B. A One-to-Many relationship from "Project" to "Task" does not exist.

Rollup fields need an existing relationship path to the related table, so without the Project-to-Task one-to-many relationship the aggregation UI cannot be configured. Missing numeric fields or security would produce errors later, not a hidden interface.

Correct answer: B. B. Tenant Scope using "Add all environments"

A tenant-level DLP policy set to add all environments covers every environment, including newly created ones. Environment scope applies to one environment only, and connector or database scope are not valid DLP policy scopes.

Correct answer: A. A. Increase the concurrency control setting of the "Apply to each" loop.

Enabling concurrency on an Apply to each loop runs iterations in parallel and cuts total runtime for large arrays. Do until adds sequential waiting, and filtering or limiting skips data rather than making required work faster.

Correct answer: D. D. URL

The URL sitemap component opens an external web address directly from the app navigation. Page is for internal app content, and Group and Sub-Area are structural containers rather than link types.

Correct answer: A. A. Conditional Branching

Business process flows support conditional branching, which routes the stage navigation based on field values, letting the process skip Qualify when Company Size equals Enterprise. Business rules change field values or visibility but do not drive stage-to-stage navigation.

Correct answer: B. B. It is intended for development and can be layered upon by other solutions.

Unmanaged solutions are the development layer where components stay fully customizable and can be built upon by other solutions. Managed solutions are the locked, distribution-ready artifacts, so the sealed and read-only descriptions belong to those instead.

Correct answer: D. D. match

The match function applies a regular expression such as INV-\d{5} against the email body and returns the matched value regardless of position. substring and split depend on fixed positions or delimiters, which are unreliable in long, free-form email text.

Correct answer: B. B) Create new versions of each custom connector with authentication policies referencing Azure Key Vault, update all flows and apps to use the new connectors, then deprecate the old ones.

Creating new connector versions backed by Azure Key Vault authentication lets you migrate flows and apps gradually without breaking them, then retire the insecure connectors. Deleting connectors outright, as in option A, would break every dependent flow and app immediately.

Correct answer: B. B) if(less(parseDateTime(triggerBody()?['timestamp'], 'dd/MM/yyyy HH:mm:ss'), addMinutes(utcNow(), -5)), 'Reject', 'Accept')

parseDateTime with the format string correctly interprets the custom timestamp, and addMinutes(utcNow(), -5) sets the five-minute cutoff before comparing with less(). Option D fails because it omits the format specifier, so parsing the custom format is unreliable.

Correct answer: A. A) Replace the Search() function with Filter() and use delegable operators only.

Filter with delegable operators like StartsWith pushes the query to Dataverse, so indexing is used server-side and results come back fast. Search is not delegable for Dataverse, which forces local evaluation and explains the long delays.

Correct answer: B. B) Create separate Dataverse environments in each region for transactional data. Use Azure Data Factory to replicate non-sensitive aggregated data to a central environment for global reporting.

Regional environments keep each region's transactional data in its own datacenter, and replicating only aggregated, non-sensitive data centrally preserves a global view. Security measures like column-level security or customer-managed keys never change where data physically resides.

Correct answer: C. C) The relationship between the tables used in Stage 2 and Stage 3 was modified or broken in the new solution version.

A multi-table business process flow depends on the relationships between its tables, so a broken or modified relationship after a solution update silently blocks the stage transition. Deactivation or missing security roles would produce visible errors, not a silent failure between two specific stages.

Correct answer: B. B) Store all secrets in Azure Key Vault, create a custom connector that retrieves secrets from Key Vault, and have all flows call this connector to get secrets at runtime.

Azure Key Vault with a custom connector gives centralized secrets, policy-based access, auditing, and rotation that flows pick up at runtime. Environment variables lack fine-grained access control and automated rotation, making them weaker for this scale.

Correct answer: B. B) Create separate Dataverse environments for each business function (HR, Finance, Operations). Migrate related databases to their respective environments and build targeted apps.

Separate environments per business function give clean security boundaries for sensitive HR data, staged migration, and independent lifecycle management. A single consolidated model across fifty databases raises governance risk and blast radius far beyond what role-based control alone can manage.

Correct answer: D. D) Use a "Do until" loop that iterates through an array of approvers determined by the request amount, sending sequential approvals and checking for rejection at each step.

A Do until loop over an approver array cleanly models sequential, variable-length chains with exit on any rejection. That said, a Switch with chained approval actions per case is also a workable design many consultants would defend as simpler to read.

Correct answer: B. B. Change the cross-filter direction of the relationships to "Single".

Single-direction cross-filtering simplifies the queries DirectQuery sends to the warehouse, which speeds up multi-filter reports without touching the source. The index option would actually help, but it changes the data source, violating the stated constraint.

Correct answer: B. B. Create a new version of the dataset in a separate workspace and use deployment pipelines to promote it.

Deployment pipelines let you build and validate the new dataset in a separate workspace, then promote it only when ready, keeping users undisturbed. Publishing the pbix directly or replacing the dataset can break active sessions with no easy rollback path.

Correct answer: B. B. Create a function in Power Query that takes a project ID as a parameter and returns the tasks, then invoke this function for each project.

Wrapping the second API call in a parameterized Power Query function and invoking it per project is the standard, reusable pattern for dependent REST calls. A full outer join cannot work because the task data does not exist until each project ID is fetched.

Correct answer: D. D. The connection between the report and the dataflow uses Import mode, and the dataset needs to be refreshed separately.

With an Import-mode connection, a dataflow refresh only updates the dataflow entities; the dataset must run its own refresh to pull the new data in. Scheduling the dataset refresh right after each dataflow refresh closes the gap that causes stale reports.

Correct answer: A. A. Rewrite the measure using the SWITCH function.

SWITCH is optimized for mutually exclusive conditions and replaces nested IF chains with a single evaluation path the engine handles more efficiently. Splitting into smaller measures only improves readability; it does not reduce, and may add, evaluation overhead at query time.

Correct answer: D. D. The table's storage mode is set to DirectQuery.

Incremental refresh only works for tables in Import mode; in DirectQuery the policy is ignored and the source is queried for the full history. Remember the Import-mode requirement, plus RangeStart and RangeEnd parameters, as core exam checks.

Correct answer: A. A. The Targets table is not related to the Product table.

Filters only flow across existing relationships, so a Product Category filter cannot reach a Targets table with no relationship path to Product. The ALL explanation would require seeing the measure definition, while a missing relationship is the structural, most likely cause.

Correct answer: A. A. Refresh the dataset in the Power BI service.

A dataset refresh forces Power BI to re-read the underlying schema, so the new column appears in the fields list while reports stay intact. Editing the query and republishing also works, but a service refresh is the simplest path and avoids replacing dataset settings.

Correct answer: D. D. "Allow users to make a copy of this report" setting in the workspace.

The workspace setting for allowing report copies creates an independent editable replica, so changes never touch the original. Sharing only controls access to the existing report, and exporting produces a static file, neither of which meets the requirement.

Correct answer: A. A. The ALL('Product') function removes the category filter, so it's ranking all products, not just those in the category.

ALL removes every filter from the Product table, including the category filter, so each row ranks against the full product list. To rank within categories, use ALLEXCEPT to keep the category filter while clearing the rest.

Correct answer: B. B. Use the BusinessCardReader.Scan method, store the extracted JSON text in a local collection upon success, and use a sync button to batch process the collection when online.

Storing scan results in a local collection and syncing later follows the offline-first pattern using collections and SaveData, then Patch when connectivity returns. Immediate Patch to Dataverse is the strongest distractor but fails whenever the connection drops mid-scan.

Correct answer: B. B. The flow will continue to run without any issues.

A DLP policy only affects flows containing a connector from the Blocked group, and this flow uses only SQL Server from the Business group. Remember, compliant flows keep running; suspension happens only when a flow actually includes a blocked connector.

Correct answer: A. A. The relationship from the parent entity to the Opportunity entity is a many-to-many (N:N) relationship. · B. B. The Total Sales field in the Opportunity entity is of the "Single Line of Text" data type.

Rollup fields require a one-to-many relationship path and a numeric source column, so an N:N relationship or a text data type blocks creation. MAX is a valid aggregate, and nine existing rollups still leaves room within the ten-field limit.

Correct answer: B. B. The flow is experiencing concurrency issues. Enable concurrency control in the trigger settings.

Duplicate emails come from concurrent flow runs triggered by rapid or repeated item changes, and enabling concurrency control with a degree of parallelism of one serializes them. Changing to create-only would break the required behavior on updates, so it is the weaker fix.

Correct answer: B. B. Add Refresh(SharePointList) to the OnSuccess property of the Form control

Calling Refresh on the data source in the form's OnSuccess property forces a fresh fetch right after a successful submit, so the gallery shows current data. Galleries have no AutoRefresh property, and Reload is not the standard mechanism here.

Correct answer: C. C. The business rules need to be manually activated after import

Business rules can arrive in a deactivated state after solution import, so they must be activated in the target environment before they execute. If the import had failed from missing privileges, the solution itself would not have imported successfully.

Correct answer: A. A. Web roles for anonymous users

Anonymous portal users inherit access through an anonymous web role, so table permissions alone won't surface records until that web role is assigned. Remember on portal questions: web roles, not security roles, govern Dataverse data visibility for anonymous visitors.

Correct answer: C. C. Implement a unique constraint in the Dataverse table

A server-side unique constraint in Dataverse guarantees no duplicates regardless of client behavior or network retries. Disabling the button during submission is a strong practical pattern too, though it only protects the UI layer, which is why C is preferred.

Correct answer: A. A. Use the User() function to get the current user's email and look up their roles

User().Email identifies the current user, and you can then look up their security roles in Dataverse, keeping everything native to the app. Office 365 profile functions don't know Dataverse roles, and while querying System User Roles directly can work, option A describes the complete, intended pattern.

Correct answer: B. Text Recognition model

Text Recognition performs OCR, which extracts raw text from PDFs and image-based documents regardless of layout, matching the requirement. Form Processing only works on structured forms with a trained layout, so it fails on varied document types; the marked answer of Form Processing is wrong.

Correct answer: D. D. The users are members of multiple security roles with different rules

Power BI unions the RLS filters from all roles a user belongs to, so extra role memberships make same-role users see different data. Exam cue: multiple roles give the most permissive union, and page filters would affect everyone on that page, not just some users.

Correct answer: B. B. Use the "List records" action with pagination

Enabling pagination on the List records action retrieves large datasets in pages, keeping each call within timeout limits. A manual Do Until loop can work but is more error-prone, and you cannot simply raise the timeout on a Power Automate action.

Correct answer: B. B. Some "Last Name" fields contain null values; modify the formula to handle nulls

Null Last Name values are being coerced to the literal string "null" during concatenation, so the formula must handle nulls explicitly. Re-mapping or resizing the field would not explain why only some records display the literal text "null".

Correct answer: C. C) There is a replication delay in Azure AD after creating a new user object; the solution is to implement a retry policy or a loop that checks for the user's presence before adding to the group.

Newly created Entra ID user objects need time to replicate before group membership succeeds, so a retry or wait-until-present loop fixes it. Permissions or throttling would fail for existing users too, which contradicts the pattern described in the scenario.

Correct answer: D. D) Split the flow into two separate flows: one (Business) that processes the data and writes to a Dataverse table, and a second (Non-Business) that is triggered from that table and posts to Twitter.

Splitting into two flows keeps Business and Non-Business connectors in separate environments of the policy while Dataverse acts as a compliant handoff point. Workarounds like HTTP actions or misclassifying custom connectors defeat governance intent and are not sustainable.

Correct answer: C. C) Add summary tables to the data warehouse and change the report to connect to these aggregated tables instead.

Pre-aggregated summary tables cut the data scanned on every DirectQuery interaction, which is the core bottleneck with a very large warehouse. Switching to Import may be infeasible or sacrifice freshness, and extra capacity only helps concurrency, not query efficiency.

Correct answer: C. C) The measure uses a hard-coded date filter instead of a dynamic one like TODAY() or NOW().

A hard-coded date filter freezes the calculation window, so new sales for that period never appear even though DirectQuery hits live data. Option A is too vague; the specific, diagnosable cause is the static filter rather than a broadly wrong formula.

Correct answer: B. B) A dedicated, non-default environment for the CoE solution.

Microsoft guidance is to install the CoE Starter Kit in a dedicated environment, separate from the default one, to isolate governance components and data. Per-user licenses for every maker and Power BI Pro are not core prerequisites for the kit to function.

Correct answer: D. D) The business process flow references a table that is not enabled for business process flows.

Activation fails when a business process flow references a table that is not enabled for business process flows, since the platform validates every referenced table at activation. The 30-stage maximum is the documented limit, so 25 stages is fine, and action steps are optional rather than required.

Correct answer: C. C) Save the file to a local drive on the machine where the gateway is installed and pass the local file path.

A desktop flow input expecting a file path must resolve on the target machine, so the file should exist on a local drive of the gateway machine and that local path passed in. Cloud locations like SharePoint or OneDrive supply URLs, not file paths the desktop flow can open directly.

Correct answer: B. B) The connection reference must be added to the solution before exporting.

Connection references are solution-aware components, so including the connection reference in the solution before export resolves the missing-dependency warning at import time. Creating the connector manually in the target environment breaks ALM portability, and no environment-side switch setting replaces packaging the reference.

Correct answer: A. A) The Get-AdminFlow PowerShell cmdlet.

Get-AdminFlow from the Power Apps admin PowerShell module is purpose-built for scripting flow inventory per environment, which you can filter by creation date and combine with run details. Admin Center analytics and the CoE dashboard are UI-oriented reporting surfaces, and flows are managed through Power Platform APIs rather than Microsoft Graph.

Correct answer: D. D) Use the SharePointIntegration.CurrentUserEmail property.

The SharePointIntegration object provides the host SharePoint context to an embedded canvas app, and CurrentUserEmail returns the current user's email reliably from SharePoint's authenticated session. User().Email or a connector can be inconsistent or add dependencies, and Param() can be spoofed.

Correct answer: C. C) The time zone specified in the "Start time" and "End time" parameters does not match the time zone of the shared mailbox.

A time zone mismatch between the start and end time parameters and the mailbox's time zone can shift the query window so it misses the day's events entirely, returning zero results. Permission issues would raise a clear error, not silently return nothing.

Correct answer: C. C) If(MyTable.TwoOptionsColumn = true, "Approved", "Rejected")

A Dataverse Two Options (Yes/No) column surfaces as a Boolean in canvas apps, so comparing it directly to true is the valid pattern for the If function. String comparisons like "Yes" or numeric 1 don't match the Boolean data type.

Correct answer: A. A) Microsoft Forms responses are read-only and cannot be updated by Power Automate.

The Microsoft Forms connector can trigger on and read responses, but it exposes no action to update or edit an existing response, so the design is unworkable. It's not a permissions or DLP issue; the capability simply doesn't exist.

Correct answer: A. A) The column is part of a managed solution.

Components installed as part of a managed solution can't be deleted directly in the target environment; you must remove them in the source solution and deploy an upgrade. Standard tables can be extended, and existing data alone doesn't block column deletion.

Correct answer: B. B) Create a view in Dataverse that filters by the "Publish Date" and use that view as the data source.

A Dataverse view with a Publish Date filter runs server-side, and the portal list simply consumes the pre-filtered view. Client-side JavaScript filtering in option C is inefficient and insecure because all records are retrieved before filtering.

Correct answer: B. B) Train

Retraining with new ticket data is the Train stage of the AI Builder model lifecycle. Publish makes a model available for use, and Quick Test only validates behavior, so neither describes the learning process itself.

Correct answer: A. A. The training sample size is insufficient for the complexity of the categories.

Five documents per class is far too little data for an AI Builder text classification model to learn reliable boundaries between nuanced categories. Option B fails because AI Builder models are directly usable in canvas apps, so the medium is not the problem.

Correct answer: C. C. Environment Maker and System Customizer.

Environment Maker plus System Customizer covers table creation and customization without granting full environment administration, matching the least-privilege requirement. Note this is arguable, since System Customizer alone cannot modify security roles; modifying security roles normally requires System Administrator privileges, so a test-taker could defend option A's role instead.

Correct answer: D. D. The embedded flow will exist as a component within the larger app, not as a standalone application.

An embedded business process flow lives as a component inside the larger model-driven app rather than running as a standalone experience, which is the key architectural constraint. That said, option D states a characteristic rather than a limitation, so some test-takers could reasonably dispute the framing.

Correct answer: C. C. A Many-to-Many (N:N) relationship.

A many-to-many relationship lets one contact link to many projects while a project accumulates multiple primary contacts over time. Note the exam-preferred pattern here is often an intersect table with dates for the audit trail, but among the options N:N is the only structure supporting both directions.

Correct answer: A. A. Edit Interactions between the visuals.

Edit interactions controls whether selecting a value in one visual filters, highlights, or ignores another visual on the same page. Drillthrough navigates to a separate page and slicers add an extra control, while the requirement is direct click-driven cross-filtering between existing visuals.

Correct answer: B. B. The expression's logic is dependent on dynamic content from previous steps that is not available in the simple test.

In the full flow the expression references runtime outputs from earlier steps, which may be missing, null, or skipped when tested in isolation. Compose supports the same workflow expression language as other actions, so a smaller function set or size limit is not the cause.

Correct answer: A. A. The Admin – Command Centre app.

The Admin Command Center app surfaces resources without active owners so admins can assess and remediate orphaned apps. The Set-Owner app only reassigns ownership after discovery, and the Power BI dashboard visualizes inventory, so either could tempt you, but identification and action live in Command Center.

Correct answer: B. B) Deploy the CoE Starter Kit's Core and Audit Components, which will begin collecting connector usage data in Dataverse tables. Wait 6 months to gather sufficient data.

The CoE Starter Kit's Audit components capture detailed, per-user connector usage into Dataverse tables, which is what long-horizon licensing analysis needs. Admin Center analytics and compliance logs lack the retention and detail required for a six-month user-level report.

Correct answer: A. A) Calculated columns are evaluated only when the record containing the column is saved, not when related records are updated. The calculated column will only refresh when the current record is edited and saved.

Calculated columns recalculate when the record holding the column is saved, so updates to related records alone leave a stale value. If permissions were the cause, as in option D, you would see nulls or errors rather than consistently outdated values.

Correct answer: A. A) Use the built-in point-in-time restore feature to create a new environment from a backup and test the restore there quarterly.

Dataverse point-in-time restore covers both data and configuration, meets the RPO and RTO, and restoring into a new environment lets you test quarterly without touching production. Options C and D replicate analytics or data only, not a consistent recoverable environment.

Correct answer: A. A) Enable the "Use PKCE" toggle in the security settings of the custom connector.

Custom connectors expose a PKCE option in the OAuth security settings that automatically generates the verifier and challenge for the flow. Manually appending parameters to the authorization URL is fragile and bypasses the connector's built-in security handling.

Correct answer: C. C) Use form componentization to load tabs and sections dynamically only when the user navigates to them.

Deferring tab and section loading until the user navigates to them directly cuts the initial rendering cost of a hundred-field form. Moving business rules to flows does not address the dominant cost, which is loading the full form up front.

Correct answer: D. D. Last Refresh = MAX('Sales'[TransactionTimestamp])

MAX on the transaction timestamp returns the most recent data actually present from the source, the best available proxy for recency in DirectQuery. NOW and UTCNOW just return the current clock time and do not reflect when source data was retrieved.

Correct answer: A. A. Publish the dataflow to a workspace and connect Power BI Desktop reports to it using the "Power BI dataset" connector.

Publishing the dataflow to a workspace creates one central, managed data-prep layer that reports consume directly, so updates propagate automatically. Templates and .pq imports create static copies, and Reference queries link queries within one file, not across reports.

Correct answer: A. A. Perform the concatenation in the source database system and import the result as a new column.

Computing the concatenated column in the source database gives you a real physical column that DirectQuery can query without unsupported DAX operations. Switching to Import mode would work but sacrifices the live connection the design depends on.

Correct answer: D. D. Create a calculated group that flags the top 10% and use it to color the data points.

Flagging the top ten percent with a calculated field and mapping it to the data point color directly highlights those products on the scatter chart. A percentile line only draws a reference line and cannot distinguish or color individual points.

Correct answer: B. B. EXCEPT

EXCEPT returns rows present in the first table but absent from the second, so all products minus products sold in the last 365 days yields the zero-sales list. DATEDIFF only measures date gaps and cannot produce the set difference the pattern depends on.

Correct answer: A. A. Change the gateway service account to a domain user with access to the data source.

Windows authentication needs a domain identity the data source can validate, so running the gateway under a domain account with SQL permissions fixes the failures. A local machine account isn't routable across the network, and switching to SQL auth violates the stated requirement.

Correct answer: A. A. Use conditional formatting on the KPI visual's status icon.

Conditional formatting rules on the status field let you map ratio thresholds to red, yellow, and green without extra components. A calculated column would be static and row-based, while the target and trend axis wells don't drive color-coded status.

Correct answer: C. C. Create a measure using time intelligence functions like PREVIOUSQUARTER within a CALCULATE statement.

A measure using CALCULATE with PREVIOUSQUARTER leverages the marked date table to compute the prior complete quarter dynamically in any context. Calculated columns are static at refresh, and relative date filters depend on user interaction rather than automatic logic.

Correct answer: C. C. Retrain and publish a new version of the model. In the flow, use the model's specific version GUID in the AI Builder action to ensure consistency, then test and update the flow logic to use the new field.

Pinning the flow to a specific published model version keeps in-flight invoices stable while the new field is tested and rolled out. Option A is tempting but switching the flow immediately risks failures for records processed during the transition window.

Correct answer: A. A. The business rule will not execute, and the "Status" field will remain unchanged.

Business rules scoped to All Forms execute in the form context, so an API update that bypasses the form never triggers the rule and Status stays unchanged. The API call itself succeeds fine; nothing in Dataverse queues it for later form processing.

Correct answer: C. C. Ask the API provider to implement server-side pagination and modify the flow to handle multiple pages of results.

Server-side pagination shrinks each HTTP response so no single call exceeds the timeout, and the flow can loop page by page without losing data. Splitting the array afterward fails because the full payload must still arrive over one request first.

Correct answer: C. C. Environment Maker

Environment Maker fits makers who create resources in an environment without privileges to assign security roles or view audit logs. System Administrator is the obvious over-privilege distractor, and Basic User lacks the ability to create tables at all.

Correct answer: A. A. If(And(Due Date <= Today()+3, Status = "Active"), "High Priority", "Normal Priority")

The correct formula uses a single If with And to require both conditions before showing High Priority. An Or-based formula would flag records meeting only one condition, which is the classic trap the exam tests on calculated column logic.

Correct answer: B. B. Implement row-level security in the Power BI dataset

RLS in the dataset enforces filtering by user identity centrally, so every report built on it stays consistent and maintainable. User-selected parameters depend on compliance and let curious users simply pick another department.

Correct answer: B. B. Use the CoE Starter Kit's Power BI dashboard

The CoE Starter Kit's Power BI dashboard gives a centralized tenant-wide view that can break storage down across environments and tables. Checking each environment's settings only shows totals, not which tables are the top consumers.

Correct answer: B. B. There's an implicit relationship between the tables affecting the calculation

An indirect relationship path in the model lets the slicer's filter propagate to the fact table and affect the measure. CALCULATE only removes filters you explicitly override, so option D overstates its default behavior; the real culprit is cross-filtering through the model.

Correct answer: B. B. Text Recognition model with custom entity extraction

OCR-based text recognition combined with custom entity extraction works across PDFs, Word, and Excel regardless of layout. A form processing model needs consistent, form-like structure, so it gets brittle when trained across many varied document types.

Correct answer: C. C) The "List items" action has a default row limit that is being exceeded, and paging must be implemented.

Large result sets from the List items action require pagination to be enabled, since the action retrieves a bounded number of rows per call and can fail on big lists. Permission problems would raise an authorization error, not a Bad Request tied to volume.

Correct answer: B. B) The account used for the Office 365 Users connection does not have the "User.Read.All" application permission granted by an admin.

Reading another user's manager through the Office 365 Users connector can fail with Unauthorized when required Microsoft Graph permissions have not been granted or consented by an admin. A missing manager would return empty data, not an authorization error, and the connector is standard, not premium.

Correct answer: A. A) Increase the number of sample documents to at least 50.

AI Builder form processing models need a diverse training set; going from 10 to 50 or more samples captures layout variation and dramatically improves accuracy. Object detection solves a different problem, and re-labeling or swapping file formats won't fix data scarcity.

Correct answer: C. C. The Gallery's SelectionMode property.

The Gallery's SelectionMode property governs single versus multiple selection, and setting it to Multiple exposes the SelectedItems collection for bulk actions. The distractor MultiSelect sounds plausible but is not a real Gallery property, which is a common trap.

Correct answer: C. C. A Gallery control with its Items property set to LookUp(Contacts, ContactID = DataForm1.LastSubmit.ContactID).Cases

A gallery whose Items retrieves the current contact record and navigates its Cases relationship shows the related cases on the same screen. LastSubmit.Cases alone depends on a prior save, and a dropdown of all cases ignores the selected contact.

Correct answer: B. B. The Windows user account configured for the gateway must have read permissions on the SQL Server.

Gateway credential failures are typically fixed by ensuring the account used for the data source has proper SQL Server access. Admin approval, Azure AD authentication, and DirectQuery mode are unrelated to resolving refresh credential errors.

Correct answer: D. D) Deploy the solution in an active-active configuration across two regions using multiple Dataverse environments and synchronize data using custom bidirectional sync flows.

Active-active deployment with bidirectional synchronization across Dataverse environments is the only listed pattern that can approach the stated recovery objectives. Synapse Link is an analytics pipeline, not a transactional replication mechanism, so active-passive with it fails the RPO requirement.

Correct answer: C. C. CALCULATE(COUNTROWS('Sales'), FILTER('Employee', RELATED('OfficeLocation'[Country]) = [Country])) > 0

Option C walks the relationship path from Sales through Employee to OfficeLocation and keeps only rows whose office country matches the user's context. The other expressions either reference columns that don't exist on Sales or ignore the country relationship entirely.

Correct answer: D. D. Slideshow for reports

A slideshow mode automatically advances through report pages on a timer, which suits unattended kiosk displays without any user interaction. Bookmarks and navigation buttons both require a click to fire, so neither delivers hands-off page cycling.

Correct answer: C. C. There is no relationship between the Product[Color] field and the Sales table

The measure returns identical totals because the Color column has no relationship path to filter the Sales table, so filter context never propagates. Since Category works fine, the measure formula itself is clearly not the problem.

Correct answer: B. B. The app has zero launches in the last 30 days

The cleanup flow defines an unused app by zero launches during the lookback window, measuring actual usage rather than edit history. An app can sit unmodified for months yet still run daily, so modification date would wrongly flag it.

Correct answer: C. C) Related(Address).City & ", " & Related(Address).Country

In a calculated column, Dataverse syntax reaches a related record through the lookup, so the City and Country fields are combined with the concatenation operator using that relationship path. CONCAT and Parent are not valid functions in calculated column expressions.