troubleshooting

You need to update a flow that is used by hundreds of employees. You want to test the update without affecting the production version. What should you use?

You need to create a column that stores the total cost of a project, which is derived from the sum of all associated expense records. Which column type should you use?

You need to ensure that a canvas app user can only save their changes if all required fields are filled. What is the most efficient way to validate this?

You want your Copilot to trigger a specific business logic in a flow only when the user asks a specific question. How do you map this?

A company has a Dataverse environment with a custom table 'Order' that includes a Lookup column to the 'Account' table. The company wants to ensure that when an Order is created, the 'Account' record's 'CreditLimit' is checked and the Order is rejected if the order total exceeds the credit limit. The validation must occur regardless of whether the Order is created via the model-driven app, API, or import. What should they implement?

Which type of chart can you create in a Model-driven app?

You are creating a new custom table in Dataverse to store customer feedback. You need to ensure that each feedback record is associated with a specific account. Which type of column should you add to the feedback table to create this association?

You are building a Power Automate flow that must call a custom AI Builder model to extract key-value pairs from scanned receipts. The model has been trained and published. You need to pass the receipt image to the model and retrieve the extracted fields. Which action should you add to the flow?

You are building a canvas app that connects to a Microsoft Dataverse table named Project Tasks. The app needs to display only tasks where the Status column equals Active and the Due Date is within the next 30 days. You must implement this filtering in a way that delegates to Dataverse and returns accurate results regardless of table size. Which approach should you use?

You are building a Power Automate flow that uses the AI Builder 'Extract information from invoices' action. The flow processes invoices from multiple vendors, and you need to ensure that the extracted data is stored in a structured format. Which output property of the AI Builder action should you use to access the extracted fields?

A Power Automate flow is failing because an AI-powered extraction step occasionally returns null values. Which expression should you use to provide a default value of 'Unknown'?

You are creating a Power Automate flow that processes many rows. You want to increase performance by processing items concurrently. Where do you configure this?

Which THREE components can be included in a Dataverse solution?

You are designing a Dataverse solution for a municipal permits office. The Permits table must record the date a permit application was received and the date the inspection was completed. Auditors require that the received date never changes after the record is created, but the inspection date must be editable by inspectors. You also need to report on the number of days between receipt and inspection. Which configuration should you use?

You are creating a canvas app that must display a list of customers from a Dataverse table. Users need to tap a customer to open a detail screen showing that customer's full record. Which property should you configure to pass the selected customer to the detail screen?

You are creating a Power Automate cloud flow that must be triggered whenever a new email arrives in a shared mailbox. The flow should then extract the email body and send it to an AI Builder model for sentiment analysis. Which trigger should you use?

Which tool would you use to create a Prompt template that extracts information from a document?

You are building a Power Automate cloud flow that must create a new item in a Microsoft Dataverse table only when an AI Builder sentiment analysis model returns a positive score above 0.8. The flow currently creates the record for every processed email. Which action sequence should you insert to enforce this condition efficiently?

What is the purpose of the 'Publish' button in the Power Apps Studio?

You want to allow your Copilot to look up internal company policies stored in a SharePoint site. What should you add to the Copilot?

When designing a Copilot, you want to ensure the agent only responds using specific company documents. How do you ensure this?

You are designing a Power Automate flow that uses an AI Builder custom model to classify support tickets. The model returns a category and a confidence score. You need to route tickets with a confidence score below 0.7 to a human reviewer, and tickets with a score of 0.7 or higher to an automated resolution queue. Which expression should you use in a Condition action to evaluate the confidence score?

Which property must you configure in a canvas app to show a specific icon based on the value of a field?

You are creating a custom table to track project milestones. You need to ensure that every milestone is associated with a specific project, and if the project is deleted, all associated milestones must also be deleted. Which relationship type should you configure?

You are developing a canvas app that calls a custom connector to retrieve inventory data from an external REST API. The API requires an API key. You need to store the key so the app can use it without exposing it to users or embedding it in the app. Where should you configure the API key?

You need to enforce data consistency across forms in a Model-driven app by hiding a field based on the value of another field. Which mechanism should you use?

Which TWO types of environments can be created in the Power Platform?

You want to make sure your canvas app is accessible. Which property should you configure for screen readers?

When creating a new environment, what is the default database type?

You have a Power Automate flow that needs to execute a script on a local Windows machine. Which component is required?

