AB-410 Practice Test 1 — 30 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?

Choose an answer to begin — your selection is scored in the full session.

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

Question 16

You are designing a Power Automate flow that uses AI Builder to process a batch of documents. You need to handle potential errors when the AI Builder action fails due to unsupported file formats. Which TWO actions or configurations should you implement to ensure robust error handling? (Choose two.)

Accepted Answer

Use a Scope action to group the AI Builder action and configure its run after to handle failures.. To handle errors from unsupported file formats, you should prevent them from reaching the AI Builder action by adding a Condition to check file extensions. Additionally, using a Scope action around the AI Builder action allows you to catch any failures and respond appropriately, such as notifying an admin. These two approaches together provide both proactive and reactive error handling.

Answer

Set the AI Builder action's retry policy to retry on failure.

Answer

Configure the AI Builder action's run after settings to run only on failure and send a notification.

Answer

Enable 'Secure Inputs' on the AI Builder action to prevent errors.

Question 17

You are building a model-driven app for a customer support team. The app uses a custom table called Support Request. You need to configure the app so that users can quickly find requests by priority and see only requests assigned to their team. Which two actions should you perform? (Choose two.)

Accepted Answer

Create a view on the Support Request table that filters by the team and add it to the app.. To let users see only their team's requests, create a filtered view and add it to the app. To let them quickly find requests by priority, enable quick find and include the Priority column in its search configuration. Together these provide both the visibility scope and the search capability required.

Answer

Add a dashboard that shows all Support Request records.

Answer

Create a business rule that sets the Priority field to High when a request is created.

Answer

Add a chart on the Support Request table to display priority distribution.

Question 18

A developer needs to create a relationship between two Dataverse tables: 'Project' and 'Task'. A project can have many tasks, but each task belongs to exactly one project. The developer also wants to ensure that when a project is deleted, all related tasks are automatically deleted. Which type of relationship and configuration should they use?

Accepted Answer

One-to-many relationship with cascade delete configured to 'Cascade All'.. The scenario describes a classic one-to-many relationship: one project has many tasks, and each task belongs to one project. To automatically delete tasks when a project is deleted, the cascade delete behavior must be set to 'Cascade All'. This ensures referential integrity and matches the requirement. Other cascade options like 'Remove Link' or 'Restrict' do not delete the child records.

Answer

One-to-many relationship with cascade delete set to 'Remove Link'.

Answer

One-to-many relationship with cascade delete set to 'Restrict'.

Answer

Many-to-many relationship with cascade delete enabled.

Question 19

You have a business requirement to categorize 'Project' records by a 'Status' field. You need to ensure users can only select from a predefined list. Which field type is most appropriate?

Accepted Answer

Choice column. A Choice column stores a predefined set of options (an option set) and restricts user input to those values, which is exactly what is needed to categorize Project records by a Status field with a fixed list. Choice columns can be local (defined per table) or global (shared across tables), and they support single or multi-select.

Answer

Whole Number column

Answer

Text column

Answer

Lookup column

Question 20

You need to group fields together on a form for better readability. What should you use?

Accepted Answer

Section. A Section is a container component on a form that groups related fields under a common heading, improving readability by visually clustering information. It allows you to organize fields into logical blocks, often with a title and collapsible behavior. This is the standard way to group fields on a form in Dynamics 365 and Power Apps model-driven apps. Tabs, columns, and Quick Views serve different purposes and do not provide the same grouping functionality.

Answer

Tab

Answer

Column

Answer

Quick View