Microsoft Power Platform Developer PL-400 Practice Test Questions

1. Topic 1, Bellows Sports



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. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.



Background

Bellows Sports is the region’s newest, largest, and most complete sports complex. The company features baseball and soccer fields and two full-size hockey rinks. The complex provides coaching, recreational leagues, a pro shop, and state-of-the art customer and player amenities.



The company is organized into the following divisions:

- Baseball

- Hockey

- Soccer



Bellow Sports runs tournaments several times per year. Each tournament runs six weeks.



Current environment

Requirements

Bellow Sports tracks players and events in Microsoft Excel workbooks and uses email to communicate with players, partners, and prospective customers. The company uses a proprietary cloud-based accounting system.



The company relies on referrals from athletes for new business. Bellows uses a third-party marketing company to gather feedback and referrals from athletes. The third-party marketing company uploads a Microsoft Excel file containing lists of potential customers and players to the FTP site that Bellows Sports maintains.



Tournaments

Customer information is stored in the Accounts entity. Each tournament record must list the associated sales representative as the tournament owner. When team members create tournament records they must enter the start date for a tournament. The end date of the tournament must be automatically calculated.



Registration form

You must create a form to allow players to register for tournaments.

The registration form must meet the following requirements:







- Each division has tournaments that take place in specific locations. Users must be able to select the division for a tournament location.

- Information about upcoming tournaments must be pre-located into the registration form when the registration form loads.

- The form must include a custom button that sends an email confirmation to the player after the player registers.

- The button must not be visible until after the form is saved.



Security

The company identifies the following job roles:







You must grant users the minimum permissions required to perform their job tasks.



Data automation

- Customer name must be added to Dynamics 365 Finance automatically after it is entered.

- You must produce a report that details the number of registrations for a day and send the report as a PDF to the management team.

- You must implement mechanisms to handle all code-related errors.

- When a customer record is updated, the system must look up the account number for the customer in the accounting system.

- Referrals must be imported into the system as soon as they are available.



Issues

Apps

- The captions for the New and Save buttons do not render properly on the form.

- Interns can create apps but cannot interact with their own data.



Portal



The query for all registered users must return the data categorized by division. Queries must return only the Name and Sport fields. Queries return all fields.



The query is as follows:







Solution checker issues

You run solution checker and observe Plug-in or workflow activity errors in the following code sets:







Code

The following code runs when the registration form loads.

You must implement a mechanism to handle errors that occur in the code:







DRAG DROP

You need to determine how to implement rules for players who register for a soccer tournament.

Which business rule actions should you use? To answer, drag the appropriate business rule actions to the correct fields. Each business rule action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

2. You need to configure the system to support automation for referrals.

What are two possible ways to achieve the goal? Each correct selection presents a complete solution. NOTE: Each correct selection is worth one point.

3. DRAG DROP

You need to address the user interface issues.

What should you do? To answer, drag the appropriate actions to the correct issues. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

4. You need to determine the primary cause of the issue reported by interns when they use the app.

What is the primary cause?

5. You need to handle errors in UpdateRecord.js.

Which code segment should you add at line UR06?

6. You need to add the script to populate event data on the form.

Which code segment should you use?

7. HOTSPOT

You need to select data types for required fields.

Which data types should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

8. You need to add the script for the registration form event handling.

Which code segment should you use?

9. DRAG DROP

You need to assign security roles to groups of users.

Which security roles should you use? To answer, drag the appropriate security types to the

correct roles. Each security 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.

10. HOTSPOT

You need to correct the portal query issues.

Which code should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

11. DRAG DROP

You need to select connectors for the app.

Which types of connectors should you use? To answer, drag the appropriate connectors to the correct requirements. Each connector 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.

12. Topic 2, Adventure Works



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. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.



Background

Current environment

Adventure Works Cycles wants to replace their paper-based bicycle manufacturing business with an efficient paperless solution. The company has one manufacturing plant in Seattle that produces bicycle parts, assembles bicycles, and distributes finished bicycles to the Pacific Northwest.



Adventure Works Cycles has a retail location that performs bicycle repair and warranty repair work. The company has six maintenance vans that repair bicycles at various events and residences.