You are building a canvas app that must display a gallery of Dataverse records sorted by a date column, and users can switch the sort order between newest-first and oldest-first via a toggle. Which approach correctly implements this requirement?

Which TWO types of forms exist for Model-driven apps?

A user needs to see records based on specific criteria. Which object should you configure?

You are auditing environment security. You find that a user can see records they should not have access to. The user is assigned two security roles, one that grants access and one that restricts it. How does Dataverse handle this?

You are designing a canvas app that connects to an on-premises SQL Server through the on-premises data gateway. The app must filter a large table by a date range and remain performant. Which TWO practices should you follow? (Choose two.)

Which TWO of the following represent advanced flow error handling? (Choose TWO)

You are building a model-driven app that uses Dataverse. You need to ensure that users can only view records that they own or that are shared with them. Which security concept should you implement?

You are creating a custom prompt in AI Hub. You want the model to act as a technical support agent. Where do you define this persona?

Which TWO methods can you use to share a canvas app with other users?

You are configuring a Dataverse table to store customer feedback. You need to ensure that the table supports auditing and that users can track changes to specific columns. Which two actions must you perform? (Choose two.)

You are assembling a canvas app screen that lists customers and lets users drill into a detail view. You want the selected customer's record to be available to a second screen without re-querying Dataverse. Which Power Fx construct should you use to pass the record between screens?

Which tool in the Power Apps environment allows you to test your canvas app without publishing it?

You need to format a number as currency in a canvas app label. Which function should you use?

You need to create a relationship between two Dataverse tables where a single record in Table A can be associated with many records in Table B, but each record in Table B can be associated with only one record in Table A. Additionally, you want to ensure that when a record in Table A is deleted, all related records in Table B are also deleted. Which relationship type and behavior should you configure?

You are designing a Power Automate flow that summarizes incoming emails using AI Hub. Which action should you use to pass the email body to a custom prompt?

You want to debug a flow that uses a large array of objects. You need to see the input and output of a specific loop iteration. How can you find this?

You are building a canvas app that must send a personalized order confirmation email whenever a customer completes a purchase. The email body must include dynamic order details and a link to the order status page. You want to minimize custom code and reuse an existing cloud flow. What should you do?

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?

You are configuring an AI Builder document processing model to extract invoice numbers and totals from PDFs. The model must be used in a Power Automate flow that processes 500 invoices daily. You need to ensure the flow can handle documents that vary in layout. Which action should you take?

You want to dynamically route a support ticket to different queues based on the sentiment score derived by an AI Builder sentiment analysis model. How is this best achieved?

Which TWO properties can you configure for a column in Dataverse?

You want to ensure that a user can only see records belonging to their business unit. Which access level should you set in the security role?

Which THREE properties are commonly used to control the visual appearance of a control in a canvas app?

Which THREE of the following are examples of agent orchestration? (Choose THREE)

What feature helps you identify errors in your model-driven app configuration?

Which TWO methods can you use to trigger a Power Automate flow?

Which THREE items can be configured in a table relationship?

You need to enforce that a custom table named Project has a unique project code. The project code is entered by users and must be unique across all records. You also want to ensure that the uniqueness check is performed server-side to prevent duplicates from any client. What should you do?

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?

You are using Copilot in Power Automate to build a flow. How do you refine the generated flow?

You are building a canvas app that submits new rows to a Microsoft Dataverse table from a form. Users report that duplicate rows appear when they click Save twice quickly. You must prevent duplicate submissions while preserving the form's normal submit behavior. What should you do?

You are creating a Power Automate flow that uses the AI Builder 'Create text with GPT' action to generate a summary. The flow must ensure that the AI-generated content is not stored in the run history for compliance reasons. What should you do?

You are configuring a model-driven app form. You need to show a field only if a choice column has a specific value. What should you use?

A Power Automate flow fails when calling a custom AI Builder prompt. The error indicates a token limit exceed. How should you resolve this?

You are creating a Dataverse table to store customer feedback. You need to capture the date and time when the feedback was submitted, including the time zone offset. Which data type should you use for the column?

When troubleshooting a failed Power Automate flow, which TWO areas should you inspect to identify the root cause?

You are building a canvas app that uses a Microsoft Dataverse table named Orders. The app must allow users to create new orders and update existing ones. You need to ensure that the app handles data validation and error handling properly. Which two actions should you perform? (Choose two.)

