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 determine the formula to use for the time entry posting automation.
Which formula should you use?
A. ‘Submit Time Entry’.Run(dpStartDate.InputTextPlaceholder, dpEndDate.InputTextPlaceholder, inptDescription.Text)
B. ‘Submit Time Entry’.Run(dpStartDate.SelectedDate, dpEndDate.SelectedDate, inptDescription.Text)
C. ‘Submit Time Entry’.Run(dpStartDate.InputTextPlaceholder, dpEndDate.InputTextPlaceholder, varUserName)
D. ‘Submit Time Entry’.Run(dpStartDate.SelectedDate, dpEndDate.SelectedDate, varUserName)
Show Answer
Correct Answer: B
Explanation: The Power Automate flow is invoked from a canvas app using the .Run() function, which must pass the actual values expected by the flow. For date picker controls, the correct property to pass is SelectedDate, not InputTextPlaceholder. The automation also requires descriptive text for the time entry, which is provided by inptDescription.Text, not the username variable. Therefore, passing dpStartDate.SelectedDate, dpEndDate.SelectedDate, and inptDescription.Text is the correct and valid formula.
Question 20
DRAG DROP -
You need to create several desktop flow processes on the same application.
Each process uses different sign-in data.
You need to create and use a standalone sign-in process.
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.
Show Answer
Correct Answer: Define input variables
Create sign-in process
Add Run desktop flow action in each process
Set input variables
Explanation: Input variables must exist before the sign-in flow can consume them. After creating the reusable sign-in desktop flow, each parent process calls it via Run desktop flow and supplies the specific credentials by setting the input variables.
Question 21
Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.
After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.
A procurement department is using email to collect large volumes of quotes from vendors.
Data from quotes, including vendor data and quote terms, must be stored in Microsoft Dataverse.
You need to create a solution to automate the process.
Solution: Cloud flow using the Extract information from invoices AI Builder model
Does the solution meet the goal?
A. Yes
B. No
Show Answer
Correct Answer: B
Explanation: The Extract information from invoices AI Builder model is prebuilt and trained specifically for invoice documents. Vendor quotes are a different document type with different structure and fields, so this model would not reliably extract quote terms or data. A custom document processing model or a different AI Builder approach would be required, therefore the solution does not meet the goal.
Question 22
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 build the automation for Time Entry Application.
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.
Show Answer
Correct Answer: Create a cloud flow.
Define input parameters using Ask in Power Apps.
Use a HTTP POST action.
Use the Call SAP function (V2).
Explanation: Time entries are submitted from a canvas app, so a cloud flow is required. Inputs must be defined with **Ask in Power Apps** to pass values from the app. The SAP middleware exposes a SOAP/HTTP endpoint, which is invoked using an HTTP POST, and SAP-specific processing is completed using the Call SAP function (V2). This approach avoids desktop dependencies and supports automated, resilient execution.
Question 23
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 determine the correct action to use for the time entry automation.
Which action should you use?
A. HTTP
B. Invoke web service
C. HTTP with Azure AD
D. Invoke SOAP web service
Show Answer
Correct Answer: D
Explanation: The case study states that SAP time entry posting is exposed through an on‑premises middleware SOAP API. For Power Automate, the correct built‑in action to call a SOAP-based service is **Invoke SOAP web service**. Other options (HTTP or HTTP with Azure AD) are more appropriate for REST/JSON APIs, which is not the interface used for SAP time postings in this scenario.
Question 24
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 for the project closure steps.
Which solution should you recommend?
A. Classic workflow
B. Desktop flow
C. Cloud flow
D. Document Automation Toolkit
Show Answer
Correct Answer: B
Explanation: The project closure process requires interacting with the SAP GUI and exporting data to a CSV file before extracting values. This type of UI-based automation against on-premises applications is not supported by cloud flows or classic workflows. Desktop flows (Power Automate for desktop) are specifically designed for robotic process automation (RPA), allowing automation of SAP GUI interactions, file exports, and CSV processing within the same on-premises network. Therefore, a desktop flow is the most appropriate solution.
Question 25
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 implement the expressions for the Time Entry Application automation.
Which expressions should you use to address the requirements and issues? To answer, move the appropriate expression to the correct requirement or issue. You may use each expression 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.
Show Answer
Correct Answer: Convert XML to JSON.
json()
Convert CSV to an array.
split()
Extract query parameters from a URL.
coalesce()
Extract property from an XML document.
xpath()
Explanation: json() converts XML output to JSON format. split() parses CSV text into an array. coalesce() is used to safely retrieve values when extracting URL query parameters that may be null. xpath() is designed to navigate XML structures and extract specific properties.
Question 26
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.
Show Answer
Correct Answer: Invoice processing → Invoice processing model
Industry events automation → Business card reader model
Statements of work → Document processing model
Application form → Document Automation Toolkit
Explanation: AI Builder invoice processing handles automated invoice creation. Business card reader extracts contact data from event cards. Document processing model extracts structured data from statements of work stored in SharePoint. Document Automation Toolkit automates extraction and population of uploaded application forms.
Question 27
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 identify the values or the behavior for the pattern added to the tenant Microsoft Power Platform data loss prevention (DIP) policy.
What should you identify? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Show Answer
Correct Answer: Pattern order number: Zero
Pattern data group: Business
Behavior when using the default pattern rule: Connector will not connect to any data
Explanation: In a tenant-level DLP policy, the explicitly added host URL pattern is evaluated before the default (*) rule, so it has order 0. Member data is regulated, so the connector must be classified as Business. The remaining default Ignore (*) rule behavior results in no data connectivity outside defined business patterns, effectively preventing connections when the default rule is applied.
Question 28
You manage the machines used for Power Automate for desktop automations. You create machine groups to organize the machines.
Users must perform automations on the machines.
You need to share the machine groups with the users.
Which portal or application should you select?
A. Power Automate machine runtime app
B. Power Automate for desktop app
C. Microsoft Power Platform admin center portal
D. Power Automate portal
Show Answer
Correct Answer: D
Explanation: Machine groups for Power Automate for desktop are shared and managed through the Power Automate web portal. In the portal, you can go to Monitor > Machines, select a machine group, and share it with users. The desktop apps and runtime app do not provide sharing capabilities, and the Power Platform admin center is not used for this task.
$19
Get all 157 questions with detailed answers and explanations
Instant download HTML + PDF delivered the moment payment clears.
Secure Stripe checkout we never see or store your card details.
7-day refund if files are defective see our refund policy.