Microsoft Power Platform App Maker - PL-100 Exam Practice Test
A company uses Microsoft Dataverse to store holiday employee request data.
An HR manager needs a report that displays overview information about the employee requests.
You need to design a report that visualizes request data over time and type.
Which Microsoft Power Bl functionalities should you use to complete each step? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
An HR manager needs a report that displays overview information about the employee requests.
You need to design a report that visualizes request data over time and type.
Which Microsoft Power Bl functionalities should you use to complete each step? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
You create a canvas app for a finance team.
The finance team members require access to the app. The finance manager must be able to make updates to the app when necessary.
You need to set permissions for the team and the finance manager by using the principle of least privilege.
Which actions should you perform for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The finance team members require access to the app. The finance manager must be able to make updates to the app when necessary.
You need to set permissions for the team and the finance manager by using the principle of least privilege.
Which actions should you perform for each requirement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
You create a canvas app for a service company.
Using the Tree view, you navigate to the ViewServices screen. The screen contains a form named DetailForm1 that only contains Label controls. You add the People icon to the header of the ViewServices screen as shown below:
When you select the icon a new Activity form opens. You must set the value of the Name field on the new Activity form to the value of the name field from DetailForm1.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Using the Tree view, you navigate to the ViewServices screen. The screen contains a form named DetailForm1 that only contains Label controls. You add the People icon to the header of the ViewServices screen as shown below:
When you select the icon a new Activity form opens. You must set the value of the Name field on the new Activity form to the value of the name field from DetailForm1.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Graphical user interface, text, application Description automatically generated
Box 1: Name_DataCardValue1.Default
Box 2: Move the icon to the Activity form and set the On Select property to the Activity screen.
The Select function simulates a select action on a control as if the user had clicked or tapped the control. As a result, the OnSelect formula on the target control is evaluated.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-select
A company uses Microsoft Teams and Microsoft 365. Employees use Microsoft Excel to create checklist and capture measurements.
The company requites a Microsoft Power Platform app to consolidate the checklists and perform the measurements- Network connectivity may not be available when measurements are taken.
Which features should you use? To answer, select the appropriate options in the answer area NOTE: Each coned selection is worth one point.
The company requites a Microsoft Power Platform app to consolidate the checklists and perform the measurements- Network connectivity may not be available when measurements are taken.
Which features should you use? To answer, select the appropriate options in the answer area NOTE: Each coned selection is worth one point.
Correct Answer:
Explanation:
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.
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.
Correct Answer:
Explanation:
Box 1: Table
Box 2: Data source
Box 3: Column
Box 4: Row
Reference:
https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query
A company is using Microsoft Power Platform and Microsoft Teams to approve work contracts.
A manager must view all approved contracts in the past year that the company sent or received. The manager must approve any pending contracts. The solution must minimize effort.
You need to recommend a solution for the company.
What should you recommend?
A manager must view all approved contracts in the past year that the company sent or received. The manager must approve any pending contracts. The solution must minimize effort.
You need to recommend a solution for the company.
What should you recommend?
Correct Answer: E
Vote an answer
You need to design the quote form layout.
Where should the data be located on the form? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Where should the data be located on the form? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
You create an automated flow by using Power Automate. The flow appears under My Flows and is connected to the development environment. The development environment has a solution to move components into a production environment.
You need to ensure that you can transfer the flow to another environment.
What should you do?
You need to ensure that you can transfer the flow to another environment.
What should you do?
Correct Answer: A
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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 co workers.
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
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 co workers.
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
Correct Answer:
Explanation:
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?
You need to display a list of all active accounts.
Which user interface components should you use?
Correct Answer: B
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).
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.
What should you do? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Correct Answer:
Explanation:
Box 1: View the sessions details page for the app in Power Apps Studio
Use PowerApps Studio, select the App, and choose and you will be directed to the app's Versions tab in PowerApps portal. There should be one version marked Live.
Box 2: Select Restore on the previous version of the app.
Restore an app from your account
* Open powerapps.com, and then click or tap Apps in the left navigation bar.
* Near the right edge, click or tap the info icon for the app that you want to restore.
* Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore.
Reference:
https://powerapps.microsoft.com/sk-sk/blog/saveandpublish/
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/restore-an-app
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.
A company uses Power Apps in a single Microsoft Dataverse environment.
Users are divided into two groups about not a canvas app should work. The company decides that each group of users will try a version of the app for one week and switch to the other version of the app the following week.
You need to manage the app creation.
What should you do?
Users are divided into two groups about not a canvas app should work. The company decides that each group of users will try a version of the app for one week and switch to the other version of the app the following week.
You need to manage the app creation.
What should you do?
Correct Answer: B
Vote an answer
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 calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?
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 calculated field of type currency on the order table that converts the order total to USD and displays the total amounts by region in a Power BI chart.
Does the solution meet the goal?
Correct Answer: B
Vote an answer
Explanation: Only visible for PassTestking members. You can sign-up / login (it's free).