Microsoft PL-100 Microsoft Power Platform App Maker (beta) Online Training

Topic 1, Wide World Importers

Overview

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.

You need to provide the app to Tailwind Traders.

What should you do?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: App Checker

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

Users who have vision, hearing, or other impairments can use your canvas app more easily and successfully if you consider accessibility as you design how the app looks and behaves. If you’re not sure how to make your app more accessible, you can run the AppChecker Accessibility checker in Power Apps Studio.

Box 2: Solution Checker

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

Use solution checker to validate your model-driven apps in Power Apps.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/accessibility-checker

https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/use-powerapps-checker

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Fill

Scenario: You must display a visual indicator in the app so that sales representatives know whether the app is offline before submitting reports.

Fill C The background color of a control.

Incorrect Answers:

DisplayMode – The mode to use for data cards and controls within the form control.

Box 2: SubmitForm

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

Use the SubmitForm function in the OnSelect property of a Button control to save any changes in a Form control to the data source.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-screen

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: 1.0.0.0

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.

A solution’s version has the following format: major.minor.build.revision. An update must have a higher major, minor, build or revision number than the parent solution. For example, for a base solution version 3.1.5.7, a small update could be a version 3.1.5.8 or a slightly more signficant update could have version 3.1.7.0. A substantially more significant update could be version 3.2.0.0.

Box 2: 20.11.1.1

Scenario:

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.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/update-solutions

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.

Reveal Solution Hide Solution

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

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

What should you do?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Power Apps mobile app

Scenario:

User1 often works in a warehouse that does not have internet connectivity.

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

The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.

You can build offline capabilities in your PowerApps app so your app users can access some data or save some data even when they don’t have an internet connection.

Box 2: Connector

Scenario: Azure SQL Database is used to store other data

Use the SQL Server connector to connect to SQL Server, in either Azure or an on-premises database, so that you can manage your data with create, read, update, and delete operations.

Reference: https://powerapps.microsoft.com/en-us/blog/implementing-offline-capability-in-your-app/

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

How should you configure the flow?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: AccessibleLabel

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

User2 is visually impaired and cannot see images.

AccessibleLabel is a label for screen readers.

An empty value for Image, Icon, and Shape controls will hide the controls from screen reader users.

Box 2: TabIndex

User3 is unable to use a mouse.

TabIndex determines if the control participates in keyboard navigation.

Keyboard navigation is an important aspect of any app. For many, the keyboard is more efficient than using touch or a mouse. The navigation order should:

Mirror what is seen visually.

Only have a tab stop at controls that are interactive.

Follow either an intuitive across and then down "Z" order or a down and then across "reverse-N" order.

You need to create the mobile app.

Which type of app should you create?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Business Process

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

Business process flows provide a guide for people to get work done. They provide a streamlined user experience that leads people through the processes their organization has defined for interactions that need to be advanced to a conclusion of some kind. This user experience can be tailored so that people with different security roles can have an experience that best suits the work they do.

Box 2: Common Data Service when a record is created

The Microsoft Dataverse (Common Data Service) connector provides the following triggers to help you define when your flows start:

When a row is created, updated, or deleted

When an action is performed

When a flow step is run from a business process flow

Reference:

https://docs.microsoft.com/en-us/power-automate/flow-types

https://docs.microsoft.com/en-us/power-automate/dataverse/overview

You need to configure functionality for submitting status reports.

What should you do?

Reveal Solution Hide Solution

Topic 2, Contoso, Ltd

Overview

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.

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

Which control should you use?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Timer

A Timer control in Power Apps is a control that can determine how your app responds after a certain amount of time passes.

Box 2: Barcode scanner

The Barcode scanner control for canvas apps scans barcodes, QR codes, and data-matrix codes on an

Android or iOS device.

Box 3: Image

Image control in Power Apps is a control that shows an image from, for example, a local file or a data source.

If you add one or more Image controls to your app, you can show individual images that aren’t part of a data set, or you can incorporate images from records in data sources.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-new-barcode-scanner

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-image

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: 1: N

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

Box 2: User or Team owned

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

User or team: Data belongs to a user or a team. Actions that can be performed on these records can be controlled on a user level.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/types-of-entities

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

What should you do?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: PowerBI Desktop

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.

PowerBI Desktop to support many data source.

