Microsoft Power Platform App Maker PL-100 Exam Questions Updated PL-100 Online Resource

1. You need to provide all app components of the application to Tailwind Traders.

What should you do?

2. A company plans to roll out several Power Apps apps to multiple business units across international operations.

The apps must be managed through an application lifecycle management (ALM) solution to provide a consistent and predictable use experience. All changes to the app must be traceable and documented in a single location. You must be able to revert to a previous version of an app. The app release cycles must be as streamlined as possible.

You need to create an application for the apps.

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

3. Topic 2, Contoso, Ltd



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

Current environment

Overview

Operations for the company are managed very informally. Only a small number of long-term employees are aware of all manufacturing processes.



Accounting system and purchasing

- The company has a cloud-based ERP/accounting system and uses the General Ledger, Accounts Receivable, and Accounts Payable modules. The current system does not have any modules that handle shop floor or manufacturing planning functionality.

- Employee information is maintained only within the accounting system. Access to the information is strictly controlled due to privacy regulations and company policies.

- All purchasing of raw materials is performed based on bills of material (BOMs) generated by the engineering department when engineering prints are created.

- The corporate office uses Dynamics 365 Finance. The operations manager reports that Dynamics 365 Finance will not be implemented for the manufacturing plants for at least five years.



Manufacturing and planning

- The plant that Contoso, Ltd. acquires uses Microsoft Excel workbooks and Microsoft Word documents to track the sales pipeline, requests for quote responses, and work estimates. The documents are stored on shared network drives.

- Printed engineering drawings are sometimes accidently used across orders. This results in rework, cost over runs, and missed deliveries.

- The company uses Job Traveler documents to detail the operations that need to be performed and the materials needed for a given job number.



Sales

- Requests for quotes are currently stored in a Sales Log workbook.

The workbook includes the following information:

- Customer request number

- Customer name

- Description

- Estimated value of the sale

- Status of the Request for Quote (RFQ) with the values of Won, Lost, No Bid, and Cancelled

- Names of the sales manager, salesperson, and estimator

- Name of the product line

- Date the quote was sent to the customer

- Approximate start and finish dates of the project

- Date the order was received, if won

- Job number, which is assigned if won

- The company has a formal process in place for managing estimates. Some sales quotes lack required supporting documentation including estimates for labor and materials even though a formal process is in place. The company wants to incorporate the formal process as part of an app.

- Salespeople often do not set status of RFQs in the Sales Log to Won when a sale is closed and the customer purchase order is received.

- An accurate sales pipeline and win/loss information cannot currently be reported because the close probability field in the Sales Log is being set to 100% when a sale is closed and 0% when a sale is lost.

- Setting up a folder system on the network drive by a customer had not improved the hand-off of the current version of the sales quote to manufacturing.



Requirements

Solution

You plan to create a solution that uses Microsoft Teams and Power Platform.

You must convert the Sales Log workbook to a Common Data Service database.

Each department will have a separate Teams channel. Employees must only be able to access the channel for their department. All employees and management will have read access to a general company channel. The Teams site must include the following channels:



Sales

- The Sales dashboard must reside in the Sales channel and must include information about active quotes, sales pipeline, and year-to-date sales KPIs for sales quotas by region.

- All Sales-related documents must be stored in folders in the files location for this channel. Document versioning will be enabled. You must store the 10 most recent versions of a document.



Manufacturing

- A dashboard that shows a capacity Heat map by month as well as expected sales that are likely to close for the next month.

- A sortable listing of all in-process jobs from the Job Setup table, by customer, start date, and product.

- Printed paper drawings must no longer be used. The drawings must be stored in folders in the files location for the manufacturing channel.



General

You must create the following apps:



Time Tracking

You must create a canvas app to track time for each employee on mobile devices.

The app must include the following:

- a Sign-in screen

- a screen to list the week’s time entries for the employee

- a screen to edit current time entries for the employee



The app must meet the following requirements:

- The app must store its data in the existing on-premises Microsoft SQL Server instance.

- Employees must only be able to access their own time tracking records from the app.

- Employees must record all time spent in the fabrication of each customer job.

- Employees must only be able to modify time records for the current and previous day.

- Employees must be able to scan their badges to check in and out of work. Each badge contains the employee name and a current picture.

- A QR code must be added to all employee badges. The code must include the employee’s number.

- Job Traveler documents must be printed as PDF documents and must include UPC E barcodes for the job number and task number. The barcodes will be used with the time tracking application.



Sales

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.

- Include a dashboard that shows all currently active quotes, their status in the sales cycle, the probability of closing, and estimated manufacturing and installation dates, by customer, product division, status, and salesperson.

- The Sales Log app must enforce process standards related to the completion of estimates and supporting materials needed during the sales lifecycle.

- Automatically perform the following actions immediately when a sale is won:

- Generate a sequential job number.

- Copy key sales information to the Job Setup entity used by manufacturing.

