AB-410 Practice Questions

Question 1

A company stores customer feedback in a Dataverse table named Feedback. Analysts frequently run reports filtered by the date the feedback was submitted, and they also sort by that date. The column currently stores the value as a single line of text, which forces slow client-side filtering. You need the column to support efficient server-side filtering, sorting, and date range queries. What should you do?

Accepted Answer

Create a new Date and Time column, migrate the feedback dates into it, and update views and forms to use the new column.. Server-side filtering and sorting on dates requires the column to be a native Date and Time type, because only then does Dataverse store and index the value in a queryable temporal format. Since existing column types cannot be converted in place, the practical answer is to introduce a correctly typed date column, migrate the values, and update the consuming views and forms. Calculated and rollup columns do not convert stored text into efficient date storage.

Answer

Change the column data type to Date and Time and keep the existing values.

Answer

Add a calculated column that parses the text value into a date at query time for each report.

Answer

Create a rollup column that aggregates the text dates and exposes them for filtering in reports.

Question 2

You are building a canvas app for a field inspection team. Inspectors must attach a photo and then have the app suggest a defect category from the image before they submit. You want to use the built-in AI capability in Power Apps rather than training a custom model. Which control or component should you add to the app to accomplish this?

Accepted Answer

The Image classification component from the AI Builder controls. Image classification is the AI Builder capability that assigns a single category label to an entire image. Because the inspectors need the app to suggest a defect category from a photo, binding an image classification component to the captured image yields the predicted label that can populate the category field. The other AI Builder components extract text, detect objects, or read business cards, none of which produce a defect category.

Answer

The Text recognizer component from the AI Builder controls

Answer

The Business card reader component from the AI Builder controls

Answer

The Object detection component from the AI Builder controls

Question 3

You are building a canvas app and need to display a running total of items in a shopping cart as users add products. The total must update immediately whenever an item is added or removed. Which approach should you use?

Accepted Answer

Store the cart items in a collection and set a label's Text property to Sum(CartItems, Price * Quantity).. Binding the label to Sum over the cart collection makes the total a derived value that recalculates automatically whenever the collection changes. This declarative approach avoids drift and handles every mutation path, including removal and quantity edits, without duplicating logic in individual button handlers.

Answer

Store the cart items in a collection and update the label's Text property inside the OnSelect of each Add to Cart button.

Answer

Use a variable that is incremented in each Add to Cart button's OnSelect and decremented in each Remove button's OnSelect.

Answer

Write the cart items to a Dataverse table and use a timer control to refresh the total every few seconds.

Question 4

Which menu in the Power Apps maker portal do you use to view all your tables?

Accepted Answer

Data. The Data menu in the Power Apps maker portal is where you can view and manage tables, including Dataverse tables and other data sources. It provides a centralized view of the data entities available to your apps and environments. This is the correct location for viewing all tables.

Answer

Flows

Answer

Solutions

Answer

Apps

Question 5

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?

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 6

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 7

You are creating a business process flow in Dataverse. What is the primary purpose of this component?

Accepted Answer

To guide users through a business process. A business process flow in Dataverse is a guided, stage-based UI component that walks users through a defined sequence of steps to complete a business scenario, such as a sales cycle from lead to opportunity to order. It enforces process consistency by presenting stages, steps, and required fields at each stage.

Answer

To act as a chatbot

Answer

To perform complex calculations

Answer

To automate background tasks

Question 8

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 9

You are creating a Power Automate flow that must send a Microsoft Teams message to a channel whenever a new high-priority item is added to a SharePoint list. The flow should include details from the item. Which trigger and action combination should you use?

Accepted Answer

Use the SharePoint 'When an item is created' trigger and add a Microsoft Teams 'Post message in a chat or channel' action, configuring the message with dynamic content from the trigger.. The SharePoint 'When an item is created' trigger and the Teams 'Post message in a chat or channel' action form the correct event-driven pattern. Dynamic content from the trigger supplies item details, and the action posts to the specified channel, meeting the notification requirement efficiently.

Answer

Use the Microsoft Teams 'When a channel message is added' trigger and add a SharePoint 'Create item' action.

Answer

Use the 'Recurrence' trigger to check the SharePoint list every minute, then use a 'Get items' action and a Teams action inside an Apply to each loop.

Answer

Use the SharePoint 'When an item is created or modified' trigger and add an Outlook 'Send an email' action to the channel's email address.

Question 10

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 11

A Power Platform administrator needs to allow users in a specific department to create and edit records in a custom table, but they should not be able to delete any records. The department users already have a security role with Read and Write privileges on the table. Which security role privilege should you modify?

Accepted Answer

Delete. Deletion of records is controlled by the Delete privilege in a security role. To prevent deletion while allowing create and edit, you must ensure the role lacks Delete permission on that table. The other privileges affect reading, updating, or associating records, not removal.

Answer

Append To

Answer

Read

Answer

Write

Question 12

What is the primary role of a 'Security Role' in Dataverse?

Accepted Answer

To define data access privileges. A Security Role in Dataverse defines the privileges a user or team has on tables, records, and other resources — essentially, it controls data access. Security roles specify Create, Read, Write, Delete, Append, Append To, Assign, and Share privileges at the table level, and the scope (User, Business Unit, Parent: Child Business Unit, Organization) determines which records the user can access. This is the primary role of a security role.

Answer

To route work items

Answer

To manage app branding

Answer

To define user authentication

Question 13

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 14

A team is building an app on Dataverse. They need to record the moment a support ticket is escalated so that downstream automations can trigger on that event, and they want the value captured automatically without the user entering it. They also want the value to remain unchanged if the ticket is later edited. Which column type best fits this requirement?

Accepted Answer

A Date and Time column named Escalated On that is set by a business rule or Power Automate flow when the escalation status changes.. The requirement is to capture the escalation moment automatically and then freeze that value. A Date and Time column populated by a business rule or Power Automate flow at the moment the escalation status changes does exactly that. A creation-time default captures the wrong event, a calculated column cannot reference the clock at an arbitrary time and recalculates on edits, and storing ticks in a number column loses native date behavior.

Answer

A calculated column that returns the current date and time whenever the escalated flag is true.

Answer

A whole number column that stores a timestamp value converted to ticks by the client application.

Answer

A Date and Time column with a default value of the current date and time.

Question 15

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

Microsoft Certified: Intelligent Applications Builder Associate AB-410 practice test

Three ways to study

Study AB-410 by domain

Study AB-410 by topic

Building The Apps practice questions

Dataverse Foundations practice questions

Business Application Logic And Automation practice questions

AB-410 fundamentals practice questions

AB-410 scenario practice questions

AB-410 troubleshooting practice questions

Microsoft Certified: Intelligent Applications Builder Associate (AB-410) (AB-410) practice questions