Box 2: PowerBI Desktop or Power BI Service on

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

Both support visualizations.

Reference: https://docs.microsoft.com/en-us/power-bi/fundamentals/service-service-vs-desktop

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

What should you do?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Model-driven app

The Sales app must meet the following requirements:

✑ Provide a central location for all sales pipeline and quote information that is easily accessible and maintains all of the versions of the estimate, quote, and engineering documents.

Compared to canvas apps, model-driven apps in PowerApps are based on underlying data ― specifically, the data stored in Common Data Service (CDS).

Box 2: Power BI Desktop

You can create a KPI in Power BI Desktop.

✑ 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

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

What should you do?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Use a Business Process flow

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

Box 2: Use a formula to set the DisplayMode property DisplayMode – The mode to use for data cards and controls within the form control.

Derived from the Mode property based and cannot be set independently:

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-form-detail

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Security role

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

Testers report that they can see time entries in the Time Tracker app, not just their own.

Box 2: Field-level security

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

Testers report that they can edit any existing time entries.

Box 3: Hierarchical security

You use field security tables to apply field-level security, which restricts field access to specified users and teams.

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.

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

Topic 3, Culinary Arts College

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

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

Which type of dashboard should you use?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

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

What should you use?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

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.

Reveal Solution Hide Solution

Correct Answer:

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.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to create the solution for subscriber orders.

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

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

You need to resolve the issue related to the student canvas app.

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.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select tables to use for the main personas in the college implementation.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to design and distribute a chatbot that captures ideas for new recipes.

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

Reveal Solution Hide Solution

Correct Answer:

You need to implement a solution to meet the ingredients inventory requirement.

Which type of public view should you use?

Reveal Solution Hide Solution

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

You need to select data types for the app.

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

Reveal Solution Hide Solution

Correct Answer:

After a job is estimated and approved, it is sent to the service staff to implement.

Requirements

VanArsdel, Ltd. plans to continue its processes by using Microsoft Power Platform tools to allow users to work more efficiently.

• Office workers and the office manager must be able to do the following:

o Use a model-driven app.

o Use email as their primary method of communication.

o Be contacted automatically when they have been assigned an estimate to complete or review.

• Salespeople must be able to do the following on their mobile device and while offline:

o Calculate the cost of concrete.

o Record notes and area measurements to calculate material costs.

o Capture multiple pictures and drawings.

• Both salespeople and office workers must be able to calculate the cost of the concrete portion of a job by using the same tool.

• All data must be stored in Microsoft Dataverse.

o Quotes must be used to create estimates.

o A new column must be added to track approval status.

o A custom table must be used to store data collected by salespeople.

o A Microsoft Power Automate flow must be used to convert the data captured by the salespeople into a quote,

o Area measurements must be converted to the quantity of units required to cover the area. The unit conversion must round up for quote lines,

o Quotes must only display lines that have values greater than 0.

• Customizations must be done by using out-of-the-box tools.

Issues

• Salespeople ate unable to save data to the custom table.

• The Power Automate flow that creates quotes returns an error when a math function is used for measurements that contain no value.

You need to resolve the error caused by empty measurements.

Which two conditions should you use to process the measurements? Each correct answer presents part or the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

HOTSPOT

You need to implement the Microsoft Power Platform tools that meet the requirements of the office workers, office manager, and salespeople.

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

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

You need to create a Power Automate flow by using a minimum number of actions for the estimate approval process.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area arrange them in the correct order.

Reveal Solution Hide Solution

Correct Answer:

You need to create a Dataverse table view for the office workers who create estimates.

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

Reveal Solution Hide Solution

You need to create the Power Automate flow to create a quote.

Which trigger should you use?

Reveal Solution Hide Solution

HOTSPOT

You need to explain to the salespeople where to store photos taken onsite in situations with both offline and online connections.

Which locations should you recommend for each connection type? To answer, select the appropriate options in the answer area. NOTE Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

You need to implement the concrete calculator.

Which Microsoft Power Platform tool or component should you use?

Reveal Solution Hide Solution

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Topic 5, Misc. Questions

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Connect data to the model.

First create an AI Builder form processing model for the customer reviews you want to process.

Step 2: Train the model.

Step 3: Publish the model.

Step 4: Use the model in a Power Automate flow.

Once you train and publish the model, create a solution-aware flow in Power Automate.

