AB-410 Timed Hard Questions — 25 Difficult Questions

Question 1

A Dataverse environment contains a custom table 'Invoice' with a column 'TotalAmount' of type Currency. You need to ensure that the 'TotalAmount' is automatically calculated as the sum of line items whenever a related 'InvoiceLine' record is created, updated, or deleted. The calculation must be consistent regardless of how the data is modified (e.g., through the app, API, or import). What should you use?

15 minute time limit — choose an answer to begin.

Accepted Answer

Rollup column on the Invoice table. A rollup column is specifically designed to aggregate values from related records, such as summing child line items into a parent total. It is maintained by the Dataverse platform and recalculates automatically, ensuring consistency regardless of how the data is modified. This makes it the correct choice for automatically calculating TotalAmount from InvoiceLine records.

Answer

JavaScript web resource on the Invoice form

Answer

Power Automate cloud flow triggered on InvoiceLine changes

Answer

Calculated column on the Invoice table

Question 2

You are creating a custom table. You want to track when a record was created and who created it. What must you do?

Accepted Answer

Enable the table for auditing. Dataverse includes 'Audit' or 'System' fields automatically, but they must be enabled in the table configuration.

Answer

Create custom fields for CreatedBy and CreatedOn

Answer

Add the fields to the form

Answer

Write a workflow

Question 3

You are configuring a Power Apps canvas app that uses a Dataverse table with a lookup column. You need to ensure the app remains performant and returns accurate results as the table grows beyond the delegation limit. Which two actions should you take? (Choose two.)

Accepted Answer

Ensure filters and lookups reference columns that are indexed in Dataverse.. Performance and accuracy under delegation come from keeping queries delegable and reducing transferred rows. Using LookUp with a delegable predicate returns just the matching record, and ensuring predicates target indexed Dataverse columns lets the connector push work to the server. Raising local row limits or copying data into a collection does not remove the underlying cap and can produce incomplete, misleading results as the table scales.

Answer

Set the app's Data row limit to 2000 in Settings so more rows are processed locally.

Answer

Wrap the table in a ClearCollect on OnStart and query the collection thereafter.

Answer

Increase the delegation limit by editing the app's JSON source directly.

Question 4

You are designing a Power Automate cloud flow that uses an AI Builder custom model to classify customer emails. The flow must handle cases where the model's confidence score is below a threshold. You need to route low-confidence emails to a human reviewer and high-confidence emails to an automated response. Which action should you use to implement the conditional logic?

Accepted Answer

Condition control with an expression comparing the confidence score to the threshold.. The Condition control is the correct choice because it evaluates a logical expression and branches the flow accordingly. By comparing the AI Builder confidence score to a threshold, you can route emails to automated responses or human review. Other actions either do not provide branching or are overkill for a simple threshold comparison.

Answer

Switch control with cases for each confidence level.

Answer

Terminate action with a custom status code.

Answer

Apply to each loop with a nested condition.

Question 5

You are designing a Power Automate cloud flow that must process a large batch of records from a Microsoft Dataverse table. The flow will be triggered manually and needs to iterate through all records, perform an action on each, and handle errors gracefully. You want to ensure the flow is efficient and does not exceed service limits. Which two actions or configurations should you use? (Choose two.)

Accepted Answer

Enable 'Concurrency Control' on the 'Apply to each' loop and set a degree of parallelism greater than 1.. To process a large batch efficiently, retrieve only the needed records with a filtered 'List rows' action, then iterate with 'Apply to each'. Enabling Concurrency Control on the loop allows parallel processing, reducing run time. These two configurations optimize performance and help avoid hitting service limits, while the other options either use inefficient patterns or non-existent features.

Answer

Use a 'Do until' loop with a condition that checks if all records have been processed, and retrieve records one at a time.

Answer

Configure the flow to run with a service account that has elevated privileges to avoid throttling.

Answer

Use the 'Batch' action to group records into a single API call.

Question 6

You are creating a Dataverse table for a real estate application. You need to store a list of property features for each listing, such as 'Pool', 'Garage', and 'Fireplace'. Each listing can have multiple features, and you want to easily filter listings by a specific feature. The features are chosen from a predefined list of 20 options. Which column type should you use?

Accepted Answer

Multi-select Choice. The need is to store multiple predefined features per record and filter by them. A Multi-select Choice column is purpose-built for this: it allows selecting multiple options from a single global or local choice list, and it supports querying with the contains operator. Other column types either cannot store multiple values, lack validation, or introduce unnecessary complexity.

Answer

Lookup

Answer

Choice

Answer

Text

Question 7

You have a business rule that runs on a form. It sets a field to mandatory. Can this be bypassed?

Accepted Answer

Yes, because it is client-side logic. Business rules that run on a form execute as client-side JavaScript in the browser (or model-driven app client), so they can be bypassed by editing the record through other means — such as the Web API, an import, a plugin, or a different form where the rule is not applied. The rule only enforces the mandatory field at the form UI layer, not at the Dataverse platform layer. This is why the correct answer is that it can be bypassed because it is client-side logic.

Answer

Yes, if the user is an admin

