Verified Microsoft PL-100 Dumps – Pass Your Microsoft Power Platform App Maker Exam by Using PL-100 Dumps (V15.02)

1. Topic 1, Wide World Importers

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

Sales representatives submit weekly status reports to regional managers. There is no standardized format for these status reports. The process for managing status reports is challenging.

Wide World Importers has decided to use Microsoft 365, Microsoft Azure, and Power Platform for future app development. Both Wide World Importers and Tailwind Traders have identical Microsoft SharePoint and Azure configurations. Both companies use separate tenants.

Requirements

Application

You must create a mobile app to streamline the creation of status reports by sales representatives. You must make the same app available to Tailwind Traders.

The mobile app must meet the following requirements:

- Minimize the use of code.

- Use formulas and expressions when necessary.

- Support a variety of visual layouts.

- Use a SharePoint list to store information about regional managers and sales representatives.

- Use Azure SQL Database to store other data.

Status reports

- Sales representatives must provide a weekly status report for all work processes each Monday.

- Representatives must enter the following information for each process:

- If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager. If the category is Work/life balance, the information must be carbon copied to the human resources department.

- If a sales representative does not submit a weekly status report by an agreed upon deadline, the system must send an email to remind the sales representative.

- 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 must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.

- When data is submitted offline, the data must be stored in the app until the app is back online.

Technical

Regardless of the UI layouts, the data recorded must be standardized in the Azure DB tables. You must use global variables in the app.

Deployment

- Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines.

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

- You must use the following version control numbering scheme:

Major: The last two digits of the year the app is packaged

Minor: Two digits that represent the month when the app is packaged

Build: A number that is incremented to represent significant changes to the app

Revision: The incremented revision for a package

- New versions of the application must completely replace previous versions of the app.

- When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version.

- Previous versions of the mobile app must be available for roll back purposes.

- All versions of software that have been used in production must be retained for five years.

Issues

The mobile app has been live for several months. Eight versions of the app have been released since the initial version of the app was deployed to sales representatives. You must revert the app to an earlier version and redesign some features.

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.

Several sales representatives have accessibility restrictions. User2 is visually impaired and cannot see images. User3 is unable to use a mouse.

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.

2. HOTSPOT

You need to configure the app to meet the requirements.

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

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

4. DRAG DROP

You publish the first version of the app and solution on November 1, 2020.

You need to create the version numbers for the app and the solution.

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

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

What should you do?

6. You need to meet the requirements for sales representative that submit status reports.

How should you configure the flow?

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

8. HOTSPOT

You need to roll back the mobile app to an earlier version.

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

9. You need to provide the app to Tailwind Traders.

What should you do?

10. You need to configure functionality for submitting status reports.

What should you do?

11. You need to create the mobile app.

Which type of app should you create?

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

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

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

What should you do?

15. You need to connect to the data source for the Job Setup app.

What should you do?

16. HOTSPOT

You need to configure the system to meet the requirements.

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

17. HOTSPOT

You need to configure the system to meet the sales requirements.

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

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

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

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

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

22. You need to implement the change requested by the operations manager.

Which control should you use?

23. You need to implement logic in the app for lost sales.

What should you do?

24. You need to create a flow for moving data from the Sales Log to the Job Setup entity.

Which type of flow should you use?

25. Topic 3, Culinary Arts CollegeCase Study

A culinary arts college trains world class chefs by offering a blend of theoretical and practical education. The culinary arts program enrolls two hundred students per term. The instructors split the students in groups of five to seven students, depending on the specialty selected. Each instructor is in charge of one group of students.

The college uses several systems to manage the student classroom activities. The college plans to implement a Microsoft Power Platform solution to replace the existing system. The goal is to align the cooking curriculum to the taste preferences of their subscribers and automate as much as possible to reduce administrative overhead. The college has two revenue streams:

• student enrollment fees and work placement brokerage

• lunch catering to businesses, school cafeterias and other consumers via subscriptions Subscribers place orders from a menu published by the instructors. The menu displays all the dishes and quantities that students will create during a cooking lesson.

The college partners with food banks to offer healthy meals to people in need. Students participate in the packaging and safe storage of any leftovers meals and notify the food banks about available meals. If 85 percent of the meals produced during a week sell out the college makes the remaining 15 percent available to food banks only.