You are designing a Power Automate cloud flow that must process a large batch of records. The flow retrieves 10,000 items from a SharePoint list and then updates each item based on a condition. You need to optimize performance and avoid hitting service limits. Which approach should you use?

What is the purpose of the App Checker in Power Apps?

A team is building an intelligent app that summarizes customer emails using an Azure OpenAI model. The model call must be made from a Power Apps canvas app, and the API key must never be exposed in the client. Which approach should the team use?

Which TWO ways can you optimize a canvas app for mobile users?

Which THREE of the following are essential when preparing a custom AI model? (Choose THREE)

You are creating a Copilot in Copilot Studio. Which TWO features help ensure that the Copilot provides accurate and relevant answers?

You are a Power Platform maker designing a Dataverse solution for a project management app. You need to create a relationship between a custom table named Project and a custom table named Task. A project can have many tasks, and each task belongs to exactly one project. You also need to ensure that when a project is deleted, all related tasks are automatically deleted. Which two actions should you perform? (Choose two.)

Which TWO properties are most important for data performance in a canvas app?

You are designing a solution for a sales tracking app. You need to create a new custom table called 'Project' that will store project details. The table must have a primary column that uniquely identifies each project and a secondary column for the project's start date. Which of the following best describes the default behavior when you create a new custom table in Dataverse?

You are building a canvas app that lets a customer service agent edit a case. The agent must not be able to save the case until the Resolution notes field contains at least twenty characters, and the Save button should visibly indicate when the form is invalid. Which configuration should you use?

You are building a Power Automate cloud flow that must call a Copilot Studio agent to summarize a long customer email. The email body is 15,000 characters. The agent is configured with a custom prompt and expects a single string input. Which action should you use to invoke the agent and pass the email body?

Which TWO of the following are valid relationship types in Dataverse?

Which THREE tools are available in the Power Apps maker portal?

Which tool is used to manage Dataverse environments and solutions?

A developer is configuring a new custom table in Dataverse. They need to ensure that the table supports auditing and that users can search for records using the Dataverse search. Which two table properties must be enabled? (Choose two.)

You are creating a Power Automate cloud flow that must run every Monday at 9:00 AM and send a summary email. You want to ensure the flow does not run on holidays. What is the simplest way to achieve this?

You are a builder working on a Power Platform solution that includes a custom Dataverse table named ProjectTask. You need to ensure that each ProjectTask record has a unique, human-readable identifier that is automatically generated when the record is created, and users should not be able to change it after creation. What should you use?

Which TWO of the following are true about Power Automate environment variables? (Choose TWO)

What happens when you delete a 'Managed' solution in a target environment?

Which component allows users to navigate between different entities in a Model-driven app?

A team is building a canvas app that calls a Power Automate cloud flow to create a record in Dataverse when a user selects a button. The flow runs but returns no data back to the app, and the app's label never updates. You confirm the flow completes successfully and returns a response. What should you verify in the app to ensure the returned value is displayed?

What is the primary benefit of using a 'Solution' in Power Platform?

Which TWO of the following are valid ways to share a flow with other users? (Choose TWO)

You are building a canvas app and need to filter a gallery based on a text input search. What is the best function to use?

You are building a cloud flow that must process items from a Microsoft Dataverse table in small groups rather than all at once, because a downstream service throttles when called too rapidly. The flow currently uses 'Apply to each' over all rows and hits throttling. Which configuration should you apply to reduce the call rate?

You are building a Copilot in Copilot Studio. You need to ensure that the Copilot can perform a lookup of a customer ID in a SQL database and return the balance. What should you create?

You are creating a new custom table in Dataverse to store product information. You need to ensure that each product has a unique identifier that is automatically generated and can be used as a primary key. Which column type should you use?

A developer is creating a custom connector for a REST API that requires an API key in the header. The connector will be used in a canvas app. The developer wants to ensure that the API key is not exposed to users of the app. What should the developer do?

You are creating a custom page for a model-driven app. What is the primary benefit of using custom pages?

You need to import a large volume of data into Dataverse. Which feature allows you to perform bulk operations efficiently?

You need to store sensitive information in your canvas app. How should you protect it?

You are building a Power Automate cloud flow that must call an Azure Function. The Azure Function requires authentication and returns a JSON payload. You need to pass a secret key to the function securely. Where should you store the secret key?

You are developing a canvas app that uses a custom connector to call an Azure Function. The function requires an API key. You need to store the API key securely so that it is not exposed in the app's source code or to users. What should you do?