Reference: https://powerapps.microsoft.com/en-us/blog/introducing-simplified-ai-builder-experience-in-power-automate/

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

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

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

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

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Unmanaged

Unmanaged Solution: The beginning state of solution is the unmanaged solution state. During this phase, you can add, edit, update, remove, delete, and test any of the components of the solution.

Box 2: Unmanaged

Box 3: Managed

Managed Solution: A managed solution is a finalized solution that can be distributed and installed. They are created by exporting an unmanaged solution by setting restrictions to prevent any further customizations. The whole point of Managed is locking down the Component states so they cannot be edited. Deleting the Managed Solution will remove all its customisations as well as data contained. Managed Solutions become read only once deployed so they cannot be manipulated.

Reference: https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685

Each maker at a company has a separate Common Data Service environment. You are customizing a canvas app. You create two new entities in your environment.

You are leaving for a vacation. Another maker will continue customizing the app in your absence.

You need to transfer the work to the other maker and ensure that you can work on the updated app when you return from your vacation.

What should you export?

Reveal Solution Hide Solution

DRAG DROP

You are designing a canvas app that will be used by all users including users who have vision impairments.

Which outcome is achieved by each action? To answer, drag the appropriate outcomes to the correct actions. Each outcome 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/sv-se/powerapps/maker/canvas-apps/accessible-apps

Note: This question is part of a series of questions that present the same scenario. Each question in

the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

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

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

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

Proposed solution: Use a Category classification model.

Does the solution meet the goal?

Reveal Solution Hide Solution

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 an Entity Extraction model.

Does the solution meet the goal?

Reveal Solution Hide Solution

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 Key Phrase Extraction model.

Does the solution meet the goal?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

DRAG DROP

You create an app with multiple screens.

Test users report that the size and type of gallery displayed on each screen are different. You must improve the consistency for the app screens.

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

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

– Create a component

– Add an input property

– Add a gallery control

From https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/create-component

step 10 and 11

You use a Microsoft SharePoint list to record information about customers.

You must perform a series of actions only when a new item is added to a SharePoint list.

You need to configure a Power Automate flow.

Which trigger should you use?

Reveal Solution Hide Solution

A company has a Common Data Service custom entity that stores customer account data.

You need to create a relationship between the custom entity and the Account entity.

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

Reveal Solution Hide Solution

You create a canvas app for technicians at a computer store. You assign technicians cases to work on.

The technicians update cases at the end of customer site visit.

The manager wants the technicians to sell warranties to the customers. If a customer agrees to purchase a warranty, technicians use the canvas app to immediately alert the sales team, and then the technician records details about the warranty into the app.

You need to create a flow to alert the sales team.

Which type of trigger should you use?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: No

Records are added, not updated.

Box 2: Yes

The Collect function adds records to a data source.

Syntax: Collect (DataSource, Item, … )

DataSource C Required. The data source that you want to add data to. If it doesn’t already exist, a

new collection is created.

Item(s) – Required. One or more records or tables to add to the data source.

Box 3: No

No records are cleared.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

You are an app maker.

You want to create apps and track customizations as part of the default solution.

You need to determine the impact of performing the work in the default solution.

What should you conclude?

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

You create a canvas app named Hardware Order that suggests computer hardware to customers.

A value must be entered for the EmployeeID field when creating a new order if the value in the OrderType field does not contain the prefix test.

You need to configure the business rule.

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

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-entity

DRAG DROP

You have the following Common Data Service entities: BusinessContracts and BusinessAccounts.

You need to configure an N:N relationship between the two entities.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Open the relationship tab of the BusinessContracts entity.

View entity relationships

From the Power Apps portal, select either Model-driven or Canvas design mode.

Select Data > Entities and select the entity that has the relationships you want to view.

With the Relationships tab selected, you can select the following views:

Step 2: Select Add relationship.

Create relationships

While viewing entity relationships, in the command bar, select Add relationship and choose Many-to-many.

Step 3: Select the BusinessAccounts entity as the related entity.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-edit-nn-relationships-portal

DRAG DROP

You are an app builder for a medical office. The medical office uses activities to book appointments and business process flows to track patient status. The cleaning staff wants the app to connect directly to a Microsoft Excel workbook to track cleaning tasks. The office does not have access to reporting tools including Power BI.

