The owner of a company needs to know who signs into the system.
You need to ensure that the owner can view the user audit logs.
Where does each action need to be performed? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Activate user auditing.: System Settings — Organization-wide auditing is switched on in the Dataverse/Dynamics 365 System Settings under the Auditing tab, where "Start Auditing" and specifically "Audit user access" are enabled; the "Audit user access" option is what records user sign-in (access) events rather than data changes. Customize the System only lets you turn auditing on for individual tables and columns once the organization-level setting exists, and Personal Settings holds per-user preferences with no auditing control at all.
View the user audit logs.: Microsoft 365 Compliance — User access/sign-in events captured by Dataverse auditing surface in the unified audit log, which is searched from the Microsoft 365 compliance (Microsoft Purview) portal audit log search, so that is where the owner reviews who signed in. The in-app options do not work for this: an Individual record only shows the audit history of that one row, Advanced Find cannot query the Audit table, and there is no User Summary report that returns sign-in activity.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. List view of the entity
- B. Microsoft Visual Studio
- C. Templates area
- D. Maker portal Correct
Explanation
The Maker portal is the designated platform for creating views accessible to all users within an organization without using custom code, aligning with Power Apps solutions. This approach adheres to organizational policies that prohibit the use of custom code.
You create a Power Apps portal to provide training and documentation for students. Students create a profile on the portal and then select and pay for courses.
You plan to add free courses to the training portfolio. Free courses must be automatically available to all students after they sign in.
You need to assign default permissions to students.
What should you do?
- A. Create a Students web role and set the Authenticated Users Role option to true. Assign the web role to each registered user.
- B. Create an entity for managing free courses. Create entity permission records to provide access to entity records for free courses and assign the entity permissions to users when they register on the portal for the first time.
- C. Create an entity for managing free courses. Create a Students web role and set the Authenticated Users role option to true. Create appropriate entity permissions to access the free course entity records and assign the entity permissions to the web role. Correct
Explanation
Option C correctly involves creating a Students web role with the Authenticated Users Role option set to true and assigning appropriate entity permissions for free course access, ensuring all authenticated users automatically have access to free courses upon signing in.
You create workflows to automate business processes.
You need to configure a workflow to meet the following requirements:
✑ Be triggered when a condition is met.
✑ Run immediately.
✑ Perform an action when a condition is met.
You need to create a workflow that automatically sends emails based on a mail merge template. To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Be triggered when a condition is met.: Subject contains data. — A classic Dataverse background workflow starts from a record event plus a condition, so the trigger here is the evaluation of record data (the email/case subject containing data), which is what fires the workflow automatically when the criterion is satisfied. "Trigger when a Power Automate button is pressed." is wrong because a manual button press is user-initiated rather than condition-driven, and "Publish workflow." is an activation step for the workflow definition, not a trigger event.
Run immediately.: Configure the workflow to run now. — Dataverse workflows can execute either in the background (asynchronously, queued as a system job) or in real time; selecting the "run now"/real-time option makes the logic execute synchronously the moment the triggering condition occurs instead of waiting for the async queue. "Approve the workflow." is not a workflow execution setting, and "Configure child workflow to run now." only applies to a subprocess called by another workflow, which does not control when the parent process itself runs.
Perform an action when a condition is met.: Send an email. — The requirement is to automatically send mail-merge-style messages, and "Send Email" is the workflow step that creates and sends an email record from a template, so it is the action placed under the condition branch. "View chart." is a user interface operation that is not available as a workflow action, and "Update a security role." does not send any communication and is unrelated to the emailing requirement.
You are a Dynamics 365 Customer Service administrator.
You need to configure the following automation for the sales team:
✑ Send an email when the status changes on an Opportunity.
✑ Text the sales manager when an Opportunity is created.
✑ Create a Wunderlist task when an Opportunity is open for 30 days.
Which tool should you use for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Email when the status changes.: Dynamics 365 workflow — A classic Dynamics 365 (Dataverse) background workflow can be registered to run on the Opportunity table when a specific field such as Status/Status Reason changes, and the built-in Send Email step delivers the message natively from the CRM record with no external connector required. A Business Process Flow is wrong here because it only guides a user through stages and cannot itself fire an automated email on a field change.
Text when the Opportunity is created.: Microsoft Flow — Sending an SMS message requires reaching outside Dataverse to a messaging service (Twilio, a phone/SMS connector, etc.), and Microsoft Flow (Power Automate) is the tool with those connectors; a Dataverse "When a row is added" trigger on Opportunity then calls the SMS action. A classic Dynamics 365 workflow is wrong because its native step list has no SMS capability and cannot call third-party services without custom code.
Create a Wunderlist task.: Microsoft Flow — Wunderlist is an external third-party service, and Microsoft Flow has a connector for it, so a scheduled or condition-based flow can create the task when an Opportunity has stayed open for 30 days. Neither a classic Dynamics 365 workflow nor a Business Process Flow can create records in an outside system like Wunderlist.
A company uses Microsoft Dataverse to manage prospects. The company has a business process flow named BPFA that is associated with the Prospect entity to streamline the prospect management process.
You add a field named Category to the Prospect entity. You create additional business process flows. You apply the business process flows to Prospect records based on the selected category. Users can switch to any other newly configured business process flows but must not use BPFA.
You need to configure the solution.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Remove all of the privileges for BPFA. Correct
- B. Use a business rule to prevent users from switching to BPFA.
- C. Deactivate BPFA. Correct
- D. Change the display order of the business process flows to move BPFA to the bottom of the list.
Explanation
A business process flow is its own table secured by security roles, and it is offered to users only while it is activated. Removing all privileges for BPFA from the users' security roles means BPFA no longer appears when they switch process, while the new flows stay available. Deactivating BPFA removes it from use altogether, so users can switch only between the newly configured flows. A business rule cannot control which business process flow a user switches to, and changing the display order only moves BPFA down the list; it can still be selected.
You are creating a business rule to implement new business logic.
You must apply the business logic to a canvas app that has a single screen named Screen1.
You need to configure the scope for the business rule.
Which scope should you use?
- A. Screen1
- B. Entity Correct
- C. All Forms
- D. Global
Explanation
For a canvas app in Power Apps, business rules must be scoped at the entity level to apply logic across the entire application. This ensures that the rule is applied consistently regardless of the specific screen or form being used.
You are a Dynamics 365 Customer Services administrator. You have a Production instance and Sandbox instance.
Users record Production instance data in the Sandbox instance.
You need to ensure that the users only record data in the Production instance.
Which security function needs to be edited to prevent access to the Sandbox? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Microsoft 365 admin center: Groups — Access to a Dynamics 365 / Dataverse environment is gated by the Microsoft 365 (Microsoft Entra ID) security group that is associated with that environment, so in the admin center you edit the security group membership and remove the users who should not touch the Sandbox; once a user is outside the group linked to the Sandbox instance, they are disabled in that environment and cannot sign in to it. Licenses is not the answer because the users still need their Dynamics 365 licenses to work in Production, and removing a license would block both environments rather than just the Sandbox.
Dynamics 365 Sandbox instance: Roles — Inside the Sandbox environment itself, access is controlled by security roles: a user with no security role assigned in that environment has no privileges and cannot open or record data there, so you edit the role assignments in the Sandbox to strip the users' access. Access rights (read, write, append, and so on) are not edited directly per user — they are the privileges defined inside a security role, so the security role is the object you actually modify.
You must create a new entity to support a new feature for an app. Records for the entity must be associated with a business unit and specify security roles for the business unit.
You need to configure entity ownership.
Which entity ownership type should you use?
- A. user or team owned Correct
- B. organization-owned
- C. none
- D. business-owned
Explanation
User or team owned entities allow for specific business unit associations and security role assignments, fulfilling the requirement to associate records with a business unit and specify security roles.
You need to ensure that there are no leads for a customer before you create a new opportunity for the customer.
How can you use duplicate detection rules to achieve this goal? To answer, select the appropriate options in the answer area.
NOTE:
Each correct selection is worth one point.
Hot Area:
Explanation
Base record type: Opportunity — In a Dataverse duplicate detection rule the base record type is the table of the record being created or checked at that moment, and the matching record type is the table you compare it against. Because the check must fire when a new opportunity is created (looking for existing leads for that customer), Opportunity is the base and Lead is the matching record type; choosing Lead or Account as the base would run the check when a lead or account is saved, not when the opportunity is created.
Base record field: Account — The comparison has to be made on the field that identifies the customer, and on the Opportunity table that is the Account (customer) lookup, which is matched against the corresponding company/account value on the Lead records. Topic is only the free-text name of the opportunity and would not identify the customer, and Originating Lead only points at the single lead an opportunity was converted from, so it would never surface other existing leads for that customer.
You have two Microsoft Power Platform environments.
Users in one environment must not be able to see the other environment.
You need to grant salespeople access to the sales company environment.
What should you do?
- A. Add salespeople to an Office 365 security group. Correct
- B. Add salespeople to a security role.
- C. Set privileges.
- D. Set app security.
Explanation
Adding salespeople to an Office 365 security group allows for the isolation of environments and control over who can access which environment. This ensures users in one environment cannot see or access another.
A veterinary office plans to use Power Platform to streamline customer experiences. The customer creates a canvas apps to manage appointments.
On the client appointment form, there is a dropdown field for clients to select their type of pet. If a client selects the option Other, the veterinarian wants a text field to appear so that additional details can be added.
You need to create a dynamically visible field.
What should you configure?
- A. workflow
- B. business process flow
- C. business rule Correct
Explanation
A business rule is the option built for this: it applies conditional logic without code, and one of its actions is Show or hide columns. A condition such as 'Pet type equals Other' shows the details text column, and the rule hides it otherwise. A workflow runs server-side processes on records and cannot change what a form displays, and a business process flow guides users through stages and steps rather than toggling individual fields. Note that business rules defined on a Dataverse table apply to both model-driven and canvas apps, but the Show or hide columns action takes effect only on model-driven forms. Inside the canvas app itself, the same behavior is built by setting the text input's Visible property to a formula, for example Dropdown1.Selected.Value = "Other".
You create an app for the sales team at a company.
Members of the sales team cannot access the app.
You need to ensure that sales team members can access the app.
Where should you configure app permissions?
- A. Dynamics administration center
- B. Manage Roles Correct
- C. Security Roles
Explanation
A model-driven app is available only to users who hold a security role that has been associated with that app. You configure this on the app itself: in Power Apps, select the app and use Manage Roles (in the current maker portal this is the app's Share pane), then select the security roles, such as the sales team's role, that may use the app. Editing Security Roles only changes the table privileges inside a role and does not by itself make the app available, and the Dynamics administration center is not where app access is assigned.
You create a parent entity and a child entity. The parent entity has a 1:N relationship with the child entity.
You need to ensure that when the owner changes on the parent record that all child records are assigned to the new owner.
You need to configure the relationship behavior type.
What should you use?
- A. Referential
- B. Referential, Restrict Delete
- C. Parental Correct
- D. Restrict
Explanation
The 'Parental' relationship behavior type ensures that when the owner of a parent record changes, all related child records are automatically assigned to the new owner. This meets the requirement specified in the question.
You need to recommend a role for users to perform several required tasks. The solution must use the principle of least privilege.
Which roles should you recommend? To answer, drag the appropriate roles to the correct functions. Each role may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
Create new users: Office 365 global administrator - users are created in the Microsoft 365 admin center (Microsoft Entra ID); of the roles offered, only the Office 365 global administrator can create users. The Office 365 service administrator role is for managing service health and support requests, and the Dynamics 365 roles cannot create tenant users.
Assign roles to users: Dynamics 365 system administrator - security roles inside the Dataverse/Dynamics 365 environment are assigned by a user who holds the System Administrator security role in that environment, so there is no need for a tenant-wide admin role.
Perform backups for an instance: Dynamics 365 service administrator - this tenant role (now called Dynamics 365 administrator / Power Platform administrator) manages environments in the Power Platform admin center, including backup and restore, without granting global administrator rights.
You are designing an app for a bank.
You must create entities for the app and configure relationships between entities:
Which relationship types should you use? To answer, drag the appropriate relationship types to the correct requirements. Each relationship type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
| Entity | Requirements |
|--------|--------------|
| LoanApplicant | This entity represents a person who is applying for a loan. The entity must contain an attribute named Email. This attribute must provide look-up for the name of the applicant. |
| Loan | This entity represents a loan application. Loan applicants may apply for one loan per application. Loan applicants may have more than one active application. |
| Property | This entity represents the property that the applicant intends to purchase. |
Explanation
Email look-up to the contact: N:1. The LoanApplicant table gets a lookup column to Contact; many loan applicants can point to one contact, which is a many-to-one relationship seen from LoanApplicant.
One type of loan per application, more than one application per applicant: N:N. Applicants and loan applications/types relate in both directions (an applicant can have many applications, and a loan type can be applied for by many applicants), which needs a many-to-many relationship.
Loans applied for a single property: N:1. Each loan has a lookup to exactly one property, while one property can be referenced by many loans, so the relationship from Loan to Property is many-to-one.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You administer the Microsoft 365 and Power Platform environments for Contoso, Ltd. The company has a model-driven app that is used to track customer interactions with employees. The app uses standard table types for customers. A user named Elisabeth Rice signs in to the app by using a sign-in name based on her current name (Rice).
After marriage, Elisabeth changes her legal name to Elisabeth Mueller.
You need to update the sign in name for the user without losing any application history.
Solution: Change Elisabeth's username in the user record for the app.
Does the solution meet the goal?
Explanation
The user record in a model-driven app (Dataverse) is synchronized from Microsoft Entra ID, and the username field is not edited in the app. Changing it there does not change the sign-in name. The sign-in name (user principal name) must be changed in the Microsoft 365 admin center or Microsoft Entra ID; the change then synchronizes to the existing Dataverse user record, so the application history is kept.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You administer the Microsoft 365 and Power Platform environments for Contoso, Ltd. The company has a model-driven app that is used to track customer interactions with employees. The app uses standard table types for customers. A user named Elisabeth Rice signs in to the app by using the following sign in name: erice@contoso.com.
After marriage, Elisabeth changes her legal name to Elisabeth Mueller.
You need to update the sign in name for the user without losing any application history.
Solution: Ask the Microsoft 365 administrator to sign in to the admin portal and change the username.
Does the solution meet the goal?
Explanation
Yes. Users of a model-driven app are Microsoft Entra ID users whose profile is synchronized to their Dataverse user (SystemUser) record. The Username managed in the Microsoft 365 admin center maps to the User Name (DomainName) field of the Dataverse user record, and this field is always synchronized. When the Microsoft 365 administrator changes the username, the same user object (same object ID) is updated and the new sign-in name flows to the existing user record in the environment. Because the user record is not replaced, all records owned by or linked to Elisabeth keep their history.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You administer the Microsoft 365 and Power Platform environments for Contoso, Ltd. The company has a model-driven app that is used to track customer interactions with employees. The app uses standard table types for customers. A user named Elisabeth Rice signs in to the app by using the following sign in name: Elisabeth.Rice@contoso.com.
After marriage, Elisabeth changes her legal name to Elisabeth Mueller.
You need to update the sign in name for the user without losing any application history.
Solution: Delete the user account in the Power Platform admin portal and recreate the account by using the new name.
Does the solution meet the goal?
Explanation
Deleting and recreating the user account in the Power Platform admin portal would result in losing all application history associated with Elisabeth Rice. To preserve this history, updating the user's profile directly within the system is necessary without deleting the account.
You need to create a system chart for the Account entity.
The chart must display a count of accounts grouped by owner and then display the accounts by Address 1: State/Province for each owner. You begin to configure chart options as shown in the image below.
How should you complete the configuration? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Legend Entries (Series): Select Field: Account. The series is the value the chart measures, and the requirement is a count of accounts, so the series field is the Account record itself. Owner and Address 1: State/Province are what the count is broken down by, so they belong on the category axis, not in the series.
Legend Entries (Series): Aggregate: Count:All. Count:All returns the number of Account records in each group, which is what "display a count of accounts" asks for. Sum and Avg need a numeric column such as Annual Revenue and do not count records.
First grouping field: Owner. The first field under Horizontal (Category) Axis Labels sets the main grouping, so each owner becomes a top-level group, which matches "grouped by owner."
Second grouping field: Address 1: State/Province. A second category field adds a sub-grouping inside each main group, so each owner's accounts are then shown by state or province. Repeating Owner, or choosing Account, would not give that breakdown.
A user has access to an existing Common Data Service database.
You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required.
Which out-of-the-box security role should you assign to the user?
- A. Environment Admin
- B. System Customizer
- C. Common Data Service User
- D. Environment Maker Correct
Explanation
The Environment Maker role allows users to create canvas apps that consume data from Dataverse without granting unnecessary permissions. Since the user already has access to the Common Data Service database, no additional privileges are required.
A company deploys several model-driven apps. The company uses shared devices in their warehouse. The devices are always powered on. Users log on to the devices and then launch the apps to perform actions.
Unauthorized users recently uploaded several files after another user failed to log out of a device. The company needs to prevent these incidents from occurring in the future.
You need to configure the solution to prevent the reported security incidents.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Prevent unauthorized access to devices.: Set a timeout in the Power Platform admin center. — In the environment's Settings > Product > Privacy + Security page, the Inactivity timeout setting automatically signs a user out of model-driven apps after a set period without activity, so an app session left open on an always-on shared warehouse device ends on its own. A group policy inactivity limit acts on the Windows session of the device, not on the app session; Azure Active Directory access controls decide who can sign in but do not end an idle session that is already open; and a Power Automate flow cannot detect inactivity on a device or sign users out of the apps.
Prevent users from uploading a specific type of file.: Enter the restricted file types in the Power Platform admin center. — The same Privacy + Security page has the Blocked attachments setting, where you list the file extensions that cannot be uploaded or downloaded as attachments in Dataverse. Entering only the allowed types would block every other type rather than the one specific type, and the SharePoint admin center controls files stored in SharePoint, not attachments uploaded through model-driven apps.
A company's sales staff wants a simplified way to manage their opportunities in Dynamics 365 Sales without adding custom code.
You need to provide a solution for each requirement.
Which solutions should you provide? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Drag and drop opportunities to change the stage.: Add a Kanban control. — The Kanban control renders opportunity records as cards in lanes, where each lane represents a business process flow stage (or a status value), and dragging a card from one lane to another writes the new stage back to the record with no code. The Editable Grid control only allows in-cell editing of column values in a grid layout and offers no lane-based drag-and-drop for moving a record through stages.
Show each salesperson their opportunities in Calendar and Kanban view.: Add both controls to the My Opportunities view. — A single view can host more than one custom control, and users switch between the available renderings from the view's display options, so adding both the Calendar and Kanban controls to one view gives each salesperson both experiences. My Opportunities is the out-of-the-box system view already filtered to records owned by the signed-in user, so it automatically shows each salesperson only their own records; the All Opportunities view would show everyone's records, and a custom view would require building that owner filter yourself.
Show each salesperson the number of open opportunities by stage in a standard view.: Use the List view. — The requirement is to use a standard (out-of-the-box) view, and the default List view of Opportunities already displays the records with a record count and lets the salesperson group, sort, or filter by stage without any customization or added code. The Kanban control is not a standard view — it is a custom control that must be added to a view — so choosing it would mean customizing rather than using the standard view as required.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You administer the Microsoft 365 and Power Platform environments for Contoso, Ltd. The company has a model-driven app that is used to track customer interactions with employees. The app uses standard table types for customers. A user named Elisabeth Rice signs in to the app by using a sign-in name based on her current name (Rice).
After marriage, Elisabeth changes her legal name to Elisabeth Mueller.
You need to update the sign in name for the user without losing any application history.
Solution: From Dynamics 365 Settings, select Email Configuration. In the active mailbox for the user, update the name.
Does the solution meet the goal?
Explanation
Updating the name in Dynamics 365 Email Configuration does not change the user's sign-in name. To update the sign-in name without losing application history, one should modify the user profile directly within Microsoft 365 or Azure Active Directory.
You plan to implement Microsoft Dataverse.
You must track changes for two columns in the Account table. You must maintain a historical log of changes for the two columns and track only what is necessary.
You configure the appropriate organization settings.
You need to configure the system to track changes for the two columns.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Enable auditing for the Account table. Correct
- B. Enable auditing for the two specific columns. Correct
- C. Enable change tracking for the Account table.
- D. Enable change tracking for the two specific columns.
Explanation
Auditing in Microsoft Dataverse allows tracking changes at the table or column level. To track changes for specific columns (Account table) and maintain a historical log of these changes, auditing must be enabled both for the Account table and specifically for the two required columns.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
On a Contact record, a user creates a Note record that contains the word running.
One week later, the user reports that they cannot find the Contact record associated with the Note record.
You need to find the Note record.
Solution: Use Categorized Search to search for the word run.
Does the solution meet the goal?
Explanation
Categorized Search returns records whose quick find columns begin with the search term, but it only searches tables enabled for it and does not search the text of Note records. Searching for run therefore cannot surface the note. Dataverse search, which indexes notes and attachments and supports matching on word forms, is the tool that can find the Note record and its related Contact.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
On a Contact record, a user creates a Note record that contains the word running.
One week later, the user reports that they cannot find the Contact record associated with the Note record.
You need to find the Note record.
Solution: Use Relevance Search to search for the word run.
Does the solution meet the goal?
Explanation
Relevance Search (Dataverse search) is full-text search with intelligent, fuzzy matching, so it does not depend on an exact keyword match and returns related forms of the search word: a search for run also finds running. Dataverse search covers notes and attachments, and for Note rows the results show extra columns with information about the related row. The search returns the Note record, and from it you can open the Contact it belongs to. The solution meets the goal.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
On a Contact record, a user creates a Note record that contains the word running.
One week later, the user reports that they cannot find the Contact record associated with the Note record.
You need to find the Note record.
Solution: Use Quick Find search on the Notes list to search for the word run.
Does the solution meet the goal?
Explanation
The solution does not meet the goal. Quick Find matches column values that begin with the search term. The word running is somewhere inside the note text, not at the start of the value, so searching for run on its own does not return the note. You must put a wildcard in front of the term (for example *run or *running) so that Quick Find matches the word anywhere in the text.
You are implementing a model-driven app to support a new line of business.
There are several places where automated business logic must be applied.
You need to determine how to apply the business logic.
Which method should you use? To answer, drag the appropriate methods to the appropriate business logic statements. Each method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Make a field read only until a value is exceeded: Business rule. A business rule can check a column's value and lock or unlock another column on the form, with no code.
Send an email when the status changes to deactivated: Real-time workflow. A classic workflow can start automatically on a status change and has a Send Email step. A Power Automate instant flow has to be started by hand, so it doesn't run automatically.
Use the previous value of a field when it is automatically updated: Real-time workflow. A real-time workflow set to run before the change sees the column's value before the update, so the logic can use the previous value. Business rules and instant flows can't read that pre-update value.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. Advanced Find
- B. Entities component of a solution Correct
- C. Microsoft Excel template
- D. Templates area
Explanation
The 'Entities component of a solution' allows creating views that can be shared across the organization without using custom code, aligning with the requirement. This option ensures that all users within the organization can access and utilize the created view.
You develop a Power Apps app.
Users report that the main form does not display data from other entities or allow them to edit data from other entities.
You need to embed information from other entities in the form and allow users to edit the data.
Which actions should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Edit data: Add a sub-grid — A sub-grid embeds a list of related records from another table directly on the main form, and because sub-grid rows can be opened or edited inline (editable grids/row-level editing), users can change that related data without leaving the form. "Add a quick create form" only speeds up creating brand-new records from a lookup or the + button rather than embedding and editing existing related data, and "Add a virtual entity" merely surfaces external data in Dataverse (historically read-only) rather than being a form control.
View data: Add a quick view — A quick view control (quick view form) is placed on the main form and renders selected fields from the record referenced by a lookup column, so information from the other table is visible in context. It is read-only by design, which is exactly why it covers the "view" requirement while the sub-grid covers editing; a reference panel is just a tab-style container that hosts related sections, not the control that pulls in another table's field values.
A company uses a canvas app to manage production resources in a specific region. Employees must be at company locations to use the app.
Due to a sudden requirement for employees to work remotely, employees no longer commute to a specific location to conduct their work and cannot access the canvas app.
You must reconfigure the app to ensure that employees only access the app from a limited number of locations.
You need to restrict access to the app.
Which components should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Ensure that employees can only access the app form a specific region: Azure Active Directory — Location- and network-based access restrictions for Power Apps are enforced by the identity provider, so you configure them in Azure Active Directory (Microsoft Entra ID), where named locations (IP ranges and countries/regions) are defined and evaluated at sign-in. Canvas app settings and the Power Platform admin center control app behavior, sharing, and environment/DLP governance but have no mechanism to restrict sign-in by geography, and the Office 365 admin center only manages users, licenses, and service settings.
Specify the locations where a user can access the app: Conditional Access policy — A Conditional Access policy targeting the Power Apps/Dataverse service applies the named locations as a condition, granting or blocking access depending on where the user signs in from, which is exactly the "only from a limited number of locations" requirement. A security role only controls privileges on Dataverse tables and records once the user is already authenticated, a Local Security policy applies to an individual Windows machine rather than cloud sign-ins, and a compliance policy in Intune evaluates device health and settings, not the user's location.
You attempt to deactivate several currencies in a Microsoft Dataverse environment.
You are not able to deactivate one of the currencies.
You need to determine why you cannot deactivate the currency.
What is the reason?
- A. You are not the currency record owner.
- B. The currency is used by an active business process.
- C. The currency is the base currency. Correct
- D. The currency is used by another record.
Explanation
The base currency in a Microsoft Dataverse environment cannot be deactivated because it is the primary currency used for financial calculations and conversions. Attempting to deactivate the base currency will result in failure as it is essential for maintaining financial integrity within the system.
A user has access to an existing Microsoft Dataverse database.
You need to ensure that the user can create canvas apps that consume data from Dataverse. You must not grant permissions that are not required.
Which out-of-the-box security role should you assign to the user?
- A. Environment Admin
- B. Basic User
- C. Environment Maker Correct
- D. System Customizer
Explanation
The Environment Maker role allows users to create canvas apps within an environment without granting unnecessary permissions. Since the user already has access to the Dataverse database, this role ensures they can build apps that consume data from Dataverse without additional privileges.
You are configuring Microsoft Dataverse security. You plan to assign users to teams.
Record ownership and permissions will differ based on business requirements.
You need to determine which team types meet the requirements.
Which team type should you use? To answer, drag the appropriate team types to the correct requirements. Each team type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Dataverse has three team types: owner teams, access teams and Microsoft Entra ID (Azure Active Directory) group teams. Like an owner team, an Azure Active Directory group team can own records and can have security roles assigned, so it meets the record ownership requirement. A Microsoft Teams team is not a Dataverse team type and is not what owns Dataverse records. An access team does not own records and has no security roles assigned to it; records are shared with the team and its members get access rights such as Read, Write and Append on those records, so it provides permissions without a security role being assigned to the team.
A company has locations in the United States, Brazil, India, and Japan. The company conducts financial transactions in all of these regions.
Financial transactions in Brazil are going to stop, but the office will remain open.
Users must no longer be able to create records associated with the Brazilian currency. Historical records must remain intact.
You need to configure Microsoft Dataverse to meet the requirement
What should you do?
- A. Disable the Brazilian language pack.
- B. Rename the Brazilian currency.
- C. Delete the Brazilian currency record.
- D. Deactivate the Brazilian currency record. Correct
Explanation
Deactivating the Brazilian currency record prevents users from creating new records associated with this currency while preserving historical data. Deleting or renaming the currency is not advisable as it could disrupt existing records, and disabling a language pack does not affect currency usage.
You are setting up Power Apps security for a company. The company has a CEO, two vice presidents, and 10 managers. Five support representatives report to each manager.
You set up Manager Hierarchy so managers are able to view data only for the representatives who report to them. The CEO must be able to view all data for everyone. All support representatives must be able to view customer information in each other's data across all managers.
You need to resolve issues that arise during testing.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Manager hierarchy security grants access through the Manager field on each user record, so when managers cannot see their reports' data, add the manager's name to each representative's user record. The CEO sits three levels above the representatives (CEO, vice president, manager, representative); if the hierarchy depth is lower than that, the CEO sees manager data but not representative data, so set the Manager Hierarchy depth to 3. The manager hierarchy only gives access upward along the reporting chain, so representatives under different managers cannot see each other's data through it; adding manager names or field security does not grant record access, so set up a position hierarchy, which is defined independently of the reporting structure, to give the representatives the required access.
You are embedding a Power Apps visual in a Power BI dashboard.
External customers must authenticate to have access to the dashboard.
You need to configure the solution.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Set the Power BI service to authenticate users. Correct
- B. Use a table in the Power BI dashboard.
- C. Publish to Power BI Report Server.
- D. Set the Power BI service to allow anonymous access.
- E. Share the Power Apps visual components with external users. Correct
Explanation
To ensure external customers can authenticate to access the dashboard with an embedded Power Apps visual, you must set the Power BI service to authenticate users (Option A). Additionally, sharing the Power Apps visual components with external users (Option E) is necessary for them to view and interact with these visuals.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. Advanced Find
- B. Entities component of a solution Correct
- C. Microsoft Excel template
- D. System Settings
Explanation
The 'Entities component of a solution' allows for the creation of views that can be included in solutions and made available to all users within an organization, adhering to the restriction against custom code.
You are designing the organization structure for a company that has 5,000 users.
You need to configure security roles for the company while minimizing administrative effort.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Apply a security role to everyone in a business unit.: Assign the security role to the default business unit team. — Dataverse automatically creates a default (owner) team for every business unit, and every user in that business unit is automatically a member of it, with membership maintained by the platform as users are added, moved, or removed. Assigning the role to that default team therefore grants it to all 5,000 users with no ongoing maintenance, whereas assigning the role individually to each user would mean thousands of manual assignments, and creating a new team and adding the business unit users would require you to keep that team's membership in sync by hand.
Ensure an individual can see records in their current business unit and a child business unit.: Grant the user the Parent: Child Business Units security permission. — In a security role, each privilege has an access level, and the Parent: Child Business Units level extends access from the user's own business unit down to all of its child (subordinate) business units, which is exactly the scope required. Granting a security role from the child business unit would not extend the user's access upward or across in the hierarchy in the way needed here, and a role from the root business unit is not the mechanism that controls scope — the access level on the privilege is; a root-level Organization-scoped role would also over-grant by exposing records across the entire organization.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses Dataverse.
The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.
You need to recommend a solution.
Solution: Configure SharePoint on-premises integration.
Does the solution meet the goal?
Explanation
The goal is to keep documents out of Dataverse storage with as little overhead as possible for an environment that uses Dataverse. The recommended way is server-based SharePoint Online integration, where documents live in SharePoint document libraries and Dataverse keeps only the document location records. Server-based integration with SharePoint on-premises is documented only for Dynamics 365 customer engagement apps and needs a hybrid setup (SharePoint 2016 SP1 or later reachable from the internet over SSL, a SharePoint Online license, realm and token-issuer changes on the farm), so it is not the solution to recommend here.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
On a Contact record, a user creates a Note record that contains the word running.
One week later, the user reports that they cannot find the Contact record associated with the Note record.
You need to find the Note record.
Solution: Use Dataverse Search to search for the word run.
Does the solution meet the goal?
Explanation
Dataverse Search is the updated term for what was previously known as Relevance Search in Microsoft Power Platform. Since Dataverse Search supports searching with keywords, using it to search for 'run' would effectively locate Note records containing the word 'running'.
You are using the Data import wizard to import records into the account table from a CSV file.
The CSV-to-table mapping is as follows:
✑ The Name column represents the account name and maps to the Account Name column.
✑ The Parent Name column represents the holding company of the account with subsidiaries underneath.
Records that are imported into the table are only related to other records in the file.
You need to configure the import to create the relationship between records.
What should you do?
- A. Map Parent Name in the CSV file to the Parent Account column. Select Account Name as the lookup criteria. Correct
- B. Map Parent Name in the file to the Parent Account column. Select Parent Account as the lookup criteria.
- C. Create an alternate key on the account table by using the Account Name column. Do not map Parent Name in the file.
- D. Look up the record IDs of the records in the Parent Account column. Add the record IDs as a new column in the file. Map the new column to the Parent Account column.
Explanation
Option A is correct. In the import wizard, map the CSV Parent Name column to the Parent Account lookup column, and set Account Name as the lookup reference. The wizard then resolves each parent by matching the name to account records, including records created in the same import. Option B uses Parent Account as the lookup criteria, so it would try to match the parent's own parent field rather than the account name. Option C leaves Parent Name unmapped, so no relationship is created; an alternate key alone does not set the lookup. Option D is impossible because the related records exist only in the file, so they have no record IDs before the import.
A company has a sales application that is supported by an Azure SQL database. You are developing a Power Apps app for use by customer service agents.
The app must reference customer data from the sales application. Data in the sales application is constantly changing and must not be replicated in Microsoft
Dataverse.
Some customer data is considered sensitive. You must protect data for specific fields when users view data in the app.
You need to configure table creation for the app.
How should you configure the app? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Dataverse table type to create for the referenced customer data.: Create a virtual table. — A virtual table surfaces data that physically remains in the external source (here, the Azure SQL database) by reading it live through a virtual connector or provider at runtime, so nothing is copied or replicated into Dataverse and the constantly changing sales data is always current in the app. The other choices — an activity table, a user-owned table, or an organization-owned table — are all standard Dataverse tables whose rows are stored in Dataverse itself, which would require importing or syncing the customer records and therefore violates the no-replication requirement.
Protect sensitive customer data for specific fields.: Create a secured column. — Column-level security (field security) lets you mark specific columns as secured and then grant Read, Update, and Create access only to the users or teams added to a column security profile, so agents without the profile cannot see the sensitive values even though they have access to the row. An alternate key only provides an alternative unique identifier for records, IME mode merely controls East Asian input behavior in a text control, and setting a field's Visible property to false only hides it in one form or app — the data is still returned and reachable through other views, exports, or the API, so it is not a security control.
A customer uses Power Apps to view and maintain their contacts that are stored in Microsoft Dataverse.
Several columns must be configured to ensure the security settings for sales associates are view only.
You need to configure the access restrictions.
Which component for field-level security should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Enable the fields for record-level security: Power Apps app designer. Column (field) security is a property of the Dataverse column. You turn it on in Power Apps (make.powerapps.com): open the table, select the column, expand Advanced options, select Enable column security, and save. The Power Platform admin center is where the column security profiles are managed, not where a column is enabled. Azure SQL and Azure Data Lake Gen2 are external storage services and play no part in Dataverse column security.
Set the security settings for the sales associates to view only: Field Security Profiles. In a field (column) security profile you set the Read, Update and Create permissions for each secured column. To make the columns view only, set Read to Allowed and Update and Create to Not Allowed, then add the sales associates (users or teams) to the profile. A user or an Azure Active Directory group team is what you assign to the profile, not where the permissions are defined. A Dataverse table carries table-level privileges through security roles, not per-column permissions.
You modify a model-driven app for a bicycle repair help desk. The model-driven app is for help desk users when customers have an issue with their bicycle.
After you add a custom table named bicycle, you configure the table for Microsoft Dataverse search. The table will contain information from callers about their bicycles. The account table is related to the custom table. Contact information is brought over to the custom table.
You add the following columns to the table:
✑ Bicycle type
✑ Tire brand
✑ Special equipment
Users must be able to perform the following types of searches:
✑ Search for all customers who have a bicycle type of Contoso and live in Florida.
✑ Search all tables for any record that contains the word broken.
You need to decide which type of search will give you the results desired.
Which search should you configure? To answer, drag the appropriate search types to the correct requirements. Each search type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Advanced find allows setting multiple criteria, such as searching for specific values in different fields (e.g., bicycle type and location). Dataverse search is suitable for keyword-based searches across all tables to find records containing a particular term like 'broken'.
You make the following customizations to a Microsoft Dataverse environment:
• Create a new table.
• Add data to the new table.
• Delete an unused area from the site map.
The components must be transported to a different environment.
You need to determine the method required to transport each component.
Which method should you use? To answer, drag the appropriate methods to the correct components. Each method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Explanation
The 'Solution' method is used to transport components like tables and site maps because they are part of the solution structure in Microsoft Dataverse. The 'Configuration Migration tool' is specifically designed to handle data migration, making it suitable for transporting data within a new table.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. System Settings
- B. Microsoft Excel template
- C. Microsoft Visual Studio
- D. Table component of a solution Correct
Explanation
The Table component of a solution is the appropriate place to create a view accessible by all users when custom coding is not allowed. This option aligns with organizational restrictions on custom code while still enabling the creation and sharing of views.
A company plans to add another language to a Microsoft Dataverse environment.
Several components were added or modified in the environment.
You need to ensure that these components get translated.
Which method should you use? To answer, drag the appropriate methods to the correct component types. Each method may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
View: Export and re-import translated text. View names and other localizable metadata of tables, columns, forms and views are translated by exporting the translations from the solution, entering the text for the added language in the exported file, and importing the translations back.
Email template: Create a separate version for each language. The content of an email template is data, not localizable metadata, so it is not included in exported translations; you create a template for each language.
Report: Create a separate version for each language. Report content is not translated by the translation export either, so you create a separate report for each language.
Use embedded labels is not used: it is not a method for translating these components.
A company uses Power Apps.
Users must be able to view only the address1 columns in the Account table.
You need to ensure other address columns are not visible to users when creating views and filters.
What should you do?
- A. Delete the other address columns from the table.
- B. Disable the Search option for the columns. Correct
- C. Use column-level security to remove read access to all users.
- D. Create business rules to hide the other address columns.
Explanation
Every Dataverse column has a Searchable property. When a column is searchable, it appears in Advanced Find and is available when users build or customize views and filters. If you clear Searchable on the other address columns, they stop appearing in the view and filter column pickers, and the address1 columns stay available. Column-level security controls who can read or update a column's values, but a secured column still shows up as a column when users build views, so it does not meet the requirement. Deleting columns is destructive and is not possible for system address columns. Business rules only show or hide columns on forms, not in the view or filter designers.
A company uses Power Apps.
You create a custom table and configure a child table relationship with the contact table.
You need to configure the cascading rules for each action.
Which behavior should you use? To answer, drag the appropriate behaviors to the correct actions. Each behavior may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
The 'Restrict' behavior prevents deletion of a custom table record if related records exist in the contact table, ensuring data integrity. The 'Cascade All' behavior ensures that sharing actions on the custom table are applied to all related records in the contact table.
You plan to add a Power Apps app to Microsoft Teams.
A Microsoft Dataverse for Teams environment has not been provisioned.
You need to create a Dataverse for Teams environment.
Which two actions can you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Create a new app in Teams. Correct
- B. Install an existing app in Teams. Correct
- C. Create a new environment in the Microsoft Power Platform Admin Center.
- D. Create an app permission policy in the Teams admin center.
Explanation
A Dataverse for Teams environment is created automatically for a team when someone creates an app in Teams for the first time (A). It is also created when someone installs an existing app built with Power Apps, such as a sample app from the Teams app catalog, for the first time (B). These environments can be created only through Microsoft Teams. The Power Platform admin center can view, back up, delete or upgrade them, but it cannot create one (C). An app permission policy in the Teams admin center only controls which apps users can use; it does not provision an environment (D).
A company uses Power Apps with Microsoft Dataverse.
The company enables auditing on the Dataverse database. The company tenant reaches the maximum storage capacity.
You need to delete some auditing data.
Which three deletion options should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. by record Correct
- B. between two specified dates
- C. by table Correct
- D. older than a specified date Correct
- E. by column
Explanation
Dataverse lets administrators delete audit data in these ways. By table: select one or more tables and delete their audit logs. Older than a specified date: delete all logs up to and including a selected date. By record: delete a single record's entire change history from its Audit History tab or from the Audit Summary view (Delete Change History). You can also delete all access logs. There is no option to delete logs between two specified dates, because the date option always deletes everything up to the chosen date. There is no option to delete audit logs for a single column.
A company uses a Power Apps app with Microsoft Dataverse.
The company requires the import of records into Dataverse. Duplicate records in the data must be deleted without user intervention.
You create a duplicate detection rule.
You need to configure the rule for the data import.
Which option should you configure?
- A. Enable the During data import option. Correct
- B. Enable the Templates for Data Import option.
- C. Disable the Allow Duplicates option.
- D. Enable the When a record is created or updated option.
Explanation
Duplicate detection rules only define what counts as a duplicate; when detection runs is controlled by the environment's duplicate detection settings, which include When a record is created or updated, When Microsoft Dynamics 365 for Outlook goes from offline to online, and During data import. Enabling During data import makes the import process apply the published rules, so records that match an existing record are flagged and kept out of Dataverse automatically, with no user decision needed. Templates for Data Import only provide column layouts for import files, Allow Duplicates is a choice made during an individual import, and When a record is created or updated applies to manual creates and updates in the app, not to imports.
A company has a model-driven app that uses Microsoft Dataverse.
Users need to add an alternate phone number when entering their account information. The users also require a list that displays the customers that do not have an alternate phone number.
You need to enable the required features.
Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
Explanation
A column is required to add an alternate phone number field in the account information form. A view can be configured to display a list of customers who do not have an alternate phone number.
You create a model-driven app for an automobile parts help desk.
A help desk agent uses a form to gather information about customers’ automobiles in two custom tables. The names of the tables are Client and Automobile.
The form must prepopulate the following information about the customer from the client table:
• First name
• Last name
The agent must be able to type the following information about the automobile:
• Automobile make
• Automobile model
You need to implement the form.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Prepopulate client information: Relationship — Creating a one-to-many relationship between the Client table and the Automobile table lets Dataverse carry the related client record onto the form, and mapped fields on that relationship automatically prepopulate First name and Last name when a new automobile record is created from the client. An Alternate key only provides an additional unique identifier for record lookup and integration, and a Virtual table surfaces data that physically lives in an external system, so neither one copies client values into the form.
Enter automobile information: Table — The automobile make and model must be typed and stored as Dataverse data, so you configure the custom Automobile table with columns for make and model and place them on the form for the agent to fill in. A View only defines how existing rows are listed and filtered, so it cannot be used to capture new input.
A company uses Power Apps. You enable auditing in Microsoft Dataverse.
Users report the following issues when viewing the audit logs:
• Unable to view the read access audit logs.
• Unable to view the Account table audit logs.
You need to troubleshoot the issues.
What are the causes of the issues? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Unable to view the read access audit logs: Auditing is not enabled at the environment level. Read-access logging (Log access and Read logs) is configured in the environment's auditing settings in the Power Platform admin center and only works when auditing is started for the environment, so read access entries are written only after auditing is turned on at that level. Storage over capacity affects creating and copying environments, not whether existing audit entries can be viewed.
Unable to view the Account table audit logs: Auditing is disabled at the table level. Even with environment auditing on, each table must have auditing enabled in its properties before changes to its rows are recorded, so an Account table with auditing off has no audit history. There is no app-level auditing setting in Dataverse, and read-access auditing does not control whether a table's change history is recorded.
A company is implementing a data model by using Dataverse.
The company requires the following columns in a new custom table:
You need to choose the column type that uses the least amount of database storage for each column.
Which column types should you choose? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
| Column name | Requirement |
|---|---|
| Special Notes | Must contain string data that stores 100 characters and be rendered as a multiline control. |
| Specification | Must contain string data that stores up to 8,000 characters and be rendered as a multiline control. |
| Student | Must contain an input control that can store a reference to an account or a contact in the system. |
| Course Type | Must contain a list of predefined options. Users must be able to select only one option. |
Explanation
Special Notes: Text Area — Text Area is a format of the Single Line of Text column type, so it is stored as an nvarchar column sized to the maximum length you set (default 100, up to 4,000 characters) while still giving users a multi-row editing box in the form. Multiline Text is the Multiple Lines of Text (memo) type, which reserves storage for a far larger value, so for a notes column that only needs a few lines Text Area is the cheaper choice; plain Text would store the same amount but does not provide the multi-row entry experience the column calls for.
Specification: Multiline Text — a specification can exceed the 4,000-character ceiling of Single Line of Text, and Multiple Lines of Text supports up to 1,048,576 characters, so it is the only type here that can hold the value at all. Text and Text Area are both Single Line of Text under the covers and cap out at 4,000 characters, so neither can be used regardless of storage efficiency.
Student: Customer — the Customer data type is a single polymorphic lookup that can point at either an Account or a Contact record, so one column covers both cases. Using Lookup would require two separate lookup columns (one to Account, one to Contact) to get the same coverage, which consumes more storage than the single Customer column.
Course Type: Choice — a Choice (option set) stores one selected value as a single integer in the column, which is the smallest footprint of the available options. Choices is the multi-select option set, which stores a delimited string of multiple integer values and therefore uses more space, and a Lookup would require a separate related table plus a GUID reference just to hold a fixed list of course types.
A company plans to implement a model-driven app. The company will enter data through the app.
The company has the following requirements:
• Users must be able to search for the data inside the app.
• Users must be able to search for the data outside the app.
You need to configure a solution for each requirement.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Search data inside the app.: Quick Find Search — Quick Find is the built-in search box on a model-driven app grid, and it runs the table's Quick Find view against the columns configured as "Find columns" for that table, so users searching from within the app get results scoped to the app's own data. Categorized Search is only a presentation mode of in-app search rather than the feature you configure for it, and Microsoft Search is a Microsoft 365 experience that lives outside the model-driven app.
Search data outside the app.: Dataverse Search — Dataverse search (formerly relevance search) builds an external Azure Cognitive Search index over the tables and columns you select, and that index is what exposes Dataverse rows to consumers outside the model-driven app, including the Microsoft 365 search connector and other client experiences. Content Search is a Microsoft Purview eDiscovery tool for Exchange/SharePoint content, not Dataverse rows, so it does not satisfy the requirement.
A company is implementing Microsoft Power Platform solutions.
The company requests information on the features that are supported by Power Fx.
You need to identify the features of Power Fx.
What should you identify?
- A. It uses an undefined value for uninitialized variables.
- B. It uses formulas that are similar to Microsoft Excel formulas. Correct
- C. It uses synchronous data operations.
- D. It uses the model-driven app formula language.
Explanation
Power Fx uses formulas that are similar to Microsoft Excel formulas, making it accessible for users familiar with Excel. This similarity aids in the ease of use and adoption within environments where Excel is commonly used.
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.
You need to identify the capabilities of virtual tables.
What is a capability of virtual tables?
- A. Virtual tables store data in the Dataverse environment.
- B. Virtual tables retrieve data from an external data source. Correct
- C. Virtual tables can be configured for user and team ownership.
- D. Virtual tables support Dataverse auditing.
Explanation
Virtual tables in Dataverse do not store data but instead retrieve it from external data sources. This capability allows for integration with various systems without the need to replicate data within Dataverse.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
• Name
• Company
• Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create an alternate key for the columns.
Does the solution meet the goal?
Explanation
An alternate key defined on the Name, Company and Contacted On columns makes Dataverse create a unique index on that combination. Once the key is active, the platform rejects any create or update that would produce a second row with the same values in those columns, whether the data comes from a canvas app, a model-driven app or an integration. Single line of text and Date and Time columns are both supported for alternate keys. Unlike duplicate detection rules, which only warn users and can be bypassed, an alternate key enforces uniqueness, so the solution meets the goal. Rows with blank (null) key values are not checked, so the key columns should be filled in.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
• Name
• Company
• Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create a Microsoft Power Fx formula for the columns.
Does the solution meet the goal?
Explanation
Creating a Microsoft Power Fx formula for the columns does not prevent duplicate rows in a Dataverse table. Power Fx formulas are used for calculations and validations at the UI level, but do not enforce uniqueness constraints on data at the database level.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
• Name
• Company
• Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create a duplicate detection rule for the columns.
Does the solution meet the goal?
Explanation
A duplicate detection rule in Dataverse can identify duplicates based on multiple columns but does not prevent the creation of those records. To enforce uniqueness and prevent duplication, an alternate key must be used instead.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a Dataverse environment. The environment is accessed from canvas and model-driven apps.
The Dataverse environment contains a table that has the following columns:
• Name
• Company
• Contacted On
The company requires that the table not contain any duplicate rows when users create data in the environment.
You need to implement a solution that meets the requirement.
Solution: Create a business rule for the columns.
Does the solution meet the goal?
Explanation
A business rule evaluates conditions and actions on the values of the current row only (whether scoped to a form or to the table), so it cannot look at other rows to check whether the same Name, Company and Contacted On values already exist. It therefore cannot prevent duplicate rows from being created from both canvas and model-driven apps. Uniqueness across a set of columns is enforced with an alternate key defined on those columns, which Dataverse checks on every create or update regardless of the app used. The solution does not meet the goal.
You must create a new table to support a new feature for an app. Records for the table must be associated with a business unit and specify security roles for the business unit.
You need to configure table ownership.
Which table ownership type should you use?
- A. user or team owned Correct
- B. business-owned
- C. none
- D. organization-owned
Explanation
The 'User or Team owned' table ownership type allows records to be associated with specific users or teams and enables the specification of security roles for business units, aligning with the requirement to associate records with a business unit and specify security roles.
A company uses Power Apps.
You create a custom phone table that is a child of the contact table.
You need to configure the cascading rules for each action.
Which behavior should you use? To answer, drag the appropriate behaviors to the correct actions. Each behavior may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Prevent the contact record from being deleted if associated with a phone record: Restrict. Setting the Delete behavior of the relationship to Restrict blocks deletion of the parent contact while any related phone rows exist.
Update the owner of the phone records when the contact owner changes: Cascade All. Setting the Assign behavior to Cascade All reassigns all related phone rows to the new owner whenever the contact is assigned. Cascade None would leave the phone rows with their old owner.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. System Settings
- B. Advanced Find
- C. Table component of a solution Correct
- D. Microsoft Excel template
Explanation
The view can be created within the table component of a solution in Dataverse without using custom code. This approach ensures compliance with organizational policies and allows all users to access the view.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. Templates area
- B. System Settings
- C. List view of the table
- D. Table component of a solution Correct
Explanation
The view can be created within the table component of a solution in Dataverse without using custom code. This approach ensures that all users in the organization can access and view it, complying with organizational policies.
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.
You need to identify the capabilities of virtual tables.
What is a capability of virtual tables?
- A. Virtual tables can be configured for user and team ownership.
- B. Virtual tables support Dataverse auditing.
- C. Virtual tables contain columns for Status, Created On, and Modified On by default.
- D. Virtual tables require configuration of a data provider. Correct
Explanation
Virtual tables in Dataverse require a data provider to be configured for connecting and retrieving data from external systems. This configuration is essential for the virtual table to function properly.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses Dataverse.
The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.
You need to recommend a solution.
Solution: Enable attachments for a table.
Does the solution meet the goal?
Explanation
Enabling attachments for a table in Dataverse increases storage consumption as the attachments are stored within the Dataverse environment. To minimize storage usage, integrating with SharePoint to manage documents externally is more effective.
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.
You need to identify the capabilities of virtual tables.
What is a capability of virtual tables?
- A. Virtual tables support change tracking.
- B. Virtual tables retrieve data from an external data source. Correct
- C. Virtual tables can be configured for user and team ownership.
- D. Virtual tables support Dataverse auditing.
Explanation
Virtual tables in Dataverse are designed to retrieve data from an external data source, allowing for real-time integration and access without the need to store that data within Dataverse itself.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. Advanced Find
- B. Studio System Settings
- C. Templates area
- D. Maker portal Correct
Explanation
The Maker portal allows non-developers to create custom views and solutions without writing any code. Since the organization does not permit the use of custom code, the Maker portal is the appropriate place to create a view accessible by all users.
A company is using Dataverse with a model-driven app. The app includes a table named Quotations.
Users in the system enter relevant details, such as customer, address, line items, and total amounts. The users then create a standardized report to manually populate the details.
The company requires the formatted report to be generated from the record and populated with the record details. The company does not want to purchase additional licenses.
You need to recommend a solution.
Which solution should you recommend?
- A. a Word template Correct
- B. an Excel template
- C. an article template
Explanation
A Word template is the most suitable solution for generating a formatted report from Dataverse records without requiring additional licenses. This approach allows for the dynamic population of record details directly into a standardized document format, fulfilling the company's requirement efficiently.
Your organization does not permit the use of custom code for solutions.
You need to create a view that can be viewed by all users in an organization.
Where should you create the view?
- A. Templates area
- B. Microsoft Excel template
- C. Advanced Find
- D. Table component of a solution Correct
Explanation
The Table component of a solution is the correct place to create a view that can be accessed by all users in an organization when custom code is not allowed. This option aligns with Microsoft's guidelines for creating accessible and compliant views within organizational constraints.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses Dataverse.
The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.
You need to recommend a solution.
Solution: Configure SharePoint Online integration.
Does the solution meet the goal?
Explanation
Configuring SharePoint Online integration meets the goal of minimizing Dataverse storage consumption because it allows storing documents and data in SharePoint instead of within Dataverse, thereby reducing the amount of storage used by Dataverse.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses Dataverse.
The company plans to store and manage documents and data in the environment. The company requires a solution that minimizes Dataverse storage consumption.
You need to recommend a solution.
Solution: Add a File column to a table.
Does the solution meet the goal?
Explanation
Adding a File column to a table in Dataverse stores the files directly within Dataverse, which increases storage consumption. To minimize Dataverse storage usage, storing documents externally and linking them via URL is more appropriate.
You are configuring Dataverse for a company.
The company has the following requirements for document management, which must be met by using native functionality:
• A single file must be stored and accessed directly from an Account row. No additional metadata should be captured.
• Multiple files must be stored and accessed from a Contact with support for version control.
• Documents must be stored within an on-premises environment.
• Additional rich-text notes must be stored alongside one or multiple file uploads.
You need to recommend a solution for each requirement.
Which solution should you recommend? To answer, move the appropriate solutions to the correct requirements. You may use each solution once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Save a file on an Account row: Document column. A file (document) column stores one file directly on the row and captures no extra metadata, which matches a single file on the Account with nothing else recorded.
Store multiple files by using version control: Microsoft SharePoint. SharePoint document management stores many files in a document library folder linked to the Contact, and from the record's Documents grid users can check documents in and out while the library keeps version history. Azure Blob Storage is not a native Dataverse document management option.
Host documents on premises: Microsoft SharePoint. Dataverse document management supports SharePoint on-premises through server-based authentication, so documents can stay in the company's own environment.
Upload documents that have rich-text metadata: Attachments. Notes in the timeline hold rich-text note content together with attached files, so each upload carries its own rich-text description.
A company is evaluating the capabilities in Dataverse and the scenarios for using virtual tables.
You need to identify the capabilities of virtual tables.
What is a capability of virtual tables?
- A. Virtual tables store data in the Dataverse environment.
- B. Virtual tables contain time dimension attributes by default.
- C. Virtual tables support change tracking.
- D. Virtual tables retrieve data from an external data source. Correct
Explanation
Virtual tables in Dataverse do not store data within the Dataverse environment but instead retrieve data from an external data source. This capability allows for real-time access to external data without the need for replication or synchronization.
You create an app to manage customer service cases.
Cases entered in forms require different types of data to be stored in different types of columns.
You need to create forms for each of the following case types:
| Case type | Requirement |
|---|---|
| Case type A | A new case form that includes a timeline |
| Case type B | A new case form that includes a business process flow |
| Case type C | A new case form that can display case data on an interactive dashboard |
| Case type D | A new mobile-friendly case form that requires minimal fields for record creation |
| Case type E | A new mobile-friendly case form that displays the subject, case title, and status fields from a parent case |
Which form types should you create? To answer, drag the appropriate form types to meet the data entry requirements. Each source may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Case type A: main. The timeline control is added to main forms, which provide the full record view. Case type B: main. Business process flows are displayed at the top of main forms; other form types do not show them. Case type C: card. Card forms are compact forms used to show record data in interactive dashboard streams and views. Case type D: quick create. Quick create forms open as a short flyout or mobile pane containing only the essential columns needed to create a record. Case type E: quick view. A quick view form is embedded in another form through a lookup and displays read-only columns, such as subject, case title and status, from the related parent case.
You are a Dynamics 365 Customer Service developer.
A salesperson creates a chart.
You need to ensure that the chart is available to all users on the team.
Which actions should the salesperson perform? To answer, drag the appropriate actions to the correct users. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Step 1: Export the user chart for import as a user chart. A chart the salesperson creates is a personal (user) chart. Exporting it as a user chart keeps it as a personal chart that the salesperson owns and controls, rather than turning it into a system chart, which would need customizer privileges and would be published to the whole organization.
Step 2: Share the chart with the team. Personal charts are visible only to their owner until they are shared. Sharing the chart with the team gives every team member access in one action. Assigning the chart would change its owner rather than give the team access, and exporting to Power BI is not needed to make a model-driven app chart available.
You implement an editable grid for the Account entity.
The business team provides the following list of features that they would like you to implement:
✑ Group by or sort columns in the current view.
✑ Configure a business rule to show an error message.
✑ Edit values in calculated fields.
✑ Edit the Address composite field.
✑ Use the editable grid on mobile phones.
Which actions can you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Statement 1 (Yes): Editable grids in model-driven Power Apps let users group by and sort on any sortable column directly in the current view, without leaving the grid or opening records. Sorting and grouping are built-in interactive capabilities of the Editable Grid control, so the business team's request is supported out of the box.
Statement 2 (Yes): Editable grids honor business rules with the entity (table) scope, including the "Show error message" action, so validation fires as a user edits a cell inline and blocks an invalid save. Business rule actions such as showing an error message, setting field values, and setting business required are all supported inside the editable grid experience.
Statement 3 (No): Calculated fields are computed by the platform from a formula rather than stored as user-entered data, so they are always read-only wherever they appear, including in an editable grid. Users can see the calculated value in the grid but cannot type over it; changing the result requires changing the source fields the formula reads.
Statement 4 (No): Composite fields such as the Address composite on the Account table are not editable in an editable grid, because a composite field is a rollup of several underlying columns (street, city, postal code, and so on) surfaced as a single display field. To change an address, the user must open the record's form and edit the individual address columns, or add those constituent columns to the view instead of the composite.
Statement 5 (No): Editable grids are not available in the phone experience of the mobile app; on phones the grid falls back to a read-only list, and users must open a record to make changes. Editable grid functionality is limited to the web client and tablets, so the requirement to edit inline on phones cannot be met.
You must create a form for team members to use. The form must provide the ability to:
✑ Lock a field on a form.
✑ Trigger business logic based on a field value.
✑ Use existing business information to enhance data entry.
You need to implement business rule components to create the form.
Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
Business rules are built from conditions, actions and recommendations. Locking or unlocking a form field is an action (Lock/Unlock). Running business logic only when a field has a certain value is done with a condition, which decides which actions run. Using existing business information to help users enter data is done with a recommendation, which suggests a value that the user can accept to fill the field.
You have a form that displays a custom field from an entity.
A customer wants to restrict users from filtering on the custom field.
You need to prevent users from filtering the field in Advanced Find.
What should you modify?
- A. Fields in the Edit Filter Criteria option of the Quick Find view
- B. a searchable field on the Field Properties form Correct
- C. Fields in the Add Find Columns option of the Quick Find view
Explanation
To prevent users from filtering on a custom field in Advanced Find, you should modify the 'searchable' property of the field to 'false' on the Field Properties form. This setting directly controls whether a field can be used for filtering in search views.
You are designing a canvas app that connects to Common Data Service.
You need to configure the app to meet the requirements and ensure that the canvas app is available offline.
What should you implement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Pass values from the current screen when moving to another screen.: Navigate. Navigate takes an optional context record as its third argument, for example Navigate(DetailScreen, ScreenTransition.Fade, {SelectedItem: Gallery1.Selected}), and the destination screen gets those values as context variables. Back only returns to the previous screen and cannot pass values. MovePrevious is not a Power Fx screen navigation function.
Display data to a user when the app is offline.: LoadData. While the app is online, SaveData stores a collection in the device's local storage. When the device is offline, LoadData reloads that collection so galleries and forms still have records to show. LoadDataOffline and ShowDataOffline are not Power Fx functions; the functions for offline storage are SaveData, LoadData and ClearData.
You have a canvas app that allows users to view, select, and purchase products. The app uses a Gallery control to display products and checkboxes that allow users to select products.
When users select items from the product catalog, they move to a different screen to complete a purchase.
Users must be able to clear all product selections when they click the button.
You need to configure the button.
What should you do?
- A. Use the Reset(Control) formula and pass the gallery control as a parameter to the Reset formula.
- B. Use the Reload(Control) formula and pass the gallery control as a parameter to the Reload formula.
- C. Use the ForAll() function to iterate through each item of the Gallery and clear user selections.
- D. Set the OnCheck value to populate a collection and the OnUncheck value to remove the item from the collection. Clear collection when the user selects the button. Correct
Explanation
Option D is correct because it involves using the OnCheck and OnUncheck properties of checkboxes to manage a collection that tracks selected products. Clearing this collection when the button is clicked effectively resets all product selections.
You have a canvas app that contains the following text input fields: Id, FirstName, LastName. The app also has a button named Button1.
The OnSelect property for Button1 contains the following expression:
Collect(People, {Id:Id.Text, FirstName:FirstName.Text, LastName:LastName.Text})
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Statement 1 (Yes): If the data source passed to Collect does not already exist, Collect creates it as a collection. Statement 2 (No): Collect always adds a new record and never matches or updates an existing one, so pressing Button1 again with the same Id creates a duplicate record. To update an existing record you would use Patch or UpdateIf. Statement 3 (No): When Collect is used with a collection, it creates new columns as needed, so adding an Age field to the record adds an Age column instead of causing an error.
You are a Dynamics 365 Customer Service administrator.
A user must be able to view system posts and activities in a dashboard.
You need to create the dashboard for the user.
Which components should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Display system posts: Timeline — The Timeline control is the Dataverse/Dynamics 365 component that aggregates and renders the post feed for a record, including auto-generated system posts (created by workflows and record events) alongside user posts, notes, and activities, so adding a Timeline to the dashboard is what surfaces system posts to the user. IFrame only embeds external web content and Organization Insights reports on aggregate usage telemetry, so neither can display the post feed.
Display activities: Lists — On a Dynamics 365 dashboard, a list (a view-based grid component) is what you add to show activity records, pointing it at the Activity table and a view such as My Activities so the user sees tasks, phone calls, emails, and appointments. Relationship Insights and Social Insights surface derived engagement or social-listening analytics rather than the underlying activity records themselves.
You are building a model-driven app. The environment has Advanced settings enabled.
A form in the app requires a custom interface.
You need to embed the custom interface onto the form without using custom code.
What should you do?
- A. Create a canvas app and bind its properties to the form. Correct
- B. Modify the model-driven app to use tablet form factor.
- C. Use an IFRAME.
- D. Create a quick view form.
Explanation
Embed a canvas app on the form. Canvas apps are built in the low-code Power Apps Studio, and an embedded canvas app is added to a model-driven form like any other control. It receives the current record from the host form through ModelDrivenFormIntegration, so its properties are bound to the form's data and a custom interface appears on the form without custom code. In the modern app designer, a custom page fills the same role. An IFRAME only shows an existing web page, so the custom interface would have to be built as separate web code. A tablet form factor changes how the app is laid out on tablets and adds no interface. A quick view form shows read-only data from a related record and cannot provide a custom interface.
A company is implementing Power Apps and Power Automate.
Several components are created within Power Apps, Microsoft Dataverse, and Power Automate. These components must be promoted from the development environment to the user acceptance test environment in a single solution package.
You need to create the solution package for promotion.
Where should you create the package?
- A. Azure DevOps
- B. Power Apps designer Correct
- C. Microsoft Power Platform admin center
- D. Azure portal
- E. Office 365 admin center
Explanation
A solution is created in Power Apps: sign in to make.powerapps.com, select Solutions, then New solution. You add the Power Apps, Dataverse and Power Automate components to it and export it as one package to import into the user acceptance test environment. Azure DevOps can automate exporting and deploying solutions, but the solution itself is created in Power Apps. The admin centers and the Azure portal do not create solutions.
A company is creating a Power Apps solution for a production facility.
The current solution is in English. The customized components must be translated into several languages.
You need to extract the text for translation.
In which location can you achieve this goal?
- A. The tables in the web application.
- B. The selected environment in the Microsoft Power Platform admin center.
- C. The solution in the web application. Correct
- D. The individual solution components in the web application.
Explanation
The solution in the web application is where text for translation can be extracted. This allows for managing and translating customized components efficiently across multiple languages within Power Apps.
You have a canvas app that allows users to view, select, and purchase products. The app uses a Gallery control to display products and checkboxes that allow users to select products.
When users select items from the product catalog, they move to a different screen to complete a purchase.
Users must be able to clear all product selections when they click the button.
You need to configure the button.
What should you do?
- A. Use the Reload(Control) formula and pass the gallery control as parameter to the Reload formula.
- B. Use the Reset(control) formula and pass the checkbox to the formula to clear user selections.
- C. Set the OnCheck value to populate a collection and the OnUncheck value to remove the item from the collection. Clear the collection when the user selects the button. Correct
- D. Use the Revert(Products) formula and pass the checkbox to the formula to clear user selections.
- E. Use the Reset(Control) formula and pass the gallery control as a parameter to the Reset formula.
Explanation
Track the selections in a collection: the checkbox OnCheck adds the gallery item to the collection, OnUncheck removes it, and the checkbox Default checks whether the item is in the collection. The button then clears the collection with Clear, and every checkbox returns to unchecked because its Default no longer finds the item. The collection also gives the purchase screen the list of selected products. Reset cannot clear the checkboxes from the button: Microsoft documents that controls inside a Gallery cannot be reset from outside the gallery, so neither Reset on the checkbox nor Reset on the gallery clears the selections. Reload is not a Power Fx function, and Revert refreshes a data source and discards errors; it does not reset control values.
A customer tracks events by using a custom entity.
The custom entity includes a custom field for the venue of the events. The customer must be able to display the events by venue in a calendar.
You need to ensure that all events display by venue in the calendar.
To which component should you add a control?
- A. Form
- B. Subgrid
- C. Chart
- D. View Correct
Explanation
The 'View' component is used to display records in a list or grid format and can be configured to show data based on specific criteria, such as venue. Adding the necessary configuration within a view allows events to be displayed by venue in a calendar format.
You are creating a canvas app.
A user will click a button on each screen of a Power Apps app to proceed to the next screen.
You need to implement the action which selects the next screen that the user sees.
Which event should you handle?
- A. ScreenTransition
- B. OnSelect Correct
- C. OnLoad
- D. OnCheck
Explanation
The 'OnSelect' event is triggered when a user clicks on a button. This makes it the appropriate event to handle for navigating to the next screen upon a button click in Power Apps.
You are a Dynamics 365 Customer Service developer.
A salesperson creates a chart.
You need to ensure that the chart is available to all users on the team.
What should you do?
- A. Share the chart with the team. Correct
- B. Assign the chart to each person on the team.
- C. Export the user chart to Power BI. Import the chart as a Power BI visualization.
- D. Export the user chart for import as a user chart.
Explanation
Sharing the chart with the team ensures that all users on the team have access to it. Assigning or exporting the chart does not directly address making the chart available to all team members as efficiently and straightforwardly.
You create an app.
You need to create the site map for the app.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
A site map is built as a hierarchy: first add an area, then add a group inside the area, then add a subarea inside the group. The subarea is what points to a table, dashboard, or URL. 'Add a view.' is not a site map step. Views belong to tables, and the site map subarea links to the table rather than to a view you create in the designer.
A company is implementing Microsoft Power Platform solutions.
The company requests information on the features that are supported by Power Fx.
You need to identify the features of Power Fx.
What should you identify?
- A. It is available for purchase through a Microsoft reseller.
- B. It uses a plug-in.
- C. It uses imperative and declarative logic. Correct
- D. It uses synchronous data operations.
Explanation
Power Fx supports both imperative and declarative logic for building applications within the Power Platform. This dual capability allows developers to write formulas that can react to events (imperative) and define structures or properties directly (declarative), making it versatile for various application needs.
You are configuring a new Power Apps portal. You have two web roles, one for authenticated users and one for anonymous users. You grant the Anonymous
Users role to users.
A test user reports that they can access the home page but cannot view a page linked from the home page.
You need to determine why the test user cannot view the portal page.
What is the cause of the issue?
- A. The setting to make the page available to everyone is disabled. Correct
- B. Inherited permissions are not enabled for the linked page.
- C. The Authenticated Users Web role does not have permission to view the page.
- D. Maintenance mode is enabled on the portal.
Explanation
The home page is public, so the test user (an anonymous visitor) can open it. In Power Pages, each page has an 'Anyone can see this page' (available to everyone) permission setting. When it is turned off for the linked page, that page is restricted to selected web roles and shows a lock icon, so anonymous visitors cannot view it. Inheritance is not the cause: a child page of a public parent is public by default, and the 'Inherit permissions from a parent page' option only applies when the parent itself is restricted. The Authenticated Users role does not apply to an anonymous visitor, and maintenance mode would block the home page as well.
A company is configuring a Power Apps portal using Microsoft Dataverse.
The company requires the following:
✑ Only authenticated users must be able to sign into the portal.
✑ Authenticated users must have varying degrees of access to the different parts of the portal.
✑ Users must enter one of several external identities when creating an account during the open registration process.
You need to configure user authentication and permissions.
Which component should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Required for each authenticated user before security can be assigned: Contact table record. Every portal (Power Pages) user is represented by a contact record in Microsoft Dataverse, and the external identity chosen during open registration is linked to that contact. Web roles and other permissions are assigned to the contact, so the contact must exist first. Account records represent organizations, not sign-in users, and 'Local user' and 'Microsoft work or school account' are only ways to authenticate.
Required for authenticated users to access restricted pages of the portal: Web roles. A web role is a collection of permissions to site content; before authenticated users can be granted access to restricted pages (page permissions) or restricted tables (table permissions), they must be assigned to a web role. The authentication options control how someone signs in, not what they can open.
You create a new solution for a business process.
The business process includes uploading specific file types to a web service.
You need to ensure that the business process works the same way anywhere the solution is deployed.
Which option should you use? To answer, drag the appropriate options to the correct configurations. Each option may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Solution System Settings are used for configuring specific solution settings that need to be consistent across deployments, such as blocked file types. Environment Variables are ideal for specifying dynamic values like URLs to web services, ensuring the business process works consistently in different environments.
A company collaborates by using Microsoft Teams.
You must create a Power Apps app directly from within a Teams channel. The app will be used by members of the channel to manage sales orders.
You need to create the app by using Dataverse for Teams.
How should you create the app?
- A. Create a canvas app by using a Power Apps personal app in Teams. Correct
- B. Create a canvas app by using the App Studio app.
- C. Use the Power Apps web designer.
- D. Create a model-driven app by using the App Studio app.
Explanation
Option A is correct because creating a canvas app using a Power Apps personal app in Teams allows for direct integration and sharing within the specified Teams channel, facilitating collaboration among members for managing sales orders.
A company has a portal. Users sign into the portal by using a social media account.
The company wants to replace the existing portal with a Power Apps portal. Users must sign up for access to the portal by using a Microsoft account and a unique invitation code that will be provided to the users.
You need to configure authentication for the home page.
Which values should you use? To answer, drag the appropriate values to the appropriate authentication settings. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
External sign in: Yes. Users sign in with a Microsoft account, which is an external identity provider, so external authentication must be enabled for the portal. Open registration: No. Users must register by redeeming a unique invitation code. Turning off open registration means users cannot create an account on their own and can sign up only with an invitation.
You are customizing a model-driven app for a company. You create a Theme template to ensure the company logo and colors are properly used within these apps.
The theme must meet the following requirements:
✑ Updated to add the logo
✑ Downloaded by the makers to create the app
You need to configure the assets. To answer, drag the appropriate configurations to the correct requirements. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
A model-driven app theme's logo is not uploaded directly as a file: the image must first exist as an image web resource, which is then selected in the theme's Logo setting, so upload the theme elements as new web resources. Theme colors (navigation bar, header, accent and other UI elements) are set as hexadecimal values, so to change the app colors you replace an existing UI item's hexadecimal number. The component library is for canvas app components and does not change a model-driven app theme.
A user needs to create a Power Apps portal app.
The user is getting a permission denied error when creating the portal app.
You need to configure permissions to create the portal app.
Which three permissions should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. In the Power Platform admin center, ensure that the user account has read-write access. Correct
- B. In Azure Active Directory, assign the Contributor role to the application at the subscription scope.
- C. In Azure Active Directory, ensure that the user has permission to register an app. Correct
- D. In the Power Platform admin center, change the portal app owner to the user.
- E. In the Power Platform admin center, ensure that the user has the System administrator security role. Correct
Explanation
To create a Power Apps portal, the user account needs read-write access mode in the Power Platform admin center (A) and the System Administrator security role in the environment (E). Portal provisioning also registered an application in Azure Active Directory for the portal, so the user also needed permission to register applications in Azure AD (C). Without it, creation failed with a permission error. Assigning the Contributor role to an application at subscription scope is not part of portal provisioning. Changing the owner of an existing portal does not let a user create a new one. Note: in today's Power Pages, a platform-managed identity is used, so the app-registration permission is no longer required for new environments.
You have a Power Apps portal app that supports a sales community and a service community in the same environment. The only language configured in the environment is English. The company wants to add support for two more languages.
The solution must meet the following requirements:
• Languages must be for both sales and service functions.
• The company logo and colors must be used and apply to all screens.
• Communities must be separate with different URLs and access lists.
You need to configure the solution.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Languages: Create two portals, one for each community. — Multi-language support is not a reason to duplicate a portal: once the two extra languages are enabled and provisioned in the environment, each portal can have additional Website Language records activated, and its pages, content snippets, and web link sets are then translated within that same site. What does force duplication is the requirement that the sales and service communities be separate with different URLs and different access lists, since a portal has a single base URL and its own web roles and table permissions, so two portals — each carrying all three languages — is the correct configuration. "Create one portal and import translations" fails the separate-URL and separate-access-list requirement, and creating a portal per language, or one per language-and-community combination, is unnecessary because a single portal already serves multiple languages.
Company logo and colors: Add themes. — Portal branding is applied through the theme, the Bootstrap-based stylesheet and theme settings, which controls colors, fonts, and the logo across every page of the site and therefore satisfies the "apply to all screens" requirement. Web resources are model-driven app components in Dataverse and do not brand a portal, and adding a portal header and footer would only restyle those two regions rather than all screens.
A company is creating a canvas app and a model-driven app to manage their customer accounts.
The canvas app requires a business rule to set the Business Type column to large if the customer size is greater than a specific currency value.
The model-driven app requires a business rule to recommend the account rating be re-evaluated when the account goes on credit hold for this app only.
You need to configure the scope for the business rules.
Which scope should you use? To answer, drag the appropriate scopes to the correct business rules. Each scope may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Business rules apply to canvas apps only when their scope is Table (Entity), because table-scoped rules run on the server and so apply to every app that writes to the table; a rule scoped to forms runs only in model-driven forms. The model-driven requirement is a recommendation that must apply in that one app only, so it is scoped to the specific form that the app uses rather than to All forms or to the table.
A company uses a Microsoft Power Platform environment.
The company plans to implement a Power Apps app. The application must meet the following requirements:
• Audit all user activity and only retain the audit logs for one year.
• Annually remove products that were created over a year ago.
You need to configure the automated processes.
What should you configure? To answer, drag the appropriate configurations to the correct requirements. Each configuration may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Audit log retention: Environment auditing. Auditing is started for the environment in the Power Platform admin center (Settings > Audit and logs > Audit settings), and the 'Retain these logs for' setting there sets how long audit logs are kept, so it can be set to one year. Table auditing only chooses which tables are audited and has no retention setting.
Product removal: Bulk deletion job. A bulk deletion job deletes the rows that match a query (products created more than a year ago) and can be scheduled to recur every 365 days, so the cleanup runs automatically each year. A filtered view only displays rows and deletes nothing.
A company creates a canvas app.
The app requires users to enter their social security number. The app should only display the last four digits when the user tabs to a different column.
You need to configure the app.
Which option should you use?
- A. Business rule
- B. Business process flow
- C. Power BI DAX
- D. Power Fx Correct
Explanation
Power Fx is the low-code formula language of canvas apps. Formulas on the input controls, for example using Right(TextInput.Text, 4) to show only the last four digits once the control loses focus, can mask the social security number after the user tabs away. Business rules and business process flows are Dataverse features for model-driven forms and processes, not canvas app control logic. DAX is the Power BI formula language and isn't used in canvas apps.
A company uses Power Apps.
The company plans to create a canvas app that uses a responsive design.
You need to configure the app.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Disable the Scale to fit setting. Correct
- B. Configure the height and width properties by using drag handles.
- C. Enable the lock orientation setting.
- D. Configure the height and width properties by using a formula. Correct
Explanation
Disabling the Scale to fit setting allows for responsive design by adapting the app layout to different screen sizes. Configuring height and width properties using a formula ensures that elements adjust dynamically based on the screen size.
A company uses model-driven apps.
Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data.
You need to configure the app.
What should you do?
- A. Create a Power Automate flow.
- B. Use a Power Virtual Agents app.
- C. Create a canvas app. Correct
- D. Modify the site map.
Explanation
A single, purpose-built data-entry screen is a canvas experience. In a model-driven app you add one as a custom page, which Microsoft describes as a special canvas app type that brings canvas capabilities into the model-driven app and is typically a single screen. You build it in Power Apps Studio with just the first name, last name, and phone number fields bound to the customer table, and it runs inside the existing model-driven app under that app's license and sharing. Modifying the site map only changes navigation: it can link to an existing page but cannot create the screen itself. A Power Automate flow automates processes and has no data-entry screen, and a Power Virtual Agents (now Copilot Studio) bot is a conversational agent, not a form for entering records.
You create a Power Apps app for Microsoft Teams using Microsoft Dataverse for Teams.
Users report that they are unable to view the app in Teams.
You need to ensure that users can access the app.
What should you do?
- A. Share the app with a security group by using the Maker portal.
- B. Publish the app by using the Maker portal.
- C. Request that a tenant administrator pin the app to the app bar in Teams.
- D. Share the app with a security group in Teams. Correct
- E. Share the app with individual users by using the Maker portal.
Explanation
Share the app with a security group in Teams. Dataverse for Teams apps are managed in the Power Apps app in Teams, not in the maker portal. A team owner opens the Build tab, gives the Colleagues with access role permissions on the app's tables, selects Share with colleagues, picks a security group and turns on Colleague can use for the app. The app then appears to those users under Built for your colleagues in the Teams app store. Sharing or publishing from the maker portal (A, B, E) does not apply to Dataverse for Teams apps. Pinning the app to the app bar (C) is an optional step a tenant administrator can take after the app is shared; on its own it gives users no access to the app or its data.
You create a canvas app.
The app requires access to data that is stored in collections. The app must provide the following actions:
• Create a new collection variable.
• Remove table values from a collection.
You need to configure functions for the app.
Which functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Create a new collection variable.: Collect — Collect(CollectionName, Item) creates the collection if it does not already exist and adds records to it. Set creates a global variable, not a collection, Select runs a control's OnSelect formula, and AddColumns only returns a modified table without storing it.
Remove table values from a collection.: Clear — Clear(CollectionName) deletes all of the records from a collection and keeps its columns. Reset returns a control to its default value, Revert refreshes records from a data source, and DropColumns returns a table with columns removed instead of removing the stored records.
A company creates a canvas app.
The company plans to make the app available in Microsoft Teams. Only employees will be allowed to use the app.
You need to add the app to Teams.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
Sign in to the Power Apps maker portal (make.powerapps.com) and open Apps, select the required app (More actions), and then select Add to Teams, which opens Teams so the app can be added for the organization's users. The Power Platform admin center is used for environment and tenant administration and has no Add to Teams action for an app. Uploading the app to a channel's Files tab or sharing it to a channel email address does not install it as a Teams app, and downloading the app package is an optional alternative that then needs a separate upload in Teams.
A company creates a Microsoft Teams app that stores data in two tables in a Microsoft Dataverse for Teams environment.
Users require access to the app and the app data.
You need to configure access.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Access to the data: Assign a permission set for each table in the app — in Dataverse for Teams, users outside the team get data access through the built-in Colleagues with access role, which by default has no access to custom tables. For each table you open Manage permissions and choose one of four permission sets (Full access, Collaborate, Reference or Private), repeating this for every table the app uses. You do not create a custom security role for this, and record sharing only grants access to individual rows.
Access to the app: Share with a security group — Share with colleagues assigns the Colleagues with access role to a single Microsoft Entra security group and turns on the apps and tables that group can use, so every member gets the app and its data, and membership changes flow through automatically. Apps are not shared with individual users in this experience, and publishing the app to a Teams channel only makes it available to members of that team.
A company plans to implement Power Pages.
The company requests that you create demonstration sites based on the following requirements:
• A website that supports automated scheduling
• A website that supports event registration
• A website that can be extended by using the company’s branding
In addition, custom development work must be minimized.
You need to identify the appropriate Power Pages templates to use.
Which templates should you use? To answer, drag the appropriate templates to the correct requirements. Each template may be used once, more than once, or not at all. You may need to drag the split between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Automated scheduling: financial institution. This template (Schedule and manage meetings) lets bank customers book appointments with a consultant by choosing services, location and availability, while staff block out their own time, so scheduling works without custom development. Event registration: after school program. This template (Program registration) lets visitors register for classes or events from a list of available offerings and can be reused by any organization that needs a registration site. Extension by using branding: blank page. A blank site starts with no prebuilt content, so the company's own branding, theme and layout can be applied in the design studio. The building permit template targets permit applications and does not meet any of the requirements.
You are modifying a model-driven app. You set up a customer table in Microsoft Power Platform to retrieve user data.
You set up a form with the following columns for users to enter their data. The form includes the following columns:
| Column | Data type |
|---|---|
| Country/region | Choices (multi-select) |
| Passport ownership | Choice (yes/no) |
| Passport expiration date | Text |
The form must do the following:
• The Country/region column must automatically populate with US when English is chosen as a language. If the user selects Other for this column, the column must remain blank so that user can enter a value.
• The Passport expiration date column must appear only if the user selects Yes in the Passport ownership column.
You need to configure the app with the least amount of effort.
What should you configure? To answer, drag the appropriate solution component to the correct requirements. Each solution component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
The Country/Region column, being a multi-select type, cannot be used in a business rule according to Microsoft documentation. Therefore, a formula is necessary for conditional logic. The Passport expiration date visibility can be managed with a business rule based on the selection of the Passport ownership column.
You have a canvas app.
The canvas app must store data in a variable that is available only to the current screen.
You need to create the variable.
Which two functions should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. UpdateContext Correct
- B. Navigate Correct
- C. SaveData
- D. Set
- E. Collect
Explanation
Context variables are scoped to a single screen, and two functions create them. UpdateContext creates or updates context variables on the current screen. Navigate can also set context variables through its optional UpdateContextRecord argument (for example, Navigate(Screen2, ScreenTransition.None, {varName: value})), and those variables are available only on the screen it navigates to. Set creates global variables, which are available across the whole app. SaveData stores a collection on the device, and Collect adds records to a collection, which is also app-wide.
You plan to create a canvas app with multiple screens.
The app needs to store temporary data while the app is running. The app has the following data requirements:
• Each screen must maintain a separate copy of data and pass the data to another screen.
• The app must be able to update separate rows of a table independently.
You need to configure variables for the data.
Which variable types should you use? To answer, drag the appropriate variable types to the correct requirements. Each variable type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
A context variable is used for maintaining separate copies of data per screen and passing it between screens, as required by the first condition. A collection is suitable for updating separate rows of a table independently, fulfilling the second requirement.
You plan to create a canvas app.
The app must meet the following requirements:
• Send an email after a record is saved.
• Display the expiration column on a form if the creation date of the record is older than 90 days.
You need to configure the app.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Send an email after a record is saved: Power Automate flow — A canvas app triggers a Power Automate flow (added via the Power Automate pane and called from an OnSuccess/OnSelect expression with the .Run() method), and the flow's Office 365 Outlook "Send an email" action handles the actual send, including any retries and server-side processing after the record is committed. A Connection is only the underlying authenticated link to a data source and does not by itself perform an action, and a Collection is just an in-memory table of rows in the app, so neither can send mail.
Display the expiration column on a form if the creation date of the record is older than 90 days: Formula — Conditional visibility in a canvas app is expressed by setting the card or control's Visible property to a Power Fx formula, for example DateDiff(ThisItem.'Created On', Today(), TimeUnit.Days) > 90, which Power Apps re-evaluates automatically as the bound record changes. A Collection would only store data rather than control the UI, and a Connection merely supplies the data source, so neither can drive whether the column is shown.
A company plans to create two Microsoft Power Platform applications.
One of the applications requires a custom control layout without using code. The other application will be used primarily by external users.
You need to create the applications.
Which application types should you use? To answer, drag the appropriate application types to the correct requirements. Each application type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
A Canvas app in the Power Platform allows for custom control layouts without requiring code, making it suitable for the first requirement. The Power Pages portal is designed to create web pages that can be accessed by external users, fitting the second requirement.
You create a Power Apps app.
The app must be able to display a list of records that are sorted by category. The app must also expand or hide the list by subtopics.
You need to configure the app.
Which tool should you use?
- A. card
- B. expression
- C. gallery Correct
- D. Power BI dashboard
Explanation
A gallery in Power Apps is used to display a list of records that can be sorted and expanded or collapsed by subtopics. This functionality directly meets the requirements specified for displaying and managing lists within the app.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to view website questions and comments.
Where should you view this information?
- A. Evaluations
- B. Lead
- C. Contact
- D. Feedback Correct
Explanation
The Contact Us page on the team website is designed to collect feedback from visitors. According to Microsoft documentation, records submitted through this form are stored in the Feedback entity.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to set up webpage permissions.
Which permissions must you set? To answer, move the appropriate permissions to the correct page. You may use each permission once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
The Home and Schedule pages are open to everyone, so 'Anyone can see this page' is appropriate. The Evaluations page should only be accessible by Prospect Users for privacy reasons. The Forms page requires Primary Contact Users to manage consent forms.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create forms required for the registration team and assistants.
Which form types should you create? To answer, move the appropriate form types to the correct roles. You may use each form type once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Registration team: Quick create. A quick create form opens in a flyout from the Parents form (for example from a lookup or subgrid), so the team can add a prospect without leaving the parent record, and it can be limited to only First Name, Last Name and Birthdate.
Assistants: Main. The main form is the full form used to view and update a record in a model-driven app, and it can contain subgrids, such as the teams the prospect has previously played on. A card form is a compact layout for views and grids, not for editing records with subgrids, and Edit is not a Dataverse form type.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to configure the Total field on the Evaluation form.
Which property should you select for the formula? To answer, move the appropriate property to the correct formula. You may use each property once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Sum(Endurance.Text,Coordination.Text,Skill.Text): Text. The Total label shows the sum of the three ratings, so the formula goes in the label's Text property, which sets what the control displays.
If(Value(Total.Text) > 25, Color.Green, Color.Black): Color. The requirement is that the number itself appears green when the total is over 25, so the formula goes in the Color property, which sets the font color. Fill would change the background instead. Font sets the typeface name and does not accept a color value.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create the evaluation record for a prospect.
What should you use?
- A. a classic Dataverse workflow
- B. a cloud flow Correct
- C. a plug-in
- D. a quick create form
Explanation
A cloud flow is the appropriate choice because custom code is not allowed, eliminating plug-ins. Quick create forms require user interaction to create records, which is not suitable for automatic record creation. Cloud flows can automatically create evaluation records based on specified triggers without requiring manual intervention.
A company is implementing Power Apps and Power Automate.
Several components are created within Power Apps, Microsoft Dataverse, and Power Automate. These components must be promoted from the development environment to the user acceptance test environment in a single solution package.
You need to create the solution package for promotion.
Where should you create the package?
- A. Azure portal
- B. Microsoft Power Platform admin center
- C. Office 365 admin center
- D. Power Apps maker portal Correct
Explanation
The Power Apps maker portal is the correct location for creating solution packages that include components from Power Apps and Power Automate. This portal provides the necessary tools to package and promote these components between different environments, such as from development to user acceptance test.
You are building a model-driven app for a company.
You identify several custom commands that the app must support, including the following commands:
• Save a row.
• Move the user to a different row in the application.
• Navigate the user to an external webpage.
• Show a notification that the user can accept or decline.
You need to identify the formula to use for each requirement.
Which formulas should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Save a row: Patch(). In model-driven app commanding, Power Fx writes data with Patch, for example Patch(Accounts, Self.Selected.Item, {...}) to update the selected record or Patch(Tasks, Defaults(Tasks), {...}) to create one. SubmitForm() and SaveData() are on the list of functions not supported in commanding, and Confirm() only shows a dialog.
Move to a different row: Navigate(). In commanding, Navigate can open another record's form (Navigate(Gallery1.Selected)), a table view or a custom page. Back() and Exit() are not supported in commanding, and Launch() opens a URL rather than a row in the app.
Navigate the user to an external webpage: Launch(). Launch("https://...") opens an external address. Navigate() only moves within the app (forms, views, custom pages).
Show a notification with options: Confirm(). Confirm displays a dialog with confirm and cancel buttons and returns true or false, so the command can act on whether the user accepted or declined. Notify() shows a one-way message, and InvokeControl() and Set() are not supported in commanding.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a Power Pages site for a supermarket chain.
The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only.
You need to configure the site security.
Solution: Configure table permissions.
Does the solution meet the goal?
Explanation
No. A table permission takes effect only when it is associated with one or more web roles, and only users in those web roles get its privileges. Configuring table permissions alone does not give the managers access. You also need a web role for store managers, assigned to them when they sign in with their corporate identity, and the table permission must use Account (or Contact) access with Create and Write privileges, so that each manager can add and update stock records for their own store only.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a Power Pages site for a supermarket chain.
The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only.
You need to configure the site security.
Solution: Use local authentication.
Does the solution meet the goal?
Explanation
Local authentication does not support integration with corporate identity management systems. Since managers need to authenticate using their corporate identities, local authentication would not meet the goal.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a Power Pages site for a supermarket chain.
The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only.
You need to configure the site security.
Solution: Use Microsoft Entra ID authentication.
Does the solution meet the goal?
Explanation
While Microsoft Entra ID authentication ensures that only authenticated users can access the site, it does not inherently restrict managers to update stock information for their store only. Additional configuration for authorization and role-based access control is required.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are building a Power Pages site for a supermarket chain.
The company plans to have the managers of individual stores use the site. Managers will authenticate on the site each week by using their corporate identity to update stock information for their store. Managers must be able to add and update stock information for their store only.
You need to configure the site security.
Solution: Configure page permissions.
Does the solution meet the goal?
Explanation
Configuring page permissions alone does not meet the goal of ensuring managers can only add and update stock information for their specific store. Role-based access control or item-level permissions are required to restrict actions to individual stores.
You are building a model-driven app. The environment has Advanced settings enabled.
A form in the app requires a custom interface.
You need to embed the custom interface onto the form without using custom code.
What should you do?
- A. Modify the model-driven app to use mobile form factor.
- B. Modify the model-driven app to use tablet form factor.
- C. Create a quick view form.
- D. Use the classic experience to add a canvas app. Correct
Explanation
An embedded canvas app lets you build a custom, low-code interface in Power Apps Studio and place it on a model-driven form like any other control, with no custom code. The canvas app can also receive contextual data from the host form. A quick view form only shows read-only data from a related record and cannot provide a custom interface. Switching the app to the mobile or tablet form factor changes where the form is shown, not what it contains.
A company uses model-driven apps.
Users in the sales department enter the first name, last name, and phone number of customers in the app. The users request a single screen in the app to enter the customer data.
You need to configure the app.
What should you do?
- A. Create a Power Automate flow.
- B. Use Copilot Studio.
- C. Create a canvas app.
- D. Modify the site map. Correct
Explanation
The site map defines the navigation of a model-driven app: its areas, groups and subareas point to tables, dashboards or pages. Adding a subarea for the customer table to the site map gives sales users one place in the app where they open the customer form and enter the first name, last name and phone number. A Power Automate flow automates processes and has no data-entry screen, Copilot Studio builds conversational agents, and a canvas app would be a separate app rather than a change to the model-driven app the users already work in.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
Support agents use a model-driven app while working on customer cases.
Agents currently switch between multiple systems to locate help content. The need to switch systems makes it difficult to find relevant information.
You need to provide an efficient way to display contextual knowledge directly within the case form without requiring the agent to refresh the record.
Solution: Call an instant flow to update article information on the Dataverse record.
Does the solution meet the goal?
Explanation
Calling an instant flow to update article information on the Dataverse record does not directly provide contextual knowledge within the case form without requiring a refresh. The solution would require additional steps or configurations, such as embedding web resources or using Power Apps components, to display content dynamically.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
Support agents use a model-driven app while working on customer cases.
Agents currently switch between multiple systems to locate help content. The need to switch systems makes it difficult to find relevant information.
You need to provide an efficient way to display contextual knowledge directly within the case form without requiring the agent to refresh the record.
Solution: Add a custom page that has a knowledge article lookup and link it by using a navigation button in the app.
Does the solution meet the goal?
Explanation
The proposed solution of adding a custom page with a knowledge article lookup linked by a navigation button does not directly display contextual knowledge within the case form. It still requires agents to navigate away from the current context, which contradicts the goal of providing information without refreshing or switching systems.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
Support agents use a model-driven app while working on customer cases.
Agents currently switch between multiple systems to locate help content. The need to switch systems makes it difficult to find relevant information.
You need to provide an efficient way to display contextual knowledge directly within the case form without requiring the agent to refresh the record.
Solution: In the case form, embed a canvas app that dynamically displays knowledge articles based on the case category.
Does the solution meet the goal?
Explanation
Embedding a canvas app within the case form that dynamically displays knowledge articles based on the case category directly addresses the need to provide contextual information without requiring agents to switch between multiple systems or refresh records, thus meeting the goal.
You are customizing a model-driven app view that is used to manage contract approvals by using Power Fx.
A custom command button must appear only when:
• One or more records are selected in the grid view.
• All selected records have a RecordStatus field value of Ready.
You need to configure the command to meet the business requirements.
Which Power Fx expressions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
At least one record is selected: CountRows(Self.Selected.AllItems) > 0. In a modern command's Visible formula, Self.Selected.AllItems is the table of rows selected in the grid. Counting it and requiring more than zero rows shows the button for any non-empty selection. CountRows(...) = 1 hides the button when two or more records are selected. !IsBlank(...) is unreliable because IsBlank does not test whether a table is empty (IsEmpty does), so an empty selection is not detected.
All selected records have a value of Ready: CountIf(Self.Selected.AllItems, RecordStatus <> "Ready") = 0. CountIf counts the selected rows whose RecordStatus is not Ready. The result is zero only when every selected row is Ready, which gives the Boolean that Visible needs. ForAll returns a table of results, not a single true/false value, so it cannot be used as the visibility condition. Self.RecordStatus = "Ready" refers to the command itself, not to the selected rows.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear on the review screen.
Support agents use a model-driven app while working on customer cases.
Agents currently switch between multiple systems to locate help content. The need to switch systems makes it difficult to find relevant information.
You need to provide an efficient way to display contextual knowledge directly within the case form without requiring the agent to refresh the record.
Solution: In the case form, add a subgrid that points to a custom table storing external article links.
Does the solution meet the goal?
Explanation
Adding a subgrid that points to a custom table storing external article links does not directly display contextual knowledge within the case form without requiring the agent to refresh or navigate away from the current record. This solution still requires agents to interact with additional elements, potentially causing disruption and inefficiency.
You plan to create user interface (UI) flows to automate several web-based business processes that you currently perform manually.
You need to ensure that users can create and run web UI flows.
Which three components must you install and configure on user's devices? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Power Automate Desktop Correct
- B. Latest version of Microsoft Edge Correct
- C. On-premises data gateway
- D. Selenium IDE Correct
- E. Latest version of Mozilla Firefox
Explanation
Power Automate Desktop (A) provides the desktop/UI flows components needed to create and run UI flows on the device. A supported browser, the latest version of Microsoft Edge (B, version 80 or later, or Google Chrome), runs the web automation with the UI flows browser extension. Selenium IDE (D) is the recorder that web UI flows used to record and play back browser actions. The on-premises data gateway (C) only connects cloud services to on-premises data and is not used for local recording, and Mozilla Firefox (E) was not a supported browser for web UI flows. Note: web UI flows with Selenium IDE have since been retired in favour of Power Automate for desktop.
You are designing a desktop user interface (UI) flow.
The UI flow automates legacy software.
You need to prepare data for transfer to Microsoft SharePoint list.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
The sequence starts with initiating the recording process. Next, selecting text on screen is necessary to capture data from legacy software. Naming and describing the output ensures clarity in data handling. Finally, specifying which information should be passed to SharePoint completes the preparation for data transfer.
You have a business process flow.
You need to update the business process flow while minimizing administrative and maintenance efforts.
What should you implement? To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
Allow users to navigate to the previous stage only from specific stages: Power Automate flow. Each business process flow instance is a Dataverse row whose active stage changes when the user moves between stages. A Power Automate flow triggered by that change can check which stage the user came from and reset the active stage when a backward move is not allowed, with no code. Microsoft recommends Power Automate over classic workflows for new automation, so the flow keeps administration and maintenance low.
Create checklist records in specific stages on demand: Action step. An action step adds a button to a chosen stage of the business process flow. The button runs a flow or classic workflow only when the user selects it, so the checklist records are created on demand in exactly the stages that need them.
Classic workflow is not used: Microsoft recommends Power Automate flows instead of classic workflows, so a classic workflow adds maintenance the requirement asks you to avoid.
You are creating a new business process flow to qualify leads.
You create an action. The action is not available inside the Action Step.
You need to make the action available to the Action Step.
Which two steps must you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Ensure that the entity for the action matches the corresponding entity for the business process flow stage. Correct
- B. Add at least one step to the action.
- C. Select Run as an on-demand process.
- D. Activate the action. Correct
Explanation
To make an action available inside the Action Step of a business process flow, it is necessary to ensure that the entity for the action matches the corresponding entity for the business process flow stage (Option A). Additionally, the action must be activated (Option D) to become available in the designer.
You plan to automate several different processes by using Power Automate.
Each process has unique characteristics.
You need to recommend components for each process.
Which components should you recommend? To answer, drag the appropriate components to the correct processes. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
Internally created web application with a basic REST API, nightly batch job: Flow that uses a custom connector. The application has an API, so a cloud flow can call it directly. Because the application was built in-house, no prebuilt connector exists for it, so you wrap its REST API in a custom connector. A scheduled cloud flow can then run the nightly batch without any UI automation. A prebuilt connector is not available for an in-house application, and a UI flow would needlessly drive the user interface when an API is available.
Public website with no API, emails processed through an unmonitored queue: Unattended UI flow. With no API, the only way to get the data is to automate the website's user interface with a UI (desktop) flow. Nobody monitors the queue, so the flow must run without a person present. Unattended desktop flows are triggered from cloud flows, sign in to the machine by themselves and are intended for tasks that need no human supervision. An attended UI flow needs a signed-in user at the machine, which does not fit an unmonitored process.
You create workflows to automate business processes.
You need to create a workflow that automatically sends emails based on a mail merge template. The workflow must contain the following configurations:
✑ Run immediately.
✑ Validate when a condition is met.
✑ Perform an action when a condition is met.
To answer, select the appropriate configuration in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Run immediately.: Approve the workflow. — A Dataverse workflow only becomes live and starts processing records once it is approved/activated; while it stays in draft it is saved but never executes, so approving it is what makes it take effect immediately. "Configure the workflow to run now" and "Configure child workflow to run now" are not what makes the process live — a child workflow is simply a process called from another workflow, and neither setting activates the definition.
Validate when a condition is met.: Trigger when a Power Automate button is pressed. — The condition in a workflow is only evaluated when the process is triggered, so you define the triggering event, and pressing the Power Automate button is the event that starts the run and causes the condition check to happen. "Publish workflow" is a lifecycle/deployment action rather than something that evaluates a condition at run time.
Perform an action when a condition is met.: Send an email. — Send Email is a standard workflow step in Dataverse, and it can use an email template (the mail merge template) to generate and send the message when the condition evaluates to true. "View chart" is a user interface activity, not a workflow step, and "Update a security role" is a security administration task that a workflow action cannot perform.
You are developing a canvas app.
You need to apply business rules to the app without writing code.
Which three actions can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Validate data and show error messages. Correct
- B. Enable or disable fields.
- C. Set field requirement levels. Correct
- D. Set field values. Correct
- E. Show or hide fields
Explanation
In canvas apps, you can validate data and show error messages, set field requirement levels, and set field values without writing code. These actions are supported by the business rule capabilities in canvas apps.
A company plans to use Power Automate to increase employee efficiency.
You need to recommend the types of flows that the company should use.
Which flow type should you recommend? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
For repetitive actions in an existing application that has no API, use a desktop flow. Desktop flows use robotic process automation to work through the application's user interface, clicking and typing as a person would, so no connector or API is needed. Cloud flows such as automated flows work through connectors and cannot drive an application's UI on their own. A business process flow only guides users through the stages of a Dataverse record.
To send an email to a contact on their birthday, use a scheduled flow. A birthday is a date, not an event, so the flow runs on a recurrence (for example, daily), finds the contacts whose birthday is today and sends the email. An automated flow needs a triggering event such as a record being created or changed, and an instant flow needs someone to start it manually.
A company is creating a business process flow in Power Automate to analyze the probability that a customer will buy a specific product.
The company uses ratings from zero to one hundred. The company assigns likelihoods based on the following table:
| Rating | Likelihood that customer will buy product |
|---|---|
| 0-35 | Low |
| 36-60 | Medium |
| 60-75 | High |
| Greater than 75 | Very High |
You need to define the business process steps. All logic must be included in a single evaluation statement.
Which step should you use? To answer, drag the appropriate steps to the correct ratings. Each step may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
With all the logic in a single evaluation (a condition with branches), each rating range that meets a condition gets its own conditional branch, and the value that meets none of them falls through to the default action. 0-35 (Low) is the fallback when no branch condition is met, so it is the Default Action. 36-60 (Medium) is met by a specific condition, so it is a Conditional Branch. 76+ (Very High) is also met by a specific condition, so it is a Conditional Branch too. Check Condition is the evaluation itself, not a result for a rating range. Custom Step is not used for branching logic.
You are creating a Power Platform solution.
You need to help end users understand which actions to take next and ensure that user interaction occurs in manageable steps.
Which actions should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Guide the user with actions to take: Configure business process flows — A business process flow presents users with a guided, prescriptive path through a process, showing at the top of the form exactly where they are and what to do next. Views and charts only present or visualize data, and workflows automate work in the background without guiding the person through it.
Ensure user interaction in manageable steps: Configure each stage with the actions that needs to be completed. — A business process flow is divided into stages, and each stage contains the steps (required and optional fields or actions) that must be completed before advancing, which breaks the process into small, manageable chunks. Configuring the timeline only surfaces activity history such as notes, emails, and appointments, and Insights provides AI-driven analytics rather than step-by-step interaction.
You are developing an app.
You must trigger a mobile notification whenever a specific hashtag is posted from Twitter. The notification will send email to the company's social media teams distribution list.
You need to create a connection to the Twitter service and build a solution.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
1. Sign in to Power Automate and create a new blank flow - the solution is a cloud flow, so it starts in Power Automate; the Business platform admin center and a 'project and connection set' are not part of this.
2. Select the Twitter connector and use the user credentials for the connection - the connection to the Twitter service is created by signing in with the Twitter account. (Microsoft has since retired the connector's shared application, so new X connections now also need your own app's consumer key and secret.)
3. Create a trigger to search for the new posts with the hashtag - the connector's 'When a new tweet is posted' trigger takes search text such as #hashtag and starts the flow whenever a matching post appears.
4. Create an action to send an email - a trigger is the event that starts the flow, and everything after it is an action, so sending the notification email to the social media team's distribution list is an action, not a second trigger. Searching for posts as an action would not start the flow automatically.
You manage Microsoft Power Platform apps for a company.
You need to hide the Flows button on the user interface.
Which configuration setting should you change?
- A. the SiteMap
- B. the Customizations section of System Settings Correct
- C. the Entity component of the default solution
- D. the Buttons tab of Flow
Explanation
The Flows button visibility can be controlled through the Customizations section of System Settings in Microsoft Power Platform. This setting allows administrators to hide or show the Flows button on the user interface.
You configure and test a user interface (UI) flow. You plan to run the flow as a scheduled flow.
The UI flow must run on a Windows 10 device. As part of process automation, the UI flow must sign into the Windows 10 device with the credentials for a user account named User1.
You need to ensure that the flow runs during non-peak hours and requires no physical user intervention.
What should you do?
- A. Ensure that the User1 account has an active user session on the device.
- B. Ensure that all user sessions are signed out. Correct
- C. Ensure that there are no active user sessions on the device.
- D. Ensure that all user sessions are signed out except for locked user sessions.
Explanation
Option B ensures that all user sessions are signed out on the target Windows 10 device, which is necessary for running unattended UI flows without physical intervention. This aligns with Microsoft's requirement for unattended execution of UI flows.
A company plans to send escalation emails to all customers with overdue invoices. You are creating a Microsoft Power Automate flow to determine whether to send an escalation email.
The system must send an alert for all invoices that are seven days or more overdue.
You need to configure the flow.
Which expression should you use?
- A. @GreaterOrEquals(TriggerEmail()?['OverdueDate']: '7') Correct
- B. 'OverdueDate' >= '7'?'TriggerEmail()': false
- C. TriggerEmail() = 'OverdueDate' >= 7;
Explanation
Option A is the only choice written as a Power Automate workflow expression that uses the greaterOrEquals comparison function: it reads the OverdueDate value from the trigger output and checks whether it is greater than or equal to 7, so an alert is sent for every invoice that is seven or more days overdue. Option B uses a ternary-style syntax and option C an assignment statement, neither of which is valid in Power Automate expressions.
You add a business process flow to the Account table. The flow has three stages.
You need to ensure that a workflow can run when a user completes the final stage.
Which option should you use?
- A. Start when: Record status changes
- B. Available to run: Run this workflow in the background
- C. Available to run: As an on-demand process Correct
- D. Available to run: As a child process
Explanation
Option C, 'Available to run: As an on-demand process', is correct because it allows the workflow to be triggered manually or automatically at specific stages within a business process flow, such as upon completion of the final stage.
You need to create a Power Automate desktop flow.
What are two possible ways to create the flow? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Record mouse and keyboard events. Correct
- B. Configure a pre-built template.
- C. Use pre-built actions. Correct
- D. Create models by using Microsoft Visio.
Explanation
Option A is correct because Power Automate Desktop allows users to create flows by recording mouse and keyboard events. Option C is also correct as users can utilize pre-built actions within the Power Automate Desktop environment to construct their flows.
You are using Power Automate to create a list of customers from a Microsoft Excel file.
The list must contain customers who meet one of the following criteria:
- Sales of less than $500,000.
- Customers who are on credit hold.
You need to create a condition to filter the list of customers.
How should you complete the filter condition? To answer, select the appropriate options in the answer area.
@[Logical operator] (less(item()?['sales'], 500000), [Condition for credit hold])
NOTE: Each correct selection is worth one point.
Explanation
Logical operator for the condition: or. A customer qualifies when they meet one of the criteria (sales under $500,000 or on credit hold), so the two expressions are joined with or(), which returns true when either argument is true. and() would return only customers who meet both criteria, and not() takes a single argument and cannot combine two conditions.
Condition for credit hold: equals(item()?['credithold'], 'true'). Inside the filter, item()?['credithold'] reads the credithold column of the current row, and equals() returns true only for customers flagged as on credit hold. empty() takes a single value and only tests whether it has no content, and not(equals(...)) inverts the test so it would match customers who are not on credit hold.
A farm uses a canvas app to manage schedules for planting fields with crop seeds. The farm uses business intelligence to provide recommendations for schedule changes based on weather data.
You must implement a business rule that changes information for several forms in the canvas app based on business intelligence data.
You need to configure the business rule.
Which scope should you use?
- A. Table Correct
- B. All Forms
- C. Form specific
Explanation
The scope for business rules in a canvas app must be at the table level because canvas apps do not support form-specific or all forms scopes for business rules. This aligns with Microsoft's official documentation on creating business rules.
A company uses Power Apps and Power Automate.
There is an issue with the existing flow in the test environment. Development changes are allowed in the test environment.
You need to troubleshoot the issue with the flow.
Which command should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Enable changes to the flow: Add existing. In the test environment the flow came in through a managed solution. To work on it in a tracked way, open an unmanaged solution in that environment and choose Add existing > Automation > Cloud flow. The changes are then captured in a solution and can be moved on through the ALM process. Remove takes a component out of a solution rather than making it available to change. Edit and Turn off do not put the flow into a solution where your changes are tracked.
Enable changes to the object: Turn off. While you troubleshoot and change the flow, turn it off so that its trigger stops firing and it does not process real events with a half-fixed definition. Make and save your changes, then turn the flow back on. Publish applies to customizations such as apps, forms and site maps, not to cloud flows. Edit only opens the designer; it does not stop the flow from running while you work on it.
You plan on implementing complex business logic in Microsoft Dataverse tables by using Power Automate flows.
You realize that the functionality required to implement the business logic is not available in a Power Automate flow.
The new business logic must work in multiple Dataverse tables. In addition, the operation must return a value after it finishes and must be able to run from an existing Dataverse action.
You need to recommend the method to implement the missing logic.
What should you recommend?
- A. Bound action
- B. Custom API
- C. Unbound action Correct
- D. Scheduled workflow
Explanation
An unbound (global) action is not tied to a specific table, so the same operation can be called for rows of any Dataverse table. Like any Dataverse action it can define output parameters that return a value when it finishes, and it can be called from workflows, Power Automate flows and other Dataverse actions. A bound action is tied to a single table, so it would not work across multiple tables. Custom API is a way of defining a message that can itself be bound or unbound, and it needs a .NET plug-in for its logic, so it does not by itself meet the multi-table requirement. A scheduled workflow runs on a timer and does not return a value to a caller.
A company plans to automate the following manual processes by using Power Automate.
You need to identify UI flow types for the two business processes.
Which desktop flow type should you use? To answer, drag the appropriate desktop flow types to the correct business processes. Each desktop flow type may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
| Process | Time to Complete | Comments |
|---------|------------------|----------|
| 1 | 30 minutes | The user's device must remain unlocked when the business process runs. The user will be required to leave their device unattended in a secure setting while the business process runs so that the user can assist with other efforts. |
| 2 | 45 minutes | The process must run after normal business hours. The device that runs the business process must remain unlocked when the business process is not running. |
Explanation
Business process 1: Attended. An attended desktop flow runs in the signed-in user's active Windows session, so the device must be unlocked while it runs. The user does not have to interact with it and can leave the unlocked device in a secure place, which is what this process describes.
Business process 2: Unattended. An unattended desktop flow runs on a schedule or trigger without a user present. Power Automate signs in to the machine itself, so it suits a process that must run after normal business hours when nobody is at the device.
You are creating a business process flow for a Power Apps app.
The business process flow must meet the following requirements:
• Must be available offline.
• Send an email to the team when a record is created.
You need to set up business process flow.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Make it available offline: Ensure that the business process flow is referencing one table. Business process flows work in mobile offline only when the whole process is based on a single table. A flow that spans two tables, or uses a different table for each stage, isn't supported offline.
Send an email to the team: Create a stage. To act automatically, you drag a Workflow component onto a stage and set it to run on stage entry or exit. A new record enters the first stage when it is created, so a send-email workflow on that stage notifies the team at creation. A step only captures a column value, and an Action Step runs a workflow only when a user selects Execute. A required column only blocks moving to the next stage, so neither one sends the email automatically.
A company has a model-driven app.
The app must meet the following requirements:
• Prevent users from saving a record if validation from a custom action fails.
• Query and update a list of records.
You need to configure processes for the app without using code.
Which processes should you use? To answer, drag the appropriate processes to the correct requirements. Each process may be used once, more than once, or not at all. You may need to
drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Prevent users from saving a record: Classic workflow. A real-time (synchronous) classic workflow that runs before the save can call the custom action and, when the validation fails, end with a Stop Workflow step set to Canceled. Dataverse then cancels the operation and shows the status message to the user as a Business Process Error, with no code. A business process flow only guides users through stages and steps and cannot cancel a save.
Query and update records: Cloud flow. A Power Automate cloud flow can use the Dataverse 'List rows' action to query a set of records and then 'Update a row' inside an Apply to each loop, so it can query and update a list of records without code.
You plan to create a canvas app.
The app requires a button on the data entry screen that users can select to send an email.
You need to configure the app.
What should you create?
- A. Classic workflow
- B. Power Automate cloud flow Correct
- C. Azure Logic App
- D. Business process flow
Explanation
Power Automate cloud flow is the correct choice for integrating email-sending functionality triggered by a button in a canvas app. It provides the necessary automation capabilities to connect and execute actions, such as sending emails, directly from the app.
You need to build a Power BI dashboard for sales managers to track opportunities.
When a new sale closes that is greater than $1 million, a notification must pop up and an email must be sent to the leadership team.
You need to ensure the email is sent without editing the Microsoft Dataverse.
Which two elements should you configure? Each correct answer is part of the solution.
NOTE: Each correct selection is worth one point.
- A. a Power Automate flow Correct
- B. a calculated column in the Dataverse
- C. a paginated report to save to Microsoft OneDrive
- D. a custom connector
- E. alerts in Power BI Correct
Explanation
Option A is correct because a Power Automate flow can be configured to trigger an email notification to the leadership team when a sale closes above $1 million without modifying the Microsoft Dataverse. Option E is correct as alerts in Power BI can be set up to notify users of specific conditions, such as sales closing over a certain threshold.
A company uses a model-driven app for customer support.
The company has the following requirements for the app:
• Send an email in real-time to customers when they enter their email address.
• Send an email to customers at the same time every day for cases that are open for more than 24 hours.
The solution should require the least amount of customization.
You need to configure the model-driven app.
Which components should you use? To answer, drag the appropriate components to the requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Send email to customer when email address entered: Classic workflow — a classic Dataverse workflow can run in real time (synchronously) when a column such as the email address changes, and it has a built-in Send Email step, so the requirement is met with configuration only. A PCF control or JavaScript would need code, which is more customization.
Send email at the same time every day: Power Automate flow — a cloud flow with a Recurrence (scheduled) trigger runs at a fixed time every day, can list the cases that have been open for more than 24 hours, and sends the emails. Classic workflows have no schedule trigger, and PCF controls and JavaScript only run when a user has a form open.
You have a classic workflow. The workflow updates a custom column on a record when an account record is created.
The workflow must update the custom column based on the following conditions:
• Update the custom column value using the Account Number.
• If the Account Number column is blank, update the custom column value using the Ticker Symbol.
• If the Ticker Symbol column is blank, update the custom column value to N/A.
You need to configure the custom column value by using the update record step.
What should you do?
- A. Add a formula that evaluates the two column values and uses the first populated value or else the default value.
- B. Add an expression that evaluates the two column values and uses the first populated value or else the default value.
- C. Add the two columns with the default value by using the Forms Assistant. Correct
- D. Add check conditions to determine if the two columns contain data.
Explanation
In the Update Record step, select Set Properties and use the Form Assistant on the custom column. Add Account Number as the first dynamic value and Ticker Symbol as the second, in that order, then enter N/A as the default value. The workflow uses the first column that has data, and uses the default value when none of them do, so one update step meets all three conditions. Classic workflows do not support formulas or expressions for column values (A, B). Check conditions (D) would need separate branches and update steps, so they do not meet the requirement to set the value in the update record step.
A company uses a canvas app.
Supervisors must approve transactions when a user from the sales department enters a revenue amount that is over $1 million.
You need to configure an approval process without using code.
What should you create?
- A. Power Automate cloud flow Correct
- B. Power Apps component framework (PCF) control
- C. Column Expression
- D. Azure Service Bus service
Explanation
Power Automate cloud flow is the correct choice because it allows configuring automated approval processes based on specific conditions without requiring custom coding. This aligns with the requirement to approve transactions over $1 million entered by sales department users in a canvas app.
A company creates a Power Automate cloud flow for a Power Apps app.
The cloud flow must send a daily email that contains a list of year-to-date (YTD) totals.
You need to configure the flow.
Which feature should you use?
- A. Loop Correct
- B. Wait
- C. Condition
- D. Parallel branch
Explanation
The Loop feature is necessary to iterate over the list of year-to-date totals to compile them into an email. This ensures each item in the list is processed for inclusion in the daily report.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a model-driven app.
The company needs to automatically update the Status column in real time.
You need to configure this feature.
Solution: Create a flow that has an Update item action.
Does the solution meet the goal?
Explanation
No. A Power Automate cloud flow runs asynchronously, after the record is saved, so it cannot update the Status column in real time while the user works in the form. Update item is also a SharePoint connector action, not the Dataverse action that a model-driven app's tables use (Update a row). For a real-time update of a column in a model-driven app, use a synchronous option such as a business rule, a calculated or formula column, or a real-time classic workflow.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a model-driven app.
The company needs to automatically update the Status column in real time.
You need to configure this feature.
Solution: Create a workflow that has an Update Record step.
Does the solution meet the goal?
Explanation
The solution does not meet the goal. Classic Dataverse workflows can run in real time (synchronously), but the Update Record step is not how a workflow changes a row's status. Dataverse workflows provide a separate Change Status step, which changes the status of the row the process runs on or of related rows. Status (and the status reason that goes with it) is set through a state change, not through the column values that the Update Record step sets. To update the Status column automatically, the workflow must use the Change Status step, so a workflow that only has an Update Record step does not meet the requirement.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a model-driven app.
The company needs to automatically update the Status column in real time.
You need to configure this feature.
Solution: Create a flow that has an Update a row action.
Does the solution meet the goal?
Explanation
Creating a flow with an Update a row action can update the Status column but does not ensure real-time updates. Real-time updates require immediate changes without waiting for a flow to trigger, which flows inherently do not provide due to their asynchronous nature.
A company uses a model-driven app. The app uses a workflow to send email. Emails are sent to new customers that enter an email address for the first time in the app.
Customers report that they do not receive an email after entering an email address.
You need to troubleshoot the issue.
In which order should you perform the actions? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
1. Clear the option to delete the workflow retention jobs — by default, completed (successful) workflow jobs are deleted automatically, so clearing Automatically delete completed workflow jobs keeps the process session records you need to troubleshoot.
2. Run the workflow — trigger it again (for example, by entering an email address on a record or running it on demand) so a new job is recorded.
3. Review the tab with the process sessions — the Process Sessions for the workflow show the status of each run and which step failed or was skipped, and why.
4. Edit the workflow — with the cause identified, deactivate and edit the workflow to correct its trigger or Send Email step, then activate it again.
A company has a Power Apps app.
The app must meet the following requirements:
• Managers assign lead records to the sales department. A new phone call record must be created if a lead record has no activities.
• An email must be sent to the manager if the phone call record created is not completed after one day.
A classic workflow must run when a lead record is assigned.
You need to configure the check conditions for the workflow.
Which value should you use for each condition? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Number of activities for new phone call record: Process Activity Count — A classic workflow check condition can test values of the process itself as well as of the record. Process Activity Count is the process value that holds how many activities the workflow has created, so the condition is built on it to decide whether the Create Record (Phone Call) step runs. The values 0 and 1 are only constants to compare against; they are not the thing the condition checks.
Duration for email sent to manager: Lead Created On + 1 Day — A wait or timeout condition in a classic workflow resumes at a point in time, set by picking a date field on the record and adding an offset of one day. Lead Created On + 1 Day gives that fixed point, after which the workflow checks whether the phone call is still not completed and sends the email to the manager. A plain 1 Day gives a length of time but no date to count from. Lead Modified On changes every time the lead is edited, so the deadline would keep moving.
You plan to create classic workflows for process automation on the Account table.
The process automation has the following requirements:
• If the Account Name column changes, a custom column named Previous Name must be updated with the original value.
• If the Credit Limit column changes, an email must be sent to the record owner with the new value.
• Asynchronous processes must be used whenever possible.
You need to implement the process automation.
What is the minimum number of workflows you should use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Background: 1. The Credit Limit notification only needs the new value and the record owner, both available after the change is saved, so it can run asynchronously in one background workflow triggered when the Credit Limit column changes. That meets the requirement to use asynchronous processes whenever possible.
Real-time: 1. Copying the original Account Name into Previous Name has to happen before the change is saved. Only a real-time workflow can be set to start Before the row's columns change (the pre-operation stage), when the old value is still available. A background workflow runs after the update is committed and would read only the new name. The two requirements need different execution modes, so they cannot be combined into a single workflow. The minimum is therefore one background workflow and one real-time workflow.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A company uses a model-driven app.
The company needs to automatically update the Status column in real time.
You need to configure this feature.
Solution: Create a workflow that has a Change Status step.
Does the solution meet the goal?
Explanation
A classic Dataverse workflow can be configured as a real-time (synchronous) workflow by clearing the 'Run this workflow in the background' option, so it runs immediately as part of the triggering operation. The workflow's Change Status action changes the status of the row the process runs on (or related rows), so a real-time workflow with a Change Status step updates the Status column automatically and in real time.
A company uses Power Apps to create maintenance requests. The maintenance manager emails the manager of the department noted in the request.
The maintenance manager wants to automate the email process when a new maintenance request is created.
You need to build a Power Automate flow to automate the email process.
Which three components should you add to the flow in sequence? To answer, move the appropriate components from the list of components to the answer area and arrange them in the correct order.
Explanation
A Power Automate cloud flow always starts with a trigger, here the creation of a new maintenance request row. A condition then checks the request (for example, which department it belongs to) so that the right manager is emailed, and an action such as Send an email runs in the condition's branch. Stages belong to business process flows and classic workflows, and a data step is not a cloud flow component, so neither is used here.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create a filter for the Underage Prospects view.
How should you set up the expression for the filter? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Underage Prospect filter — first dropdown (field): Age at Registration — the scenario defines a prospect as underage if they are younger than 18 years old at the time of registration, and Age at Registration is the calculated field that already holds exactly that value, so filtering on it matches the business definition and keeps returning correct results every week without editing the view. Current Age is measured against today's date, so a prospect who registered at 17 would drop out of the view on their eighteenth birthday even though they registered underage; Birthdate (even with a relative operator such as Last x years) also reflects the prospect's current age rather than the age at registration, and Created On describes when the record was created, not the prospect's age.
Underage Prospect filter — second dropdown (operator, applied to value 18): Is less than — Age at Registration is a numeric calculated field, and "Is less than 18" returns everyone younger than 18, which is precisely the underage definition. "Is greater than" would invert the logic and return prospects over 18, while "Last x years" and "Older than x years" are date operators that apply to date fields such as Birthdate or Created On, not to a numeric age column.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to create a flow to send an email to the primary contacts.
Which action should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Select a flow trigger: Recurrence. The consent email must be sent automatically every week, and the Recurrence trigger starts a cloud flow on a fixed schedule such as weekly. "When a row is added, modified, or deleted" fires on each record change rather than on a weekly schedule, and "Manually trigger a flow" depends on someone starting it by hand.
Find primary contact: Get a row by ID. The underage prospect's Primary Contact lookup already holds the unique identifier of the parent's Contact row, so the Dataverse "Get a row by ID" action returns exactly that record and its email address. "List rows" queries a set of records with a filter rather than resolving a known lookup value, and "Condition" only evaluates logic and returns no record data.
Create email: Send an email (V2). This action composes and sends the message from the user's mailbox in one step, so the body can include the team website link and the current date with the full month name, date, and year, and with server-side synchronization configured the email can be tracked to the contact record in Dataverse. "Send an email notification (V3)" sends from a generic Microsoft notification service address, not a synchronized mailbox, so it is not tracked. "Add a new row" only creates an unsent email record, and "Perform a bound action" needs an existing record and does not author the message.
You are creating Power Automate automations targeting Dataverse.
The automations must meet the following requirements:
• Run a custom API created by a developer. The API performs an action against an existing Account row in the system.
• Create three rows in Dataverse. If an error occurs when you create the second row, the first row must be deleted.
• Run several create, update, and delete operations as part of a single transaction without writing custom code.
• Run several complex operations targeting multiple rows in the system as part of a single transaction.
You need to configure the actions.
Which actions should you configure? To answer, move the appropriate actions to the correct requirements. You may use each action once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
Explanation
A custom API that acts on an existing Account row is bound to the Account table, so call it with Perform a bound action. A changeset request groups Add a new row, Update a row and Delete a row actions into a single transaction: if any operation fails, the successful ones are rolled back, so it handles both creating three rows where a failure on the second must undo the first, and running several create, update and delete operations in one transaction without custom code. Complex operations across multiple rows in one transaction need custom business logic, such as a developer's custom API or action that runs as a single operation, which is called with Perform an unbound action. Add a new row on its own creates one row with no transaction.
A company has a business process flow that executes on the Contact table.
The company requires that the steps in the flow be executed in real time when users create a new task and update the status of a Contact row.
You need to implement a solution that automates the steps.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation
1. Create a new business process flow on the Contact table in the business process flow designer, so the stages and steps are defined for the process.
2. Add a flow step to the stage, so that an automation runs from the business process flow at that point in the process.
3. Create a new custom action with action steps. Custom actions run synchronously in real time, so the steps run when users create the task and update the status of the Contact row, without waiting for an asynchronous process.
Activating, updating or creating a separate cloud flow is not part of this sequence: cloud flows run asynchronously and would not meet the real-time requirement.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
ADatum Corporation provides verification and investigation services that are used by insurance companies, law firms, and other organizations in the public sector. Services include verifying an individual’s background, qualifications, and specific scenarios that require onsite visit.
The thorough work ADatum Corporation performs results in highly accurate cases with minimal critical information missing. Because of these high-quality results, ADatum Corporation is quickly proving itself as one of the best in the industry. In recent months, business has significantly increased, with most new business coming from high-profile companies and individuals.
Management has decided to create a new qualification verification (QV) role to help ensure that clients get the most accurate results. This role examines completed work to ensure that nothing is missed.
Current environment -
Data storage and retention -
• All information sent by clients for services is stored in Microsoft Dataverse with a model-driven app as the interface.
• Clients enter their data in a website, which then uses a service account to create the records in the Dataverse database.
• Team members currently have full access to all Service Request records.
Service requests -
• The Service Request table includes header information about the individual or organization that is the subject of verification.
• New Service Request records are assigned to a queue. All potential users who will be performing the verifications have access to these records.
• A service request is assigned to a single user who will ensure that all qualifications are verified. This single user is the only one able to process Qualification records related to their own service requests.
• Many required tasks when performing verification services are currently done by using manual processes.
• To keep up with demand, ADatum Corporation identifies several processes that can be replaced by using Power Automate flows to hire fewer new staff and keep costs down.
Qualification verification -
• The qualification table contains details about an individual school degree, professional qualifications, and other qualifications that must be verified.
• A service request can have one or more Qualification records associated with it.
• Record status is pending verification until the initial team member finishes, at which point the member changes the status to Complete.
• When all qualification records related to a service request are verified either by manual or automated processes, the results are made available to ADatum Corporation’s client.
• In the rare event that results are questioned, a new service request is created and verified independently of the previous work that took place.
• To complete a service request, users perform the following actions: o Send a templated email by using Microsoft Outlook to the client after all qualifications for a service request are checked. o Change the service request status to Completed. Currently, service requests do not indicate when all Qualification records are addressed.
Microsoft Power platform environment
• The following environments exist: development, testing, user acceptance testing (UAT), and production.
• Managed solutions are used to move customizations from the development environment to other higher-level environments. These solutions are created and maintained by the power users and provided to internal IT for deployment when they are ready.
• Two managed solutions, Verification Process Automation and Onsite Visit, share several components.
• All customizations to Power Platform components are performed by several power users who have received training and are certified as subject matter experts.
• Power users have been granted the System Administrator security role in the development environment.
• Corporate policy prohibits power users from writing code due to lack of a formal code review process.
• Internal IT will not be able to supply any development resources for this project due to a lack of staff. This means that any customizations and automation created for this project must be low-code/no-code for the power users to implement them.
• Customizations created by power users are deployed by internal IT.
Requirements -
Process automation -
ADatum Corporation plans to establish a new QV department to verify completed work so that the quality of work is maintained. The new process for verifying professional qualifications must automate the following:
• Enter data and navigate the authority’s website. The authority website UI changes frequently because the company constantly improves the user experience.
• Search page contents for a specified value to determine validity.
• Update the corresponding Qualification record in Dataverse.
The new process for completing a service request must automate the following:
• Set the Service Request record status to Complete when work on all Qualification records is finished.
• Send an email to the client with the results when the service request is completed. The email must list each qualification as either Valid or Not Valid, depending on the verification.
Qualification verification -
• Service request results will not be released to clients until all related Qualification records are set to a Complete status.
• To check work done by a wide array of users, 10 percent of Qualification records must be double checked.
• Qualification records must be automatically assigned to a queue.
• Qualification records must be flagged with a new status field named Assigned to ensure that records are rechecked.
• Ensure that only QV team members can change the status from Assigned to In Progress to Complete.
• Record the name of the QV team member who performed the work and the date completed.
Governance and security -
• All components required for the verification process must be included in a new solution.
• Corporate security requires that deployments to non-development environments must be automated using service accounts.
• User security and data access must also be consistent across environments, except for the elevated access of the power users in the development environment.
• The Onsite Visit managed solution has a table that is not in the Verification Process Automation managed solution. This table must be upgraded prior to the go-live date without the other shared components.
• A VP of sales requires a test environment to demonstrate to potential clients the security policies that are included in their initial offering.
Issues -
• More employees than are required can access individual client information and continue to have access after a service request is completed.
• When users go on vacation, all their outstanding Service Request records are assigned to a substitute employee. The substitute employees are unable to see all the qualifications related to their service requests.
• Currently, testing the new QV functionality outside the development environment is not possible due to corporate security policies requiring the same security role across all environments.
• Internal IT reports that the solution import to the test environment failed because of missing dependencies related to the flow for completing service requests.
You need to create the automation for the qualification verification process.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Add a Dataverse connector. Correct
- B. Add an Outlook connector. Correct
- C. Create an on-premises data gateway reference.
- D. Update the Qualification records to finished.
- E. Create a Service Request record.
Explanation
Adding a Dataverse connector allows for updating Qualification records based on verification results. Adding an Outlook connector enables sending templated emails to clients after all qualifications are verified.
A company is using the Account table and a main form named Account Main.
The company defines the following requirements for the Account Main form:
• Evaluate a single value selected as part of a drop-down list.
• Display a message and suggestion based on business intelligence if the drop-down list value equals a specific value.
• Logic must run against this form only.
You need to implement the logic.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
Explanation
A single-select drop-down list is a choice column; a choices (multi-select) column would allow several values and is not supported by business rules. Create a business rule on the Account table, set its scope to the Account Main form so the logic runs on that form only, and add a Recommendation action, which shows a message and suggestion based on business intelligence when the condition on the choice value is met. Recommendations are available only for form-scoped business rules, so Entity scope does not apply, and Show Error Message only displays an error without a suggestion.
A company creates a Power Automate cloud flow for a Power Apps app.
The cloud flow must send an email to each active contact.
You need to configure the flow.
Which feature should you use?
- A. Condition
- B. Apply to each Correct
- C. Wait
- D. Parallel branch
Explanation
The 'Apply to each' feature in Power Automate is used to iterate over a list or array of items. In this scenario, it will be used to send an email to each active contact, making it the correct choice.
You are creating a cloud flow for an automation targeting Dataverse.
When a new account is created in Dataverse, the name of the account must be updated based on the following logic:
• If the Account Category Code equals Preferred Customer (1), pre append the value Preferred | to the name.
• If the Account Category Code equals Standard (2) or is not populated, pre-append Standard | to the name.
You need to define the correct formula to use for the automation.
Which formula should you use?
- A. if(equals(triggerOutputs()?['body/accountcategorycode'], 1), concat('Preferred | ', triggerOutputs()?['body/name']), concat('Standard | ', triggerOutputs()?['body/name'])) Correct
- B. if(equals(triggerOutputs()?['body/accountcategorycode'], 2), concat('Standard | ', triggerOutputs()?['body/name']), concat('Preferred | ', triggerOutputs()?['body/name']))
- C. if(equals(outputs('trigger')?['body/accountcategorycode'], 1), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ', outputs('trigger')?['body/name']))
- D. if(equals(outputs('trigger')?['body/accountcategorycode'], 2), concat('Standard | ', outputs('trigger')?['body/name']), concat('Preferred | ', outputs('trigger')?['body/name']))
Explanation
Trigger values in a cloud flow are read with triggerOutputs()?['body/<column>'], not outputs('trigger'), which rules out C and D. Option A tests whether accountcategorycode equals 1 (Preferred Customer) and prepends 'Preferred | ' in that case; every other case, including Standard (2) and an empty value, falls to the else branch and prepends 'Standard | '. Option B tests for 2, so an empty category would wrongly get 'Preferred | '.
A cloud flow you authored failed several times in production due to a transient network issue. The issue is now resolved.
You need to reprocess the failed flow runs with the least amount of administrative effort.
What should you do?
- A. Resubmit each run individually.
- B. Resubmit all runs in bulk. Correct
- C. Rerun the trigger action.
- D. Turn the flow off and then on.
Explanation
Resubmitting all runs in bulk is the most efficient method to reprocess failed flow runs with minimal administrative effort. This approach allows for the simultaneous resubmission of multiple failed runs, reducing the need for individual handling.
You are creating a Power Automate cloud flow. The cloud flow will create several SharePoint Online list items based on a variety of conditions.
If any of the dependent SharePoint Online actions fail, you must revert the changes while the automation runs.
You need to design the cloud flow to meet the requirement.
Which two actions should you implement for the design? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Add a scope. Correct
- B. Set Run After to Has failed. Correct
- C. Perform a changeset request action.
- D. Retrigger the flow run.
Explanation
Adding a scope allows for the grouping of actions to control their collective execution and handle failures uniformly. Setting 'Run After' to 'Has failed' enables specific actions to execute in response to a failure within the scope, facilitating rollback or corrective measures.
A company has a Power Apps app.
The app must meet the following requirements:
• Managers assign lead rows to the sales department. A new phone call row must be created if a lead row has no activities.
• An email must be sent to the manager if the phone call row created is not completed after one day.
A classic workflow must run when a lead row is assigned.
You need to configure the check conditions for the workflow.
Which value should you use for each condition? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Number of activities to evaluate for the new phone call row: Process Activity Count. In a classic workflow check condition you can evaluate values of the process itself, not only of the row. Under Process, Activity Count gives the number of activities related to the row, so the condition can test whether it equals 0 and create the phone call only when the lead has no activities. The literal values 0 or 1 are only static numbers with nothing to compare them against.
Duration to delay before sending an email to the manager: Lead Created On + 1 Day. A wait condition or process timeout in a classic workflow is set relative to a date and time column on the row plus an offset. Created On never changes, so the deadline stays fixed; when it passes, the workflow checks whether the phone call is completed and emails the manager. Lead Modified On + 1 Day would move each time the lead is edited and keep pushing the deadline back, and a bare 1 Day is not anchored to any row date in the choices given.
A company uses Power Automate extensively.
The company maintains the following three environments:
| Environment name | Dataverse enabled | Purpose |
|------------------|-------------------|---------|
| Environment1 | No | Used for a small task management application. Administrators of the environment must be able to view failed flow run details only. |
| Environment2 | Yes | Stores highly sensitive data that must not leave the geographical boundary. Auditing policies dictate that all activities must be stored for 90 days. Administrators need to receive automatic smart detection alerts. |
| Environment3 | Yes | Central environment for the company, used to store analytical data for all cloud flow runs across the tenant which then surface in a model-driven app. No flows execute in this environment. |
You need to recommend a monitoring solution for each environment. The solution must minimize development effort.
Which tools should you recommend? To answer, move the appropriate tools to the correct environments. You may use each tool once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Environment1: Power Platform admin center — The Power Automate analytics in the Power Platform admin center include an Errors report that shows recurring flow errors with counts, the flow, its creator and the last occurrence. Environment admins can view it with no setup, and it does not depend on Dataverse, which this environment lacks; it covers exactly the need to view failed run details only.
Environment2: Application Insights — Cloud flow run, trigger and action telemetry can be exported from a managed, Dataverse-backed environment to an Application Insights resource through Data export in the admin center. You choose the Azure region of the resource, so the data stays inside the required geography, Application Insights retains data for 90 days by default, and it provides smart detection alerts that notify administrators of anomalies automatically.
Environment3: Power Automate Management connector — A central environment that runs no flows of its own needs to collect data about cloud flows in every environment in the tenant and store it in Dataverse for a model-driven app. The Power Automate Management connector (the approach the CoE Starter Kit uses) retrieves flows and their runs across environments and writes them into Dataverse tables, without custom code.
Microsoft Purview is not needed: it audits user and admin activity rather than monitoring flow run health or raising smart detection alerts.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating Power Virtual Agents chatbot that captures demographic information about customers.
The chatbot must determine the group a customer belongs to based on their age. The age groups are:
✑ 0 - 17
✑ 18 - 25
✑ 26 - 35
✑ 36 - 55
✑ 55 - 100
You need to configure the chatbot to ask a question that can be used to determine the correct age group.
Solution: Use age for Identify in the question and then add branches for each group that use conditional logic.
Does the solution meet the goal?
Explanation
The solution meets the goal. Age is a prebuilt entity, so a Question node set to Identify Age pulls the customer's age out of their answer and saves it as a number in a variable. You can then add one Condition branch per age group. Each branch combines two number comparisons with And, for example Age is greater than or equal to 18 And Age is less than or equal to 25. The topic follows the branch whose condition is true, so every customer lands in the right group.
You are designing a Power Virtual Agents chatbot.
The chatbot must be able to maintain customer information if the conversation topic changes during a dialog.
You need to configure variables to store customer name and email address.
Which type of variable should you create?
- A. session
- B. slot
- C. bot Correct
- D. topic
Explanation
Bot variables (now called global variables) are available in every topic of the bot. Their values persist for the whole user session, so the customer's name and email address stay available when the conversation moves to another topic. Topic variables can be used only in the topic where they are created, unless they are passed explicitly. Slot is an entity-filling concept, not a variable scope, and Power Virtual Agents has no separate 'session' variable type.
You are designing a Power Virtual Agents chatbot for a store.
You need to teach the chatbot to acknowledge the store's product categories and the variations within specific categories.
You need to create custom entities to provide the chatbot with the knowledge of the product categories.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Analyze misspellings, grammar variations, and semantic variations: Smart matching — When you build a custom closed-list entity in Power Virtual Agents, enabling Smart matching lets the bot automatically correct and interpret user input that does not exactly match a list item, covering typos, grammatical forms (singular/plural, verb tense), and semantically related wording. Fuzzy matching is not a Power Virtual Agents entity option, and Topics only define conversation paths — neither performs this input analysis.
Make the bot smarter by expanding the matching logic: Synonyms — Each item in a custom entity's list can be given synonyms, so alternative words customers use for the same product category (for example "sofa" for "couch") still resolve to that single list item, broadening what the entity recognizes. Slot filling stores a matched value rather than expanding what can be matched.
Extract a category selected by a user during a conversation into a variable for later use: Slot filling — Slot filling is the mechanism that takes the entity value the bot detects in the user's utterance and saves it into a variable, so the selected product category can be reused later in the topic or passed to a Power Automate flow. Smart matching and Synonyms only improve how the value is recognized; they do not capture it into a variable.
A customer has a support website that includes FAQ pages, knowledge articles, and support content.
You plan to leverage an existing Power Virtual Agents bot to enhance and streamline existing support functionality for the existing support portal.
You need to create topics from existing website content. The process must minimize human errors during topic creation.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
1. Capture suggested topics: in the Topics page, use the topic suggestions feature and point it at the support site's FAQ and knowledge pages so the bot extracts suggested topics from the existing content automatically, which avoids errors from authoring topics by hand.
2. Add selected topics to the chatbot: review the suggestions and add the ones you want; each is created as a topic with its trigger phrases and messages already filled in from the web content.
3. Enable the topics: topics added from suggestions are created turned off, so turn them on so the bot can use them in conversations.
Identifying pre-filled trigger phrases and the Automate icon are not required steps to create topics from existing website content.
You are creating a Power Virtual Agents chatbot that uses multiple topics.
Each user interaction can reference more than one topic.
You need to be able to capture a value in an initial topic and use it in subsequent topics.
Which type of variable should you create?
- A. Context
- B. Bot Correct
- C. Topic
Explanation
The 'Bot' variable type in Power Virtual Agents is global, meaning it can be accessed and used across all topics within the chatbot. This makes it suitable for capturing a value in an initial topic and using it in subsequent topics.
A company has a custom website.
You need to embed a Power Virtual Agents chatbot into the website.
What should you use?
- A. Webpage URL
- B. Form ID
- C. Bot ID
- D. Custom web channel Correct
Explanation
To embed a Power Virtual Agents chatbot into a custom website, you should use the Custom web channel. This method allows for integration directly within the specified webpage, facilitating interaction between the bot and website visitors.
A company is developing several Power Virtual Agents chatbots. The company manufactures more than 1,000 different products.
The chatbots must prompt users to enter or select a product.
You need to store the product information so that it can be reused across all chatbots.
Where should you store the model data?
- A. Global variables
- B. Custom entities Correct
- C. Topics
- D. Multiple choice options
Explanation
A custom (closed list) entity holds a list of values, such as the 1,000+ product names with synonyms, that topics can use to prompt the user and recognize the product they enter or select; the same entity can be reused by every topic and recreated in other chatbots, instead of retyping the list in each question. Multiple choice options are defined inside a single question and suit only a few choices, not more than 1,000 products. Global variables store values captured during a conversation, not a predefined list of products, and topics define conversation paths rather than store data.
A company creates a Power Virtual Agents chatbot.
You need to determine when live agents are engaged to provide support.
Which metrics should you use? To answer, drag the appropriate metrics to the correct processes. Each metric may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
Explanation
Determine which topics are transferred to live agents most often: Escalation rate drivers. This chart lists the topics with the highest escalation rate, so it shows which topics most often end in a hand-off to a live agent.
Determine the number of chats per day that are transferred to live agents: Session outcomes over time. This chart shows, per day, how many sessions ended in each outcome (resolved, escalated, abandoned, unengaged), so the escalated count gives the daily number of chats transferred to live agents. Escalation rate is a single percentage rather than a daily count, and Engagement over time shows engaged sessions in total, not which were escalated.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating Power Virtual Agents chatbot that captures demographic information about customers.
The chatbot must determine the group a customer belongs to based on their age. The age groups are:
✑ 0 - 17
✑ 18 - 25
✑ 26 - 35
✑ 36 - 55
✑ 55 - 100
You need to configure the chatbot to ask a question that can be used to determine the correct age group.
Solution: Use Date and time for Identify in the question and then add branches that use conditional logic to determine the age group.
Does the solution meet the goal?
Explanation
The solution does not meet the goal because using Date and time for Identify in the question is not appropriate for determining age groups. Instead, the chatbot should ask for the customer's age directly and use conditional logic to determine the correct age group based on the provided age.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating Power Virtual Agents chatbot that captures demographic information about customers.
The chatbot must determine the group a customer belongs to based on their age. The age groups are:
0 - 17
✑ 18 - 25
✑ 26 - 35
✑ 36 - 55
✑ 55 - 100
You need to configure the chatbot to ask a question that can be used to determine the correct age group.
Solution: Use multiple choice options for Identify in the question and create options that represent each of the age groups.
Does the solution meet the goal?
Explanation
The solution meets the goal because using multiple choice options allows the chatbot to categorize customers into predefined age groups effectively. Each customer can select one option that best represents their age, ensuring accurate group determination.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
You are creating Power Virtual Agents chatbot that captures demographic information about customers.
The chatbot must determine the group a customer belongs to based on their age. The age groups are:
✑ 0 - 17
✑ 18 - 25
✑ 26 - 35
✑ 36 - 55
✑ 55 - 100
You need to configure the chatbot to ask a question that can be used to determine the correct age group.
Solution: Create a custom Age group entity and synonyms for each individual age in the corresponding item. Use Age group for Identify in the question.
Does the solution meet the goal?
Explanation
The solution of creating a custom Age group entity with synonyms for each age within the corresponding groups and using it in the question does meet the goal of determining the correct age group. Although not optimal, this method can effectively categorize customers into predefined age groups based on their input.
You create a new Power Virtual Agents chatbot for an organization.
Testing and production deployment of the chatbot are not complete.
You need to ensure that appropriate users can access the chatbot.
Which methods should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Test the chatbot with unlicensed internal users: Use the demo website — the demo website is the built-in pre-production channel meant for collecting feedback from colleagues before go-live; testers only need the link to chat with the bot. Sharing the bot (individually or with a security group) is limited to users who hold a Power Virtual Agents (Copilot Studio) license, so neither sharing option works for unlicensed testers.
Allow other licensed internal users to edit the chatbot: Share the chatbot to each user individually — sharing for collaborative authoring gives co-authors permission to view, edit, configure, share and publish the bot, and it can only be granted to individual users in your organization. Security groups can be granted permission to chat with the bot, but not to co-author it, and deploying to Microsoft Teams only lets people chat with the bot.
Deploy the chatbot to production for public consumption: Embed the chatbot code in an IFrame on your company's public website — after publishing, the custom website channel provides embed code, and an IFrame on the public site exposes the bot to external visitors, which is what public consumption requires. Deploying to Microsoft Teams only reaches users inside your own tenant, and AppSource distributes the bot as an app for other organizations to install rather than serving customers on your website.
You are designing a chatbot for a sports outlet.
You need to complete the chatbot.
Which features should you use? To answer, drag the appropriate features to the correct requirements. Each feature may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Relate to a real-world object: Entities. An entity represents a real-world object or concept (such as a product, size, city or date), so the bot can recognize that information in what the user says.
Define the path and triggers: Topics. A topic holds the trigger phrases that start it and the conversation path (messages, questions and conditions) the bot follows.
Conditional routing: Variables. Variables store what the user answered or what the bot looked up during the conversation, and condition nodes test those values to send the conversation down different branches. Flows (Power Automate) call external actions and services; they don't do the routing inside a topic.
A company has marketing teams for different regions.
A user creates and publishes a chatbot within Microsoft Teams for their specific marketing team.
The base metrics retrieved by the chatbot are relevant to all marketing teams.
The other marketing teams request access to the chatbot.
You need to publish the chatbot to the entire company.
What should you do?
- A. Configure the chatbot to be used with the Teams channel.
- B. Submit the chatbot for admin approval. Correct
- C. Copy the published chatbot link and email it to the other teams.
- D. Invite the other teams to the team that has the chatbot.
- E. Export the chatbot and import it into a corporate environment.
Explanation
Submitting the chatbot for admin approval is necessary to make it visible in the Microsoft Teams app store under 'Built by your org', allowing all marketing teams within the company to access and use it.
You create a Power Virtual Agents chatbot to reduce the number of incoming support calls that require a live person.
The chatbot does not direct users to the correct information. You determine that this is because the chatbot is not able to identify which product a user is referring to in a conversation.
You need to present a list of products so that users can select the correct product.
What should you create?
- A. Table
- B. Variable
- C. Slot filling
- D. Entity Correct
Explanation
Creating an entity allows you to define a set of related terms or items, such as products, that users can select from. This aligns with the requirement to present a list of products for user selection in Power Virtual Agents.
You are creating a Power Virtual Agents chatbot for a Microsoft Power Platform power apps portal app.
The job title of users must be stored automatically when users log in. The job title must always appear in the chatbot.
You need to configure the job title functionality.
Which mechanism should you use?
- A. artificial intelligence
- B. variable Correct
- C. entity
- D. topic
Explanation
A variable in Power Virtual Agents is used to store information such as the job title of users throughout their conversation. By setting a variable upon user login, you can ensure that this data persists and is displayed consistently within the chatbot.
You are designing a Power Virtual Agents chatbot.
The environment you plan to use does not appear as an option in the Power Virtual Agents user interface.
You need to ensure that you can create the chatbot in the environment.
What should you do?
- A. Change the region for the environment.
- B. Convert the environment to a sandbox environment.
- C. Create an environment in a supported region. Correct
Explanation
Creating an environment in a supported region ensures that it will be available for selection in the Power Virtual Agents user interface. Changing regions or converting to a sandbox does not address the availability of the environment option.
You are a system administrator for a company with locations in Mexico, United States, and France. The company has both fulltime employees and contractors in all regions. Fulltime employees use a mobile app. The company has two security groups: fulltime employees and contractors.
The company requests a chatbot in Microsoft Teams to answer employee benefit questions. The chatbot must meet the following requirements:
• It must be in the local language.
• Only fulltime employees may access the chatbot.
You need to configure the chatbot.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Chatbot in local language: Create one chatbot that manages all three languages. — A Copilot Studio (formerly Power Virtual Agents) agent can be configured as a multilingual agent with a primary language and secondary languages, so the benefit topics are authored once and the agent answers in English, Spanish, or French based on the user's language. Three separate chatbots would triple the authoring and maintenance of identical benefit content, and Teams channels have no language setting that changes the language the bot itself responds in.
Employee access: Publish the chatbot in Teams. — The company asked for the chatbot in Microsoft Teams, so it must be published to the Teams channel; when it is made available in Teams its availability can be limited to the fulltime employees security group, so contractors cannot use it. Sharing the chatbot on its own does not deliver it in Teams, the mobile app channel would put the bot in the company's mobile app rather than in Teams, and AppSource is a public marketplace for distributing apps to other organizations, which is the opposite of restricting access to internal fulltime employees.
A company sells all types of bicycles, bicycle parts, and accessories. You are creating a chatbot by using Microsoft Power Virtual Agent for the bicycle shop.
When someone types in a bicycle brand name or terms such as helmet or shoes, the chatbot must automatically go to the accessories section of the chatbot.
You need to configure the chatbot functions.
Which two functions should you configure? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Entities Correct
- B. Fallback topic
- C. Smart matching
- D. Synonyms Correct
- E. Slot filling
Explanation
Entities (A) are used to define specific terms like bicycle brands and accessories that the chatbot should recognize. Synonyms (D) ensure that related terms are understood as equivalent, directing users effectively to the accessories section.
You plan to create a Power Virtual Agents bot.
The bot must support single sign-on.
You need to publish the bot.
Which two locations should you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Mobile app developed for iOS and Android
- B. Website developed using pro developer tools Correct
- C. Microsoft Teams Correct
- D. Azure Bot Service channels
Explanation
Single sign-on with Microsoft Entra ID is supported only on certain publishing channels. A custom website built with pro developer tools supports SSO: the bot is hosted in a custom canvas that uses MSAL to exchange the signed-in user's token. Microsoft Teams also supports SSO once the Teams SSO settings are configured. SSO is not supported for Azure Bot Service channels or for the mobile app channel, so those locations do not meet the requirement.
A company is planning to create a Power Virtual Agents bot.
The bot has the following requirements:
• The bot must provide address information for the company.
• The bot must be available from Microsoft Teams and from the internet website of the company.
You need to configure the bot.
Which component should you use?
- A. Channel Correct
- B. Template
- C. Composer
- D. Skill
Explanation
Channels in Power Virtual Agents enable the bot to be accessible from various platforms including Microsoft Teams and websites. This meets the requirement for the bot's availability.
A company plans to implement a voice-enabled Power Virtual Agents bot.
The company has the following requirements for the bot:
• Recognize when a caller states Tennis or any variation of the word.
• Provide options when a caller states the name of a sport.
You need to configure the bot.
Which features should you use? To answer, select the appropriate options in the answer area.
Explanation
Recognize when caller states Tennis.: Entity — Entities are the Power Virtual Agents building block for identifying a real-world piece of information in what a caller says, and a closed list custom entity lets you define "Tennis" with synonyms and variations (tennis match, lawn tennis, and so on) plus smart matching, so spoken variants and misspellings still resolve to the same item. A Variable only stores a value once it has been captured and does nothing to recognize the word, and a Topic is matched on overall intent through trigger phrases rather than extracting a specific term.
Provide options when caller states name of sport.: Topic — A topic is the conversation path that gets triggered when the caller's utterance matches its trigger phrases, and its authoring canvas is where you add the question node with multiple choice options presented back to the caller. An Entity would only recognize the sport name without driving any conversation, and a Variable merely holds the caller's selection rather than presenting the choices.
A company plans to implement chatbots by using Power Virtual Agents.
The company has the following requirements for the bots:
• Users in the accounting department must be able to create a bot for frequently asked questions.
• The support desk users must be able to use the bot.
The users must not be able to change environment parameters in the Microsoft Power Platform environment.
You need to configure the permissions for the bots.
Which actions should you implement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Users can create a bot.: Assign users to a security role. — Creating a Power Virtual Agents bot requires the maker-level privileges that come from a Dataverse security role in the target environment, such as Environment Maker; assigning accounting-department users that role lets them build bots without granting environment-level control. Assigning the System Administrator role would work technically but violates the requirement that users must not be able to change environment parameters, since administrators can modify environment settings.
Support desk users can use the bot.: Share the bot with a security group. — Power Virtual Agents bots are shared for use by adding users or an Azure AD security group as bot users, which grants chat access only and no authoring or environment rights. Assigning the support desk users Maker permissions instead would let them create and edit bots, which is more access than "use the bot" requires.
You use Power Virtual Agents to create a bot that will answer and transfer help desk calls.
You create topics that contain nodes and functions. The company has the following requirements for the bot:
• When a caller states the word issue, help, or problem, the bot must respond with the question, “How can we help you today?”
• When the bot responds with the question, “How can we help you today?”, the bot must provide the caller with the choices of hardware, software, or other.
• When the caller asks a question, the bot must save the response so that it can perform an action on the response.
You need to configure the bot.
Which nodes or functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Caller states issue, help, or problem.: Trigger phrase — Trigger phrases are the sample utterances defined on a Power Virtual Agents topic, and the bot's natural language understanding model matches what the caller says against them to decide which topic to start; adding "issue", "help", and "problem" as trigger phrases is what causes the topic (and its opening "How can we help you today?" message) to fire. A Question node cannot start a conversation on its own — it only runs once a topic has already been triggered.
Bot provides choices.: Question — A Question node asks the caller something and can be configured with "Multiple choice options", which renders selectable options such as hardware, software, and other. A Message node is the wrong choice here because it only displays text to the caller and neither presents choices nor waits for a response.
Responses are temporarily saved.: Variable — Every Question node stores the caller's answer in a variable, which holds the value for the remainder of the conversation so later nodes, conditions, or actions can act on it. An Action would call a Power Automate flow or plugin to do work with a value, but it is the variable that actually retains the caller's response.
A company creates a bot by using Power Virtual Agents.
The company requires the bot to transfer callers to an agent if the bot is unable to recognize a customer’s request.
You need to configure the bot for the unrecognized information from the customer.
Which feature should you use?
- A. Fallback skill
- B. Fallback topic Correct
- C. Fallback workstream
- D. Fallback entity
- E. Fallback queue
Explanation
The Fallback topic is designed to handle situations where the bot cannot understand or process a customer's request. Configuring this feature ensures that callers are transferred to an agent when the bot fails to recognize the information provided by the customer.
A company plans to create a Power Virtual Agents chatbot.
The bot has the following requirements:
• Prompt for a location of the customer and the call must be routed to a support agent for the location.
• Transfer support calls at each location to a support bot that uses the Bot Framework.
You need to configure the bot.
Which components should you use? To answer, drag the appropriate components to the correct requirements. Each component may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Route to location: Topics. A topic holds the conversation path: a Question node asks the customer for their location, and condition branches then route the conversation to the support agent for that location. Variables and entities only store or recognize the answer; the routing logic itself lives in a topic.
Route to support bot: Skills. A Power Virtual Agents (Copilot Studio) bot calls a bot built with the Bot Framework by registering that bot as a skill and invoking it from a topic, which hands the conversation to it. A variable only stores a value and cannot transfer the conversation to another bot.
A company is building a Power Virtual Agents chatbot.
Users in the accounting department require access to collaborate with the building of the bot. Users in the sales department require access to only chat with the bot.
You need to configure the bot.
Which sharing options should you use? To answer, drag the appropriate sharing options to the correct requirements. Each sharing option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Users in the accounting department: Users. A bot can be shared for collaborative authoring only with individual users, who get permission to view, edit, configure, share and publish it. Security groups and Everyone in the organization cannot be given authoring access.
Users in the sales department: Active Directory security groups. Sharing a bot with a security group gives its members permission only to chat with the bot, without authoring rights. Everyone in the organization also grants chat-only access, but it would include every user in the company, not just the sales department.
You create a Power Virtual Agents bot.
You observe that the bot is not able to recognize input from some users.
You need to configure the bot response for unrecognized input from users.
What are two possible ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Connect to a different channel.
- B. Display a system-defined error message.
- C. Use a fallback topic. Correct
- D. Transfer to an agent. Correct
Explanation
Use a fallback topic (C): the system Fallback topic is triggered On Unknown Intent when user input does not match any topic. You can customize it, for example by adding a catch-all response, calling a flow, or redirecting to another topic. Transfer to an agent (D): when the bot still cannot work out the intent after asking the user to rephrase, it hands the conversation to a live agent through the Escalate system topic. Configuring that hand-off is also a complete way to respond to unrecognized input. Connecting a different channel does not change how unrecognized input is handled, and there is no system-defined error message to configure for this case.
You plan to create a Power Virtual Agents bot.
The bot has the following requirements:
• Ensure that user responses are available to any topic.
• Recognize a list of words from spoken language of users.
You need to configure the bot.
Which features should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
User responses are available to any topic: Global variable — In Power Virtual Agents, a variable created inside a topic is scoped to that topic only, so its value is lost when the conversation moves elsewhere. Promoting it to a global variable makes the stored user response persist for the whole conversation and be readable and writable from any other topic; "Bot variable" is not the feature name used for this scoping (global variables are the mechanism), and an entity classifies input rather than storing it across topics.
Recognize a list of words from spoken language: Entity — Entities are the natural-language understanding building blocks that let the bot recognize a defined list of values and their synonyms in whatever a user says, including closed lists you author as a custom list entity. A topic is only a conversation path triggered by trigger phrases, and a variable merely holds a value once it has been extracted, so neither performs the recognition itself.
You deploy a Power Virtual Agents chatbot that integrates with Dynamics 365 Omnichannel for Customer Service.
You observe that the chatbot is not able to recognize the questions asked by users.
You need to ensure that the chatbot can respond to unrecognized questions. The solution must minimize administrative effort.
What should you do?
- A. Add a fallback topic. Correct
- B. Create new topics.
- C. Create an entity.
- D. Modify the Escalate system topic.
Explanation
Adding a fallback topic is the correct approach as it allows the chatbot to handle and respond to questions that do not match any existing topics, thereby minimizing administrative effort by not requiring the creation of new specific topics for each possible question.
A company deploys a chatbot that is embedded in a Power Pages website.
The company has the following requirements for the chatbot:
• Microsoft Entra ID users only must be able to use the chatbot when accessing sensitive data.
• The chatbot must be accessible only from the Power Pages website.
You need to recommend a solution that meets the requirements.
Which two options should you recommend? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Enable Only for Teams authentication.
- B. Configure a data loss prevention policy.
- C. Set up a new channel for the chatbot.
- D. Enable Manual authentication. Correct
- E. Enable web channel security. Correct
Explanation
Option D enables manual authentication, allowing the chatbot to authenticate users with Microsoft Entra ID. Option E ensures that the chatbot is accessible only from the Power Pages website by enabling web channel security.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study
-
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background
-
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment
-
Environment
-
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table
-
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table
-
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table
-
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website
-
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team.
o Schedule: A page open to everyone to view the tryout and game schedule.
o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only.
o Forms: A page that displays the consent form.
o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User.
o All primary contacts and prospects are assigned to their respective roles.
Requirements
-
Registration
-
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent
-
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect
o contain a link to the team website
o be automatically sent weekly and tracked to the contact record in Dataverse
o include the current date using the full month name, date, and year
Evaluations
-
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to configure the Primary Contact field.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Primary Contact data type: Lookup. Parents and prospects are both contacts and must be linked, so the Primary Contact column has to be a lookup to the Contact table (a self-referential relationship). A Text or Choice column only stores a value and creates no link to the parent's contact record.
Visibility: Business rule where the Set Visibility action is Yes. The field must appear only when the prospect is underage, and custom code is not allowed. A business rule with the condition Age at Registration is less than 18 and a Show/Hide Field action set to show the field reveals it when the condition is met. Setting visibility to No would hide it for exactly the prospects who need it, and the hide options on the card or quick view form hide the field statically on a form that is not used to edit the prospect.
Requirement: Business rule where the Business Required action is Business Required. The field must be filled in before saving only for underage prospects, so the same business rule sets the column's requirement level to Business Required when the condition is met. Business rules can set column requirement levels on forms. Making the column Business required at column level would demand a primary contact on every contact, including parents and adult prospects; Business recommended never blocks the save; and Not Business Required removes the requirement.
You are a Dynamics Sales administrator for a car dealership. The dealership uses only out-of-the-box functionality. When a new car is sold, the salesperson uses a Word template to generate a letter from the quote to thank the customer.
You need to determine if you can revise the template.
Which Word template change can you make?
- A. Add the Discount field conditionally.
- B. Format the table to have alternating color rows.
- C. Format the Created On field to a long date format.
- D. Add the address of the customer. Correct
Explanation
The Dynamics Sales out-of-the-box functionality allows adding fields to the Word template that are not originally present. Since the customer address field is necessary for a personalized thank-you letter and was not initially included, it can be added.
You manage the Dynamics 365 Customer Service environment for an organization.
Microsoft SharePoint will not be deployed in the environment for a year.
You need to integrate Microsoft Office 365 solutions with the Dynamics 365 instance to help the sales team with internal collaboration efforts.
Which three solutions can you currently implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Microsoft Skype for Business Correct
- B. Microsoft Exchange Online Correct
- C. Microsoft OneNote
- D. Microsoft Yammer Correct
- E. Microsoft OneDrive for Business
Explanation
Without SharePoint, only integrations that do not depend on SharePoint document management can be used. Skype for Business (presence and click-to-call/IM, since replaced by Microsoft Teams) and Exchange Online (server-side synchronization of email, appointments and tasks) work without SharePoint, and Yammer (now Viva Engage) collaboration feeds were integrated directly with Dynamics 365. OneDrive for Business relies on server-based SharePoint integration and requires at least one active SharePoint site, and OneNote integration stores notebooks in SharePoint document locations, so neither can be implemented until SharePoint is deployed.
A company plans to implement AI Builder to add intelligence to several business processes.
Each business process uses different sources and produces different outputs.
You need to determine which AI Builder model types to use.
Which model types should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Identify a person's age in a paragraph when written using the pattern twenty years old.: Entity extraction — AI Builder's entity extraction model reads unstructured text and classifies spans into predefined entity types such as age, person, date, quantity, or location, so it can pull "twenty years old" out of a paragraph and return it as an age value regardless of whether it is written in words or digits. Key phrase extraction only surfaces the main talking points of the text without typing them as an age, and text recognition (OCR) is for pulling text out of images rather than analyzing text you already have.
Identify items and prices from an invoice.: Form processing — the form processing model is trained on document layouts to extract specific named fields and, critically, table rows, which is exactly what an invoice's line items with descriptions and prices are; it returns each item and price as a structured key/value or table output usable in Power Automate or a canvas app. Text recognition would return only a flat, unstructured dump of every word on the invoice with no mapping of item to price, and object detection identifies physical objects in photos, not fields in a document.
You create and publish a Power BI report that contains an embedded canvas app. The report will be used by multiple people.
The canvas app has an issue that must be corrected.
You update the canvas app.
You need to ensure that the updated canvas app is available in the published Power BI report.
What should you do?
- A. Manually refresh the data source on the published Power BI report
- B. Publish the canvas app Correct
- C. Publish the Power BI report from Power BI Desktop and reshare to any users
- D. Publish the Power BI report from Power BI Desktop
Explanation
Publishing the updated canvas app is necessary to make it available in the embedded Power BI report. Simply updating the app does not propagate changes until the app itself is republished.
You create a report by using Power BI Desktop and publish the report to the Power BI service. You enable Power BI visualization embedding in a model-driven app.
You need to configure the model-driven app to display a Power BI tile.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
First, create a personal dashboard in the model-driven app (Dashboards > New), because Power BI tiles can be embedded only on personal dashboards, not on system dashboards. Next, select an area of the dashboard, choose Power BI Tile on the toolbar, and pick the workspace, Power BI dashboard and tile to display; the report's visuals must already be pinned to a Power BI dashboard you can access, which the published report and enabled embedding setting provide for. Finally, share the personal dashboard with the appropriate users in the app; for them to see the tile, the underlying Power BI dashboard must also be shared with them in Power BI. Ensuring availability to security roles applies to system dashboards, not personal dashboards.
You use Power BI Desktop to configure Power BI reports.
You need to create a canvas app that displays user account information and include the app in a Power BI report.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. From the Power Apps Insert menu, add a Power BI tile
- B. From the Power BI Desktop menu, insert a Power Apps visual and include the required fields in the Power Apps data Correct
- C. Publish the report to the Power BI service Correct
- D. Connect to Common Data Service from Power BI Desktop Correct
Explanation
Option B is correct because you need to insert a Power Apps visual in Power BI Desktop and configure it with the required fields. Option C is necessary as publishing the report to the Power BI service makes it accessible for embedding the app. Option D is relevant since connecting to Common Data Service from Power BI Desktop allows accessing user account information.
A company uses Microsoft Dataverse to store sales data.
For the past few quarters, the company has experienced a decrease in sales revenue. The company wants to improve sales forecasting.
The company plans to use AI Builder to implement the solution. You select fields that will be used for prediction.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
The sequence starts with training the AI model using existing sales data from Microsoft Dataverse. After successful training, the model must be published to make it available for use. Finally, integrating and utilizing this model within Power Apps enables real-time or batch predictions to improve sales forecasting.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
The sales team at a software company wants to attach a large number of supporting documents to customer records, but management does not want to incur the cost of additional storage.
The company does not have any Office 365 application integrations enabled.
You need to recommend a storage solution that keeps storage costs low.
Solution: Enable Outlook integration.
Does the solution meet the goal?
Explanation
Enabling Outlook integration does not reduce storage costs for storing a large number of supporting documents. Instead, it integrates email and calendar functionalities which do not address the cost concern related to document storage.
You have a business process flow (BPF) that interacts with the Account entity.
You modify the BPF and add a new stage at the beginning.
You need to identify the impact of the new version on the existing account records.
What is the outcome in each scenario? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
What happens to existing accounts?: Existing accounts show the new BPF. — A business process flow definition is not versioned per record: each account's process instance simply points at the BPF definition, so as soon as the modified flow is saved and activated, records already running that process render the updated stage sequence, including the newly added first stage. That is why "Existing accounts show the old BPF" is wrong — there is no snapshot of the previous stage layout kept on the record — and "Existing accounts only show the new stage" is wrong, since the added stage is inserted into the full flow rather than replacing the stages the records were already progressing through.
What happens to new accounts?: No BPF is linked to a new account. — A BPF is attached to a newly created record only while the process is active and available to the creating user (activated, ordered as the applicable process for the table, and granted through the user's security roles); while the flow is being modified it is deactivated, so records created in that window are saved with no process instance and no stage. For that reason neither "The new BPF is showing in a new account" nor "The new BPF shows only the new stage for a new account" applies — nothing is linked at all until the flow is activated again, at which point the process must be applied to those records manually or by switching the process on the record.
You are examining several processes to determine if you can automate the processes by using Power Automate.
The processes must run without human intervention when possible.
You need to determine which flow type should be used for each process.
Which flow type should you use? To answer, drag the appropriate processes to the correct flow types. Each process may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Scheduled Cloud Flows are ideal for processes running at specific intervals without human intervention. Unattended Desktop Flows are suitable for automating tasks with desktop applications where no user presence is required. Attended Desktop Flows are used when the process involves user interaction, such as copying data from a website.
A company uses Microsoft Teams. You plan to create a Power Apps app for Microsoft Teams.
You need to determine the environment that will used by the app.
Which environment will the app use?
- A. An existing Dataverse environment that you select.
- B. An existing Dataverse for Teams environment that you select.
- C. A Dataverse environment that is automatically created for the team.
- D. A Dataverse for Teams environment that is automatically created for the team. Correct
Explanation
When creating a Power Apps app for Microsoft Teams, a Dataverse for Teams environment is automatically created for the team. This specific environment type is designed to integrate seamlessly with Microsoft Teams and provides the necessary data storage and management capabilities directly within the Teams context.
You create a canvas app for a sales team. The app has an embedded Power BI tile that shows year-to-date sales. Sales users do not have access to the data source that the tile uses.
Sales team users must be able to see data in the Power BI tile. You must minimize the level of permissions that you grant and minimize administrative overhead.
You need to share another Power BI component to make the data visible.
What should you share?
- A. The Power BI dataset the tile uses as a data source.
- B. The Power BI workspace that includes the tile.
- C. The Power BI dashboard that includes the tile. Correct
Explanation
Sharing the Power BI dashboard that includes the tile ensures sales team users can view the data without needing direct access to the dataset or workspace, minimizing permissions and administrative overhead.
You have a model-driven app. You create five Microsoft Excel templates for analyzing customer data.
Four of the templates must be available to all users. The remaining template must be available only to you. You configure the appropriate security roles for users.
You need to determine how to upload the Excel templates.
Which method should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Available to everyone: In the Settings menu, select Document Templates. — Templates uploaded through Settings > Templates > Document Templates are stored as organization-owned document templates, so every user whose security role grants read access to the Document Template table can see and run them from the Excel Templates command. This is the only administrative upload path here; Email Templates is the wrong area because it holds email body templates for the email table, not Excel workbook templates for data analysis.
Available only to yourself: In the view for the email records, select Excel Templates. — Uploading from the Excel Templates command on a record view creates a user-owned personal Excel template, which stays private to the person who uploaded it until it is explicitly shared, which is exactly what is needed for the fifth template. Using Settings > Document Templates instead would publish it organization-wide and defeat the requirement to restrict it to you.
You configure an alert in Power BI.
You need to alert users when the value of a tile exceeds a threshold. To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Where should you configure the Power BI alert so that it triggers the process?: Power BI — Data alerts are created directly in the Power BI service, on a dashboard tile pinned from a card, KPI, or gauge visual, where you set the threshold condition on the tile itself. Power Automate cannot create the alert; it only consumes one afterwards through the "When a data driven alert is triggered" trigger, and Common Data Service (Dataverse) and the Power BI admin portal have no alert-authoring capability of this kind — the admin portal governs tenant settings, not tile thresholds.
Who can see alerts configured for Power BI?: The person who created the alert. — Power BI data alerts are strictly private to their creator: no one else can see or manage an alert you set, not even the dashboard owner, and sharing the dashboard does not share your alerts or their notifications. That rules out the dashboard-owner, dashboard-access, and Power BI-instance options, since each viewer must configure their own alert on the tile to be notified.
You are using Power BI to build a dashboard for a company.
You must make the dashboard available to a specific set of users, including employees and five external users. The number of employees that require access to the dashboard varies, but is usually less than 100.
Employees and external users must not be permitted to share the dashboard with other users.
You need to share the dashboard with the employees and external users.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Create a dynamic distribution list. Add all users to the distribution list and use the list to share the dashboard.
- B. Sign into the Power BI service. Open the dashboard and select Share. Correct
- C. Enter the individual email address of internal and external users. Correct
- D. Sign into Power BI Desktop. Open the dashboard and select Share.
- E. Clear the Allow recipients to share your dashboard (or report) option. Correct
- F. Create a distribution list. Add all users to the distribution list and use the list to share the dashboard.
Explanation
Option B is correct because sharing the dashboard requires signing into the Power BI service and selecting Share. Option C is correct as it involves entering individual email addresses for both internal and external users to ensure they receive access directly. Option E is necessary to prevent recipients from further sharing the dashboard with other users, adhering to the requirement that only specified individuals can view the content.
You create a report by using Power BI Desktop and a Power BI dataset that is connected to Azure SQL Database.
Multiple groups of employees will use the report.
You need to ensure that each group of employees can see only data that pertains to their group.
What should you do?
- A. Create and assign field security profiles.
- B. Create and assign Common Data Service security roles.
- C. Create and assign roles by using row-level security. Correct
Explanation
Row-level security (RLS) in Power BI restricts the data that users can see based on their group or role. This ensures each group of employees only sees relevant data, meeting the requirement specified.
A company uses Microsoft Dataverse manage account and contact information.
The company plans to use the AI Builder model to make key business decisions.
You need to integrate prebuilt AI Builder models with Power Automate flows.
Which models should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Extract key phrases from a PDF document: Text recognition model and key phrase extraction model. The prebuilt key phrase extraction model accepts only text, so the prebuilt text recognition (OCR) model first reads the text out of the PDF. The flow then passes that text to key phrase extraction. Either model alone isn't enough.
Determine the likelihood that customers will purchase additional products: Sentiment analysis model. The question asks for prebuilt models. Prediction is a custom AI Builder model that you have to build and train on your own historical data, so it doesn't qualify. The prebuilt sentiment analysis model scores customer text, such as feedback or emails, as positive, negative, or neutral. Positive sentiment is the signal that a customer is likely to buy more. Category classification and entity extraction only tag or pull terms out of text and say nothing about how the customer feels.
The sales manager receives a list of leads from a partner company monthly. The field names that are provided do not match the fields in Microsoft Dataverse tables. A data map does not exist.
You need to import the leads without changing the data from the partner company.
What should you do?
- A. Create a data map on the first import by using the Import Data wizard. Correct
- B. Add a template for Import Data.
- C. Use Import Field Translations.
- D. Create a data map in Data Management.
Explanation
When you import a file whose column headings do not match the Dataverse column names, the Import Data wizard shows the unmatched columns on the Review Mapping step and lets you map each one to the right column by hand, so the partner's file can be imported exactly as received. In the same wizard you can enter a name in the Name your data map box to save the mapping, so the monthly lead files can reuse it next time without mapping again. Import Field Translations imports translated text for localized field values, not column mappings. Adding an import template would mean reshaping the partner's data to fit the template, which the requirement rules out. Creating a data map separately in Data Management is extra work compared with building and saving it during the first import.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
The sales team at a software company wants to attach a large number of supporting documents to customer records, but management does not want to incur the cost of additional storage.
The company does not have any Office 365 application integrations enabled.
You need to recommend a storage solution that keeps storage costs low.
Solution: Enable server-based SharePoint integration.
Does this meet the goal?
Explanation
Server-based SharePoint integration lets users manage documents in the context of a Dataverse record while the files themselves are stored in SharePoint document libraries. Because the documents live in SharePoint, which has its own storage allocation in the Microsoft 365 tenant, the large number of supporting documents does not consume additional Dataverse file capacity, which is far more expensive. The company has no Office 365 integrations enabled yet, so enabling server-based SharePoint integration is the step that provides this low-cost document storage. The solution therefore meets the goal.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
The sales team at a software company wants to attach a large number of supporting documents to customer records, but management does not want to incur the cost of additional storage.
The company does not have any Office 365 application integrations enabled.
You need to recommend a storage solution that keeps storage costs low.
Solution: Enable OneNote integration.
Does this meet the goal?
Explanation
OneNote integration adds a OneNote notebook to a record for taking notes. It does not change where file attachments are stored, so attaching a large number of supporting documents still uses Dataverse storage. To keep storage costs low, enable SharePoint Online document management integration so that the documents are stored in SharePoint document libraries instead of Dataverse. OneNote integration also depends on SharePoint integration being set up first, so on its own it does not meet the goal.
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
The sales team at a software company wants to attach a large number of supporting documents to customer records, but management does not want to incur the cost of additional storage.
The company does not have any Office 365 application integrations enabled.
You need to recommend a storage solution that keeps storage costs low.
Solution: Enable OneDrive for Business.
Does this meet the goal?
Explanation
Enabling OneDrive for Business requires Office 365 integrations to be enabled. Since the company does not have any Office 365 application integrations enabled, this solution would not meet the goal without additional setup.
You are creating Power BI reports for a company.
A company that has a model-driven app wants to use Power BI reports within the app. You create the reports.
You need to ensure that these reports are available within the app.
Which two actions should you perform? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Share the Power BI report to all users.
- B. Add the Power BI report to the Site Map dashboards. Correct
- C. Create a PCF file.
- D. Use the native reports in model-driven apps.
- E. Add the Power BI report to a dashboard in the model-driven app. Correct
Explanation
B: In the model-driven app designer you add a Dashboard page and pick the Power BI embedded system dashboard. It then appears in the site map's Dashboards subarea, so users can open the Power BI report from the app's navigation. E: Adding the Power BI report to a dashboard in the model-driven app (a Power BI embedded system dashboard, or Power BI tiles on a dashboard) makes the report available inside the app. D is wrong because native model-driven app reports are SSRS-based reports built with the report wizard and cannot show Power BI reports. Sharing the report (A) only grants access in the Power BI service and doesn't surface it in the app. A PCF component (C) is custom code and isn't needed.
A company is training an AI model using a custom table to determine the amount of time it takes to deliver a package based on several key fields.
The testing data used to train the model is used for all training and regression testing scenarios and is considered complete data.
The trained model predicts a 2 percent variance between the estimated delivery time and the actual delivery time of packages.
The executive sponsors reject the model because the actual variance is at 15 percent.
You need to address the sponsors' concern.
What should you do?
- A. Replace the training data with real-world data. Correct
- B. Reduce the size of the data used within the model.
- C. Increase the size of the data used with the model.
- D. Use sample training data from Microsoft.
Explanation
Replacing the training data with real-world data can improve model accuracy by better reflecting actual conditions. Reducing or increasing data size (options B and C) without addressing data quality issues may not resolve variance problems.
A bank uses Power BI visualizations to help determine whether they should loan money to a customer. The bank has three different visuals that are part of a
Power BI report. The bank uses a set of four risk variables that indicate whether the customer is creditworthy.
You must create a mechanism so that bank employees can change the values of the four risk variables. Changes to the value of any variable must cause the three visualizations to update.
You need to create the solution.
Which action should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Update the visualizations when users change the values of the risk variables.: Embed a Power BI report in a model-driven app. — Hosting the whole report inside the model-driven app keeps all three visuals together on one page, so a change to a risk variable re-evaluates the report and every visual re-renders in the same interaction, which is exactly the requirement. The other direction (embedding a canvas app or a model-driven app inside the Power BI report) only adds a data-entry surface within the report and does not give bank employees the report-driven refresh of all three visuals inside the app they work in.
Ensure that users can adjust the values of the four risk variables that contribute to a customer's credit risk.: Use the Power BI service. — The four risk variables are exposed as report parameters/slicers, and the Power BI service is what publishes and renders that interactive report so users can change the values and have the measures recalculate for the embedded visuals. "Use Power BI tiles" refers to the canvas-app Power BI tile control, which shows a single pinned, read-only tile and accepts no user input, and "Use Power Apps visuals" embeds an app inside the report rather than providing the parameter-driven values the visuals consume.
You create a JavaScript web resource named MyBusinessLogic. The code it contains uses functionality from a third-party JavaScript library.
You notice that an independent software vendor (ISV) solution uses the same third-party library in their managed solution.
You plan to deploy your solution to other environments by using a managed solution. The ISV solution might not be installed in the other environments.
You need to package the solution for deployment
What are two ways to achieve this goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Create a new JavaScript web resource by using the code from the third-party library. Add the new JavaScript web resource along with MyBusinessLogic to the solution. Correct
- B. Add a copy of the JavaScript library from the ISV to the solution along with MyBusinessLogic.
- C. Add the code from the third-party JavaScript library to MyBusinessLogic. Add MyBusinessLogic to the solution. Correct
- D. Add only the third-party JavaScript web resource to the solution.
Explanation
Option A ensures the third-party library is included in your solution package, making it independent of ISV presence. Option C integrates the third-party code directly into MyBusinessLogic, eliminating dependency on external resources.
A company creates a canvas app.
The app requires near real-time data from an accounting system that resides in a customer's data center.
You need to implement a solution for the app.
What should you create?
- A. On-premises data gateway Correct
- B. Azure DevOps pipeline
- C. Data integration project
- D. Power Pages
Explanation
An on-premises data gateway is required to securely connect a canvas app to an accounting system located in a customer's data center for near real-time data access. This gateway facilitates the communication between cloud services and on-premise systems.
You create a canvas app that uses data from a Microsoft SQL Server database.
You use a dataflow to move some of the data from the database to Microsoft Dataverse. Users will filter the data by using the app.
You need to filter data in the dataflow and in the canvas app.
Which tools should you use? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Filter data in the dataflow: Power Query. Dataflows are built in Power Query Online, so filter steps defined there remove rows before the data is loaded into Microsoft Dataverse. Filter data in the canvas app: Power Fx. Canvas apps use Power Fx formulas such as Filter, Search and LookUp (for example in a gallery's Items property) to filter records, and these are delegated to Dataverse where possible. T-SQL is not written inside a canvas app, and Kusto (KQL) queries Azure Data Explorer and Log Analytics data, not dataflows or canvas apps.
You have a canvas app with an embedded Power BI tile.
You share the canvas app. Users report that they are unable to access the Power BI content.
You need to determine why users are unable to access the content.
What is the cause of the user's problems?
- A. The Power BI dashboard is not shared. Correct
- B. The Power BI connection is not shared.
- C. The Power BI Display mode property on the Power BI tiles is set to Disabled.
- D. The Power BI interactions property on the Power BI tiles is set to Off.
Explanation
The Power BI dashboard is not shared. Users cannot access the embedded Power BI content in a canvas app if the underlying Power BI dashboard or report has not been explicitly shared with them, leading to access issues.
You plan to create a Power BI dataflow.
The Power BI dataflow has the following requirements:
• Be able to create a copy of the dataflow to separate Power BI workspaces.
• Schedule the dataflow to update every day at 11:00 AM.
You need to configure the dataflow.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Copy Power BI dataflow: Export the JSON file — A dataflow's definition (its entities, queries, and mappings) can be exported from the workspace as a model.json file, which you then import into another Power BI workspace to recreate the dataflow there, giving you the copy across workspaces. Changing the settings or the properties only edits the existing dataflow in place and produces no portable copy, and a streaming dataset is a different real-time artifact entirely, not a way to duplicate a dataflow.
Schedule updates.: Configure the Power BI service — Refresh scheduling for a dataflow lives in the Power BI service: you open the dataflow's scheduled refresh settings in the workspace and set the time zone and the 11:00 AM refresh time (adding gateway credentials if the source is on-premises). Refresh history only shows the outcome of past refreshes rather than defining a schedule, so it cannot meet the daily 11:00 AM requirement.
You plan to create a dataflow to import data into Microsoft Dataverse by using Power Query.
The dataflow has the following requirements:
• A table of aggregated data must be created in dataflow storage.
• A unique identifier must be created for the table.
You need to configure the dataflow.
Which solutions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Table of aggregated data: Computed entity — In a dataflow, a computed entity is a table whose data is produced by running additional Power Query transformations (such as group-by aggregations, joins, or summarizations) over data already loaded into dataflow storage, and the result is materialized and stored there rather than re-pulled from the source. A linked entity only references a table from another dataflow without performing or storing the aggregation, and a merge query is just a single transformation step, not a stored table.
Unique identifier: Alternate key — When a dataflow loads data into Dataverse, an alternate key defines the column (or combination of columns) that uniquely identifies each row, so the dataflow can match incoming records to existing rows and perform upserts instead of creating duplicates. A plain key column in Power Query does not create the uniqueness constraint that Dataverse uses for record matching during import.
You plan to create a dataflow by using Power Query to transform the data.
You observe that some cells display an error instead of the expected data.
You need to obtain more details about the errors.
What should you do?
- A. Use the App Checker.
- B. Select the cell with the error. Correct
- C. Use the Flow Checker.
- D. Select the row that includes the cell with the error.
- E. Use the Advanced Editor.
Explanation
Selecting the cell with the error in Power Query allows you to view detailed error information directly related to that specific cell. This action provides insights necessary for troubleshooting and resolving data transformation issues.
A company creates a model-driven app.
Users require access to a Power BI report that is embedded in the app.
You need to configure the app.
Where should you add the report?
- A. XML report
- B. Dashboard Correct
- C. Business rule
- D. Power Automate cloud flow
Explanation
The Power BI report should be added to a Dashboard within the model-driven app. This allows users to access and interact with the report directly from the app interface.
A company is implementing Microsoft Power Platform solutions.
The company requests information on the features that are supported by Power Fx.
You need to identify the features of Power Fx.
What should you identify?
- A. It uses imperative and declarative logic. Correct
- B. It uses an undefined value for uninitialized variables.
- C. It uses a plug-in.
- D. It uses the model-driven app formula language.
Explanation
Power Fx supports both imperative logic for defining how actions should occur and declarative logic for specifying what should happen, aligning with its design to be flexible like spreadsheet formulas.
You use a dataflow to import data into Microsoft Dataverse.
The data uses the following schema:
| Column name | Data type |
|---|---|
| accountid | Unique Identifier |
| accountnumber | Text |
| createdon | Date and Time |
| modifiedon | Date and Time |
| versionnumber | Big Integer |
The data must load in the least amount of time.
You need to configure the incremental refresh settings for the dataflow.
Which columns should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Filter field: createdon — Incremental refresh in a Power Platform dataflow requires a DateTime column to slice the source data into time-based partitions (for example, "refresh rows from the last N days"), and createdon is the Dataverse system DateTime column that records when each row first entered the table, so it correctly defines which rows belong to which historical range. accountid and accountnumber are identifier columns, not date/time values, so they cannot be used as the range filter, and versionnumber is a BigInt row-version value rather than a date, so it is also unusable here.
Detect data changes: modifiedon — When "Detect data changes" is enabled, the dataflow compares the maximum value of the chosen DateTime column per partition against the previous run and reloads only the partitions where that value has increased, which is what keeps the load time to a minimum. modifiedon is updated by Dataverse every time a row is changed, so it accurately signals which partitions contain updates; createdon would never change for existing rows and would therefore miss edits, while accountnumber and versionnumber are not DateTime columns and are not valid selections for this setting.
A company uses Dataverse to store the names of contacts. The company uses a shared Microsoft Excel file to collect the data.
The company requires that the contacts be added to Dataverse automatically every day.
You need to identify which tools are required to create and perform the import.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Create the import: Dataflow. A dataflow is the only option here that can be authored once and then run on a recurring schedule, which is what "added to Dataverse automatically every day" requires. You create the dataflow in the Power Apps maker portal, point it at the shared Excel file, map the columns to the Contact table, and set a refresh schedule. Import from Excel and the Import Wizard are one-off, manual upload operations, and a data map is only the column-mapping definition used by such an import, so none of them meets the daily automatic requirement.
Perform the import: Power Query. Dataflows are built on and run by the Power Query engine, which connects to the Excel source, applies the transformations and column mappings, and loads the rows into the Dataverse Contact table on each scheduled refresh. Connections and custom connectors only provide authenticated access to a data source rather than doing the extract-transform-load work, and Power Apps is the app-building layer that hosts the maker experience, not what runs the import.
A company is implementing Microsoft Power Platform solutions.
The company requests information on the features that are supported by Power Fx.
You need to identify the features of Power Fx.
What should you identify?
- A. It is available for purchase through a Microsoft reseller.
- B. It uses an undefined value for uninitialized variables.
- C. It uses formulas that are similar to Microsoft Excel formulas. Correct
- D. It uses synchronous data operations.
Explanation
Power Fx uses formulas that are similar to Microsoft Excel formulas, making it accessible for users familiar with Excel. This similarity facilitates easier adoption and use within the Power Platform environment.
A company is implementing Microsoft Power Platform solutions.
The company requests information on the features that are supported by Power Fx.
You need to identify the features of Power Fx.
What should you identify?
- A. It uses imperative and declarative logic. Correct
- B. It is available for purchase through a Microsoft reseller.
- C. It uses an undefined value for uninitialized variables.
- D. It provides a manual compiler.
Explanation
Power Fx supports both imperative and declarative logic for building applications within the Power Platform. This dual support allows developers to write scripts that can react to events (imperative) and define how data should be presented or calculated (declarative).
You create a Power Platform help Desk solution.
You need to create a dashboard that displays information on help desk cases that are handled each week.
Which dashboard components should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Add a tag chart by using opened cases: Area chart — a tag chart is one of the chart visualizations you place into a chart area of the dashboard layout, so the component you add here is the chart area itself rather than a stored chart definition. It is not a System chart, because you are positioning a visualization in the dashboard canvas, and it is not a Personal dashboard, because that describes the container you are building, not the piece being added to it.
Add a stacked column chart shared with your team: System chart — system charts are owned by the organization and saved with the table in a solution, so every user with read access to the table sees them, which is exactly how a chart gets shared with a whole team. A Personal dashboard would keep the visual private to the person who created it unless it were individually shared with each user.
Add a Microsoft Power BI visualization: Personal dashboard — in model-driven apps, Power BI tiles and embedded reports can only be placed on personal (user-owned) dashboards; the system dashboard designer does not offer a Power BI tile component, and the org setting for Power BI embedding must be enabled first. A System chart is a Dataverse chart definition and cannot host a Power BI visual at all.
Add a chart from a view that a user creates: Personal dashboard — a chart built on a user's own personal view is user-owned data, and personal views and personal charts can only be surfaced on a personal dashboard. A System chart has to be defined against system views and saved as part of the solution, so it cannot be sourced from a view an individual user created.
Add a doughnut chart that shows cases by owner: Area chart — a doughnut chart is a standard chart visualization dropped into one of the chart areas of the dashboard layout, so the dashboard component being used is the chart area. Choosing System chart or Personal dashboard would describe where a chart definition is stored or who can see the dashboard, not the layout component that renders the doughnut visual.
You create a Power Automate flow as part of a managed solution. The flow alerts users when files are uploaded to a SharePoint location.
Files are uploaded to SharePoint at a much higher rate than expected. Users report that they receive too many notifications about uploaded files.
You need to stop the flow and correct the issue.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Disable the flow in the managed solution: Disable the flow from the Power Automate portal. Open the flow in Power Automate (its details page) and select Turn off. This stops the SharePoint trigger at once and ends the flood of notifications without changing the managed solution. The Azure portal does not manage Power Automate cloud flows, so it cannot be used to disable one.
Verify changes to the flow: Run the Flow checker and then turn on the updated flow. Flow checker validates the edited flow while it is still off and reports errors and warnings, such as missing or invalid parameters. You fix those problems before the SharePoint trigger can fire again, then turn the flow back on. Turning the flow on first, or relying on the Test feature, lets the trigger run again before the corrected flow has been validated.
You create a new independent software vendor (ISV) solution for a Power Apps app.
The Power Apps solution will be imported into multiple customer environments. The environments will have a large variety of solutions and publishers.
You need to avoid naming conflicts during solution import.
Which element should you configure?
- A. Package type
- B. Configuration page
- C. Marketplace
- D. Prefix Correct
- E. Version
Explanation
Configuring a prefix for the elements in your Power Apps solution helps avoid naming conflicts when importing into environments with many solutions and publishers. This ensures that all components have unique names, preventing overwrites or conflicts.
A company has employees in France, Mexico, and the United States. You are creating a Power Apps app to allow users to add client records to Microsoft
Dataverse. The default language for the company is English.
The company wants the app to display each local language.
You need to add the Spanish and French languages.
Which four actions should you perform in sequence for each language? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
1. Select an unmanaged solution: translations can only be exported from an unmanaged solution, so pick the solution that contains the app's customized tables and columns, not a managed one.
2. Export translations: this produces a compressed file containing CrmTranslations.xml with every localizable label in the solution.
3. Add a language code column and translated wording in the CrmTranslations.xml file: the file has a column per language code (for example 1036 for French and 3082 for Spanish); you add the target language column and its translated text rather than replacing the existing base-language column.
4. Import translations: import the compressed file back into the environment so the translated labels are applied, then publish customizations. Exporting or importing the whole solution is not needed to translate labels.
A company uses a model-driven Power Apps app in a new environment. The base language is English.
You need to configure French and Spanish.
Which configuration component should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Allow a language to be used within an organization: Language packs — before French or Spanish can be offered anywhere in a model-driven app, the corresponding language pack must be present, because the pack supplies the translated platform UI strings, labels, and system messages that make that language available to the organization. "Default language" only sets the base language (here English) rather than adding new ones, "Language collation" governs sorting and comparison rules for text, and "LCID" is just the numeric locale identifier used to reference a language, not the component that makes it usable.
Enable the languages: Environment — once the packs are available, an administrator turns the languages on at the environment level in the settings area (Settings > Product > Languages), which provisions the translated strings for that Dataverse environment and lets users then pick French or Spanish as their personal display language. "Tenant" is the wrong scope because language enablement is per environment, not applied across the whole tenant; "Browser" only affects the user's own locale preference and cannot provision a language; and there is no per-"Power Apps app" language enablement setting.
A company creates a Microsoft Power Apps app through the Power Apps designer portal for use in Microsoft Teams.
This app needs to be promoted to the user acceptance testing environment.
You need to complete the Microsoft recommended actions before you export the solution.
Which two actions should you complete? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Run the solution checker. Correct
- B. Set the Optimized embedding appearance field to true.
- C. Clone a solution.
- D. Write validation tests.
- E. Publish all changes. Correct
Explanation
According to Microsoft's official documentation, before exporting a solution in Power Apps, it is recommended to run the solution checker (Option A) to identify and resolve potential issues. Additionally, publishing all changes (Option E) ensures that the latest updates are included in the exported package.
You create functionality for a company. The functionality includes a Microsoft Dataverse table with a form for data entry. The functionality will be distributed to other lines of business in the company, each with its own Dataverse environment.
New forms must not be created in order for updates to the functionality to work correctly.
You need to package the new functionality for distribution.
What should you do?
- A. Use a patch solution and disable the ability to create new forms for the table.
- B. Use a managed solution and include only the needed form.
- C. Use an unmanaged solution and include only the needed form.
- D. Use a managed solution and disable the ability to create new forms for the table. Correct
Explanation
Distribute the functionality as a managed solution and, before exporting it, turn off the table's managed property 'New forms can be created'. Managed properties are set in the unmanaged development environment and take effect once the managed solution is imported elsewhere; recipients cannot change them, only the publisher can through a solution update. A managed solution on its own still lets recipients add customizations such as new forms if the table remains customizable, so including only the needed form (B) does not meet the requirement. An unmanaged solution (C) gives no protection, and a patch (A) only updates an existing parent solution rather than packaging the functionality for first distribution.
You are using a development environment to add a new column to a system table. You plan to move the changes to a test environment when they are complete.
The changes must meet the following requirements:
✑ Must be clearly identified so that they are not confused with system components and components from other solutions.
✑ Must not affect any existing components in the test environment.
You need to prepare a solution for deployment to the test environment.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
Create a new publisher first: its customization prefix is stamped on every new component (for example the new column's schema name), so the changes are clearly identified and not confused with system components or with components from other solutions. Next, create a new unmanaged solution in the development environment and select that publisher; development is done in unmanaged solutions, which are later exported (typically as managed) to the test environment. Then add the existing system table to the solution without its other components and add the new column; choosing to add the table with all components would also carry every existing column, form and view, and importing those would overwrite components that already exist in the test environment. Finally, run the solution checker to validate the solution before exporting it. A managed solution cannot be edited in the development environment, and choosing an existing publisher would not give the changes their own identifying prefix.
A company uses Power BI dashboards.
A manager wants to understand the raw data in one of the charts.
You need to present the data.
What should you do?
- A. Export the dashboard to Microsoft PowerPoint.
- B. Export the dashboard to Microsoft Excel. Correct
- C. Change to focus mode.
- D. Drill down in the dashboard controls.
Explanation
Exporting the dashboard to Microsoft Excel allows the manager to access the raw data used in one of the charts for detailed analysis. This option provides direct visibility into the underlying dataset, which is necessary for understanding the raw data.
You are a consultant. A client asks you to remove several solutions in one of their Microsoft Dataverse environments.
The client wants to know what effect removing the solutions will have on the rest of the system.
You need to explain the results of removing the solutions.
Which components will be affected? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Unmanaged solution with a custom table in a parent-child relationship: The solution only. When an unmanaged solution is deleted, only the solution container is removed. All the unmanaged customizations in it, including the custom table, its relationship and the lookup column that implements it, remain in effect and belong to the default solution, and no data is deleted.
Managed solution patch that updates a column label: The solution and the updated column label. A patch contains only changes layered on top of its parent managed solution and cannot delete components. Uninstalling the patch removes that layer, so the label reverts to the value from the parent solution, while the column, its data, and the forms and views that use it remain.
ISV managed solution with a custom table and site map changes: The solution, the table, and any data in the table. When a managed solution is uninstalled, all the customizations and extensions it contains are removed, and the data stored in custom tables that are part of that solution is lost. The custom table and its data are therefore removed along with the solution (its site map layer is removed as well).
You are creating tables for use with Microsoft Power Platform components.
The display names of the tables must not be changed when the solution is promoted to the user acceptance testing environment.
You need to apply this restriction to the solution.
Where should you make the changes?
- A. Segmented solution
- B. Default solution
- C. Power Apps
- D. Unmanaged solution Correct
- E. Managed solution
Explanation
Locking the display name is done with the table's managed properties (Advanced > Managed properties > Display name can be modified). Microsoft documents that managed properties are applied while the solution is unmanaged in the development environment; they take effect when the solution is exported as managed and imported into another environment such as user acceptance testing, where they can be viewed but not changed. Being managed on its own does not lock display names, a managed solution cannot be edited to add the restriction, and the default solution, segmented solutions and Power Apps are not where the restriction is set.
A company uses a model-driven app with Microsoft Dataverse in a single environment.
The company requires a canvas app that includes the same data as the model-driven app.
You need to create the canvas app.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
Canvas apps are built in Power Apps (make.powerapps.com), not in the Power Platform admin center, so first sign in to the Power Apps Maker portal. Because the model-driven app stores its data in Dataverse, choose Dataverse as the source (not Excel) so the canvas app uses the same tables. Finally, select the tables to include, let Power Apps generate the app, and save it.
A company that manufactures medical devices uses Power Apps to manage their sales and device maintenance.
A table named Devices in Microsoft Dataverse has a column named Status. The Status column must have a new status value of Review added to the existing Choice values of Active and Inactive.
The table must be added to a solution to be promoted once the change is made.
Only this change must be promoted to the test environment. The changes must not be able to be changed once promoted.
You need to add the change to a solution for promotion.
Which option should you use for each action? To answer, drag the appropriate options to the correct actions. Each option may be used once, more than once, or not at all.
NOTE: Each correct selection is worth one point.
Explanation
Add the Devices table to the solution: Add existing. The Devices table already exists in the environment, so you bring it into the solution with Add existing > Table. Do not choose Include all objects, so the unchanged parts of the table are left out and are not promoted.
Add the status column changes only to the solution: Add required components. With the table in the solution, the changed Status column (its Choice values now include Review) is brought in as the component the solution needs, without adding the rest of the table's objects. Add column is wrong because it creates a new column, and Status already exists. Export the solution as managed so the change cannot be edited in the test environment.
A company is updating a Power Apps solution that contains two tables named Services and Equipment.
The company is creating a new solution to update the current solution for the following requirements:
• The Services table must be updated to include change tracking.
• The Equipment table must be updated to include four new columns.
• The solution must update only the components that need to be added or changed.
You need to create the solution.
Which table option should you use? To answer, drag the appropriate options to the correct tables. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Services: Include entity metadata. Change tracking is a property of the table itself, so in a segmented solution you add the table with its metadata (table properties) only, without its columns, forms or other components.
Equipment: Select components. Only the four new columns need to ship, so you add the table and pick just those columns, which keeps the solution limited to the components that were added or changed.
Include all components is wrong for both tables because it adds every component of the table, which goes against updating only the components that changed.
A company uses a model-driven app. The app uses a Power Virtual Agents chatbot.
The company has two locations in different countries/regions with separate environments for each location. Each location has a development environment, a testing environment, and a production environment. The company uses the Application Lifecycle Management (ALM) process for the environments.
You need to create the different Power Virtual Agents bot environments.
How many Power Virtual Agents bot environments are required?
- A. 1
- B. 2
- C. 3
- D. 6 Correct
Explanation
The company has two locations with separate environments for each location, including development, testing, and production. Therefore, 3 environments per location multiplied by 2 locations equals 6 Power Virtual Agents bot environments required.
A company plans to create an app by using Power Apps.
The company has the following requirements:
• The app must be able to enter data into Microsoft SharePoint.
• Users must be able to add the app into Microsoft Teams.
You need to recommend which app to create.
Which type of app should you recommend?
- A. model-driven app as a personal app
- B. model-driven app as a tab app
- C. canvas app as a personal app
- D. Canvas app as a tab app Correct
Explanation
A canvas app as a tab app in Microsoft Teams meets the requirement of integrating directly into Teams and allows interaction with SharePoint for data entry.
A company records data in Microsoft SharePoint Online. The company is creating a mobile app by using Microsoft Power Platform only.
The company requires the app to connect directly to SharePoint Online to collect data.
You need to recommend which Microsoft Power Platform product or feature to implement.
What should you recommend?
- A. Power Automate
- B. Power Pages
- C. Canvas app Correct
- D. Model-driven app
Explanation
A Canvas app in the Microsoft Power Platform is suitable for creating a mobile application that can directly connect to SharePoint Online to collect data. This option provides a flexible and user-friendly interface tailored for mobile use.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to format the Current Date field for parental consent.
What should you use?
- A. switch
- B. dynamic content
- C. expression Correct
- D. condition
Explanation
The 'expression' option is the correct choice for formatting the Current Date field in this scenario. Expressions allow for dynamic content generation based on specific criteria, such as including the full month name, date, and year, which aligns with the requirement to format the current date accurately for parental consent emails.
This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.
To start the case study -
To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.
Background -
Bellows College is a post-secondary school that wants to start a football team. The college uses Microsoft Power Platform to manage its recruiting efforts. The registration team and assistants use model-driven apps. The coaches use canvas apps on their mobile devices.
Prospects are considered underage if they are younger than 18 years old at the time of registration.
Current environment -
Environment -
• Custom code is not allowed in the system.
• Server-side synchronization is configured for emails, appointments, contacts, and tasks.
• The database and file storage of Dataverse must be minimized to keep costs low.
Contact table -
• Birthdate is a custom date and time field.
• Age at Registration is a calculated field that displays the age of the prospect at the time of registration.
• Current Age is a calculated field that displays the age of the prospect based on the current date and time.
Evaluation table -
• The Evaluation table is a custom table used to track evaluation criteria.
• Evaluation records cannot be manually created.
• Users must not be able to continue until an evaluation record is created automatically for the prospect.
Consent table -
• The consent forms completed by the parents are stored as records in the Consent table.
• Occasionally, a parent cannot complete the consent online and a paper copy must be printed. The signed copy must be scanned and stored with the consent record.
Team website -
• The team website is created by using Power Pages.
• A starter layout template was used to create the site.
• The site consists of five pages:
o Home: A page open to everyone to view the announcements from the team. o Schedule: A page open to everyone to view the tryout and game schedule. o Evaluations: A page that displays tracking from the evaluation table. Prospects are able to view their own information only. o Forms: A page that displays the consent form. o Contact Us: A page for anyone to submit questions and comments.
• Two web roles for authenticated users are created: Primary Contact User and Prospect User. o All primary contacts and prospects are assigned to their respective roles.
Requirements -
Registration -
• Parents and prospects are created as contacts and must be linked.
• The registration team must be able to rapidly create prospects without navigating away from the Parents form. Only the First Name, Last Name, and Birthdate fields should be displayed for the team.
• Assistants must be able to update prospect information and add teams that the prospect has previously played on to a subgrid.
Parental consent -
• When a prospect is underage, a Primary Contact field will appear. The field must be populated before the prospect record can be saved.
• A view named Underage Prospects that lists all underaged prospects is required.
• The Underage Prospects view must run once a week without requiring modifications to display correct information.
• A consent email must meet the following requirements:
o be sent to the primary contact of each new underage prospect o contain a link to the team website o be automatically sent weekly and tracked to the contact record in Dataverse o include the current date using the full month name, date, and year
Evaluations -
• Coaches rate prospects each day on a scale of 1-10 in three categories: endurance, coordination, and skill.
• The total of the three categories is displayed at the bottom of the form. If the total for the day is greater than 25, the number should appear green.
You need to store scanned consent forms.
Where should you store the forms?
- A. Attachment
- B. Column
- C. Notes
- D. SharePoint Correct
Explanation
Storing scanned consent forms in SharePoint aligns with the requirement to minimize Dataverse file storage for cost efficiency. SharePoint provides a scalable and secure solution for document management outside of Dataverse.
A company has implemented server-side synchronization in Dataverse.
Users have the following synchronization requirements:
• As emails are moved to specific locations within an inbox, the emails must relate back to a specific record in Dataverse.
• Information about key individuals must sync automatically to Outlook.
• Tagged appointments in Outlook must sync automatically to Dataverse.
You need to recommend a solution for each requirement.
What should you recommend? To answer, move the appropriate features to the correct requirements. You may use each feature once, more than once, or not at all. You may need to move the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Explanation
Synchronize moved items: Folder-level tracking. With folder-level tracking, you set up Exchange folders that are linked to a specific Dataverse record, so when an email is moved into one of those folders it is tracked automatically and set Regarding that record.
Individuals appear in Outlook: Appointments, contacts, and tasks synchronization. This server-side synchronization setting syncs Dataverse contacts (the key individuals) to Outlook automatically, along with appointments and tasks. Email synchronization only handles incoming and outgoing email messages.
Synchronize tagged appointments: Outlook category tracking. When a user tags an Outlook item, including an appointment, with the Tracked to Dynamics 365 category, server-side synchronization picks it up and tracks it in Dataverse automatically. Folder-level tracking covers email only, not appointments.
You are creating a model-driven app that has an embedded Power BI report. Another functional consultant set up an environment variable for the report.
You add the dashboard to a solution in the development environment and then import the changes to a production environment as a managed solution.
When you test the report, the data appears the same as it did in the development environment.
You delete the solution in production.
You need to resolve the development environment issue before redeploying the solution.
What should you do?
- A. Update the environment variable current value
- B. Remove the environment variable current value. Correct
- C. Update the environment variable default value.
- D. Create a new environment variable.
Explanation
The current value of an environment variable takes precedence over the default value. If the current value is part of the solution, it is exported and imported with the solution. That is why the report in production still pointed at the development data. Microsoft's guidance is to remove the current value from the solution before exporting: in the solution, select the environment variable, then under Current Value select ... > Remove from this solution. The value stays in the development environment, but it is not exported, so a production value can be entered when the solution is imported. Updating the current value in development would still carry a development value into production. Changing the default value has no effect while a current value is present. Creating a new environment variable does not fix how the value is packaged.
You are creating tables for use with Microsoft Power Platform components.
The display names of the tables must not be changed when the solution is promoted to the user acceptance testing environment.
You need to apply this restriction to the solution.
Where should you make the changes?
- A. Segmented solution
- B. Default solution
- C. Unmanaged solution Correct
- D. Managed solution
Explanation
Managed properties control what can be customized after a solution is imported as managed. You set them on the table in the unmanaged solution in the development environment (for example, turning off the option that allows the display name to be changed), and then export it as managed. When it is imported into the user acceptance testing environment, the display names cannot be changed. A managed solution cannot be edited directly, the default solution is not what you export to promote, and a segmented solution only controls which components are included.
A company is using Dataverse with a custom table named Prospects. The Prospects table has a lookup to the Account table.
SharePoint document management is configured in the environment but is not configured for the Prospects table. All documents saved as part of the integration must be accessed by using an Account row linked to the Prospects table.
Based on new requirements from end users, the Prospects table must be reconfigured for use with the document management feature.
You need to configure the integration.
Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Explanation
Server-based SharePoint integration and document management are already configured in the environment, so they do not need to be enabled again; only the Prospects table needs to join. First, edit the Prospects table and turn on its SharePoint document management option, which lets the table participate in the integration. Next, navigate to Document Management settings and run the wizard, selecting the Prospects table so that document locations are created for its rows. Because documents must be reached through the Account row linked to each prospect, select the Based on entity checkbox with Account: the folder structure is then built under the related account's folder, which works because Prospects has a single lookup (N:1) to Account. Clearing Based on entity would store prospect documents in their own flat library, and adding a File column would store files in Dataverse rather than SharePoint.
A company is using a model-driven app in a production environment.
You must set up server-side synchronization for all users to connect with the company’s Exchange Online instance.
You need to determine the locations to use to complete the configuration.
Where should you navigate to? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Set up the server profile.: Microsoft Power Platform admin center — Email server profiles for server-side synchronization are created and managed per environment under Settings > Email > Server Profiles in the Power Platform admin center, where you choose the Exchange Online profile and its authentication method. The Exchange admin center configures Exchange itself and has no knowledge of Dataverse server profiles, and the maker portal solution area is for building apps and components, not tenant/environment email infrastructure.
Set default processing.: System settings — The Email tab of System Settings (Settings > Email > Email Settings in the admin center) is where you set the environment-wide defaults for how incoming email, outgoing email, and appointments/contacts/tasks are processed, and it is these defaults that new mailboxes inherit. Personalization settings only change options for the individual signed-in user, so they cannot set the default synchronization method for all users.
Approve email.: User mailbox in Dataverse — Before a mailbox can synchronize, a Dataverse administrator must open the mailbox record (Settings > Email > Mailboxes) and choose Approve Email, which is the security check that confirms the mailbox is allowed to send and receive through server-side sync. Exchange admin center cannot perform this approval because the approval flag lives on the Dataverse mailbox record.
Test and enable mailboxes.: User mailbox in Dataverse — Once approved, you select the mailbox records in Dataverse and choose Test & Enable Mailbox, which runs incoming/outgoing/ACT tests against Exchange and writes the results back to the mailbox record's alerts. This action exists only on the Dataverse mailbox entity, not in the Exchange admin center.
You are implementing server-side synchronization for a company. The company uses Exchange Online with no permissions delegated. All users are assigned the Approve Email Addresses for Users or Queues privilege.
You set up the server profile and configure the mailboxes. You encounter an issue when you attempt to approve mailboxes for other users.
You need to identify who can approve the mailbox.
Who should you identify?
- A. All users
- B. Microsoft Power Platform Administrator
- C. Any system administrator
- D. User who owns the mailbox Correct
Explanation
With Exchange Online, approving another user's mailbox requires the System Administrator role together with the Microsoft 365 Global admin or Exchange admin role, or the Delegated Mailbox Approver role; the Approve Email Addresses for Users or Queues privilege alone is not enough, and a system administrator or Power Platform (service) administrator by itself cannot approve. In this scenario no such permissions are delegated, so the only person who can approve the mailbox is the user who owns it: a user can approve their own mailbox when their user principal name matches the mailbox email address, they have at least user-level Write on the Mailbox table, and they have the Approve Email Addresses privilege (or self-approval without the privilege is allowed).
You develop a model-driven app that has an embedded Power BI report in the development environment.
Another environment has a Power BI workspace that corresponds to the development environment.
All deployments must take place by using the maker portal.
When you manually deploy changes to the other environment, you observe that the report from the development workspace is displayed.
You need to resolve the issue.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
- A. Use a solution settings file.
- B. Replace the Report component with a Power BI Dashboard component.
- C. Add an environment variable. Correct
- D. Include the current value in the solution.
- E. Remove the current value in the solution. Correct
Explanation
Add an environment variable (C): an embedded Power BI report in a model-driven app can use a Power BI environment variable that holds the workspace and the report. Each environment can then point at its own workspace instead of the hard-coded development workspace. Remove the current value in the solution (E): if the current value is exported with the solution, the target environment keeps using the development workspace. If you remove the current value from the solution before export, the development environment keeps its value, and the target environment is asked for its own value when the solution is imported in the maker portal. A solution settings file is used for automated deployments with pac CLI or pipelines, not for manual deployments from the maker portal. Including the current value causes the problem described. Switching to a dashboard component does not change which workspace is used.
You are exporting a solution from a development environment that contains a form and a view for a custom table.
When you attempt to import the solution into another environment, the import fails due to missing dependencies.
You need to ensure that the solution can be imported successfully.
What should you do to resolve the dependency errors?
- A. Select Export as Unmanaged when exporting the solution.
- B. Publish all customizations in the environment before exporting the solution.
- C. Select Include all objects when adding the table to the solution. Correct
- D. Select Export as Managed when exporting the solution.
Explanation
Selecting Include all objects when adding the table to the solution ensures that all dependencies are included during export, which resolves dependency errors upon import into another environment.
You need to address the executive's concerns regarding unnecessary data access.
Which security changes should you make? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Security Measure for Unnecessary user access to client data during verification: Assign records to a service account and add the team member doing the verification by using an access team — an access team grants privileges on one specific record to the individual users added to it, so the verifier gets exactly the access needed for the record under review and nothing else, while ownership stays with a neutral service account. Assigning the records to the verifier and dropping the table to Basic (User) scope would make that person the owner and would still expose every record they own, and sharing the record directly is a manual, per-record permission that is harder to manage and revoke than an access team driven by the service request process.
Security Measure for Unnecessary user access to client data after the request is completed: Assign records to the QV team when the service request is completed — reassigning ownership to the Quality Verification team removes the individual verifier's ownership-based access once the work is done, while keeping the completed records available to the team that legitimately needs them for quality review. Leaving the records on the service account or on the individual team member would either strand the data with no business owner or leave the verifier with continued access to client data after the request has closed.
You need to resolve the issue reported by substitute employees after they are assigned service requests.
How should you configure the system? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Relationship: Service Request 1:N Qualification — Cascading behaviors (Assign, Share, Reparent, Delete, Merge) are defined only on the parent side of a one-to-many relationship, so the Service Request table must be the "1" side with Qualification rows as the related children in order to expose the cascading rules that push access down when a request is reassigned. Service Request N:1 Qualification points the wrong way (it would make Service Request the child, so cascading would be configured on Qualification instead), and Service Request N:N Qualification is a many-to-many relationship, which has no cascading behavior settings at all.
Cascading rule: Cascade All — With Cascade All, the Assign and Share actions performed on the parent Service Request are applied to every related Qualification row regardless of who owns them, so when a service request is reassigned to a substitute employee that person also receives ownership/access to the related qualification records and no longer hits the missing-record or permission error. Cascade None would leave the child rows untouched and reproduce the reported problem, and Restrict is only a delete-side rule that blocks removing a parent that still has children — it does nothing to grant the substitute access.
You need to implement the requirement for the VP of sales.
What should you do?
- A. Use a test account with a base security role with QV security added. Correct
- B. Add the System Administrator security role to your user account.
- C. Use a test account with only QV security added.
- D. Add QV security to your user account.
Explanation
Option A is correct because it ensures the VP of sales has a base security role for fundamental access and QV security added for specific requirements, providing necessary permissions without excessive privileges.
You need to embed the check-in solution into the communication solution. To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
What must you use to embed the check-in solution?: Power Apps Web Studio — Embedding a Power Apps canvas app into a Microsoft Teams-based communication solution is done from the Power Apps maker portal (Power Apps Web Studio), where you open the app and use the Add to Teams / Share with Teams option to generate the app package that Teams consumes. Visual Studio is a developer IDE and is not needed for a no-code embed, AI Builder only supplies prebuilt and custom AI models, and Common Data Service (now Dataverse) is the underlying data platform rather than an embedding tool.
Where must the check-in solution be available within the communication solution?: in a tab — A Power Apps app embedded in Microsoft Teams surfaces as a Teams tab that can be pinned to a channel, chat, or personal app area, giving users the full app experience inside the collaboration workspace. The chat section only carries messages and adaptive cards, the Microsoft 365 Apps selection grid is the general app launcher rather than a location inside the communication solution, and an embedded webpage would require an external site instead of the native Teams app integration.
You need to add controls to the check-in solution for the health and wellness questions.
Which form control should you use?
- A. Drop down Correct
- B. Check box
- C. Text input
Explanation
The drop-down control ensures that users physically interact with each answer by selecting 'yes' or 'no', meeting the requirement for health and compliance during check-in.
You need to design the resort portal to meet the business requirements.
Which data source should you use?
- A. Microsoft Dataverse Correct
- B. Microsoft Excel
- C. Azure SQL Database
- D. SQL Server
Explanation
Microsoft Dataverse is the appropriate data source for designing a resort portal as it supports integration with various services and can import Excel sheets, making it suitable for self-service check-in processes that require specific guest data.
You need to design the resort portal's email registration process.
Which solutions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Implement the invitation code redemption process.: Embed the invitation code in the email link URL. — Power Pages (portal) invitations are redeemed through a redemption URL, so the invitation record's code is appended to the link sent to the contact (for example .../register/?invitation=<code>&returnurl=%2F), and the portal reads that query string parameter and redeems the invitation automatically when the customer clicks through. Auto-populating the code on the sign-in screen is wrong because redemption happens on the registration/redeem invitation page rather than the sign-in page and the code still has to travel in the link to get there, and sending a username with a temporary password is not how invitation-based registration works — the customer creates their own credentials during redemption, and mailing a password is insecure.
Validate the user's email.: Invitation code sign-up — the invitation is generated against an existing Dataverse contact record and emailed only to the address stored on that contact, so only someone with access to that mailbox can obtain and redeem the code, which proves ownership of the email address and links the new portal login to the correct contact. Two-factor authentication confirms a second factor for an account that already exists rather than proving the address belongs to a known contact, and Azure Active Directory authentication or social provider sign-in delegates identity to an external provider without tying the sign-in to the contact's registered email in Dataverse.
You need to design the resort portal's email registration process.
Which solution should you use?
- A. Default the invitation code from the email upon logging into the portal
- B. Auto-populate the invitation code field on the sign in screen from the email link
- C. Embed the invitation code in the email link URL Correct
- D. Send the customer their username and temporary password in the email link
Explanation
Embedding the invitation code in the email link URL allows for a seamless registration process by directly utilizing the provided code without additional manual input, ensuring accuracy and ease of use.
You need to be able to move a Power Automate desktop flow used in the verification process to the testing environment.
What should you do?
- A. Share a copy of the desktop flow with a member of internal IT.
- B. Use the Export option in the flow to get the flow identifier and provide it to internal IT.
- C. Send a copy of the desktop flow to a member of internal IT.
- D. Create the desktop flow in a solution and provide it to internal IT. Correct
Explanation
Creating a desktop flow within a solution allows for the organized packaging of flows along with their dependencies. This method facilitates easy transfer and deployment to different environments, such as moving from verification to testing.
You create a desktop flow to interact with a certification authority's website.
You need to get data in and out of the desktop flow.
How should you set up the input and output parameters? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Inbound: Connect by using the Dataverse connector from the desktop flow and retrieve the qualification data. — Power Automate for desktop includes Dataverse actions (List rows / Get a row by ID) that let the desktop flow authenticate to the environment and pull the qualification record's data directly at runtime, which is the supported, unattended-capable way to feed data into the automation. Copying and pasting is a manual step that defeats the automation, and running a cloud flow "to send data to the desktop flow" is not how the handoff works — a cloud flow passes values only through the desktop flow's declared input variables when it invokes the flow, not as an independent push.
Outbound: Send data from the desktop flow to a cloud flow to update the qualification record. — The desktop flow exposes output variables whose values are returned to the calling cloud flow when the "Run a flow built with Power Automate for desktop" action completes; the cloud flow then uses the Dataverse Update a row action to write the verification data back to the qualification record. Manual copy and paste is not automation, and while Dataverse actions exist in desktop flows, the exam-intended and cleanest outbound pattern is returning the captured values to the orchestrating cloud flow, which owns the record update.
You need to configure a Power Automate flow to send the email with the results to the client.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Process qualification records for a service request.: Apply to Each — a service request returns a collection of qualification records (a List rows / Dataverse query result), and Apply to Each is the loop action that iterates over every item in that array so each qualification is handled individually. Condition only branches once on a single true/false test and Switch only routes on one value, so neither can walk through a multi-record collection.
Evaluate a qualification.: Do until — evaluating an individual qualification requires repeating the evaluation until the qualifying criteria are met (or the record reaches a terminal state), and Do until is the loop that keeps running while its condition remains false, re-checking after each pass. Condition would test the qualification only once with no re-evaluation, and Apply to Each iterates a fixed collection rather than repeating until a result is reached.
You need to capture the Date Completed value from the website using a desktop flow.
Which method should you use?
- A. Use optical character recognition (OCR) on the screen to locate and extract the value.
- B. Display an input dialog and prompt the user to enter the value.
- C. Extract the value from the window the browser is using.
- D. Retrieve the value from the HTML element in the webpage. Correct
Explanation
Power Automate desktop browser automation actions (for example, Get details of element on web page or Extract data from web page) read the value straight from the HTML element of the page through its UI element selector. This is the most reliable option: OCR depends on screen resolution and rendering, extracting from the browser window treats the page as a desktop UI and is less precise, and prompting the user is not automation.
You need to assign 10 percent of the Qualification records to the QV queue through table configuration by using a Power Automate flow.
What should you do?
- A. Create an autonumber column on the Qualification table and assign its qualification records if the number cleanly divides by 10. Correct
- B. Create a calculated column on the Service Request table that sums the number of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field.
- C. Create a roll-up column on the Service Request table that is the count of qualification records, generates a random number between zero and the number from the new field, and assigns each qualification record if the number generated is 10 percent or less of the value of the new field.
- D. Create an autonumber column on the Service Request table and assign its qualification records if the number cleanly divides by 10.
Explanation
Option A correctly addresses the requirement by using an autonumber column on the Qualification table to ensure that every 10th record is assigned, which approximates a 10 percent distribution. This method ensures a systematic and consistent allocation of records without relying on randomness.
You need to configure a Power Automate flow to send the email with the results to the client.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Trigger settings: Set Table name to Qualification and Column filter to statuscode. The flow uses the Dataverse trigger When a row is added, modified or deleted on the Qualification table, because a service request can only be completed after its qualifications are finished, so a change to a qualification is the event to react to. The column filter is statuscode (Status Reason), which holds detailed values such as Pending Verification and Complete; statecode only holds the broad Active/Inactive state, and triggering on Service Requests would not fire when a qualification changes.
Logic to complete service requests: Loop through related qualification records and complete if all are in Complete status. One service request can have several qualifications, so a single qualification being Complete is not enough, and Pending Verification means work is not finished. The flow lists the qualifications related to the parent service request, checks each status reason, and completes the service request only when every one of them is Complete.
You need to design the FAQ solution to handle unknown responses.
Which component should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Explanation
Handle an unknown question from a guest in a conversation: Escalate. In Power Virtual Agents, the Escalate system topic takes over when the bot can't resolve what the guest asked, so the guest has a path from the bot to a human agent instead of reaching a dead end. A Failure path isn't a Power Virtual Agents component for this purpose, because error branches handle action or flow failures, not unanswered questions. The Fallback topic only asks the guest to rephrase within the bot. It doesn't hand the unknown question off, which this design requires.
Redirect a guest with an unknown question to a live staff member: Omnichannel for Dynamics 365 Customer Service. Omnichannel for Customer Service receives the escalated conversation and routes it through queues and work streams to an available live agent. It passes along the bot transcript and context so the staff member can continue the conversation. Power Apps has no live-chat routing capability. Microsoft Teams and the Power Virtual Agents web application are only channels where the guest sees the chat, not the engine that assigns the conversation to a human agent.
You need to embed the FAQbot into the communication solution.
Which actions should you perform? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Add the new FAQ solution to the communication solution for the first time: Create a new app. The FAQ solution has never been added to the team, so nothing exists there yet to import. Creating a new app in Power Apps for Teams sets up the team's Dataverse for Teams environment, which then holds the FAQ solution. 'Import an existing app' and 'Import a new page' assume something has already been built for that team.
Configure the FAQ solution in Microsoft Teams: Import a chatbot. The FAQbot already exists, so you don't build a new one. You export it and import it into the team's environment through the Power Apps app in Teams, which brings over its topics and content. Creating a new chatbot would mean rebuilding the FAQ content from scratch. 'Configure the FAQbot' doesn't work because the bot isn't in the team's environment until it has been imported. After the import, settings that don't carry over, such as channel details, may need to be set again.
A guest asks about the start time of a specific scheduled event and wants to know what the snow conditions will be like during their stay.
You need to determine how to design the chat solution to answer those questions.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Identify and reference the company event a guest mentions.: Load the extracted topic into a variable — In a Power Virtual Agents chatbot, once the guest's phrase triggers the events topic, the value pulled from that trigger phrase must be stored in a variable so the bot can carry the specific event name through subsequent questions and pass it to the action that looks up the start time. Simply loading the response into a variable does not capture the topic-level extraction that identifies which company event was mentioned, and smart matching applies to matching user input against entity values rather than persisting the identified event for reuse.
Identify attributes for snow conditions.: Create a custom entity — Snow conditions (powder, packed, icy, slush, and similar terms) are not covered by the prebuilt entities, so you define a custom closed-list entity with those values and synonyms, which lets the bot recognize and extract the condition from natural language. A new topic only defines a conversation branch and a new variable only stores a value, neither of which teaches the bot how to recognize the domain-specific snow terminology in the first place.
You need to design the chat solution to answer the inquiry from Guest1.
Which three components can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Variables
- B. Escalations Correct
- C. Smart match Correct
- D. Synonyms
- E. Topics Correct
Explanation
Escalations can route inquiries to appropriate handlers, Smart Match can automatically identify and respond to user queries based on predefined patterns, and Topics allow for categorizing and responding to specific types of questions. These components independently provide complete solutions for handling guest inquiries.
You need to create the FAQ solution content.
What should you do first?
- A. AI Builder
- B. Automate
- C. Suggest topics Correct
- D. Trigger phrases
Explanation
Suggesting topics is the initial step in creating FAQ solution content as it helps identify the most relevant and frequently asked questions. This foundational step ensures that the subsequent content creation aligns with user needs.
You need to set up the new service request completion process.
Which two components should you include in the solution? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. connection reference
- B. business process flow Correct
- C. Power Automate flow Correct
- D. connection
Explanation
A business process flow (BPF) ensures that the service request completion process is consistent and follows defined steps. Power Automate Flow automates necessary actions to complete the service request efficiently.
You need to design and create the solution for gathering contact information from guests for marketing purposes.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Extract business card data.: AI Builder — AI Builder is the Power Platform's low-code AI service, and it is the component that supplies the business card reader capability that pulls names, job titles, phone numbers, and email addresses out of a scanned or photographed card. Common Data Service (Dataverse) is only the data store where the extracted contact rows are ultimately saved, and Power Automate/Power Virtual Agents merely orchestrate or converse — none of them can perform the optical extraction themselves, they simply invoke the AI Builder model.
Implement the contact gathering solution.: Use a prebuilt AI model. — AI Builder ships a prebuilt business card reader model that is already trained and requires no data collection, tagging, or training on the maker's part, so it can be dropped straight into a canvas app (via the Business Card Reader control) or a flow to capture guest details. Creating a new entity extraction component would mean building and training a custom model that targets unstructured text rather than card images, and integrating directly with Azure Cognitive Services adds pro-code work and a separate Azure subscription for a scenario the prebuilt model already covers out of the box.
You need to embed the business card solution in the check-in app.
What should you use?
- A. Input control
- B. Custom component
- C. Button control
- D. AI Builder component Correct
Explanation
The AI Builder component is designed for integrating intelligent solutions like business card scanning into applications. It provides the necessary tools and intelligence to process and extract information from business cards efficiently.
You need to design the guest check-in solution.
Which technologies should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Develop the base check-in solution: Canvas app — Check-in is a single, tightly scripted task performed by front-desk staff on tablets, and a canvas app lets you lay out exactly that screen flow (search the guest, confirm details, mark arrival) pixel by pixel while still writing to Dataverse and using device features such as the camera or barcode scanner. A model-driven app would impose its generic form/grid navigation rather than a purpose-built kiosk screen, and a Power Apps portal targets anonymous or external web visitors instead of an internal, device-based check-in experience.
Access the check-in solution on the check-in devices: Dynamics 365 for phones and tablets — The check-in devices are mobile tablets running the Dynamics 365 client, and that app is the supported way to open the Dataverse-backed check-in solution on them, including the embedded canvas app, with mobile-optimized layout and offline-capable behavior. A web browser would depend on a constant connection and would not give the tailored tablet experience or native device integration, and a traditional desktop application is not a delivery option for Power Platform apps at all.
You need to add the missing components to the Verification Process Automation solution.
Which two components should you add? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
- A. Service Request statuscode field
- B. Dataverse connection reference
- C. Qualification statuscode field Correct
- D. On-premises data gateway reference
- E. Outlook connection reference Correct
Explanation
The import failed because the flow for completing service requests depends on components that are not in the solution. The flow checks the Qualification records' status, and the Qualification statuscode field has been customized with new status values (such as Assigned), so that field must be added to the solution as a dependency. The flow also sends the templated results email through Outlook, so the solution needs an Outlook connection reference that maps to a connection in the target environment. An on-premises data gateway is not used, and the Service Request status field keeps its standard values, so it is not a missing customized dependency.
You need to coordinate updates and deployment for managed solutions containing completed work without disrupting the system.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:
Explanation
Deployment option for changes to an unrelated table: Deploy a patch with the changes made from the current solution. — A patch is created from an existing managed solution and carries only the delta (the added or modified components), so importing it layers the new table changes on top of what is already installed without touching unrelated components or removing anything, which is exactly what is needed for a small, isolated change that must not disrupt the running system. Deploying a full copy of the current or new solution with the upgrade option would reinstall the entire solution and delete any components no longer present in the package, an unnecessarily heavy and riskier operation for a single unrelated table.
Deployment option for automation enhancements: Deploy a full copy of the original solution using the upgrade option. Then, deploy the new solution by using the update option. — The upgrade pass on the original solution rolls up (consolidates) any outstanding patches and cleans out components that were deliberately removed, giving a clean, consistent base; the follow-up new solution is then brought in with the update option, which merges its automation components into the target environment while preserving components that are not part of that package, so existing customizations and dependencies keep working. The alternatives that use the upgrade option for both deployments, or that apply the new solution before the original is upgraded, risk deleting components the other solution still depends on or leaving the base solution in an inconsistent, un-rolled-up state.