You are building a Power Apps canvas app that uses AI Builder to classify customer messages into categories. The app must display the predicted category and confidence score. You need to configure the app to call the AI Builder model. Which component should you use?

You are building a canvas app that calls a custom connector to an internal REST API. The API requires an API key that must never be exposed to app users or stored in the app itself. You need the connector to authenticate without embedding the secret in the app. What should you configure?

You are troubleshooting a form in a model-driven app. The field is read-only even though the user has 'Write' permissions. What is the most likely cause?

Which property of a Text Input control in a canvas app allows you to display a placeholder text?

Which navigation element in a model-driven app allows you to group related tables together?

A canvas app uses a Microsoft Copilot Studio agent to summarize long text fields. Users report that the first summary request after the app has been idle for several minutes takes much longer than subsequent requests, and occasionally times out. You must reduce the perceived latency without changing what the agent returns. What should you do?

You are using an AI Builder prompt to summarize customer feedback. The prompt is producing output in a format that is not consistent for your downstream database. What should you use to enforce a structure?

Which TWO field types allow for mathematical calculations?

A canvas app calls a Microsoft Copilot Studio agent that returns a long generated summary. Users on tablets report the summary is cut off in a label, and scrolling within the label is not possible. You must show the full summary while keeping the layout stable. What should you do?

You are creating a new custom table in Dataverse. You need to ensure that users can quickly find records by searching for a specific text field. Which column property should you enable to allow the field to be used in search?

You need to allow a user to select multiple items from a list in a canvas app. Which control should you use?

Which THREE of the following can cause an AI model to fail in production? (Choose THREE)

Which THREE of the following are primary capabilities of Dataverse business rules?

You are building a canvas app that uses a Microsoft Dataverse table with a column named 'Status' that has choices: New, In Progress, and Closed. You need to display the status as a colored badge in a gallery. Which approach should you use to dynamically set the badge color based on the status value?

You want to automate the extraction of data from invoices using AI Builder. Which model type should you choose?

Which THREE items are considered 'Managed' components in a solution?

You are building a canvas app that connects to Dataverse. You need to store a list of product categories that will be used across multiple apps. The categories should be easy to update without modifying any app. What should you create?

You have created a Copilot agent for your canvas app. Where do you configure the topics the agent can respond to?

A system administrator is setting up a new Dataverse environment. They need to ensure that users can only access records that they own or that are shared with them, and that they cannot see records owned by other users in the same business unit. Which security concept should they configure?

Which TWO settings are crucial when deploying a model-driven app to production?

You are preparing a solution for transport from a development environment to a production environment. The solution contains a custom table, a model-driven app, and several cloud flows that reference environment variables. During import testing, you discover that the flows fail because their connection references point to the developer's personal connections. You need to identify which behaviors are true of connection references and environment variables when a solution is exported and imported. (Choose two.)

Which TWO types of security roles exist in Dataverse?

You are building a canvas app and need to show the signed-in user a temporary success banner at the top of the screen after they submit a form. The banner should appear immediately and disappear on its own after a few seconds without navigating away. Which Power Apps feature should you use?

What is the primary function of an AI Builder 'Prebuilt' model?

You are building a Microsoft Copilot Studio agent that must answer questions using an internal SharePoint site. The site requires authenticated access. You need the agent to retrieve content only from that site and respect the signed-in user's permissions. Which configuration should you use?

You are building a model-driven app for a service desk. Managers need a view that shows only open cases assigned to their team, sorted by priority. The view must be available to all managers without giving them design privileges. What should you create?

A maker publishes a canvas app that reads from a Dataverse table. Users report that records created by teammates are visible, but when a user tries to update a record created by someone else, the save fails with a permission error. The maker confirms the users share the same security role. Which Dataverse concept most likely explains why updates fail while reads succeed?

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?

You are building a Power Automate cloud flow that processes incoming invoices. The flow uses an AI Builder custom document processing model to extract total amounts. You need to ensure that when the model's confidence score for the total amount is below 0.85, the flow routes the invoice to a human reviewer. What should you do?

You are configuring a Dataverse environment for a multinational company. The company requires that certain records be accessible only to users in the same business unit, while other records should be accessible to all users in the organization. You need to set up security roles to enforce this. Which of the following security role privileges should you configure to allow users to read records only within their business unit?

In a canvas app, how do you change the order of items in a gallery?