Answer

No, it is enforced at the database level

Answer

No, it is enforced by the app

Question 8

You need to prevent a user from deleting a record. Which permission should you remove from their security role?

Accepted Answer

Delete. The Delete permission in a security role controls whether a user can delete records of a given entity. Removing the Delete privilege from the user's security role prevents them from deleting records, while still allowing other operations like reading or writing. This is the most direct and least-privilege way to prevent deletion.

Answer

Write

Answer

Read

Answer

Append

Question 9

You are building a Power Automate flow that uses an AI Builder model to analyze customer feedback and then triggers a Copilot Studio agent to generate a personalized response. Which TWO actions or configurations are required to enable the flow to call the agent and use its response? (Choose two.)

Accepted Answer

Map the AI Builder output to the agent's input parameters in the 'Invoke an agent' action.. To enable a Power Automate flow to call a Copilot Studio agent and use its response, you must add the 'Invoke an agent' action and map the AI Builder output to the agent's input parameters. These two steps establish the connection and provide the necessary data for the agent to generate a response, which the flow can then use.

Answer

Create a custom connector to the Copilot Studio agent's API.

Answer

Configure the agent to use the 'Generative answers' feature.

Answer

Enable the 'Respond to the user' setting in the agent's authoring canvas.

Question 10

You are migrating a solution from development to production. You notice the custom table is missing. What is the most common reason?

Accepted Answer

The table was not added to the solution. The most common reason a custom table is missing after migrating a solution is that the table was never added as a component to the solution in the source environment. Solutions only export components explicitly included; if the table was created outside the solution context, it will not be part of the export and thus will not appear in the target.

Answer

The environment is a trial

Answer

The solution is managed

Answer

The table is a system table

Question 11

You are building a canvas app that uses a gallery to display orders from a Dataverse table. Users need to filter the gallery by order status and sort by order date. The app must perform well with over 10,000 orders. Which approach should you use?

Accepted Answer

Use SortByColumns(Filter(Orders, Status = varStatus), "OrderDate", Descending) in the gallery's Items property.. To filter and sort a large Dataverse table efficiently, both operations must delegate to the server. SortByColumns is delegable for Dataverse and can be combined with a delegable Filter. Using Sort or collecting into a collection risks hitting row limits and returning incomplete or incorrectly sorted data.

Answer

Use Collect(FilteredOrders, Filter(Orders, Status = varStatus)) in OnVisible, then sort the collection in the gallery.

Answer

Use Filter(Orders, Status = varStatus) and set the gallery's Sort property to OrderDate descending.

Answer

Use Filter(Orders, Status = varStatus) and Sort(Filter(Orders, Status = varStatus), OrderDate, Descending) in the gallery's Items property.

Question 12

You are building a canvas app that reads and writes data in a Dataverse table. You need to ensure that users can only see records they own or that are shared with them, and that this security is enforced regardless of how the app queries the data. What should you configure?

Accepted Answer

Configure Dataverse security roles and record ownership so access is enforced by the platform.. Dataverse enforces record-level security through security roles, ownership, and sharing, and these rules apply to every client that accesses the data, including canvas apps. Configuring roles and ownership ensures users see only the records they own or that are shared with them, and the enforcement cannot be bypassed by app-level queries.

Answer

Apply a Filter function in every gallery and form to restrict records to the current user.

Answer

Enable the table's auditing setting so access attempts are logged and reviewed.

Answer

Set the app's data source to use a service account with limited permissions.

Question 13

You are designing a Power Automate cloud flow that processes incoming invoices. The flow uses an AI Builder 'Invoice processing' prebuilt model to extract fields such as invoice total and vendor name. You need to store the extracted values in a Microsoft Dataverse table and then trigger a Power Apps canvas app to display a confirmation screen. The flow must handle cases where the AI Builder model returns a low confidence score for a field. What is the most appropriate way to implement this?

Accepted Answer

Use a 'Condition' action to check the confidence score; if it is below a threshold, send an approval to a human reviewer and wait for the response before writing to Dataverse.. AI Builder returns confidence scores for extracted fields. The correct approach is to evaluate those scores with a Condition action and, when confidence is low, pause for human approval before writing to Dataverse. This ensures data quality and uses the approval result to control whether the record is created and the canvas app is triggered.

Answer

Write all extracted values to Dataverse regardless of confidence, then use a Power Apps formula to highlight low-confidence fields for the user to correct.

Answer

Configure the AI Builder model to automatically retry extraction up to three times if confidence is low, then write the best result to Dataverse.

Answer

Use the 'Parse JSON' action to extract the confidence score from the AI Builder output and set a variable; if low, terminate the flow with a failure status.

Question 14

Which THREE capabilities are provided by Copilot Studio to integrate AI into business logic?

Accepted Answer

