microsoft pl-100 online test

Microsoft Power Platform App Maker

What students need to know about the pl-100 exam

  • Total 206 Questions & Answers
  • Has case studies
  • Passing score: 700

Question 1 Topic 1, Case Study 1Case Study Question View Case

You need to provide the app to Tailwind Traders.
What should you do?

  • A. Within Managed Properties, set the value of the Allow customizations option to true. Export the app as a managed solution.
  • B. Use the Share App feature.
  • C. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as a managed solution.
  • D. Within Managed Properties, set the value of the Allow customizations option to false. Export the app as an unmanaged solution.
Answer:

C

Explanation:
Scenario: The completed app and all supporting components must be provided to Tailwind Traders. Tailwind Traders must
not be able to make changes to any of the components.
Managed Solution: A managed solution is a finalized solution that can be distributed and installed. They are created by
exporting an unmanaged solution by setting restrictions to prevent any further customizations. The whole point of Managed
is locking down the Component states so they cannot be edited. Deleting the Managed Solution will remove all its
customisations as well as data contained.
Managed Solutions become read only once deployed so they cannot be manipulated.
Reference: https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685

Discussions

Question 2 Topic 1, Case Study 1Case Study Question View Case

DRAG DROP
You need to ensure that the app can support the needs of User2 and User3, and meets the production deployment
requirements.
Which tools should you use? To answer, select the appropriate tool in the answer area.
NOTE: Each correct selection is worth one point.
Select and Place:

Answer:

Explanation:
Box 1: App Checker
Scenario: Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images.
User3 is unable to use a mouse.
Users who have vision, hearing, or other impairments can use your canvas app more easily and successfully if you consider
accessibility as you design how the app looks and behaves. If you're not sure how to make your app more accessible, you
can run the AppChecker Accessibility checker in Power Apps Studio.
Box 2: Solution Checker
Scenario: Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and
performance guidelines.
Use solution checker to validate your model-driven apps in Power Apps.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/accessibility-checker
https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-powerapps-checker
Create solutions

Discussions

Question 3 Topic 1, Case Study 1Case Study Question View Case

HOTSPOT
You need to resolve the issue for User1.
What should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: Power Apps mobile app Scenario:
User1 often works in a warehouse that does not have internet connectivity.

User1 needs to edit an existing status report and submit a new status report.

The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the

internet, the app must immediately submit the status report.
You can build offline capabilities in your PowerApps app so your app users can access some data or save some data even
when they don't have an internet connection.
Box 2: Connector
Scenario: Azure SQL Database is used to store other data
Use the SQL Server connector to connect to SQL Server, in either Azure or an on-premises database, so that you can
manage your data with create, read, update, and delete operations.
Reference:
https://powerapps.microsoft.com/en-us/blog/implementing-offline-capability-in-your-app/
Design solutions

Discussions

Question 4 Topic 1, Case Study 1Case Study Question View Case

DRAG DROP
You need to modify the app design to meet the accessibility needs of the sales associates.
Which properties should you configure? To answer, drag the appropriate properties to the correct restrictions. Each property
may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Answer:

Explanation:
Box 1: AccessibleLabel
Scenario: Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and
performance guidelines. User2 is visually impaired and cannot see images.
AccessibleLabel is a label for screen readers.
An empty value for Image, Icon, and Shape controls will hide the controls from screen reader users.
Box 2: TabIndex
User3 is unable to use a mouse.
TabIndex determines if the control participates in keyboard navigation.
Keyboard navigation is an important aspect of any app. For many, the keyboard is more efficient than using touch or a
mouse. The navigation order should:
Mirror what is seen visually.
Only have a tab stop at controls that are interactive.
Follow either an intuitive across and then down "Z" order or a down and then across "reverse-N" order.

Discussions

Question 5 Topic 1, Case Study 1Case Study Question View Case

You need to create the mobile app.
Which type of app should you create?

  • A. model-driven app
  • B. portal app
  • C. Microsoft 365 web app
  • D. canvas app
Answer:

D

Explanation:
An accessible canvas app will allow users with vision, hearing, and other impairments to successfully use the app. In
addition to being a requirement for many governments and organizations, following the below guidelines increases usability
for all users, regardless of their abilities.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/accessible-apps

Discussions

Question 6 Topic 2, Case Study 2Case Study Question View Case

You need to modify the entity form to resolve the customer request number issue.
What should you do?

  • A. Use a calculated field
  • B. Change the data type of the customer request number field to Lookup
  • C. Change the data type of the customer request number field to Autonumber
Answer:

C

Explanation:
Scenario: Users report that the customer request number is difficult to interpret. They request that you change the number to
a system generated sequential number.
Autonumber columns are columns that automatically generate alphanumeric strings whenever they are created.
Incorrect Answers:
B: The LookUp function finds the first record in a table that satisfies a formula.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/autonumber-fields

Discussions

Question 7 Topic 2, Case Study 2Case Study Question View Case

HOTSPOT
You need to implement features for the solution.
Which Power Platform component should you use for each feature? To answer, select the appropriate options in the answer
area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: Model-driven app
The Sales app must meet the following requirements:
Provide a central location for all sales pipeline and quote information that is easily accessible and maintains all of the

versions of the estimate, quote, and engineering documents.
Compared to canvas apps, model-driven apps in PowerApps are based on underlying data specifically, the data stored in
Common Data Service (CDS).
Box 2: Power BI Desktop
You can create a KPI in Power BI Desktop.
1. Open your report editor in Power BI Desktop then select a report on which you are working.
2. On your right, you will see a Visualizations pane and a Fields pane.
3. From the Visualizations pane, select the KPI visual.
4. Etc.
Box 3: Power Automate

Discussions

Question 8 Topic 2, Case Study 2Case Study Question View Case

You need to connect to the data source for the Job Setup app.
What should you do?

  • A. Configure a scheduled synchronization with the Common Data Service database
  • B. Configure SQL Server database permissions
  • C. Create a stored procedure that retrieves time records for a specific employee
  • D. Configure an on-premises data gateway
Answer:

D

Explanation:
Scenario: The Job Setup entity must store its data in the existing on-premises SQL Server instance.
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between on-premises data (data
that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, Power Apps, Power
Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and
other data sources on their on-premises networks, yet securely use that on-premises data in cloud services.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference

Discussions

Question 9 Topic 2, Case Study 2Case Study Question View Case

HOTSPOT
You need to resolve the issues found during testing.
Which option should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer:

Explanation:
Box 1: Security role
Scenario: Employees must only be able to access their own time tracking records from the app. Testers report that they can
see time entries in the Time Tracker app, not just their own.
Box 2: Field-level security
Scenario: Employees must only be able to modify time records for the current and previous day. Testers report that they can
edit any existing time entries.
Box 3: Hierarchical security
You use field security tables to apply field-level security, which restricts field access to specified users and teams.

Discussions

Question 10 Topic 2, Case Study 2Case Study Question View Case

You need to resolve the users issue with the time tracking app.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

  • A. Add a component to the time tracking screen for tracking total time.
  • B. Create a new component inside of the component library for the time tracking app.
  • C. Upload the component to AppSource.
  • D. Add the Total Time field to the screen and set the value of the field property to Rollup.
Answer:

A B

Explanation:
Scenario Issue: Users want to be able to see their weekly total time entered from all screens.
A component library provides a centralized and managed repository of components for reusability.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/component-library

Discussions
To page 2