You are building a model-driven app for a claims team. A business rule on the Claim table must hide a section of the form when the Claim Type is set to Auto, and must also set a default value for the Adjuster field. You need the rule to run in the browser and on mobile without custom code. Which approach should you use?

Which TWO actions should you take when troubleshooting a broken data connection in a canvas app?

You are designing a Power Automate cloud flow that orchestrates multiple Copilot Studio agents. The flow must pass context between agents and handle failures gracefully. Which TWO actions or features should you use to achieve this? (Choose two.)

Where do you define the table relationships in the Power Apps maker portal?

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.)

You are designing a Dataverse solution for a sales tracking app. You need to categorize each opportunity by a predefined set of stages, such as 'Prospecting', 'Qualification', and 'Proposal'. Each opportunity can have only one stage at a time, and you want to ensure users select from these exact values. What should you create?

You are using Copilot to generate a canvas app. You want to add a specific layout. What is the most effective approach?

You are building a canvas app that uses a Microsoft Copilot Studio agent to classify incoming support emails and route them. You need the classification to be reliable and the routing to be testable before release. Which two actions should you perform? (Choose two.)

A user needs to see the history of changes made to a record's fields. What feature must be enabled?

Which component should you use to create a user-friendly process guide on a form?

What is the primary purpose of a Dataverse 'Solution'?

What is the purpose of the 'Default Solution' in Dataverse?

You are designing a Dataverse data model for a field service application. A dispatcher must be able to assign a work order to exactly one technician, but a technician can be assigned many work orders over time. The work order table already exists and the technician table already exists. You need to add the relationship that enforces this business rule with the least administrative effort. What should you create?

You are building a model-driven app for a healthcare clinic. The clinic wants to track patients and their appointments. A patient can have many appointments, and each appointment is associated with exactly one patient. When a patient is deleted, all their appointments should also be deleted. Which relationship behavior should you configure between the Patient and Appointment tables?

A user complains that their changes in a canvas app are not saved to the Dataverse table. What is the most common reason?

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

You are using AI Builder's document processing model to extract invoice total amounts from PDFs. You need to ensure the extracted data is automatically saved to a SharePoint list. What is the most efficient way to achieve this in Power Automate?

Which TWO settings in Power Automate can you modify to improve the execution speed of a flow?

A Power Automate cloud flow uses a Copilot Studio agent to classify support tickets. The agent returns a JSON object with a 'category' field. You need to branch the flow based on the category value and then log the ticket ID and category to a Microsoft Dataverse table. Which combination of actions should you use to parse the agent response and write the record?

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

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

You are building a canvas app that includes a form for users to submit support requests. After a user submits the form, you want to display a temporary success message at the top of the screen that disappears after a few seconds. Which Power Apps function should you use to show this message?

You are creating a canvas app that must display a list of products from a SharePoint list. Users need to be able to select a product and see its details on a separate screen. Which control should you use to display the list and enable selection?

You are building a Power Automate cloud flow that must call two different Copilot Studio agents in parallel to analyze a customer inquiry, then combine their responses. You need to ensure both agents receive the same input and that the flow waits for both before merging results. (Choose two.)

You have a table that is set to 'Organization' owned. What does this mean for security?

What is the first step to create a model-driven app from an existing table?

You are designing a Power Automate flow that uses an AI Builder model to extract data from invoices. The flow must handle cases where the model returns a low confidence score for a field. Which approach best ensures that low-confidence extractions are reviewed by a human before being committed to a SharePoint list?

A developer creates a custom table named 'Project' in Dataverse. They need to ensure that each project record has a unique project code that is automatically generated when the record is created. The code must follow the format 'PRJ-00001', 'PRJ-00002', etc. Which Dataverse feature should they use to achieve this?

You are building an automation in Power Automate that must process a batch of invoices. Each invoice requires the same sequence of actions: extract data with an AI Builder model, validate the extracted fields against a SharePoint list, and if valid, post the data to Dataverse. The invoices are independent and can be processed concurrently. You want to minimize the total processing time while ensuring each invoice is handled exactly once. What should you configure in the flow?

A solution architect must design a Dataverse table that stores historical sensor readings. The table will grow to hundreds of millions of rows, and queries will almost always filter by sensor identifier and a timestamp range. Which design choice best supports efficient querying at this scale?

You need to ensure that an AI model only processes documents from a specific language. Where do you validate this?

You are auditing Dataverse environment performance. You find that a custom table has excessive growth. Which action should you take to manage storage capacity effectively?