Adventure Works Cycles recently deployed Dynamics 365 Finance and Dynamics 365 Manufacturing in a Microsoft-hosted environment for financials and manufacturing. The company plans to leverage the Microsoft Power Platform to migrate all of their distribution and retail workloads to Dynamics 365 Unified Operations.



The customer uses Dynamics 365 Sales. Dynamics 365 Customer Service and Dynamics 365 Field Service.



Retail store information

✑ Adventure Works Cycle has one legal entity, four warehouses, and six field service technicians.

✑ Warehouse counting is performed manually by using a counting journal. All warehouse boxes and items are barcoded.

✑ The Adventure Works Cycles retail location performs bicycle inspections and performance tune-ups.

✑ Technicians use paper forms to document the bicycle inspection performed before a tune-up and any additional work performed on the bicycle.

✑ Adventure Works Cycles uses a Power Apps app for local bike fairs to attract new customers.

✑ A canvas app is being developed to capture customer information when customers check in at the retail location. The app has the following features:



Technology

Requirements

✑ A plug-in for Dynamics 365 Sales automatically calculated the total billed time from all activities on a particular customer account, including sales representative visits, phone calls, email correspondence, and repair time compared with hours spent.

✑ A shipping API displays shipping rates and tracking information on sales orders. The contract allows for 3,000 calls per month.

✑ Ecommerce orders are processed in batch daily by using a manual import of sales orders in Dynamics 365 Finance.

✑ Microsoft Teams is used for all collaboration.

✑ All testing and problem diagnostics are performed in a copy of the production environment.

✑ Customer satisfaction surveys are recorded with Microsoft Forms Pro. Survey replies from customers are sent to a generic mailbox.



Automation

✑ A text message must be automatically sent to a customer to confirm an appointment and to notify when a technician is on route that includes their location.

✑ Ecommerce sales orders must be integrated into Dynamics 365 Finance and then exported to Azure every night.

✑ A text alert must be sent to employees scheduled to assist in the repair area of the retail store if the number of repair check-ins exceeds eight.

✑ Submitted customer surveys must generate an email to the correct department. Approval and follow-up must occur within a week.



Reporting

✑ The warehouse manager’s dashboard must contain warehouse counting variance information.

✑ A warehouse manager needs to quickly view warehouse KPIs by using a mobile device.

✑ Power BI must be used for reporting across the organization.



User experience

✑ Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.

✑ All customer repairs must be tracked in the system no matter where they occur.

✑ Qualified leads must be collected from local bike fairs.



Issues

✑ Warehouse counting must be performed by using a mobile app that scans barcodes on boxes.

✑ All customer repairs must be tracked in the system no matter where they occur.

✑ Qualified leads must be collected from local bike fairs.



Internal

✑ User1 reports receives an intermittent plug-in error when viewing the total bill customer time.

✑ User2 reports that Azure consumption for API calls has increased significantly to 100 calls per minute in the last month.

✑ User2 reports that sales orders have increased.

✑ User5 receives the error message: ‘Endpoint unavailable’ during a test of the technician dispatch ISV solution.

✑ The parts department manager who is the approver for the department is currently on sabbatical.



External

✑ CustomerB reports that the check-in app returned only one search result for their last name, which is not the correct name.

✑ Nine customers arrive in the repair area of the retail store, but no texts were sent to scheduled employees.

✑ Customers report that the response time from the information email listed on the Adventure Works Cycles website is greater than five days.

✑ CustomerC requested additional information from the parts department through the customer survey and has not received a response one week later.



HOTSPOT

You need to select visualization components.

What should you use? To answer, select the appropriate options from the answer area. NOTE: Each correct selection is worth one point.

13. You need to modify Microsoft flow to resolve CustornerCs issue .

What should you do?

14. You need to identify the execution mode that is being used for the ISV solution reported by User5.

Which type of execution mode is in use?

15. You need to reduce the number of Azure consumption API calls for User2.

Which markup segment should you use?

A)





B)





C)





D)

16. You need to improve warehouse counting efficiency.

What should you create?

