microsoft pl-400 practice test
Microsoft Power Platform Developer
Question 1
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.
Answer:
Explanation:
Box 1: Create a custom connector
A custom connector is a wrapper around a REST API (Logic Apps also supports SOAP APIs) that allows
Logic Apps, Power Automate, or Power Apps to communicate with that REST or SOAP API.
Box 2: Use an AppSource connector
You can only retrieve the Customer, UnifiedActivity, and Segments entities through the Power Apps
connector. Other entities are shown because the underlying connector supports them through
triggers in Power Automate.
Scenario: Customer information is stored in the Accounts entity.
Box 3: Use a native application function
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.
Reference:
https://docs.microsoft.com/en-us/connectors/custom-connectors/
https://docs.microsoft.com/en-us/dynamics365/customer-insights/audience-insights/export-power-
apps
Question 2
You need to determine the primary cause of the issue reported by interns when they use the app.
What is the primary cause?
- A. Interns have the System Customizer security role but need the Environment Maker security role.
- B. Interns have the Common Data Service User security role but need the Environment Maker security role.
- C. Interns have the Environment Maker security role but need the Common Data Service User security role.
- D. Interns have the Environment Maker security role but need the System Customizer security role.
- E. Interns have the Environment Maker security role but need the Delegate security role.
Answer:
D
Explanation:
Scenario: Interns can create apps but cannot interact with their own data.
Environment Maker role: Can create new resources associated with an environment, including apps,
connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role
doesn't have any privileges to access data within an environment.
System Customizer role: full permission to customize the environment. However, users with this role
can only view records for environment entities that they create.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
Question 3
You need to handle errors in UpdateRecord.js.
Which code segment should you add at line UR06?
- A. catch(error) { alert("Caught error: " + error.message);}
- B. Exception exception = Server.GetLastError() ; if(exception != null)}
- C. catch(exception e){ console.writeline(e)}
- D. function (error){ console.log(error.message)}
Answer:
A
Explanation:
https://docs.microsoft.com/en-us/powerapps/developer/model-driven-
apps/clientapi/reference/xrm-webapi/updaterecord
Question 4
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.
Answer:
Explanation:
Box 1: Add &ribbondebug=true to the end of the application URL.
Scenario: The captions for the New and Save buttons do not render properly on the form.
You can use the an in-app tool called the Command Checker to inspect the ribbon component
definitions to help us determine why the button is not rendered correctly.
To enable the Command Checker, you must append a parameter &ribbondebug=true to your D365
application URL. For example: https://yourorgname.crm.dynamics.com/main.aspx?appid=9ab590fc-
d25e-ea11-a81d-000d3ac2b3e6&ribbondebug=true
Box 2: Use the Ribbon Workbench
Adding Buttons to Ribbons
Download and install Ribbon Workbench.
Select a suitable ICON for your button.
Create a solution.
Edit the button in Ribbon Workbench.
Publish and test.
Reference:
https://support.microsoft.com/en-us/help/4552163/ribbon-troubleshooting-guide
https://neilparkhurst.com/2015/10/19/adding-buttons-to-ribbons/
Question 5
You need to add the script for the registration form event handling.
Which code segment should you use?
- A. formContext.data.entity.addOnSave(myFunction)
- B. formContext.data.addOnLoad(myFunction)
- C. formContext.data.removeOnLoad(myFunction)
- D. addOnPreProcessStatusChange
- E. formContext.data.isValid()
Answer:
B
Explanation:
Scenario: Information about upcoming tournaments must be pre-located into the registration form
when the registration form loads.
addOnLoad adds event handlers to the Subgrid OnLoad event event.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/model-driven-
apps/clientapi/reference/grids/gridcontrol/addonload
Question 6
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.
Answer:
Explanation:
Scenario: The company identifies the following job roles:
You must grant users the minimum permissions required to perform their job tasks.
Intern: Environment Maker
Environment Maker: Can create new resources associated with an environment, including apps,
connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role
doesn't have any privileges to access data within an environment.
Manager: System Administrator:
System Administrator: Has full permission to customize or administer the environment, including
creating, modifying, and assigning security roles. Can view all data in the environment.
Sales representative: Common Data Service User
Basic User/ Common Data Service User: Read (self), Create (self), Write (self), Delete (self)
Can run an app within the environment and perform common tasks for the records that they own.
Question 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.
Answer:
Explanation:
Box 1: Option Set
Box 2: Date only
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.
Box 3: Lookup
Customer information is stored in the Accounts entity. Each tournament record must list the
associated sales representative as the tournament owner.
Note: When you create a new lookup column you are creating a new Many-to-One (N:1) table
relationship between the table you’re working with and the Target Row Type defined for the lookup.
There are additional configuration options for this relationship that are described in Create and edit
relationships between tables. But all custom lookups can only allow for a reference to a single row
for a single target row type.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/types-of-fields
Question 8
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.
- A. Azure Function that uses the Discovery service
- B. workflow extension
- C. Azure Function that uses a listener
- D. Power Automate flow
Answer:
CD
Explanation:
https://docs.microsoft.com/en-us/dotnet/api/system.io.filesystemwatcher
https://docs.microsoft.com/en-us/power-automate/
Question 9
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.
Answer:
Explanation:
Scenario:
Weight: Set visibility action to No.
Age: Set Business Required action to Business required
Height: Set visibility action to No.
Question 10
You need to add the script to populate event data on the form.
Which code segment should you use?
- A. formContext.data.addOnLoad(myFunction)
- B. formContext.data.removeOnLoad(myFunction)
- C. formContext.data.entity.addOnSave(myFunction)
- D. addOnPreProcessStatusChange
- E. formContext.data.isValid()
Answer:
A
Question 11
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.
Answer:
Explanation:
Scenario: 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:
Box 1: GET ..$select=name, sport
Use select to return only the Name and Sport fields.
Box 2: $apply(groupby(sport ne null)
Categorize by division, that is to sports.
Topic 2, Adventure Works
Case study
Overview
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:
Customer selects yes or no if they are on the mailing list.
Customer selects the amount of times they have visited the store.
Customer selects the type of service needed.
The search result returns all last name records that match the search term.
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.
Question 12
You need to improve warehouse counting efficiency.
What should you create?
- A. a flow that updates the warehouse counts as the worker performs the count
- B. a model-driven app that allows the user to key in inventory counts
- C. A Power BI dashboard that shows the inventory counting variances
- D. a canvas app that scans barcodes to allow a warehouse worker to select inventory counts
Answer:
D
Explanation:
Scenario: Warehouse counting is performed manually by using a counting journal. All warehouse
boxes and items are barcoded.
Question 13
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.
- A. a flow that maps inspection data to Dynamics 365 Field Service
- B. a logic app that guides the technician through the inspection
- C. a canvas app that guides the technician through the inspection
- D. a model-driven app based on customer service entities
Answer:
AD
Explanation:
Scenario: 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.
Reference:
https://docs.microsoft.com/en-us/dynamics365/field-service/overview
https://us.hitachi-solutions.com/blog/canvas-vs-model-driven-apps/
Question 14
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.
- A. LookUp to Filter
- B. Filter to LookUp
- C. Search to LookUp
- D. LookUp to Search
Answer:
AD
Explanation:
CustomerB reports that the check-in app returned only one search result for their last name, which is
not the correct name.
The Filter function finds records in a table that satisfy a formula. Use Filter to find a set of records
that match one or more criteria and to discard those that don't.
The LookUp function finds the first record in a table that satisfies a formula. Use LookUp to find a
single record that matches one or more criteria.
The Search function finds records in a table that contain a string in one of their columns.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup
Question 15
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?
- A. asynchronous
- B. atomicity
- C. transfer
- D. synchronous
Answer:
D
Explanation:
User5 receives the error message: ‘Endpoint unavailable’ during a test of the technician dispatch ISV
solution.
When you choose to use a synchronous execution mode any failure will be reported back to the user
of the application with an Endpoint unavailable error dialog informing the user that the webhook
service endpoint may be configured incorrectly or is not available.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/use-webhooks