You are an app builder for a logistics company. The company uses a Dataverse table named Shipment with a choice column named ShipmentStatus that includes options such as Draft, InTransit, Delivered, and Cancelled. Business rules must automatically set the ShipmentStatus to Delivered when the ActualDeliveryDate column is populated, but users should not be able to manually change the status to Delivered if the ActualDeliveryDate is empty. Which Dataverse feature should you use to implement this requirement?

You are creating a Power Automate flow that triggers when a new email arrives in a shared mailbox. The flow must extract the email body and use a Copilot Studio agent to generate a summary, then post the summary to a Microsoft Teams channel. You need to ensure the flow only processes emails from a specific domain. What should you do?

You need to send an email with an attachment that is generated by a flow. The file size is 25MB. Why might this fail?

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

You have an app generated via natural language. You want to change the primary field of the app. Where do you change this?

You are creating a Power Automate cloud flow that must call a Copilot Studio agent and then branch based on the agent's response. The agent returns a structured JSON payload containing a 'priority' field. You need to use that 'priority' value in a subsequent 'Condition' action. What should you do?

You are building a Power Automate flow that uses an AI Builder document processing model to extract data from invoices. The flow must handle cases where the model's confidence score is below a threshold. Which two actions should you include in the flow? (Choose two.)

You notice that an image in your canvas app is blurry. What should you check to ensure it displays at high quality?

Which THREE items are considered 'Components' in a Power Platform Solution?

You are building a canvas app that uses an AI Builder model to classify customer messages. You need the app to display the classification result immediately after the user submits a message. Which approach should you use?

You are building a Power Automate cloud flow that must create a new record in Microsoft Dataverse and then immediately send a Microsoft Teams message containing the record's unique identifier. The flow currently uses the 'Add a new row' action followed by 'Post message in a chat or channel'. During testing, the Teams message sometimes posts before the Dataverse record is fully committed, so the identifier is missing. What should you do to ensure the Teams message always includes the correct identifier?

In a model-driven app, which view should you modify if you want to change the columns displayed to users by default?

You are building a canvas app that connects to a Microsoft Dataverse table with over 100,000 records. Users report that the gallery shows only the first few hundred records and filtering does not return expected results. You need to ensure the app retrieves and filters all records correctly. What should you do?

You are building a Power Automate flow that uses an AI Builder invoice processing model. The flow must extract line items and then post them to an ERP system. You notice that the model returns a confidence score for each extracted field. What should you do to ensure data quality before posting?

Your organization requires that a flow must wait for manager approval before proceeding to update a Dataverse record. Which action should you use?

You are designing a Power Automate cloud flow that processes incoming invoices. The flow uses AI Builder to extract key fields, then routes the invoice for approval if the total exceeds $10,000. You need to ensure that the approval request includes the extracted invoice number and total. Which configuration should you use?

You are building a canvas app in Power Apps that connects to a Microsoft Dataverse table containing 200,000 contact records. Users report that the gallery takes more than 30 seconds to load. You need to reduce the load time while keeping the gallery functional for searching by last name. What should you do?

A developer is creating a Power Automate cloud flow that must retrieve all active accounts with a specific industry and then update a custom column on each. The flow will run daily. Which Dataverse action should be used to efficiently retrieve the records?

You are configuring a Power Automate flow that uses a Premium connector. What is a requirement for this flow to be shared with other users?

Which THREE types of controls are commonly used to input data in a canvas app?

You are building a Power Automate flow that needs to trigger whenever a row is added to a Dataverse table. Which trigger should you select to ensure the flow runs in near real-time?

You are creating a canvas app that must let users edit a Dataverse record in a form and save changes back to the table. You want the form to validate required fields before saving and to submit only when validation passes. Which control and property combination should you use?

A Power Platform environment requires that users from the 'Sales' team cannot see 'Lead' records owned by the 'Marketing' team. You have already verified security roles. What is the next logical step?

You are building a model-driven app for a chain of fitness studios. The app uses a custom Dataverse table named ClassSession that has a Many-to-One relationship to a custom table named Studio. Each studio has a weekly capacity limit stored in a Whole Number column named WeeklyCapacity. You need to prevent a user from creating a ClassSession record if the total number of ClassSessions for that studio in the same week would exceed the studio's WeeklyCapacity. The validation must run whenever a ClassSession is created or updated, regardless of whether the change comes from the model-driven app, a Power Automate flow, or the Web API. What should you use?