- If the sale is lost, the Status field must be set to Lost and the reason for the loss must be entered into a provided text field. The reason must be added to the end of the description field.

- Ensure that employees can easily update the Sales Log even if they are at a customer site.



Manufacturing and planning

The app must meet the following requirements:

- Provides features to plan and predict capacity resource requirements for current and upcoming orders in the pipeline.

- Replace paper timesheets and track check-in, check-out, breaks, and the time spent on each job task.

- Record time elapsed while performing work and for viewing of engineering drawings.

- The Job Setup entity must store its data in the existing on-premises SQL Server instance.

- Job Traveler documents must be generated as a PDF document and printed from the Job Setup entity.



Issues

- Uses report that the customer request number is difficult to interpret. They request that you change the number to a system generated sequential number.

- The operations manager reports that users often incorrectly sign in to the time tracking app. The operations manager asks that the time tracking app display the employee’s photo once they have scanned their badge.

- Users want to be able to see their weekly total time entered from all screens.

- Testers report that they can see time entries in the Time Tracker app, not just their own. Additionally, they can also edit any existing time entries.



HOTSPOT

You need to create the solution assets.

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

4. You are creating a canvas app. You plan to use variables that are scoped to a screen to store values.

You need to create and update the value of the variables.

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

5. HOTSPOT

You need to meet the requirement for the time tracking app.

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

6. HOTSPOT

A company is building a Power Apps app to track key project tasks.

Users assign three tasks a risk status on a scale of 0 to 100 by using slider input controls named RiskStatus on the app. The highest risks use the risk status value of 100.





If the combined value of all the tasks is 150 or above, a header bar on the screen must display the text HIGH RISK.

You need to configure a solution to change the text on the header bar.

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

7. DRAG DROP

A company has 500 products. Each product is referenced by a product ID. Each product belongs to one of eight product categories.

You are creating an app to manage requests for new products.

The product categories will never change. Categories are defined in the column itself, not in a separate table. The data must be structured in a way that does not allow for misspellings.

Only two new tables should be created in Microsoft Dataverse:

✑ Products: Holds the products that can be requested.

✑ Requests: Holds the requests for the product ID and quantity.

The products are filtered by product category.

You need to identify the data types to use when building the table columns in Dataverse.

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

8. HOTSPOT

A company uses several forms for biannual performance evaluations. The company conducts the evaluations by using a pen and paper process. The evaluations contain several performance areas that have a score of 1-10. A paragraph explains the score.

The company must scan completed performance evaluations into a Common Data Service entity by using a Power Apps app. The information in the documents must automatically map to entities and convert into quantifiable information.

If any key phrases in the scored topics cause concern, the company must follow a series of actions to prepare for a follow up.

You need to extract the information and perform the actions when the evaluations are scanned.

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

9. You are creating a multi-page canvas app that loads tabular data from an external data source.

Once loaded, the data must be available to all screens within the canvas app.

You need to reduce the number of times that the app must retrieve data from the data source.

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

10. Topic 3, Misc. Questions



You are an app designer for a hotel.

The hotel wants to create an app to help the housekeeping staff schedule work.

You need to create a new environment for the app.

Where should you create the environment?

11. You need to resolve the user’s 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.

12. DRAG DROP

You store data about products in two Microsoft Excel worksheets.

The data contains duplicate rows.

You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.

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.

13. 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 company has locations in multiple countries and regions across four continents.

The company stores the total amount of each order in the local currency of the country/region where the customer is located. The company stores the applicable exchange rates in a custom US dollars (USD) exchange rate table.

You need to create a visualization that displays the total amount of orders by country/region in USD.

Proposed solution: Create a model-driven chart on the country/region table that aggregates the total amount of the orders by country/region.

Does the solution meet the goal?

14. 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.

You build a canvas app for a manufacturing company. The company receives parts and materials from many vendors. You create a form to collect information from packing slips.

Receivers must be able to take a picture of packing slips to receive materials instead of manually entering data in the app.

You need to ensure that users can scan packing slip information into the form.

Proposed solution: Use a Category classification model.

Does the solution meet the goal?

15. HOTSPOT

You need to create a flow for sending required emails to the regional manager.

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

16. 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.

17. DRAG DROP

You create an app with multiple screens.

Test users report that the size and type of gallery displayed on each screen are different.

You must improve the consistency for the app screens.

You need to create a reusable gallery that displays information based on the current record.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

18. You have a Power Platform solution that uses Common Data Service.

You need to secure all fields that support field-level security.

Which field can you secure?

19. You need to modify the entity form to resolve the customer request number issue.

What should you do?

20. A company uses data loss prevention (DLP) policies. You have a Power Automate flow that posts Twitter mentions into a Microsoft SharePoint list.

You are not able to activate the flow.

You need to troubleshoot the issue.

What are two possible reasons why you cannot activate the flow? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

21. You have a Power Platform solution that uses Common Data Service.

You need to secure all fields that support field-level security.

Which field can you secure?