17. HOTSPOT

You need to select the visualization component.

What should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

18. You need to ensure that Adventure Works Cycle can track information from visitors to bike fairs.

What should you create?

19. You need to reduce response time for the information email on the website.

What should you create?

20. DRAG DROP

You need to recommend solutions to meet the e-commerce automation requirements.

Which platform tools should you recommend? To answer, drag the appropriate tools to the correct requirements. Each tool may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

21. You need to resolve CustomerB’s issues with the check-in application.

Which two options can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

22. You need to reduce response time for the information email on the website.

What should you create?

23. You need to replace the bicycle inspection forms.

Which two solutions should you use? Each answer presents part of the solution. NOTE: Each correct selection is worth one point.

24. DRAG DROP

You need to resolve the performance issue with the Total Billed customer plug-in.

In which order should you perform the actions? To answer, move all actions from the list of actions to the answer area and arrange them in the correct order.

25. DRAG DROP

You need to identify why employees are not receiving notification that nine customers are checked in and waiting in the repair area.

Which components should you test for each step? To answer, drag the appropriate components to the correct steps. Each component may be used once, more than once, or not at all.

You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

26. You need to ensure that Adventure Works Cycles can track information from visitors to bike fairs.

What should you create?

27. You need to improve the efficiency of counting warehouse inventory.

What should you create?

28. You need to modify the Power Automate flow to resolve CustomerC’s issue.

What should you do?

29. Topic 3, Contoso Pharmaceuticals



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. If the case study has an All Information tab, note that the information displayed is identical to the information displayed on the subsequent tabs. When you are ready to answer a question, click the Question button to return to the question.

Background

Contoso Pharmaceuticals manufactures and sells drugs to retail and wholesale pharmacies, hospitals, and research facilities.

The company plans to implement Dynamics 365 Sales and Dynamics 365 Finance.



Current environment

✑ Contoso maintains a Microsoft Excel workbook that lists all drugs they supply.

✑ Pharmacies submit order requests through email.

✑ All information at customer locations is handwritten by customer representatives.

✑ Contoso uses Cerner, which is a medical industry application that uses a proprietary database.

✑ Some accounts are referrals from other pharmacies.

✑ Every pharmacy has its own Dynamics 365 Sales instance.



Requirements

General

Contoso wants to ensure that there is minimal custom code and custom connectors in the system.



Accounts

✑ Ensure that the names of the pharmacies are synced between the accounting and the customer management systems.

✑ Account numbers should be entered automatically into the pharmaceutical system that is in a Cerner database and kept in sync.

✑ When the account is entered into the system, extra fields must appear if the referral customer box is selected. If the box is not selected, the extra fields must not appear.

✑ A trigger must be created that changes the Priority field to 1 in the Account record 10 days after an Account record is created.

✑ A field named Priority_Trigger must be created to trigger the Priority field.

✑ A field named Facility type field must be added in order to select whether a

customer is a retail pharmacy, wholesale pharmacy, research facility, or hospital.



Users

✑ UserA must be able to create and publish Power Apps apps.

✑ UserB must be the owner of all the systems and be able to provide permissions and create all new environments.

✑ UserC must be able to create apps connected to the systems and update the security roles and entities.

✑ Pharmacy representatives must only be able to run the apps and access their own records.

✑ Access to the accounting Power Apps app must be restricted to accounting team members.

✑ End users must have minimum access to the required systems.

✑ Only supervisors must be able to view phone numbers in the Accounts form.

✑ Developers must be able to create new apps for all users.

✑ Sales users must only have access to their own records.



Reporting

Pharmacy orders must be displayed in four graphs as follows:

✑ Annual revenue over $100,000

✑ Annual revenues under $100,000

✑ Research facilities

✑ Hospitals

The graphs must be interactive, and users must be able to drill down on any dimension.



Customizations

✑ Ensure that notifications are sent to the sales team when a lead is added by using Slack.

✑ Ensure that leads have a review stage added to the sales process.

✑ Doctors must be manually added to a custom entity named Doctor if the doctor is not listed.

✑ Refill dates for customer prescriptions should be automatically determined and a notification should be sent to the customer.