You are creating a Power Automate flow that must run every weekday at 9:00 AM to send a summary email. Which trigger should you use?

You are creating a canvas app that displays a list of products. You want the app to show a warning icon next to any product whose stock quantity is below 10. The gallery already has an Image control. What should you set the Visible property of the Image control to?

A canvas app uses a SQL Server table with over 100,000 rows. Users report that a gallery showing filtered records is slow and sometimes returns incomplete results. You have already set the data source to enable delegation where possible. Which action should you take next to improve performance and correctness?

You are creating a Power Automate flow that must send an adaptive card to a Microsoft Teams channel when a new high-priority ticket is created in a SharePoint list. The card should include the ticket title, priority, and a link to the item. Which action should you use to post the card?

You are building a Power Automate flow that uses an AI Builder model to process invoices. The flow must extract data from the invoices and then validate the extracted total against a threshold. Which TWO actions are required to achieve this? (Choose two.)

You are configuring a new custom table in Dataverse to store project tasks. You need to ensure that the table supports attachments, allows users to add notes, and tracks when records are created and modified. Which two actions should you perform? (Choose two.)

Which THREE of the following are benefits of using Copilot in Power Automate? (Choose THREE)

You are building an automation that must call a Power Automate cloud flow from a Copilot Studio agent. The flow returns a JSON payload containing a customer's order status. You need the agent to display the order status to the user in a conversational reply. Which action should you configure in the agent's topic?

A Copilot needs to be restricted to only answer questions based on the documentation provided in a specific SharePoint folder. How should you configure this?

You are building a Power Automate cloud flow that must create a new record in a Microsoft Dataverse table every time an AI Builder custom document processing model extracts a purchase order number. The flow currently runs manually and you need it to start automatically when a new PDF is uploaded to a SharePoint document library. Which trigger should you use?

You are creating a model-driven app for a property management company. The app must include a custom page that displays a map of all properties using a third-party JavaScript mapping library, and this page must appear in the main site map alongside standard table views. Which approach should you use to add this custom page?

Which entity property determines if a record can be renamed by a user?

You are configuring field-level security for a sensitive 'Salary' field. You have enabled the field for security. What must be done next to ensure the user cannot read the data?

You are a solution architect for a large enterprise. The company uses Dataverse and needs to ensure that when a custom table named Invoice is created or updated, a series of complex calculations are performed and the results are stored in related records across multiple tables. The calculations involve aggregating data from several other tables and must run reliably even if initiated from bulk data imports or background processes. You need to minimize development effort and ensure the logic is reusable across multiple apps. What should you use?

You are using AI Hub to categorize customer support emails. You need to ensure the model processes only emails with high sentiment scores. Where do you configure this logic?

You are designing a Dataverse table to store support tickets. Each ticket must be assigned a unique, automatically generated identifier that users can easily reference. The identifier should follow a consistent pattern, such as 'TCK-00001', and increment for each new record. Which Dataverse feature should you use to meet this requirement?

Which THREE actions are essential when designing a robust Power Automate cloud flow that interacts with Dataverse?

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?

What is the primary function of a 'Business Process Flow' in a model-driven app?

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?

Which component in a model-driven app is used to present a summary of data?

Which THREE of the following are true about Copilot Studio agents? (Choose THREE)

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

A developer needs to ensure that a custom field value is validated before the record is saved to the database. Where should this logic be placed?

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?

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.)

Where can you view the historical run logs for a specific Power Automate cloud flow?

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?

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

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?

Which TWO of the following are best practices for securing flow logic? (Choose TWO)

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?

You want to trigger a cloud flow from a Power Apps button. What is the most important step in the flow design?

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?

Which type of relationship is required to allow multiple 'Contacts' to be associated with multiple 'Accounts'?

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

When you generate a canvas app from natural language, what happens to the data?

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.)

You are implementing 'Human in the Loop' with a Power Automate flow. Which action stops the flow and waits for an input?

You have a Power Automate cloud flow that processes invoices using AI Builder. The flow is triggered when a new file is added to a SharePoint document library. You need to ensure that the flow only processes PDF files and extracts key fields. Which action should you add first in the flow?

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?

A user has 'User' level access to a table. They create a record. Who is the owner of the record?

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?

You are building a canvas app that uses a Microsoft Dataverse table named 'Projects'. You need to ensure that when a user opens the app, only projects where the 'Owner' column equals the current user's email are loaded. Which function should you use in the app's OnStart property to filter the data efficiently?

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.)

