PL-100 無料問題集「Microsoft Power Platform App Maker」
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.
正解：
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 two SQL Server environments and two Common Data Service environments.
The company policy states that only specific administrators can create environments. SQL Server and Common Data Service groups must be distinct.
You need to assign security access.
What should you assign? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
The company policy states that only specific administrators can create environments. SQL Server and Common Data Service groups must be distinct.
You need to assign security access.
What should you assign? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Graphical user interface, text, application Description automatically generated
Box 1: System Administrator and Environment Security group
Security model for the databases
When a database is created, the users who have environment roles assigned to them, will continue to maintain those privileges.
Users with Environment Admin role are now assigned to System Administrator role. Users with Environment Maker continue to possess the same role.
Box 2: Environment Admin
The Environment Admin role can perform all administrative actions on an environment, including the following:
* Add or remove a user from either the Environment Admin or Environment Maker role.
Box 3: Environment Maker
Environment Maker: Can create new resources associated with an environment, including apps, connections, custom APIs, gateways, and flows using Microsoft Power Automate. However, this role doesn't have any privileges to access data within an environment. More information:
Box 4: System Customizer
System Customizer: Has full permission to customize the environment. However, users with this role can only view records for environment entities that they create.
Reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security
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.
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.
正解：A、B、H
解答を投票する
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.
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.
正解：
Explanation:
A company receives its marketing campaign performance report as a Microsoft Excel file. The company stores the file in Microsoft SharePoint.
A user updates the Excel file daily with updated data.
The company needs a solution that automatically displays the latest analytics.
You need to create a basic report that contains pie charts that display the most profitable channels.
You need to propose the right solution.
Solution: Microsoft Power Bl report querying Excel file using its path.
Does the solution meet the goal?
A user updates the Excel file daily with updated data.
The company needs a solution that automatically displays the latest analytics.
You need to create a basic report that contains pie charts that display the most profitable channels.
You need to propose the right solution.
Solution: Microsoft Power Bl report querying Excel file using its path.
Does the solution meet the goal?
正解：A
解答を投票する
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?
正解：A
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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.
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.
正解：
Explanation:
Box 1: Calculated
Calculated columns are calculated in real-time when they are retrieved. Calculated columns can be composed using different data types. For example, an Integer calculated column may reference values from Decimal or Currency columns.
Box 2: Simple
A simple column isn't defined as a calculated or rollup column.
Box 3: Rollup
Because rollup columns persist in the database, they can be used for filtering or sorting just like regular columns.
Reference:
https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes
You create a custom table as part of a solution in the development environment. You deploy major version solutions as managed solutions to production. The organization does not allow new solutions to be created in the production environment.
When a minor update is made to a column length, users cannot enter entire values.
You need to allow users to enter entire values in the column.
Solution: Uninstall the most recent version of the solution from the production environment.
Does the solution meet the goal?
When a minor update is made to a column length, users cannot enter entire values.
You need to allow users to enter entire values in the column.
Solution: Uninstall the most recent version of the solution from the production environment.
Does the solution meet the goal?
正解：B
解答を投票する
A production line app maker at a manufacturing company creates a canvas app that looks for available inventory in a SQL database. The production line workers use the inventory app across all work centers.
The production line workers report the following app issues from the shop floor:
* The app reports a delegation warning.
* Voice command functionality is unreliable.
You have minimal information about the issues. You are not allowed to enter the production facility.
You need to troubleshoot the issues.
How should you troubleshoot the issues? To answer, select the appropriate options in the answer area.
The production line workers report the following app issues from the shop floor:
* The app reports a delegation warning.
* Voice command functionality is unreliable.
You have minimal information about the issues. You are not allowed to enter the production facility.
You need to troubleshoot the issues.
How should you troubleshoot the issues? To answer, select the appropriate options in the answer area.
正解：
Explanation:
Graphical user interface Description automatically generated
Box 1: Check the number of items in the collection
If the data in your data source exceeds 500 records and a function can't be delegated, Power Apps might not be able to retrieve all of the data, and your app may have wrong results.
Note: Delegation is where the expressiveness of Power Apps formulas meets the need to minimize data moving over the network. In short, Power Apps will delegate the processing of data to the data source, rather than moving the data to the app for processing locally.
Box 2: Use the Advanced Tools/Monitor feature
Monitor is available by default for all canvas apps. Using Monitor, you can trace events as they occur in a canvas app during the authoring experience in Power Apps Studio, or you can use Monitor to debug the published version of a canvas app.
Example: Consider the scenario where an app has been deployed, and the initial version of the app experiences performance degradation. The app also intermittently generates errors with no clear pattern.
Loading data in the app succeeds most of the time, but fails sometimes.
When you check Monitor, you see data operations as expected. However, you also see several responses that have HTTP status code 429, indicating that there have been too many requests in a specific timeframe.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview
https://docs.microsoft.com/en-us/powerapps/maker/monitor-canvasapps
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.
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.
正解：
Explanation:
Graphical user interface, text, application, email Description automatically generated
Step 1: Upload the worksheets to OneDrive
A data source needs to be specified. The data needs to be available.
Step 2: Create a dataflow
Step 3: Create queries for the worksheets
You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.
Step 4: Add conditional columns to perform checks on the data
Step 5: Append the output of the queries
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows
https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query
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.
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.
正解：
Explanation:
Graphical user interface, text, application, email Description automatically generated
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.
* Open your report editor in Power BI Desktop then select a report on which you are working.
* On your right, you will see a Visualizations pane and a Fields pane.
* From the Visualizations pane, select the KPI visual.
* Etc.
Box 3: Power Automate
A company creates a Power Apps app that allows service representatives to record information about on-site client visits. Service representatives perform a one-hour site visit with each client each quarter.
Service representatives use the app to perform the following activities:
* View their scheduled visits for the day.
* Record notes from service visits.
* Schedule service technicians for issues uncovered during site visits.
* Scan and upload service quote forms to a folder named Service Quote folder on Microsoft OneDrive once the customer has signed a service quote.
Service quotes that are over $10,000 are aut omatically sent to the service manager for review and approval.
Visits that are not closed at the end of the day are automatically moved to the following day unless it is the last day of the quarter. All client visits not performed for the quarter are escalated to the service manager for follow-up.
You need to create flows to meet the requirements.
Which type of flows should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Service representatives use the app to perform the following activities:
* View their scheduled visits for the day.
* Record notes from service visits.
* Schedule service technicians for issues uncovered during site visits.
* Scan and upload service quote forms to a folder named Service Quote folder on Microsoft OneDrive once the customer has signed a service quote.
Service quotes that are over $10,000 are aut omatically sent to the service manager for review and approval.
Visits that are not closed at the end of the day are automatically moved to the following day unless it is the last day of the quarter. All client visits not performed for the quarter are escalated to the service manager for follow-up.
You need to create flows to meet the requirements.
Which type of flows should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
正解：
Explanation:
Graphical user interface, text, application Description automatically generated
Box 1: Adaptive card flow
Adaptive Cards are a platform-agnostic method of sharing and displaying blocks of information without the complexity of customizing CSS or HTML to render them.
Directing content to Teams channels:
Post your own adaptive card as the Flow bot to a channel
This action posts an adaptive card as a Flow bot to a specific Teams channel. In this case, you will be prompted for Teams instance, and a channel where the card will be posted. The flow-maker will have to have access to the Teams instance in order to post an adaptive card there. In this case, only URL buttons function by redirecting to the URL configured within the flow.
Box 2: Button flow
Create a button flow to run routine tasks by simply tapping a button. Customize your flow by allowing the user to provide specific details that will be used when the flow runs.
Reference:
https://docs.microsoft.com/en-us/power-automate/overview-adaptive-cards
https://docs.microsoft.com/en-us/power-automate/button-flow-with-user-input-tokens
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 creating a canvas app that displays a list of accounts.
Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts.
You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen.
You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail.
You need to complete the app.
Solution:
* Add an edit form to Screen_AccountDetail and set the Default Mode of the form to New
* Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail).
* Set the data source of the form to Accounts.
* Set the Item property of the form to Selected.
* Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts).
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.
You are creating a canvas app that displays a list of accounts.
Users must be able to select an account and view details for the account. The app must include a feature that brings the user back to the list of accounts.
You add a blank screen named Screen_Accounts and add a gallery named Gallery_Accounts to the screen.
You set the data source of Gallery_Accounts to Accounts and add another blank screen named Screen_AccountDetail.
You need to complete the app.
Solution:
* Add an edit form to Screen_AccountDetail and set the Default Mode of the form to New
* Set the OnSelect property of Gallery_Accounts to Navigate(Screen_AccountDetail).
* Set the data source of the form to Accounts.
* Set the Item property of the form to Selected.
* Add a back icon on Screen_AccountDetail and set its OnSelect property to Navigate(Screen_Accounts).
Does the solution meet the goal?
正解：B
解答を投票する
解説: (JPNTest メンバーにのみ表示されます)
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 a Microsoft Power Apps developer.
Business users must use an app on mobile phones to access charts that display the sales data of customers.
Microsoft Dataverse stores the sales data.
You need to propose a solution to meet the requirements.
Solution: Use a Power Apps canvas app that follows responsive design principles with embedded Power Bi reports.
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.
You are a Microsoft Power Apps developer.
Business users must use an app on mobile phones to access charts that display the sales data of customers.
Microsoft Dataverse stores the sales data.
You need to propose a solution to meet the requirements.
Solution: Use a Power Apps canvas app that follows responsive design principles with embedded Power Bi reports.
Does the solution meet the goal?
正解：A
解答を投票する