You need to create apps for the following groups of users.

Apps must not require customizations or the use of additional products.

Which type of app should you build for each group? To answer, drag the appropriate app types to the correct groups. 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/embedded-canvas-app-guidelines

https://global.hitachi-solutions.com/blog/canvas-vs-model-driven-apps

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Canvas App

Box 2: Model-driven app

Model-driven app design is a component-focused approach to app development. Model-driven app design doesn’t require code and the apps you make can be simple or very complex. Unlike canvas app development where the designer has complete control over app layout, with model-driven apps much of the layout is determined for you and largely designated by the components you add to the app.

Box 3: Power Automate

Power Automate is a service that helps you create automated workflows between your favorite apps and services to synchronize files, get notifications, collect data, and more.

Box 4: Power Virtual Agents bot

When you create bots with Power Virtual Agents, you author and edit topics.

Topics are discrete conversation paths that, when used together within a single bot, allow for users to have a conversation with a bot that feels natural and flows appropriately.

Creating a bot with Power Virtual Agents is easy to do with the no-code authoring canvas, and there are a number of ways you can manage how topics interact, how you want the conversation to flow, and what it should feel like.

Reference:

https://docs.microsoft.com/en-us/power-virtual-agents/authoring-fundamentals

https://docs.microsoft.com/en-us/power-automate

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

You are not able to activate the flow.

You need to troubleshoot the issue.

What are two possible reasons why you cannot activate the flow? Each correct answer presents a

complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You are an app maker. You are creating a canvas app.

You do not have access to Power BI.

You need to add charts to the app.

Which three chart types can you add directly to the canvas app? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You are an app maker. You are creating a canvas app.

You do not have access to Power BI.

You need to add charts to the app.

Which three chart types can you add directly to the canvas app? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

You are an app maker. You are creating a canvas app.

You do not have access to Power BI.

You need to add charts to the app.

Which three chart types can you add directly to the canvas app? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

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

✑ 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?

Reveal Solution Hide Solution

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?

Reveal Solution Hide Solution

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 a display form to Screen_AccountDetail.

✑ 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?

Reveal Solution Hide Solution

HOTSPOT

You are configuring security to enable users to analyze data by using Microsoft Excel templates.

You create a security role named TemplateAdministrator and configure the role as shown below and assign the role to a user named User1.

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.

Reveal Solution Hide Solution

Correct Answer:

HOTSPOT

An administrator plans to create and deploy dashboards for use only by sales associates. The dashboards will display the current sales pipeline, open cases, recent major wins, and key opportunities by postal code.

Sales associates must be able to act on the specific data displayed in dashboards.

You need to create the dashboards.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: User

Type of dashboard: If you want your dashboards to be available across the organization and do not want to manage the access levels at a more detailed level, you might want to create an organization-owned dashboard. However, if you are concerned about the access privileges and security of your dashboard, consider creating a user-owned dashboard where you have more control on who can access it.

Box 2: Single-stream

The single-stream dashboards display real-time data over one stream based on an entity view or queue. The single-stream dashboards are typically helpful to Tier 2 service leads or managers, who monitor fewer, but more complex or escalated cases.

Reference:

https://docs.microsoft.com/en-us/powerapps/developer/model-driven-apps/create-dashboard

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/configure-interactive-experience-dashboards

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?

Reveal Solution Hide Solution

You create a model-driven app for a company. The app will be used to manage events that the company organizes.

The Events entity ownership type is set to User or team. Members of the marketing team are assigned the MarketingTeam security role. All privileges for the role are set to User access.

All employees must be able to view event records. Only members of the marketing team are permitted to create or edit event records. You create a role named OtherEmployees.

You need to configure the MarketingTeam and OtherEmployees security roles.

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

Reveal Solution Hide Solution

You create a canvas app within a Power Platform environment.

You need to identify potential accessibility issues for the canvas app before making the app available to other users.

Which tool should you use?

Reveal Solution Hide Solution

You create a canvas app within a Power Platform environment.

You need to identify potential accessibility issues for the canvas app before making the app available to other users.

Which tool should you use?

Reveal Solution Hide Solution

You create a canvas app within a Power Platform environment.

You need to identify potential accessibility issues for the canvas app before making the app available to other users.

Which tool should you use?

Reveal Solution Hide Solution

You create a canvas app.