Current system

• The college manages subscribers and their dish preferences by using a SQL Server-based app that is hosted in the college's on-premises datacenter. Each week, data is extracted as a Microsoft Excel workbook and distributed to instructors.

• Recipes are stored as Microsoft Word documents in SharePoint libraries. Access to recipes is restricted to instructors and students.

• The college uses Microsoft 365 for emails, classroom and kitchen bookings, and document management.

• Students will use a Microsoft Outlook calendar to see their group's schedule and to collaborate with instructors and other students.

Current processes

• Instructors use Microsoft Excel workbooks to capture class attendance information for cooking classes

• Instructors develop the culinary arts program and refine it periodically.

• Instructors are responsible for monitoring kitchen processes

• Instructors order the ingredients in bulk from food distributors. The instructors define threshold quantities that trigger inventory replenishment.

• Students self-organize in teams and brainstorm to produce new recipes.

• Students earn credits faster if they create new recipes in their specialty and the new recipe gains enough votes from subscribers

Cooking classes

• Each cooking class has a start date, a start and end time, a minimum and a maximum number of participants, and a cuisine specialty.

• Students select one main cuisine to specialize in when applying for enrollment

• Students participating in a cooking class can participate as a chef or as a helper. There is only one chef per session. Everyone else is a helper

• Instructors select the chef and recipe for each cooking class and distribute a link to the recipe document before each class.

• Each instructor performs quality checks on dishes that are offered for sale and evaluates both the chef and the helper.

Subscriptions

• The college offers the following types of subscriptions based on a client's commitment to order