You are creating a Power Automate cloud flow that must run whenever a new file is added to a specific SharePoint document library. The flow should then send the file to an AI Builder model for processing. Which trigger should you use?

You need to create a field that automatically calculates the total revenue of a customer based on related invoices. Which field type should you use?

A user reports that their Copilot is hallucinating. Which setting should you adjust to reduce this?

You are a Power Platform developer. You need to create a new custom table in Dataverse to store product information. The table must have a column that can store a monetary value and another column that can store a yes/no choice. Which column data types should you use?

What is the maximum number of environments a single tenant can create?

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.)

You are building a canvas app that displays a list of products from a Dataverse table. You want to show the total price of all products in a label. Which function should you use in the label's Text property?

A developer is building a canvas app that must let a user pick a single date from a calendar-style picker. The selected date then filters a gallery of records. Which control should the developer add to the screen for this purpose?

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?

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?

Which of these is NOT a valid trigger for a Power Automate flow?

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?

You are troubleshooting a failed flow run. Where do you find the specific input and output data for each action?

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

You need to automate document extraction using AI Builder. The documents are varied invoices. Which model type should you configure?

A Power Platform developer is creating a new custom table in Dataverse. They need to store a list of predefined options that users can select from, such as 'High', 'Medium', or 'Low' priority. Which type of column should they use?

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?

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

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?

You want to automate the process of sending an email whenever a specific field value changes. What is the best way to achieve this?

In a canvas app, you want to allow users to upload images to Dataverse. Which control is best suited for this?

What is the purpose of the 'Parallel' branch in Power Automate?

A user reports they cannot see a custom table in their app, even though the table is part of the solution. What is the most likely cause?

Which TWO of the following are key components of a Power Automate flow? (Choose TWO)

Which THREE features help ensure your canvas app is performant?

In AI Hub, what does 'Training' refer to?

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

You have an app that needs to connect to an on-premises SQL Server. What is required to facilitate this?

Which of the following is a benefit of using Solutions for your Power Automate flows?

You are building a solution that includes a flow and an app. Where should you save these components to ensure they can be easily moved between environments?

You are designing a Dataverse solution for a hospital. You need to track patient visits and the medications prescribed during each visit. A visit can have multiple medications, and a medication can be prescribed in multiple visits. You also need to store the dosage and frequency for each medication prescribed in a visit. What is the most appropriate way to model this relationship?

You need to create a Power Automate flow that processes a large batch of documents using an AI Builder custom model. The flow must process each document independently and in parallel to reduce overall processing time. Which action should you use to achieve parallel processing?

Which TWO actions can be performed in the Power Platform admin center?

You need to automate a process that extracts data from PDF invoices. Some invoices are multi-page. Which model type should you use?

A flow needs to perform an action every 5 minutes. What is the limitation regarding the 'Recurrence' trigger?

You need to trigger a Cloud Flow from a canvas app when a button is clicked. How do you integrate the flow?

You are building a model-driven app and need a field to be mandatory only when another field is filled. How do you achieve this?

Which TWO types of components can be included in a Power Apps Solution?

You are building a model-driven app for a sales team. The app uses a Dataverse table named Opportunity. You need to ensure that when a user opens an Opportunity record, they see a read-only list of related Contacts that are associated with that Opportunity. The list should appear on the main form and allow users to open a Contact record. What should you add to the form?

You are designing a Dataverse solution for a real estate agency. The agency needs to track properties and the agents who list them. Each property can have only one listing agent, but an agent can list many properties. You create a table named Property and a table named Agent. You need to establish the relationship so that when an agent is deleted, their listed properties remain but the Listing Agent column is cleared. Which relationship type and behavior should you configure?

Which TWO items are visible in the Power Apps 'Tree View' pane?

A canvas app user reports that a gallery is not displaying data from a Dataverse table. You verify the connection is active. What is the most likely cause?

You want to use AI Builder to predict whether a customer will churn. You have a Dataverse table with historical churn data. What is the first step?

You are designing a Dataverse table to store customer orders. You need to ensure that each order is automatically assigned a unique, sequential order number that users can easily reference. The number should be generated when a new record is created and should not be editable by users. What should you use?

You are using Power Automate to automate a business process that requires human approval before an order is finalized. The approver must be able to approve or reject directly from Microsoft Teams. Which action should you use to request approval?

Which THREE features are part of Dataverse security?