A user is not able to determine which field currently has focus. You run App checker to identify errors.

You need to verify that the focused border thickness is set to a value greater than zero.

Which section of the App checker results should you check?

Reveal Solution Hide Solution

DRAG DROP

You have a solution that contains a Power Automate flow, an environment variable, and a model-driven app.

Which three steps 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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Adjust the version number.

Step 2: Select the managed solution.

Managed Solution: A managed solution is a finalized solution that can be distributed and installed. They are created by exporting an unmanaged solution by setting restrictions to prevent any further customizations. The whole point of Managed is locking down the Component states so they cannot be edited. Deleting the Managed Solution will remove all its customisations as well as data contained. Managed Solutions become read only once deployed so they cannot be manipulated.

Step 3: Publish all changes.

Reference: https://powerusers.microsoft.com/t5/Power-Apps-Pro-Dev-ISV/Managed-vs-Unmanaged/td-p/495685

You create a canvas app.

You need to make the app available to other people in your company.

What are two possible ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

DRAG DROP

You create a custom field on the Account entity.

Members of TeamA must have full access to the field. Members of TeamB must have no access to the field.

You need to configure security.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Enable field security for the field

Step 2: Create a field security profile and set all the permissions for the custom attribute to Yes.

Step 3: Add TeamA to the field security profile.

Note: Field-level security is available for the default fields on most out-of-box entities, custom fields, and custom fields on custom entities. Field-level security is managed by the security profiles. To implement field-level security, a system administrator performs the following tasks. Enable field security on one or more fields for a given entity.

Associate one more existing security profiles, or create one or more new security profiles to grant the appropriate access to specific users or teams.

DRAG DROP

You are designing an app for a bank. You plan to use the following entities in the app:

You need to configure the relationships between the entities.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Many-to-many

Box 2: Many-to-one

A client have a single branch office.

A branch office can have many clients.

Box 3: One-to-many

A branch office can have many employees.

An employee only works at one branch office.

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?

Reveal Solution Hide Solution

A company delivers products to multiple communities. The company creates a canvas app connected to a Common Data Service database. The app tracks communities to see where the delivery volume is the highest.

Drivers must enter delivery information on a form that uses an entity named Delivery. Depot staff must enter information on a pick-up form that uses an entity named Pick-up. Each form contains a community field that is based on a shared list across both forms.

You need to create the community field.

Which type of field should you create?

Reveal Solution Hide Solution

A company has an on-premises system that stores product information. The company plans to replace the information with a Power Platform solution that uses the Common Data Service.

The Power Platform solution needs to use data from the product information system.

You need to transform and import the data from the product information system.

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

Reveal Solution Hide Solution

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.

Reveal Solution Hide Solution

Correct Answer:

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

In a Common Data Service database, you create a canvas app and a custom entity. The app also reads data from the Account entity in the Common Data Service database.

Entity access permissions will be controlled by the Common Data Service User security role. You create a Common Data Service solution.

You need to replicate the changes to a new Common Data Service database.

Which two components should you include with the canvas app? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

HOTSPOT

You need to create a model-driven app without using code.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: App designer

As an app maker, you can create and edit public views by using Power Apps.

Box 2: Site Map designer

Site maps define the navigation for your app. Create a site map for your app with ease by using the tile-based site map designer.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-edit-views-app-designer

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/create-site-map-app

HOTSPOT

You are creating a capacity planning dashboard with Power BI desktop.

The dashboard must be able to be used within a model-driven manufacturing planning app as well as be embedded within a Microsoft Teams channel.

The data sources are as follows:

You need to determine the appropriate method for accomplishing each task.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Use a Date Gateway

You can install an on-premises data gateway on the same local computer as SQL Server (in production, it would typically be a different computer).

Box 2: Create an entity relationship in CDS Solution Explorer

You can create relationships with CDS Solution Explorer.

Box 3: Create an aggregate table

Rollup columns help users obtain insights into data by monitoring key business metrics. A rollup column contains an aggregate value computed over the rows related to a specified row. This includes regular tables and activity tables such as emails and appointments.

Reference:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-sql-tutorial

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-edit-entity-relationships

https://docs.microsoft.com/en-us/powerapps/maker/data-platform/define-rollup-fields

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?

Reveal Solution Hide Solution

DRAG DROP