• Public - lunch orders placed between 1(h00 AM and noon from an open menu, subject to availability. Most occasional and high-volume subscribers became fans of the college after ordering from the public subscription,

o Occasional subscribers - a fixed number of meals, either monthly or weekly, o High volume - businesses that provide their staff free lunches every workday.

• A group of 25 business subscribers each order an average of 2.OO0 meals per day.

• The number of occasional subscribers varies daily.

• The college generates a QR code for high-volume subscribers to allow staff to vote for their favorite dishes.

Class management

• The solution must track credits earned by the students.

• Students require a fixed number of credits in the chefs role to gain the cuisine specialization. Students can acquire credits by using any of the following methods: o number of hours in practical sessions as helpers

o number of hours as chefs

o popular votes from dishes prepared as chefs o marks from the class instructor

• Students must confirm their attendance by selecting Start at the beginning of each class and selecting Done at the end of the class.

• The student s total number of practice hours and credits earned must display in the app

• Students team up together to create new recipes and must keep their recipes confidential.

• The instructors photograph dishes that pass quality checks and upload the photographs to the daily menu that is made available to subscribers.

• Dish votes are counted based on the number of people who marked the dish as a favorite.

• The college requires a lively visual that displays marketing data on their public-facing website.

Subscriptions

• The subscriber administrators must approve the credit terms for high-volume subscribers.

• Occasional and high-volume subscribers must be able to place orders online.

• Subscribers should be able to mark a dish as favorite directly from their order.

Food management

• Instructors must be able to reserve the quantities of ingredients that they require for cooking sessions.

• Each ingredient has a primary unit of measure for bulk ordering and a second unit of measure for using in a recipe. (For example, flour in pounds when ordering and in cups for use in a recipe).

• The app must display the current inventory and reserved quantities for each ingredient needed for a recipe. The display must be consistent for appropriate roles.

• Food banks must be able to access the food pool online and place their orders from a filtered list based on their location.

• The college must replace the food bank notifications with an automated system that food bank users can access directly from the college s public website.

• The app must use a chatbot to replace the food bank notifications so that food bank users

can see food available for pickup by food banks.

Food management

• One instructor discovers discrepancies in the ingredient inventory and requests the standardization of the units of measures for all ingredients. Each time an ingredient is used in a recipe, the secondary unit of measure must be populated and be read only.

• Students report that they are not able to see their total practice hours in the app.

HOTSPOT

You need to design the data model for the cooking classes.

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

26. DRAG DROP

You need to select a design approach for the required features.

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

27. You need to resolve the instructor's issue and ensure that the same issue does not occur again.

What should you use?

28. You need to implement reporting to support the college marketing efforts.

Which type of dashboard should you use?

29. DRAG DROP

You need to create the food bank notification.

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.

30. HOTSPOT

You need to implement the student attendance requirements.

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

31. Topic 4, Misc. Questions

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 are developing a model-driven app that uses a Common Data Service database. App users will have a variety of different security roles.

Development and testing must be performed using production data. Multiple testers must be used at each testing stage.

You need to provision and configure new environments for development and testing.

Solution:

✑ Provision production environments named P1 and P2.

✑ Copy the current production environment to P1 and P2.

✑ Use P1 for development and P2 for testing.

Does the solution meet the goal?

32. DRAG DROP

You are creating a Power Automate cloud flow to update a column on each Item in a list of Microsoft Dataverse records. Records are sorted in order of priority.

You must use a complex expression to determine the column value. The column value must be stored in a variable to make future maintenance easier. Records must be processed based on the sorted order.

You need to add flow steps to process the list of records.

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.

33. A company creates multiple cases in Microsoft Dataverse each day with a status of New.

For all cases with a status of New, the system must send an email to the customer and then change the status to in Process.

You need to create a Microsoft Power Automate cloud flow to automatically send the email.

What should you do?

34. DRAG DROP

A company uses Power Apps.

The company requites a canvas app that connects to the following sources:

• SharePoint list

• Microsoft 365 mailbox

• SOAP API

You need to select connector types.

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

35. HOTSPOT

A company is creating new app for use by technicians.

Previous versions of the app do not render properly on tablets and phones.

You need to ensure that the new app renders properly on all devices.

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

36. You create a canvas app that connects to a Common Data Service database.

Users report that they do not see any data in the app.

You need to ensure that users can view data in the app.

What should you do?

37. You are creating an app for an organization’s human resources (HR) department. You create an Employee entity in an unmanaged Common Data Service solution.

Another user creates the following Power Automate flows separately from the solution:

You need to incorporate the flows that can be added to the solution.

Which two flows can you include? Each correct selection presents a complete solution. NOTE: Each correct selection is worth one point.

38. DRAG DROP

You ate designing an app to track time off for employees. Employee data, including employee ID number, is stored in an existing data source used by other apps.

Employees must be able to look up their employee ID number and enter time-off start and end dates in the app.

You need to configure the elements of the data source.

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

39. 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 custom rollup field of type currency on the country/region table that aggregates all the total amounts for the orders from that country/region and display this rollup field in a Power BI chart.

Does the solution meet the goal?

40. You need to set the value for a global variable named RunningTotal to 5 and navigate to the previous screen named MainScreen.

Which formula should you use?

41. A company is consolidating communications processes by using Microsoft Teams and Microsoft Power Platform technologies.

A Power Automate flow monitors social media channels to identify high-impact trends.

When the Power Automate flow identifies the trends, consistently formatted and standardized feedback must be collected from the channel members within Teams.

You need to streamline the Power Automate and Teams communication process.

What should you use?

42. DRAG DROP

A company is migrating to a new Microsoft 365 tenant. You create an expense management canvas app and cloud flow in the old Microsoft 365 tenant.

You need to move the latest version of the canvas app and cloud flow to the new tenant.

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.

43. 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?

44. HOTSPOT

You are designing edit forms to dismay individual records selected from a list m a canvas app.

The control layout must respond to a variety of screen sizes and orientations that demonstrate the following behaviors:

• Automatically resize and arrange controls from top to bottom

• Maintain the original position of the controls.

• Require no additional property changes.

You need to select the layout type.

Which layouts should you use? To answer, select the appropriate options in the answer area.

45. 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 are developing a model-driven app that uses a Common Data Service database. App users will have a variety of different security roles.

Development and testing must be performed using production data. Multiple testers must be used at each testing stage.

You need to provision and configure new environments for development and testing.

Solution:

✑ Provision sandbox environments named S1 and S2.

✑ Copy the production environment to both S1 and S2.

✑ Use S1 for development and S2 for testing.

Does the solution meet the goal?

46. DRAG DROP

A company uses Power Automate. You manage two cloud flows named A and B.

Users must perform the following activities:

• Manage the properties of cloud flow A.

• Manually trigger cloud flow B

You need to set up privileges for the business users by using the principle of least privilege

Which privilege types should you grant for each activity? To answer, drag the appropriate privilege types to the correct activities. Each privilege 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.

47. A company is using Power Virtual Agents in Microsoft Teams to expose Microsoft Dataverse data to employees.

You create a chatbot that retrieves a list of customers by postal code from a Dataverse table. The chatbot will accept requests from a user and must connect to Dataverse to retrieve the data.

You need to connect the chatbot to the Dataverse table.

What should you use?

48. You are creating a model-driven app that allows users to create and edit a list of existing accounts.

You need to display a list of all active accounts.

Which user interface components should you use?

49. DRAG DROP

You are Designing a Power Virtual Agents chatbot in Microsoft Teams. You create an outline to describe how a conversation should be structured.

You need to configure the chatbot.

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

50. A company uses Power Apps and Microsoft Dataverse. The company has a managed solution in the production environment.

You make changes to the solution m the development environment. Some components are unused. The changes to the solution must be reflected in the production environment.

You need to ensure that all unused components are removed.

What should you do?

51. A company stores financial files in Microsoft SharePoint document libraries.

When a user uploads a new file, the user's manager must approve the request.

You need to design a cloud flow to meet The requirement.

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

52. HOTSPOT

A state planning department stores demographic data in a local SQL Server database.

The department uses a local report server to analyze the data for land development purposes.

You need to create a visual to display the demographic data.

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

53. You complete work on a new canvas app in a development environment and add the app to a solution. You export the solution from the development environment and import the solution into a production environment.

After several days you notice that the background color for the canvas app in the production environment has changed from white to grey.

You need to determine why the background color changed.

What are two possible causes for the background color change? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

54. DRAG DROP

You plan to create apps for a company.

You need to identify the Power Platform tools required.

What should you use? 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.

55. DRAG DROP

You are configuring a new Common Data Service environment by using the Power Apps Maker portal.

You need to create an entity that uses the prefix xyz.

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.

56. DRAG DROP

A call center manager monitors incoming phone calls. The manager analyzes the performance of phone reps by using a custom view. The view contains a custom field named Phone call Duration in Minutes.

The call center manager must present an Excel spreadsheet daily to upper management. The spreadsheet must contain the call center performance for further trending analysis and corrective actions.

You need to create the spreadsheet.

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.

57. DRAG DROP

A company stores sales orders in a Microsoft Excel workbook. The company stores customer data in a SQL Server database.

You must import the data into a Microsoft Dataverse instance.

You need to define the mapping for the migration.

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

58. HOTSPOT

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

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

For each task, the user selects a button named RiskLevel to send the name of the task and RiskStatus number to key project stakeholders. The color of the button must change to the color listed in the following table based on the value of the RiskStatus control.

The default color for the button is green.

You need to configure the solution to change the color of the RiskLevel button.

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

59. You are using Test Studio to test a Power Apps canvas app.

You need to ensure that the app conforms to several use cases.

What should you do first?

60. 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 custom column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI Desktop and display this column in a Power BI chart by country/region.

Does the solution meet the goal?

61. HOTSPOT

A coworker creates a canvas app.

The canvas app contains the following formula.

The formula is attached to the OnVisible property of the first screen that users see:

You are updating the canvas app.

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

62. You are designing an interactive report for a model-driven app. The report will use more than five million records. The query that retrieves data for the report requires more than five minutes to complete. You need to create the report.

Which option should you use?

63. HOTSPOT

You are a technical assistant for a legal services organization. The company uses SharePoint to manage documents and Microsoft Dataverse as the data store. The company has strict rules about access, permissions, and privacy.

Lawyers and paralegals use Microsoft Teams for communications and collaboration. Employees use personal devices to access legal files. You do not have access to the admin area in Microsoft Power Platform.

You need to ensure that these rules are observed consistently and managed in one place.

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

64. A company uses a canvas app to encourage employees to take reading breaks during their work schedule. The reading breaks are created automatically as Outlook tasks in the employees Outlook app. The app must trigger a Power Automate cloud flow when specific data is captured in the canvas app. You need to create and configure the flow.

Which flow step should you configure first?

65. You create a Power Platform solution. Solution data is stored in a variety of documented cloud services.

You must also be able to connect to one or more industry data sources.

You need to configure the data sources.

What should you do?

66. DRAG DROP

A company uses Power Automate.

The company requires three cloud flows for the following:

• Send email notifications to a team member after an expense request is approved.

• If a document is uploaded to OneDrive. forward the document as an email attachment.

• Send an email at 4:00 PM on Fridays to remind team members to submit timesheets.

You need to create the cloud flows.

Which cloud flow types should you create? To answer, drag the appropriate cloud flows to the correct activities. Each cloud flow 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.

67. HOTSPOT

Users in your company vote on color choices for marketing materials by using the following canvas app:

Users enter color names into a text control and then select Add color to add the color to the Color options radio control. You must remove all the listed colors when a user selects Clear Selection.

You need to implement the functionality.

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

68. You create a model-driven app for salespeople.

Users must interact with a business process flow that invokes multiple tables. You need to instruct users where to find the business process flow, which component should you use?

69. DRAG DROP

A company is building multiple Power Apps apps to support a mobile sales team.

The apps must all share a common control that has custom properties.

You need to create a solution for the apps.

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

70. A company uses Microsoft platforms for all accessibility, compliance, and security auditing.

The auditing and compliance division of the company flags a newly created Power Apps canvas app due to accessibility issues. The app must be unpublished until it conforms to Microsoft accessibility requirements and recommendations.

You need to identify all accessibility issues for a solution.

What should you use?

71. A company uses Power Apps.

The company creates a solution that contains the following items:

• environment setting

• flow that accesses Microsoft Dataverse

• plug-in with an unsecure configuration

• environment variable with a default value

The company plans to import solutions manually.

You need to document the solution component type that prompts for user input.

Which component type should you document?

72. 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 Text Recognition model.

Does the solution meet the goal?

73. A clothing retailer is creating a Power Virtual Agents chatbot in Microsoft Teams. The chatbot will use Microsoft Dataverse for Teams to provide sales metrics by store.

A user wants to be able to ask the chatbot to see all the sales for pants.

You need to configure the chatbot to provide sales data for pants even when a user enters the terms jeans, slacks, or trousers.

Which chatbot component should you use?

74. DRAG DROP

You create a canvas app. You run App checker to validate the app.

App checker returns error results.

You need to locate where the errors occur.

Which areas should you review? To answer drag the appropriate areas to the correct error messages. Each area may be used once, more than once, or not at all You may need to drag the spirt bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.

75. DRAG DROP

You create multiple apps as part of an unmanaged solution.

You need to move the apps to another environment.

You need to pick the appropriate solution type for each requirement.

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

76. DRAG DROP

A company uses data from a publicly available web service. You plan to create a tabular report by using Power 81 Desktop to visualize data from the web service.

The data returned in one column is numeric and must be converted to a corresponding text value. The most up-to-date version of the data must always be used.

You need to create the report and make it available only to coworkers.

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. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select

77. DRAG DROP

A company is creating Power Apps apps for their customer service team.

You must create a final released solution to export to their test environment that cannot be changed in the new environment.

You need to determine the types of solutions to use.

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

78. 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 is deploying Microsoft Power Platform components to streamline a job candidate screening process.

The human resources (HR) representatives of the company plan to attend school career fairs. The HR representatives must qualify and enter potential job candidates into a Power Apps app.

The HR representatives must enter the following information for each candidate:

If a candidate is currently unqualified for a job position but would eventually qualify based on follow-up criteria, the follow-up checkbox must be selected or cleared in the system immediately.

The company plans to create a similar Power Apps app that will contain the same business use case, but for internal employees and promotions.

You need to create a Power Apps app solution to automatically mark the candidate for follow up.

Proposed solution: Create a Power Automate flow with conditions that use entered data as default data.

Does the solution meet the goal?

79. DRAG DROP

A company uses Power Automate and Power Apps to streamline business processes.

You need to use AI Builder to analyze customer reviews of the company’s products.

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.

80. DRAG DROP

You are creating entities in a Common Data Service database to capture sales data.

You create an entity named Sales that includes the following fields:

You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.

You need to configure the fields for the entities.

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