PL-500 Practice Exam Free – 50 Questions to Simulate the Real Exam
Are you getting ready for the PL-500 certification? Take your preparation to the next level with our PL-500 Practice Exam Free – a carefully designed set of 50 realistic exam-style questions to help you evaluate your knowledge and boost your confidence.
Using a PL-500 practice exam free is one of the best ways to:
- Experience the format and difficulty of the real exam
- Identify your strengths and focus on weak areas
- Improve your test-taking speed and accuracy
Below, you will find 50 realistic PL-500 practice exam free questions covering key exam topics. Each question reflects the structure and challenge of the actual exam.
DRAG DROP - You plan to create a Microsoft Visio process diagram. You need to create the diagram and then export the diagram as a Power Automate flow. Which five 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.
A client would like you to create a custom connector. You need to configure the connector. Which element is required?
A. On-premises data gateway
B. Power Automate per user license
C. JSON sample for request
D. Power Automate per flow license
E. API Key
You are creating automation solutions for a company. You create a cloud flow that includes a Scope action. What is the purpose of the Scope action?
A. Run a group of actions based on conditional input.
B. Run a group of actions based on input from a switch statement.
C. Group actions together and ensure that all actions succeed or fail as a group.
D. Terminate a flow run.
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 plan to use a cloud flow. The flow must be contained within a solution. You need to add the cloud flow to a solution. Solution: Create a scheduled cloud flow outside of a solution. Add the cloud flow into a managed solution. Does the solution meet the goal?
A. Yes
B. No
DRAG DROP - Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - First Up Consultants is a professional services organization headquartered in Europe, with offices in North America. The company supports small- to medium-sized and enterprise organizations with a range of information technology, project management, change management, and finance management consultancy needs. The organization employs 500 full-time consultants and engages with over 1,000 external contractors to support the delivery of its various projects. Current environment - The company has been using Microsoft Power Platform for several years and currently has the following implemented: • A model-driven app named Project Planning Application that is used by the project management office (PMO) team within the company to plan, schedule and collate information for each client project. The application supports the following functionality areas: o Storage for project-level information, such as start date, end date and client data. o A series of inputs to capture detailed information for statements of work as part of a standard document format. This information is manually entered by the PMO team. o Information regarding internal and external consultants is stored within a custom table called Resources. o Information within the Resources table regarding full-time consultants is typically populated manually by the PMO team. For external consultants, the company regularly attends industry events and collates business cards for potential new employees or external contractors. Information regarding these individuals is then manually entered into the application. The PMO team then asks suitable candidates to complete an application form in Microsoft Word standard format and upload it via a secure URL. Again, the PMO team then manually enters the data into Project Planning Application. • A canvas app named Time Entry Application is used by the employees and external contractors to capture the time worked on projects. The application has been configured with the following defined controls: o dpStartDate: A date picker control to indicate the start date of the time entry. o dpEndDate: A date picker control to indicate the end date of the time entry. o inptDescription: A control used to indicate the type of activity and project worked on. • A mobile app stores the current user's email address as part of a variable called varUserName. The company uses Microsoft SharePoint on premises to store all sensitive documents. Company policy mandates that all client-related documents are stored within this environment only. The company uses SAP as its back-end accounting system. The company maintains separate SAP systems in each legal jurisdiction where it is based. The system is relied upon for the following critical business processes: • External contractors working on a project send their invoices to a dedicated mailbox that is monitored by the company's accounting team. The accounting team must then manually process these invoices into SAP at the end of each month. Due to the number of external contractors, hundreds of invoices must be processes monthly. • Basic API access for the SAP system is provided via a mixture of native application APIs and a middleware Simple Object Access Protocol (SOAP) API hosted on premises. The middleware API supports the ability to post time entries against the relevant projects in any SAP system by specifying the system and client ID as a query parameter in the URL. The middleware API was developed several years ago, and the source code is no longer available. Data is returned in XML format, which can then be analyzed further. • When a project enters the closure phase, members of the PMO team need to navigate to SAP, enter some details, and then capture information from a PDF that is generated and opened on the screen, such as the final settlement amount. This information is then manually entered into Project Planning Application. The company maintains a separate system containing detailed profile information regarding internal employees. The PMO team currently manually enters information from this system into the Resources table. Developers in the company have created a modern REST API for this system, which is actively maintained. The system contains highly sensitive personal information (PI) regarding each employee. The company has several on-premises Windows environments that it has identified as suitable for usage because they exist within the same physical network as SAP and the middleware API. These environments must be patched regularly, and all activities targeting these environments must be automated. Project Planning Application - • Rather than manually populating the statement of work information, users should place it in a SharePoint folder for this information to be extracted and mapped to the correct inputs. • A new automation is required to integrate with the profile information system. Because the company plans to consume this data in several ways, a streamlined mechanism for working with the API is required to improve reusability. • An automation is required to handle the project closure steps in SAP and to store the relevant information from SAP into the app. • Once a new candidate uploads a completed application form, information from the form should be copied automatically into Project Planning Application. Time Entry Application - • Time Entry Application needs to be extended to integrate alongside SAP, ensuring postings for time entries are processed successfully. When a time entry is submitted, the entry should be posted automatically to SAP. • Time entries must always be submitted with relevant text that indicates the type of activity and project worked on. • The automation should be able to detect and handle any errors that occur when posting individual time entries. Invoice Processing - • Invoices sent to the account’s mailbox must be processed automatically and created as invoices within SAP. General - • Development efforts should be avoided or mitigated when there is native functionality already available. • Reusability of components is desired to assist citizen developers in creating any solutions in future. • All automation activities should run without disruption during an outage or a patching cycle. • Use of username and password credentials should be avoided. • Automations should not rely on human intervention to execute. • Use of public cloud file services should be restricted. • Where possible, JSON should be the preferred format when transferring data. Issues - • Users within the PMO team report that it takes many hours to put the data from each business card into the system. • You create the automation to process the time entries, called Submit Time Entry, and add it to the application. Users report issues with the formula used to connect to the automation. • During a monthly patch cycle, IT support team members cannot identify the correct steps to patch the machine without disrupting any automation. • While performing an audit of the new solution during the test phase, the company's information security team identifies that users can freely save confidential documents to OneDrive for Business. • When creating the automation for the project closure process, you discover that some of the required information needs to be exported via the SAP GUI and extracted from a comma-separated value (CSV) file. • When building the automation for the profile information system, you identify that all requests into the API will fail unless the following HTTP header value is specified: o Accept: application/json You need to recommend a solution to address the requirements and issues. Which feature should you recommend? To answer, move the appropriate feature to the correct requirement or issue. You may use 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.
DRAG DROP - You are developing automation solutions for a company. You need to select the applicable flow type to automate the following tools and technologies: Microsoft Excel - Desktop application - File system - Which flow types should you use? To answer, drag the appropriate flow types to the correct automation targets. Each 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.
HOTSPOT - You are developing a new release for an automation solution. You need to use the right feature. Which feature should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT - You are creating an automation for a company. When a new record is created in a Microsoft Dataverse table, the automation must add the same data to an enterprise resource planning (ERP) system. The ERP system does not have an API. You need to create the automation solution. What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP - A company plans to use Microsoft Power Platform. The company requires multiple test environments for users. The company wants to ensure that the Microsoft Power Platform environments are appropriate for the following cases: • UserA wants to test Microsoft Power Platform features for a limited time. • UserB wants to test solutions. You need to select the environment type for each use case. Which environment types should you select? To answer, drag the appropriate environment type to the correct scenarios. Each environment 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.
You need to resolve the fulfillment status flow issue. Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each connect selection is worth one point.
A. Ensure that the flow instance does not remain in the queue for more than three hours.
B. Ensure that all users are signed out from the target machine.
C. Use different local Windows accounts for all machines.
D. Ensure that the flow is not using elevated privileges.
E. Trigger the flow by using an on-premises data gateway.
HOTSPOT - Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service. Woodgrove Bank has 177 branches across the United States with 5.000 branch staff and supervisors serving over 750,000 members. The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel. Current environment. Bank applications • An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates. • An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface. • An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support. • SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents. • Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously. Current environment. Bank devices • All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests. • All branch employees and supervisors are provided with a Windows workstation. Requirements. New member enrollment Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process. First step: • Members complete an online Woodgrove Bank document and email the PDF attachment to the bank’s shared mailbox for processing. Second step: • Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address. • Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology. Third step: • A branch supervisor approves the members’ application from their mobile device. • Only supervisors are authorized to complete application approvals. Fourth step: • Data that is received from applications must be validated to ensure it adheres to the bank's naming standards. The bank has the following requirements for the members’ data: • New members must be enrolled by using the document automation solution. • Member data is subject to regulatory requirements and should not be used for non-business purposes. • A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow. Requirements. Bank fees - The process for calculating bank fees include: • using a shared Excel fee workbook with an embedded macro, and • an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members' fees based on the number of products. Requirements. Fraud detection - The bank has the following requirements to minimize fraud: • Branch employees must use the Fraud Finder application during onboarding to validate a member’s identity with other third-party systems. • Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address. • If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team. Requirements. Technical - The bank has the following technical requirements: Flows - • The Fraud Finder application uses a custom connector with Power Automate to run fraud checks. • The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee s workstation and completes the approval. • The banker desktop flow runs using the default priority • An IT administrator is the co-owner of the banker desktop flow. • The IT department will be installing the required OCR language packs. • The Extract text with OCR action is used to import the members' secondary identification Member Management System - • A secure Azure function requires a subscription key to retrieve members’ information. • Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates. • The host URL has been added to the custom connector as a new pattern. • A tenant-level Microsoft Power Platform data loss prevention (DLP) policy has been created to manage the production environment. • A developer creates a desktop flow to automate data entry into a test instance of the Member Management System. • A developer creates an on-demand attended desktop flow to connect to a data validation site and retrieve the most current information for a member. Banker desktop application - • A banker desktop flow is required to update the core banking system with other systems. • When a transaction is complete, the branch employee submits the request by using a submit button. • After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update. • The banker desktop flow must be prioritized for all future transactions. Deployment & testing - • Development data must be confined to the development environment until the data is ready for user acceptance testing (UAT). • The production environment in SharePoint Online must connect to the development instance of the Member Management System. • Developers must be able to deploy software every two weeks during a scheduled maintenance window. • The banker desktop flow must continue to run during any planned maintenance. • The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request. Scalability - • The bank requires a machine group to distribute the automation workload and to optimize productivity. • The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group. Security - • The IT administrator uses a service principal account for machine connection. • The IT administrator has the Desktop Flow Machine Owner role. Issues - A branch staff member reports the document automation solution is not processing new members’ data and emails are not being sent for approvals. An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow. Code - A Power Automate developer created the following script for the Member Management System desktop flow:You need to implement the scripting action for the Member Management System flow. What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
You are using the Microsoft Power Apps maker portal to begin deployment of a solution. You are preparing for deployment of updates from a test environment to production. You need to deploy the solution. Which three actions should you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Set the solution version.
B. Create the environment.
C. Delete the solution.
D. Apply the solution upgrade.
E. Import the solution.
HOTSPOT - A company runs a process that includes multiple applications and departments. The process contains several constraints and could be more efficient. You need to understand the process and identify problems. Which feature should you use for each scenario? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP - You are developing automation solutions for a company. You need to use an environment variable in a cloud flow. 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.
DRAG DROP - Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service. Woodgrove Bank has 177 branches across the United States with 5.000 branch staff and supervisors serving over 750,000 members. The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel. Current environment. Bank applications • An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates. • An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface. • An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support. • SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents. • Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously. Current environment. Bank devices • All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests. • All branch employees and supervisors are provided with a Windows workstation. Requirements. New member enrollment Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process. First step: • Members complete an online Woodgrove Bank document and email the PDF attachment to the bank’s shared mailbox for processing. Second step: • Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address. • Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology. Third step: • A branch supervisor approves the members’ application from their mobile device. • Only supervisors are authorized to complete application approvals. Fourth step: • Data that is received from applications must be validated to ensure it adheres to the bank's naming standards. The bank has the following requirements for the members’ data: • New members must be enrolled by using the document automation solution. • Member data is subject to regulatory requirements and should not be used for non-business purposes. • A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow. Requirements. Bank fees - The process for calculating bank fees include: • using a shared Excel fee workbook with an embedded macro, and • an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members' fees based on the number of products. Requirements. Fraud detection - The bank has the following requirements to minimize fraud: • Branch employees must use the Fraud Finder application during onboarding to validate a member’s identity with other third-party systems. • Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address. • If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team. Requirements. Technical - The bank has the following technical requirements: Flows - • The Fraud Finder application uses a custom connector with Power Automate to run fraud checks. • The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee s workstation and completes the approval. • The banker desktop flow runs using the default priority • An IT administrator is the co-owner of the banker desktop flow. • The IT department will be installing the required OCR language packs. • The Extract text with OCR action is used to import the members' secondary identification Member Management System - • A secure Azure function requires a subscription key to retrieve members’ information. • Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates. • The host URL has been added to the custom connector as a new pattern. • A tenant-level Microsoft Power Platform data loss prevention (DLP) policy has been created to manage the production environment. • A developer creates a desktop flow to automate data entry into a test instance of the Member Management System. • A developer creates an on-demand attended desktop flow to connect to a data validation site and retrieve the most current information for a member. Banker desktop application - • A banker desktop flow is required to update the core banking system with other systems. • When a transaction is complete, the branch employee submits the request by using a submit button. • After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update. • The banker desktop flow must be prioritized for all future transactions. Deployment & testing - • Development data must be confined to the development environment until the data is ready for user acceptance testing (UAT). • The production environment in SharePoint Online must connect to the development instance of the Member Management System. • Developers must be able to deploy software every two weeks during a scheduled maintenance window. • The banker desktop flow must continue to run during any planned maintenance. • The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request. Scalability - • The bank requires a machine group to distribute the automation workload and to optimize productivity. • The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group. Security - • The IT administrator uses a service principal account for machine connection. • The IT administrator has the Desktop Flow Machine Owner role. Issues - A branch staff member reports the document automation solution is not processing new members’ data and emails are not being sent for approvals. An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow. Code - A Power Automate developer created the following script for the Member Management System desktop flow:
A company uses activity logging to measure performance for invoice processing. Users report that the data analytics department takes too long to manually analyze data. The company requires an automatic process to speed up activity log analysis and provide insights. You need to select the Microsoft Power Platform feature to meet the company requirement. Which feature should you select?
A. Power Automate for cloud
B. Process mining
C. Task mining
D. Power Automate for desktop
You are developing a flow that interacts with a Microsoft Dataverse table named Account. The table includes the following columns:The flow must only trigger when a record is added to the Accounts table and the following conditions are met: the websiteurl field is set to https://microsoft.com the crabd_triggerflow field is set to Yes You need to configure the flow trigger. Which trigger condition expression should you use?
A. @and(equals(triggerOutputs()?[‘body/crabd_triggerflow’], ‘126690000’), equals(triggerOutputs()?[‘body/websiteurl’], ‘https://microsoft.com’) )
B. @and(equals(triggerOutputs()?[‘body/crabd_triggerflow’], 126690001), equals(triggerOutputs()?[‘body/websiteurl’], ‘https://microsoft.com’) )
C. @or(equals(triggerOutputs()?[‘body/crabd_triggerflow’], 126690000), equals(triggerOutputs()?[‘body/websiteurl’], ‘https://microsoft.com’) )
D. @or(equals(triggerOutputs()?[‘body/crabd_triggerflow’], ‘126690001’), equals(triggerOutputs()?[‘body/websiteurl’], ‘https://microsoft.com’) )
You are creating a solution that will use a Choice field for approvals. You need to ensure that other users can use the Choice field with their Microsoft Dataverse tables. What should you use?
A. Global choice
B. Local choice
C. Environment variable
DRAG DROP - You are developing automation solutions for a company. You need to use Microsoft Office scripts in a cloud flow to calculate the number of business days between two dates. 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.
DRAG DROP - You deploy a cloud flow to a production environment. You make changes to the cloud flow in a development environment. You import the updated solution to the production environment. You observe that the cloud flow is not updated. You need to resolve the issue. 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.
DRAG DROP - A company has an unattended cloud flow solution. The solution includes a desktop flow that runs on a virtual machine. The company reports that the cloud flow processes more transactions per day than the planned capacity. You need to scale the solution to keep up with demand. 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.
You are developing a desktop flow that reads data from a table in a Microsoft Excel workbook. You need to read the cell in the fourth row and first column of the table. Which two expressions can you use? Each correct answer presents a complete solution. NOTE: Each correct answer is worth one point.
A. %ExcelData[1][4]%
B. %ExcelData[4][0]%
C. %ExcelData[‘Column1’][4]%
D. %ExcelData[4][‘Column1’]%
DRAG DROP - A company stores confidential documents in a SharePoint document library. A developer must create an automation solution in a default environment that processes documents from the SharePoint library and uploads approved documents to Azure File Storage for archiving purposes. The automation must meet the following requirements: * Prevent modification or deletion of approved documents from Azure File Storage. * Prevent sharing of documents from SharePoint or Azure File Storage. You need to configure a data loss prevention (DLP) policy. Which five 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.
DRAG DROP - A company plans to implement AI models to perform business processes. You need to determine whether to use prebuilt or custom AI models. Which type of model should you use for each scenario? To answer, drag the appropriate model types to the correct scenarios. Each model 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.
HOTSPOT - A company has a customer relationship management (CRM) app installed on a machine. Each month an employee signs into the machine by using their Azure Active Directory (Azure AD) account to generate a financial statement for each account in a list of accounts. The list of accounts is stored in Microsoft Dataverse. The employee must send each customer their statements by using Office 365 Outlook. You need to develop a solution to automate the task. Which components should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
HOTSPOT - You create a solution that includes a Power Automate cloud flow and desktop flow. You observe the following issues with the solution: • A single Power Automate cloud flow action has a long run time. • The Power Automate desktop flow encounters an error. You need to debug the solution. Which debug features should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP - You are designing an automation that processes information from documents attached to emails. You need to extract data from the attachments and insert the data into a custom Microsoft Dataverse table. Which five 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.
You are creating a custom connector to support invoice automation. You connect a Power Automate flow to the custom connector and successfully authenticate. When you test the flow, you observe that several actions are missing from the custom connector. You need to update the custom connector settings. What should you do?
A. Change the connection name.
B. Set the action visibility option to None.
C. Change the parameter drop-down type to Static.
D. Set the action visibility option to Internal.
E. Add an action description value.
HOTSPOT - You are automating a form on a website. The website uses the following HTML markup to define each field on the form:The label for each field is unique in the form. You need to write data to the form. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service. Woodgrove Bank has 177 branches across the United States with 5.000 branch staff and supervisors serving over 750,000 members. The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel. Current environment. Bank applications • An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates. • An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface. • An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support. • SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents. • Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously. Current environment. Bank devices • All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests. • All branch employees and supervisors are provided with a Windows workstation. Requirements. New member enrollment Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process. First step: • Members complete an online Woodgrove Bank document and email the PDF attachment to the bank’s shared mailbox for processing. Second step: • Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address. • Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology. Third step: • A branch supervisor approves the members’ application from their mobile device. • Only supervisors are authorized to complete application approvals. Fourth step: • Data that is received from applications must be validated to ensure it adheres to the bank's naming standards. The bank has the following requirements for the members’ data: • New members must be enrolled by using the document automation solution. • Member data is subject to regulatory requirements and should not be used for non-business purposes. • A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow. Requirements. Bank fees - The process for calculating bank fees include: • using a shared Excel fee workbook with an embedded macro, and • an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members' fees based on the number of products. Requirements. Fraud detection - The bank has the following requirements to minimize fraud: • Branch employees must use the Fraud Finder application during onboarding to validate a member’s identity with other third-party systems. • Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address. • If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team. Requirements. Technical - The bank has the following technical requirements: Flows - • The Fraud Finder application uses a custom connector with Power Automate to run fraud checks. • The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee s workstation and completes the approval. • The banker desktop flow runs using the default priority • An IT administrator is the co-owner of the banker desktop flow. • The IT department will be installing the required OCR language packs. • The Extract text with OCR action is used to import the members' secondary identification Member Management System - • A secure Azure function requires a subscription key to retrieve members’ information. • Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates. • The host URL has been added to the custom connector as a new pattern. • A tenant-level Microsoft Power Platform data loss prevention (DLP) policy has been created to manage the production environment. • A developer creates a desktop flow to automate data entry into a test instance of the Member Management System. • A developer creates an on-demand attended desktop flow to connect to a data validation site and retrieve the most current information for a member. Banker desktop application - • A banker desktop flow is required to update the core banking system with other systems. • When a transaction is complete, the branch employee submits the request by using a submit button. • After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update. • The banker desktop flow must be prioritized for all future transactions. Deployment & testing - • Development data must be confined to the development environment until the data is ready for user acceptance testing (UAT). • The production environment in SharePoint Online must connect to the development instance of the Member Management System. • Developers must be able to deploy software every two weeks during a scheduled maintenance window. • The banker desktop flow must continue to run during any planned maintenance. • The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request. Scalability - • The bank requires a machine group to distribute the automation workload and to optimize productivity. • The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group. Security - • The IT administrator uses a service principal account for machine connection. • The IT administrator has the Desktop Flow Machine Owner role. Issues - A branch staff member reports the document automation solution is not processing new members’ data and emails are not being sent for approvals. An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow. Code - A Power Automate developer created the following script for the Member Management System desktop flow:
A. The document processor flow is turned on.
B. The email importer flow is set to include attachments.
C. The document automation validator flow includes business logic.
D. The shared mailbox is set in the email importer flow.
Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background: Contoso Pharmaceuticals distributes specialty pharmaceuticals, ingredients, and raw materials throughout North America. The company has 33 offices and 12 warehouses across the US, Mexico, and Canada. As their customers’ needs grow in sophistication, Contoso wants to delight customers with breakthrough products, exceptional service, and on-time delivery of materials. They want to automate time consuming and manual processes that are prone to error. Contoso wants to consolidate and automate ordering and fulfillment processes. * The company has a fleet of 500 delivery trucks. The company has 150 drivers and uses third-party contractors to deliver goods. * The company has 400 warehouse workers and 30 finance clerks. * Contoso has 85 sales representatives and 50 customer service representatives. Sales representatives spend most of their time on the road visiting customers or prospects. * The IT department consists of four system administrators and six system analysts. Current environment: Contoso Pharmaceuticals has a custom enterprise resource management (ERP) system. It is difficult to integrate other applications and services with the system. Office staff manually key in purchase orders, customer orders, and invoices after they receive a scan or hard copy of an agreement. Applications: * The company uses a custom supplier management system named SMSApps that runs on each user’s workstation. The system is costly to run and maintain. SMSApp does not have an API. * Sales representatives manage customer requests by using Dynamics 365 Sales. * Contoso has Microsoft Power Platform development, user acceptance testing (UAT), and production environments. * Administrators create one Accounts Payable (AP) mailbox for each environment to support testing. * The use of a DLP policy and Desktop Flow development is specified as part of the automation requirements. Business Process: 1. Sales representatives create quotes by using a Microsoft Word document template. The template allows representatives to include product, quantity, and cost estimation details that will be needed to fulfil an order. The representative converts quotes to a PDF file and emails the file to the customer for approval. 2. The sales representative alerts the finance team about the new order and emails the finance team a copy of the quote for processing. 3. The finance team prints the quote and manually creates a purchase order (PO) into SMSApp to request materials from a known and trusted vendor. 4. The SMSApp distributes the PO to stakeholders. The system sends a copy to a shared finance team mailbox. 5. Once a PO is fulfilled by a vendor, the system sends an email to the finance mailbox. The finance team releases an order to the warehouse. 6. Materials are shipped from the vendor to one of Contoso’s warehouses. Warehouse workers enter key information from the waybill into SMSApp. The materials are unloaded and racked in the warehouse until they are shipped to customers. 7. Upon checking for new daily orders in SMSApp, they see an open order is pending that is awaiting the newly received materials. 8. The Warehouse worker loads an order onto a truck for delivery and marks the order as complete in SMSApp. 9. Sales representatives provide fulfillment status and tracking information for orders. 10. A finance clerk prepares an invoice and sends the invoice to the customer by email. The clerk sends a copy of the email to the shared AP mailbox. 11. The AP team monitors the shared mailbox to confirm that the customer has paid the invoice. Functional requirements: * Large volume orders must be processed before other orders. * Invoices must be cross-checked with received items against packing slip for shipments. * The finance team must be able to analyze patterns in transactional data to conduct fraud prevention activities. * You must automate the process of entering data about incoming orders into SMSApp. * The solution must follow the principle of least privilege. Purchase Order Quantity flow: * You must create an unmanaged solution to update purchase order details in SMSApp. The flow must use a manual trigger. * Members of Accounts Payable team will be testers for the solution. They must be able to access the Purchase Order Quantity flow. Flow for processing invoice data: * You must create a flow to monitor the AP mailbox. When an invoice arrives as an attachment in the inbox, the flow must automatically process the invoice data by using a form processing model. The flow must cross-check the received items against the packing slip. * You must use different Accounts Payable email addresses for development, user acceptance testing (UAT), and production environments. * You must use an environment variable to represent the Accounts Payable mailbox for the environment in use. * You must be able to use the environment variable across multiple cloud flows, a custom connector, and a canvas app. Technical requirements: * Users must only be allowed to connect to and access systems that are required for the employee to perform required job tasks. * All automation flows must be either co-owned or shared between staff. * All employees must be able to access the new environment to build personal productivity automations. * You must distribute the workload for desktop flows to optimize productivity. Monitor flows: * All data extracted from Invoices should be stored in a custom Dataverse entity. Only employees who are part of Finance role should be able to edit all Invoice data but must be prevented from creating or deleting one. Invoice data: All users report that they can see and modify invoice data. New environment: * The IT department creates a new environment. A user creates a cloud flow named FlowA in the environment that triggers a desktop flow. A user reports that the cloud flow does not trigger the desktop flow to run. * Microsoft Dataverse is not provisioned in the new environment. You attempt to create a Desktop flow in the default environment but receive a Dataverse error message and cannot proceed. Data entry automation flow: An administrator runs a new desktop flow in the development environment to automate data entry into SMSApp. The flow automatically reverts to a suspended state. Order fulfillment flow: You must automate the customer communication process by using an unattended desktop flow. The flow must check the fulfilment status of each active order in SMSApp. If an order is fulfilled, the flow must send the customer an email that includes tracking information for their order. You need to configure permissions for the Purchase order quantity flow. Which permission should you assign?
A. Co-owner
B. User
C. Run-only user
D. Owner
You create a variable named NewVar as shown in the configuration screen below.You attempt to set the value of NewVar to the following URL: https//contoso.sharepoint.com/Mictosoft/PP/Shared%20Documents/Forms/AllItems.aspx The Set variable page alerts you that there is a syntax error. You need to resolve the issue. What should you do?
A. Escape the forward slash characters (/) with a back slash (/).
B. Replace the percent sign (%) with two percent sings (%%).
C. Replace the forward slash characters (/) with two forward slash characters (//).
D. Escape the percent sign (%) with a back slash (%).
Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service. Woodgrove Bank has 177 branches across the United States with 5.000 branch staff and supervisors serving over 750,000 members. The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel. Current environment. Bank applications • An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates. • An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface. • An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support. • SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents. • Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously. Current environment. Bank devices • All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests. • All branch employees and supervisors are provided with a Windows workstation. Requirements. New member enrollment Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process. First step: • Members complete an online Woodgrove Bank document and email the PDF attachment to the bank’s shared mailbox for processing. Second step: • Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address. • Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology. Third step: • A branch supervisor approves the members’ application from their mobile device. • Only supervisors are authorized to complete application approvals. Fourth step: • Data that is received from applications must be validated to ensure it adheres to the bank's naming standards. The bank has the following requirements for the members’ data: • New members must be enrolled by using the document automation solution. • Member data is subject to regulatory requirements and should not be used for non-business purposes. • A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow. Requirements. Bank fees - The process for calculating bank fees include: • using a shared Excel fee workbook with an embedded macro, and • an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members' fees based on the number of products. Requirements. Fraud detection - The bank has the following requirements to minimize fraud: • Branch employees must use the Fraud Finder application during onboarding to validate a member’s identity with other third-party systems. • Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address. • If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team. Requirements. Technical - The bank has the following technical requirements: Flows - • The Fraud Finder application uses a custom connector with Power Automate to run fraud checks. • The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee s workstation and completes the approval. • The banker desktop flow runs using the default priority • An IT administrator is the co-owner of the banker desktop flow. • The IT department will be installing the required OCR language packs. • The Extract text with OCR action is used to import the members' secondary identification Member Management System - • A secure Azure function requires a subscription key to retrieve members’ information. • Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates. • The host URL has been added to the custom connector as a new pattern. • A tenant-level Microsoft Power Platform data loss prevention (DLP) policy has been created to manage the production environment. • A developer creates a desktop flow to automate data entry into a test instance of the Member Management System. • A developer creates an on-demand attended desktop flow to connect to a data validation site and retrieve the most current information for a member. Banker desktop application - • A banker desktop flow is required to update the core banking system with other systems. • When a transaction is complete, the branch employee submits the request by using a submit button. • After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update. • The banker desktop flow must be prioritized for all future transactions. Deployment & testing - • Development data must be confined to the development environment until the data is ready for user acceptance testing (UAT). • The production environment in SharePoint Online must connect to the development instance of the Member Management System. • Developers must be able to deploy software every two weeks during a scheduled maintenance window. • The banker desktop flow must continue to run during any planned maintenance. • The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request. Scalability - • The bank requires a machine group to distribute the automation workload and to optimize productivity. • The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group. Security - • The IT administrator uses a service principal account for machine connection. • The IT administrator has the Desktop Flow Machine Owner role. Issues - A branch staff member reports the document automation solution is not processing new members’ data and emails are not being sent for approvals. An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow. Code - A Power Automate developer created the following script for the Member Management System desktop flow:
A. API key
B. No authentication
C. OAuth 2.0
D. Basic
E. Windows
HOTSPOT - You are developing an automation solution for a bank. The solution will use a cloud flow and a desktop flow. The cloud flow retrieves sensitive information from Azure Key Vault and must pass the information to the desktop flow. You configure a Get secret action as shown in the Get secret exhibit. You configure the desktop flow as shown in the Desktop flow exhibit. You need to ensure that no one can preview sensitive information by viewing the cloud flow or desktop flow run details. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
DRAG DROP - You create a Microsoft Power Platform solution. You create variables to define input values for the flow. You export the solution as managed and import the solution into a user acceptance testing (UAT) environment. The flow in the UAT environment is still using the values from the development (DEV) environment. You need to resolve the issue. 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.
You create a custom connector that retrieves data from an API. The host URL of the API requires a connection with a dynamic subdirectory path. You need to ensure the custom connector's requests are completed successfully. Which two features should you use? Each correct answer presents a part of the solution. NOTE: Each correct selection is worth one point.
A. Use references
B. Define a base URL
C. Define a policy
D. Use custom code
HOTSPOT - You need to design automation solutions for a company. What should you implement? To answer, select the appropriate configuration in the answer area. NOTE: Each correct selection is worth one point.
Case study -
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. When you are ready to answer a question, click the Question button to return to the question.
Background:
City Power and Light is one of the biggest energy companies in North America. They extract, produce and transport oil. The company has more than 50 offices and 100 oil extraction facilities throughout the United States, Canada, and Mexico. They use railways, trucks, and pipelines to move oil and gas from their facilities.
The company provides the following services:
* Produce oil from oil sands safely, responsibly, and reliably.
* Refine crude of into high-quality products.
* Develop and manage wind power facilities.
* Transport oil to different countries/regions.
City Power and Light uses various Microsoft software products to manage is daily actives and run its machine-critical applications.
Maintenance Tasks:
A user named Admin1 creates a cloud flow named ManagePipelineMaintenanceTasks. Admin1 applies a data loss prevention (DLP) policy to the flow. Admin1 shares the flow with a user named PipelineManager1 as co-owner. You must determine the actions that PipelineManager1 can perform.
Maintenance Scheduler:
You create a cloud flow that uses a desktop flow. The desktop flow connects to third-party services to fetch information. You must not permit the desktop flow to run for more than 20Â minutes.
You must configure sharing for MaintenanceScheduler to meet the following requirements:
* User1 must be able to work with you to modify the desktop flow.
* User2 must be able to access and review the run history for the flow.
* You must grant User3 permissions to run but not modify the desktop flow.
ERPDataOperations flow:
City Power and light uses an enterprise resource planning (ERP) system. The ERP system does not have an API.
Each day the company receives an email that contains an attachment. The attachment lists orders from the company’s rail transportation partners. You must create an automation solution that reads the contents of the email and writes records to the ERP system. The solution must pass credential from a cloud flow to a desktop flow.
RailStatusUpdater:
City Power and Light actively monitors all products in transit. You must create a flow named RailStatusUpdater that manages communications with railways that transport the company’s products. RailStatusUpdater includes five desktop flow actions.
You must run the desktop flows in attended mode during testing. You must run the desktop flows in unattended mode after you deploy the solution. You must minimize administrative efforts.
Packaging:
You must package the automations in a solution. All required components must be included in the solution.
ProductionMonitor flow:
You create a cloud flow named ProductionMonitor which uses the Manually trigger a flow trigger. You plan to trigger ProductionMonitor from a cloud flow named ProdManager.
You add a Run a Child flow action in ProdManager to trigger ProductionMonitor. When you attempt to save ProdManager the following error message displays:
Request to XRM API failed with error: 'Message:Flow client error returned with status code "Bad request" and details "("error":
{"code":ChildFlowUnsupportedForinvokerConnections", "message": The workflow with id 8d3bcde7-7e98-eb11-b1ac-000d3a32d53f", named FlowA cannot be used as a child workflow because child workflows only support embedded connections. "}}"Code" 0x80060467 InnerError.'
CapacityPlanning flow:
Developers within the company use could flows to access data from an on-premises capacity planning system.
You observe significant increases to the volume of traffic that the on-premises data gateway processes each day. You must minimize gateway failures.
DataCollector flow:
You have a desktop flow that interacts with a web form. The flow must write data to several fields on the form.
You are testing the flow. The flow fails when attempting to write data to any field on the web form.
RailStatusUpdater flow:
The RailStatusUpdater flow occasionally fails due to machine connection errors. You can usually get the desktop flow to complete by resubmitting the cloud flow run. You must automate the retry process to ensure that you do not need to manually resubmit the cloud flow when machine connection errors occur.
You need to resolve the issue with the DataCollector flow.
What are two possible ways to achieve the goal? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Configure the Populate text field on a web page actions to continue running the flow in case of error.
B. Replace the Populate text field on a web page action with the Send keys action to write data.
C. Remove the Focus text field on a web page actions that precede actions which write data to text fields.
D. Add an if web page contains action to determine whether a field exists and write data only when true.
E. Modify selectors to ensure that field attributes are mapped correctly.
You have an automation solution that uses a desktop flow. The flow reads data from a file that is stored on a UserA’s machine and writes the data to an application. You import the solution to an environment that is connected to UserB’s machine. UserB reports that the flow fails. An alert indicates that the path to a file does not exist. You confirm that the file present on the UserB’s desktop. You need to resolve the issue. What should UserB do?
A. Delete and recreate the file.
B. Use the Get Windows environment variable action to read the USERNAME environment variable and use the value in the path to the user’s desktop.
C. Modify the action to retry if the process cannot find the file.
D. Change access rights for the file to allow read operations for the PAD process.
Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - Woodgrove Bank is a large, member-owned bank in the United States Woodgrove Bank provides financial products with low customer fees and direct customer service. Woodgrove Bank has 177 branches across the United States with 5.000 branch staff and supervisors serving over 750,000 members. The primary languages used by most members include English and Spanish when interacting with customer service representatives. The Woodgrove Bank headquarters is in California and has 450 office workers. The office workers include financial advisors, customer service representatives, finance clerks, and IT personnel. Current environment. Bank applications • An application named Banker Desktop. The branch employees use this desktop app to review business transactions and to perform core banking updates. • An application named Member Management System. This application is a custom customer relationship management (CRM) that integrates with other systems by using an API interface. • An application named Fraud Finder. This application is a mission-critical, fraud management application that runs on the employees' desktops. The bank has experienced challenges integrating the application with other systems and is expensive to support. • SharePoint Online provides an employee intranet as well as a member document management system that includes polices, contracts, statements, and financial planning documents. • Microsoft Excel is used to perform calculations and run macros. Branch employees may have multiple Microsoft Excel workbooks open on their desktop simultaneously. Current environment. Bank devices • All supervisors are provided with a mobile device that can be used to access company email and respond to approval requests. • All branch employees and supervisors are provided with a Windows workstation. Requirements. New member enrollment Woodgrove Bank requires new members to sign up online to start the onboarding process. The bank requires some manual steps to be performed during the onboarding process. First step: • Members complete an online Woodgrove Bank document and email the PDF attachment to the bank’s shared mailbox for processing. Second step: • Members are asked to provide secondary identification to their local branch, such as a utility bill, to validate their physical address. • Branch staff scan the secondary identification in English or Spanish using optical character recognition (OCR) technology. Third step: • A branch supervisor approves the members’ application from their mobile device. • Only supervisors are authorized to complete application approvals. Fourth step: • Data that is received from applications must be validated to ensure it adheres to the bank's naming standards. The bank has the following requirements for the members’ data: • New members must be enrolled by using the document automation solution. • Member data is subject to regulatory requirements and should not be used for non-business purposes. • A desktop workflow is required to retrieve member information from the Member Management System on-demand or by using a cloud flow. Requirements. Bank fees - The process for calculating bank fees include: • using a shared Excel fee workbook with an embedded macro, and • an attended desktop flow that is required to automate the fee workbook process. The flow should open an Excel workbook and calculate the members' fees based on the number of products. Requirements. Fraud detection - The bank has the following requirements to minimize fraud: • Branch employees must use the Fraud Finder application during onboarding to validate a member’s identity with other third-party systems. • Branch employees must be able to search for a member in the Fraud Finder application by using a member's full name or physical address. • If fraudulent activity is identified, a notification with member details must be sent to the internal fraud investigation team. Requirements. Technical - The bank has the following technical requirements: Flows - • The Fraud Finder application uses a custom connector with Power Automate to run fraud checks. • The application approval process triggers a cloud flow, then starts an attended desktop flow on the branch employee s workstation and completes the approval. • The banker desktop flow runs using the default priority • An IT administrator is the co-owner of the banker desktop flow. • The IT department will be installing the required OCR language packs. • The Extract text with OCR action is used to import the members' secondary identification Member Management System - • A secure Azure function requires a subscription key to retrieve members’ information. • Production flows must connect to the Member Management System with a custom connector. The connector uses the Azure function to perform programmatic retrievals, creates, and updates. • The host URL has been added to the custom connector as a new pattern. • A tenant-level Microsoft Power Platform data loss prevention (DLP) policy has been created to manage the production environment. • A developer creates a desktop flow to automate data entry into a test instance of the Member Management System. • A developer creates an on-demand attended desktop flow to connect to a data validation site and retrieve the most current information for a member. Banker desktop application - • A banker desktop flow is required to update the core banking system with other systems. • When a transaction is complete, the branch employee submits the request by using a submit button. • After submitting the request, an instant cloud flow calls an unattended desktop flow to complete the core banking update. • The banker desktop flow must be prioritized for all future transactions. Deployment & testing - • Development data must be confined to the development environment until the data is ready for user acceptance testing (UAT). • The production environment in SharePoint Online must connect to the development instance of the Member Management System. • Developers must be able to deploy software every two weeks during a scheduled maintenance window. • The banker desktop flow must continue to run during any planned maintenance. • The fraud custom connector requires a policy operation named EscalateForFraud with a parameter that uses the members' full name in the request. Scalability - • The bank requires a machine group to distribute the automation workload and to optimize productivity. • The IT administrator needs to silently register 20 new machines to Power Automate and then add them to the machine group. Security - • The IT administrator uses a service principal account for machine connection. • The IT administrator has the Desktop Flow Machine Owner role. Issues - A branch staff member reports the document automation solution is not processing new members’ data and emails are not being sent for approvals. An IT administrator reports that the banker desktop flow has become unresponsive from data that is queued in another flow. Code - A Power Automate developer created the following script for the Member Management System desktop flow:
A. Set the machine group in maintenance mode.
B. Enable maintenance mode on all machines.
C. Disable the banker desktop cloud flow.
D. Enable maintenance mode on each machine separately.
E. Update the connected environment on the running machines.
HOTSPOT - You create an environment for a company. You need to configure security to meet the company’s requirements and follow the principle of least privilege. Which security roles should you assign? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
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 a cloud flow that will use two Update Row actions to interact with Microsoft Dataverse. Neither of these actions are dependent on each other. You must minimize the amount of processing time require to complete the flow. You need to implement the actions in the cloud flow. Solution: Create two sequential Update Row actions. Does the solution meet the goal?
A. Yes
B. No
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 a cloud flow that will use two Update Row actions to interact with Microsoft Dataverse. Neither of these actions are dependent on each other. You must minimize the amount of processing time require to complete the flow. You need to implement the actions in the cloud flow. Solution: Create a do until loop. Does the solution meet the goal?
A. Yes
B. No
DRAG DROP - Overview - Contoso Pharmaceuticals has a custom enterprise resource management (ERP) system. It is difficult to integrate other applications and services with the system. Office staff manually key in purchase orders, customer orders, and invoices after they receive a scan or hard copy of an agreement. Applications - • The company uses a custom supplier management system named SMSApps that runs on each user’s workstation. The system is costly to run and maintain. SMSApp does not have an API. • Sales representatives manage customer requests by using Dynamics 365 Sales. • Contoso has Microsoft Power Platform development, user acceptance testing (UAT), and production environments. • Administrators create one Accounts Payable (AP) mailbox for each environment to support testing. • The use of a DLP policy and Desktop Flow development is specified as part of the automation requirements. Security - You assign all users one or more Microsoft Dataverse security roles. Business Process - 1. Sales representatives create quotes by using a Microsoft Word document template. The template allows representatives to include product, quantity, and cost estimation details that will be needed to fulfil an order. The representative converts quotes to a PDF file and emails the file to the customer for approval. 2. The sales representative alerts the finance team about the new order and emails the finance team a copy of the quote for processing. 3. The finance team prints the quote and manually creates a purchase order (PO) into SMSApp to request materials from a known and trusted vendor. 4. The SMSApp distributes the PO to stakeholders. The system sends a copy to a shared finance team mailbox. 5. Once a PO is fulfilled by a vendor, the system sends an email to the finance mailbox. The finance team releases an order to the warehouse. 6. Materials are shipped from the vendor to one of Contoso’s warehouses. Warehouse workers enter key information from the waybill into SMSApp. The materials are unloaded and racked in the warehouse until they are shipped to customers. 7. Upon checking for new daily orders in SMSApp, they see an open order is pending that is awaiting the newly received materials. 8. The Warehouse worker loads an order onto a truck for delivery and marks the order as complete in SMSApp. 9. Sales representatives provide fulfillment status and tracking information for orders. 10. A finance clerk prepares an invoice and sends the invoice to the customer by email. The clerk sends a copy of the email to the shared AP mailbox. 11. The AP team monitors the shared mailbox to confirm that the customer has paid the invoice. Requirements - Functional requirements - • Large volume orders must be processed before other orders. • Invoices must be cross-checked with received items against packing slip for shipments. • The finance team must be able to analyze patterns in transactional data to conduct fraud prevention activities. • You must automate the process of entering data about incoming orders into SMSApp. • The solution must follow the principle of least privilege. Purchase Order Quantity flow - • You must create an unmanaged solution to update purchase order details in SMSApp. The flow must use a manual trigger. • Members of Accounts Payable team will be testers for the solution. They must be able to access the Purchase Order Quantity flow. Flow for processing invoice data • You must create a flow to monitor the AP mailbox. When an invoice arrives as an attachment in the inbox, the flow must automatically process the invoice data by using a form processing model. The flow must cross-check the received items against the packing slip. • You must use different Accounts Payable email addresses for development, user acceptance testing (UAT), and production environments. • You must use an environment variable to represent the Accounts Payable mailbox for the environment in use. • You must be able to use the environment variable across multiple cloud flows, a custom connector, and a canvas app. Technical requirements - • Users must only be allowed to connect to and access systems that are required for the employee to perform required job tasks. • All automation flows must be either co-owned or shared between staff. • All employees must be able to access the new environment to build personal productivity automations. • You must distribute the workload for desktop flows to optimize productivity. • A DLP policy must be created and applied to the Development environment. Connectors required by the data entry automation flow must be added to the policy. Order fulfillment flow - You must automate the customer communication process by using an unattended desktop flow. The flow must check the fulfilment status of each active order in SMSApp. If an order is fulfilled, the flow must send the customer an email that includes tracking information for their order. Monitor flows - • All data extracted from Invoices should be stored in a custom Dataverse table. • You must assign users from the finance to the Finance business unit. You must add these users to a new security role named Finance. • Finance users must be prevented from creating or deleting invoice records. • All users must be able to view invoices. Issues - Invoice data - All users report that they can see and modify invoice data. New environment - • The IT department creates a new environment that includes Microsoft Dataverse. An employee reports operational issues in Power Platform Admin center. • A user switch to the new environment and creates a cloud flow named FlowA that triggers a desktop flow. The user reports that the cloud flow does not trigger the desktop flow to run. • A user attempts to create a Desktop flow in the default environment. A Dataverse error message displays. Data entry automation flow - An administrator runs a new desktop flow in the development environment to automate data entry into SMSApp. The flow automatically reverts to a suspended state. Order fulfillment flow - The warehouse team observers that the order fulfillment flow has stopped working. Orders are flowing into SMSApp but customers do not receive tracking emails. A system administrator is troubleshooting the flow on the target machine. You need to implement a solution to manage the priority of incoming orders. 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.
You must create new flows within a solution and import exiting flows into the solution. You need to configure the solution. Which three actions can you perform? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
A. Create the flows within the solution to automatically create connection references.
B. Select connections for connection references when you import solutions into an environment.
C. Add an existing connection reference into the solution in the same environment.
D. Add credential information to each connection reference.
E. Modify each trigger and action when you add a flow into the solution to use connection references instead of connections.
DRAG DROP - You are setting up a data loss prevention (DLP) policy for an environment. The default policy group is set to Non-business. You must configure the following apps in the policy: • AppA will be used for tracking business-sensitive data. • AppB will be deployed in six months and must be automatically added to the published policy. • AppC uses a custom connector. The connector uses personal data for testing. When testing is complete, the connector will connect to business-sensitive data. You need to select the appropriate policy for each app. Which policy should you use for each app? To answer, drag the appropriate policies to the correct apps. Each app 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.
HOTSPOT - You are developing automation solutions for a company. You need to select the components to use for each scenario. You must minimize development efforts. Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
DRAG DROP - A user is evaluating the capabilities of both process mining and task mining. You need to determine when you should use process mining or task mining. Which Process advisor capability should you use? To answer, drag the appropriate capabilities to the correct requirements. Each capability 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.
HOTSPOT - You need to configure the solution for the ERPDataOperations flow. Which configuration values should you use? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Case study - 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. When you are ready to answer a question, click the Question button to return to the question. Background - First Up Consultants is a professional services organization headquartered in Europe, with offices in North America. The company supports small- to medium-sized and enterprise organizations with a range of information technology, project management, change management, and finance management consultancy needs. The organization employs 500 full-time consultants and engages with over 1,000 external contractors to support the delivery of its various projects. Current environment - The company has been using Microsoft Power Platform for several years and currently has the following implemented: • A model-driven app named Project Planning Application that is used by the project management office (PMO) team within the company to plan, schedule and collate information for each client project. The application supports the following functionality areas: o Storage for project-level information, such as start date, end date and client data. o A series of inputs to capture detailed information for statements of work as part of a standard document format. This information is manually entered by the PMO team. o Information regarding internal and external consultants is stored within a custom table called Resources. o Information within the Resources table regarding full-time consultants is typically populated manually by the PMO team. For external consultants, the company regularly attends industry events and collates business cards for potential new employees or external contractors. Information regarding these individuals is then manually entered into the application. The PMO team then asks suitable candidates to complete an application form in Microsoft Word standard format and upload it via a secure URL. Again, the PMO team then manually enters the data into Project Planning Application. • A canvas app named Time Entry Application is used by the employees and external contractors to capture the time worked on projects. The application has been configured with the following defined controls: o dpStartDate: A date picker control to indicate the start date of the time entry. o dpEndDate: A date picker control to indicate the end date of the time entry. o inptDescription: A control used to indicate the type of activity and project worked on. • A mobile app stores the current user's email address as part of a variable called varUserName. The company uses Microsoft SharePoint on premises to store all sensitive documents. Company policy mandates that all client-related documents are stored within this environment only. The company uses SAP as its back-end accounting system. The company maintains separate SAP systems in each legal jurisdiction where it is based. The system is relied upon for the following critical business processes: • External contractors working on a project send their invoices to a dedicated mailbox that is monitored by the company's accounting team. The accounting team must then manually process these invoices into SAP at the end of each month. Due to the number of external contractors, hundreds of invoices must be processes monthly. • Basic API access for the SAP system is provided via a mixture of native application APIs and a middleware Simple Object Access Protocol (SOAP) API hosted on premises. The middleware API supports the ability to post time entries against the relevant projects in any SAP system by specifying the system and client ID as a query parameter in the URL. The middleware API was developed several years ago, and the source code is no longer available. Data is returned in XML format, which can then be analyzed further. • When a project enters the closure phase, members of the PMO team need to navigate to SAP, enter some details, and then capture information from a PDF that is generated and opened on the screen, such as the final settlement amount. This information is then manually entered into Project Planning Application. The company maintains a separate system containing detailed profile information regarding internal employees. The PMO team currently manually enters information from this system into the Resources table. Developers in the company have created a modern REST API for this system, which is actively maintained. The system contains highly sensitive personal information (PI) regarding each employee. The company has several on-premises Windows environments that it has identified as suitable for usage because they exist within the same physical network as SAP and the middleware API. These environments must be patched regularly, and all activities targeting these environments must be automated. Project Planning Application - • Rather than manually populating the statement of work information, users should place it in a SharePoint folder for this information to be extracted and mapped to the correct inputs. • A new automation is required to integrate with the profile information system. Because the company plans to consume this data in several ways, a streamlined mechanism for working with the API is required to improve reusability. • An automation is required to handle the project closure steps in SAP and to store the relevant information from SAP into the app. • Once a new candidate uploads a completed application form, information from the form should be copied automatically into Project Planning Application. Time Entry Application - • Time Entry Application needs to be extended to integrate alongside SAP, ensuring postings for time entries are processed successfully. When a time entry is submitted, the entry should be posted automatically to SAP. • Time entries must always be submitted with relevant text that indicates the type of activity and project worked on. • The automation should be able to detect and handle any errors that occur when posting individual time entries. Invoice Processing - • Invoices sent to the account’s mailbox must be processed automatically and created as invoices within SAP. General - • Development efforts should be avoided or mitigated when there is native functionality already available. • Reusability of components is desired to assist citizen developers in creating any solutions in future. • All automation activities should run without disruption during an outage or a patching cycle. • Use of username and password credentials should be avoided. • Automations should not rely on human intervention to execute. • Use of public cloud file services should be restricted. • Where possible, JSON should be the preferred format when transferring data. Issues - • Users within the PMO team report that it takes many hours to put the data from each business card into the system. • You create the automation to process the time entries, called Submit Time Entry, and add it to the application. Users report issues with the formula used to connect to the automation. • During a monthly patch cycle, IT support team members cannot identify the correct steps to patch the machine without disrupting any automation. • While performing an audit of the new solution during the test phase, the company's information security team identifies that users can freely save confidential documents to OneDrive for Business. • When creating the automation for the project closure process, you discover that some of the required information needs to be exported via the SAP GUI and extracted from a comma-separated value (CSV) file. • When building the automation for the profile information system, you identify that all requests into the API will fail unless the following HTTP header value is specified: o Accept: application/json You need to identify the components required to deploy the automation for Project Planning Application. Which three components should you identify? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A. Application ID
B. Client secret
C. Username
D. Tenant ID
E. Password
Free Access Full PL-500 Practice Exam Free
Looking for additional practice? Click here to access a full set of PL-500 practice exam free questions and continue building your skills across all exam domains.
Our question sets are updated regularly to ensure they stay aligned with the latest exam objectives—so be sure to visit often!
Good luck with your PL-500 certification journey!