You are an app maker for a college. You create an app for student enrollment. The app captures the education level of the applicants.

The education level at the time of enrollment is an option set is in the student entity.

The entity includes three levels:

✑ High school

✑ College

✑ Bachelor

You must split the College option into two option sets:

✑ College C 1 Year

✑ College C 2 years

The split must not impact existing data.

You need to create the two option sets.

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.

Reveal Solution Hide Solution

Correct Answer:

You are developing a canvas app to monitor time. The app includes a Text Input control named TIC1 and a Timer control named TIM1.

You need to set TIM1 to a default value.

What should you do?

Reveal Solution Hide Solution

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

DRAG DROP

You have an existing Power Apps environment.

You need to create a Common Data Service database for the environment.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Select an existing environment

Add a database in the admin center:

HOTSPOT

You are creating a Power Automate flow.

You have an array that contains items with different color attributes. You plan to filter the array by using the following filter expression within the flow:

@or(equals(item()?[‘color’], ‘red’),contains(item()?[‘color’],’blue’))

The filter returns results only when the expression resolves to true.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: No

Box 2: Yes

The item color must be red, or item color contains blue.

Box 3: Yes

You create and publish a canvas app component library to perform complex calculations.

You discover an error in one of the calculations. You correct the issue and publish the component library. A co worker uses the original version of the component library in a canvas app.

You need to ensure that the co-worker uses the updated version of the component library.

What should you do?

Reveal Solution Hide Solution

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

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

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

Reveal Solution Hide Solution

DRAG DROP

You have a model-driven app that has an entity named Marinas. You have an entity named Boats that list the boats associated with each marina.

You must add a list of boats to the Marinas form. You must also add an option for users to select different views including boat owners and marina members.

You need to embed the list of boats associated with a Marina record in the entity form.

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Step 1: Add a Subgrid component to a form

You add a subgrid component the same way as you add any other component.

Step 2: Select Show related records and then select the related entity and default view for the subgrid

Configure a subgrid component.

Properties available to configure when using a subgrid component on a form using the form designer include:

✑ Show related rows

When selected, the subgrid displays only rows related to the current row that is displayed on the form.

Step 3: Select the Allow users to change view option Configure a subgrid component.

Properties available to configure when using a subgrid component on a form using the form designer include:

✑ Allow users to change view

When selected, app users can change from the Default view to another view of the table selected in the Table property.

Step 4: Save and publish the form

Reference: https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/form-designer-add-configure-subgrid

DRAG DROP

You create the following apps for a company that provides financial guidance services: a model-driven app for financial advisers that work in the company’s offices and a canvas app for remote financial advisers.

You need to create business rules for a custom counselling entity used by all financial advisers.

Who will be affected by the business rules? To answer, drag the appropriate financial adviser types to the correct business rules. Each financial adviser type may be used once, more than once, or not at all. You may need to drag the split bat between panes or scroll to view content. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Office-based and remote financial advisers

Model driven apps can use all actions available on business rules, however not all business rule actions are available for canvas apps at this time.

Box 2: Office-based financial advisers only

If you’re building a Canvas app, you must use table as the scope (not All forms, not a specific form)

Box 3: Office-based financial advisers only

The following actions are not available on Canvas apps:

Show or hide columns

Enable or disable columns

Create business recommendations based on business intelligence.

Reference: https://docs.microsoft.com/en-us/powerapps/maker/data-platform/data-platform-create-business-rule

HOTSPOT

You need to store a list of products and their colors.

You have a Power Apps app that includes the following elements:

✑ a text box for the product name

✑ a drop-down list for the product color

✑ a button to add a product to the list

✑ a status message that shows whether the addition of a product to the list was successful

The button uses the following formula:

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: No

The Collect function adds records to a data source. If the data source doesn’t already exist, a collection is created.

Box 2: Yes

Box 3: No

Use the Set function to set the value of a global variable, which temporarily holds a piece of information, such as the number of times the user has selected a button or the result of a data operation.

Reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-clear-collect-clearcollect

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-set

You are creating a canvas app.

You need to store and retrieve small amounts of data on a local device when the app is offline.

Which set of functions should you use?

Reveal Solution Hide Solution

You are creating a canvas app.

You need to display a limited list of choices to the end user. You must standardize the values and appearance of the list across all forms.

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

Reveal Solution Hide Solution