Plugins for calling external systems.. Option B is correct because Copilot Studio supports plugins (including Power Platform connectors and custom REST-based plugins) that let the copilot call external systems and APIs, embedding AI-driven actions directly into business logic. Option C is correct because topics define the conversational flow through trigger phrases, questions, conditions, and actions, giving deterministic control over how the copilot handles a business process. Option E is correct because Generative Answers enable the copilot to retrieve and synthesize responses from configured knowledge sources (such as SharePoint, websites, or Dataverse), grounding AI output in enterprise data. Option A does not belong because Copilot Studio does not automatically translate all user emails; translation would require separate services or flows. Option D does not belong because Copilot Studio is a conversational AI platform and provides no direct hardware control capability.

Answer

Automatic translation of all user emails.

Answer

Direct hardware control.

Question 15

You are using the 'Copilot' control in your canvas app. How do you link it to your specific data?

Accepted Answer

Configure the Data sources property. The Copilot control in a canvas app is connected to your data through its Data sources property, where you select the tables or entities the Copilot should use to answer questions and generate responses. Configuring this property is what grounds the Copilot in your specific business data rather than generic knowledge.

Answer

Change the app name

Answer

Write a custom API connector

Answer

Update the environment variable

Question 16

You are building a canvas app that uses a Microsoft Dataverse table with delegation. A gallery must show only rows where the Status column equals 'Active' and the CreatedOn is within the last 30 days. The table contains over 100,000 rows. Which approach ensures the gallery returns the correct set of rows without loading the entire table into memory?

Accepted Answer

Set the gallery's Items to Filter(Accounts, Status = "Active" && CreatedOn >= DateAdd(Now(), -30, Days)) and rely on Dataverse delegation for both conditions.. Dataverse delegates Filter conditions using equality and comparison operators, so combining Status and CreatedOn in a single Filter expression pushes both predicates to the server. This returns only the active rows created in the last 30 days, avoiding the overhead and row-limit issues of client-side filtering.

Answer

Set the gallery's Items to Filter(Accounts, Status = "Active") and apply the date condition in the gallery's OnVisible property using a collection.

Answer

Set the gallery's Items to FirstN(Accounts, 100000) and then apply Filter on the result to reduce the set.

Answer

Use the Search function in the gallery's Items to match the status and date, since Search always delegates to Dataverse.

Question 17

Which TWO of the following steps are required to move an AI-powered solution to production? (Choose TWO)

Accepted Answer

Import the solution into the target environment. Option E (Export the solution) is correct because moving an AI-powered solution to production begins with exporting it from the source environment as a managed or unmanaged solution, which packages all components (AI models, flows, connectors, environment variables) into a portable .zip file. Option D (Import the solution into the target environment) is correct because the exported solution must then be imported into the production environment, where the platform unpacks and provisions its components so the AI solution can run there. The unmarked options do not belong: manually recreating all flows (A) defeats the purpose of solutions and risks inconsistency, deleting the original AI model (B) would destroy the source artifact rather than deploy it, and hardcoding environment IDs (C) is an anti-pattern that breaks portability, whereas environment variables and connection references should be used instead.

Answer

Manually recreate all flows

Answer

Delete the original AI model

Answer

Hardcode the environment IDs

Question 18

A developer is building a model-driven app that must display a list of active contacts related to an account, with the ability to quickly filter and sort by multiple columns. The developer needs to add this to the account main form. Which control should be used?

Accepted Answer

Subgrid. The requirement is to display a list of related contacts with filtering and sorting. A subgrid is the standard form component for showing related records in a tabular format, and it supports multiple views and sorting. Timeline and quick view forms are for activities and single records respectively, while editable grid is for inline editing.

Answer

Editable grid

Answer

Quick view form

Answer

Timeline control

Question 19

You are designing a Power Automate cloud flow that uses an AI Builder custom document processing model to extract fields from invoices. The flow must handle documents that fail extraction by logging the error and continuing without stopping the entire run. Which configuration should you apply to the AI Builder action?

Accepted Answer

Set the action's retry policy to none and enable 'Configure run after' on the subsequent logging action to run only if the AI Builder action fails.. Using run-after configuration on a subsequent action to trigger on failure or timeout, combined with disabling retries, allows the flow to log the error and continue. This is the correct pattern for graceful error handling in Power Automate without halting the entire run.

Answer

Add a parallel branch that runs the logging action simultaneously with the AI Builder action.

Answer

Wrap the AI Builder action in a Scope action and set the Scope's concurrency control to 1, then place the logging action after the Scope.

Answer

Enable 'Secure Inputs' and 'Secure Outputs' on the AI Builder action and add a Terminate action with status Succeeded after it.

Question 20

You are configuring an AI Builder custom document processing model to extract line items from invoices. The model performs well on vendor name and invoice date but consistently misses the line item table. You have already uploaded 50 labeled samples. What should you do first to improve table extraction?

Accepted Answer

Add more labeled samples that include a variety of line item table layouts and formats.. Poor table extraction usually stems from insufficient variety in labeled examples. Adding samples that show different line item table layouts gives the model the patterns it needs to generalize. Switching model type, increasing iterations without new data, or changing the document type does not address the root cause and risks harming the fields that already perform well.

Answer

Increase the number of training iterations to 100 without changing the dataset.

Answer

Switch the model to a prebuilt invoice model and remove the custom labels.

Answer

Change the document type to 'Receipt' in the model configuration.