✑ Fields for the doctor’s name and phone number must be displayed in the customer record.

✑ The doctor entered on the customer’s record must be validated against doctors that exist in the system.

✑ The new solution will be sold to other pharmacies for use. The application must not allow changes to be made.

✑ The solution must be error free so that when it is installed in other environments it does not cause issues.

✑ A custom mobile app must be created to allow salespeople to add or search by pharmacy name.

✑ Pharmacy records must be uniquely identified by pharmacy name, address, contact name, and phone number.

✑ When a pharmacy is added by using the mobile app, the phone number must be validated to be all digits.



You need to create the model-driven app for referral.

Which function should you add?

30. DRAG DROP

You need to select a process to create each function.

Which process should you use? To answer, drag the appropriate processes to the correct functions. Each process may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

31. You need to ensure that users can create the required charts.

Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

32. You need to configure that the mobile app meets the requirements for phone entries.

Which expression should you use?

33. DRAG DROP

You need to select a process to create each function.

Which process should you use? To answer, drag the appropriate processes to the correct functions. Each process may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

34. You need to create an application to deploy to other pharmacies .

What should you do?

35. You need to configure the trigger for account records.

Which expression should you use?

36. DRAG DROP

You need to assign the minimum environment security role to the appropriate users.

Which security roles should you use? To answer, drag the appropriate security roles to the correct users. Each security role may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

37. HOTSPOT

You need to configure the fields with the appropriate type.

Which type should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

38. Topic 4, Misc. Questions



HOTSPOT

A delivery service uses a canvas app to track and deliver packages. The app uses SQL Server as a data store.

The database includes the following tables:





The app includes the following code to save all required information. (Line numbers are included for reference only.)





For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

39. HOTSPOT

You are troubleshooting Power Apps solutions.

You need to determine the cause for the identified issues.

What is the root cause for each issue? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

40. You create a Power Apps app that integrates with Dynamics 365 Customer Service.

You update the app and run solution checker on the original solution. You receive an error stating solution checker cannot export the solution.

You need to determine the primary cause for the issue.

What is the primary cause?

41. HOTSPOT

A company is building a new model-driven app.

The app must integrate with a number of on-premises and cloud solutions. No VPNs are in place.

You need to determine the method for each integration.

Which methods should you use? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

42. HOTSPOT

An organization has a custom Assignments entity that guides agent actions. Team leaders for each assignment group must be able to review any changes made to assignment data by their agents.

You have the following JSON segment:





For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.

43. HOTSPOT

You create a Power Platform solution to track purchasing requirements for bills of material (BOMs) and their subcomponents.

The solution must meet the following requirements:

✑ Ensure that the BOMs are enabled to include the necessary subcomponents.

✑ Report changes to the BOMs or their sub-components that are made by engineers.

You need to configure the solution.

What should you do to meet each requirement? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

44. You are creating a custom connector in Power Apps to connect to a third-party application.

The definition in the connector must be set so that it is not visible to the end user.

You need to select the appropriate visibility parameter.

Which parameter should you use?

45. A travel company has a Common Data Service (CDS) environment.

The company requires the following:

Custom entities that track which regions clients have traveled.

The dates their clients traveled to these regions.

You need to create the entities and relationships to meet the requirements.

Which three actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

46. You are implementing custom business logic in a Power Apps portal.

You need to use Liquid templates to display dynamic content.

To which three entities can you include Liquid code? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

47. A company has two development instances, two test instances, two staging instances, and one production instance.

The test team reports connection issues with the test and staging instances.

You need to identify which if the instances the testing team currently has access.

Which two URLs can you use? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

48. 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 once correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You are designing a one-way integration from the Common Data Service to another system.

You must use an Azure Function to update the other system. The integration must send only newly created records to the other system. The solution must support scenarios where a component of the integration is unavailable for more than a few seconds to avoid data loss.

You need to design the integration solution.

Solution: Register a webhook in the Common Data Service that connects to the Azure Function. Register a step on the webhook which runs synchronously on the record’s Create message and in the post-operation stage.

Does the solution meet the goal?