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

Topic 1, Wide World Importers

This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.

To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.

At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

To start the case study

To display the first question in this case study, click the Next button. Use the buttons in the left pane to explore the content of the case study before you answer the questions. Clicking these buttons displays information such as business requirements, existing environment, and problem statements. When you are ready to answer a question, click the Question button to return to the question.

Background

Current environment

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

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

Requirements

Application

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

The mobile app must meet the following requirements:

– Minimize the use of code.

– Use formulas and expressions when necessary.

– Support a variety of visual layouts.

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

– Use Azure SQL Database to store other data.

Status reports

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

– Representatives must enter the following information for each process:

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

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

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

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

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

Technical

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

Deployment

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

– The completed app and all supporting components must be provided to Tailwind Traders.

– Tailwind Traders must not be able to make changes to any of the components.

– You must use the following version control numbering scheme:

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

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

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

Revision: The incremented revision for a package

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

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

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

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

Issues

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

User1 often works in a warehouse that does not have internet connectivity. User1 needs to edit an existing status report and submit a new status report.

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

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

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?

BF70D5D

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:

Topic 4, 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 Team A 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

DRAG DROP

A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.

You need to insert the custom control into the Power Apps app.

Where should you complete the actions? To answer, drag the appropriate locations to the correct

actions. Each location 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: Components

DRAG DROP

A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.

You need to insert the custom control into the Power Apps app.

Where should you complete the actions? To answer, drag the appropriate locations to the correct

actions. Each location 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: Components

DRAG DROP

A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.

You need to insert the custom control into the Power Apps app.

Where should you complete the actions? To answer, drag the appropriate locations to the correct

actions. Each location 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: Components

DRAG DROP

A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.

You need to insert the custom control into the Power Apps app.

Where should you complete the actions? To answer, drag the appropriate locations to the correct

actions. Each location 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: Components

DRAG DROP

A company must use a Power Apps app custom control that is exported from a different canvas Power Apps app.

You need to insert the custom control into the Power Apps app.

Where should you complete the actions? To answer, drag the appropriate locations to the correct

actions. Each location 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: Components

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

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

A company has locations in multiple countries and regions across four continents.

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

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

Proposed solution:

Create a custom column that converts the order total to USD by using the relationship between order local currency and the USD exchange rate table in Power BI Desktop and display this column in a Power BI chart by country/region.

Does the solution meet the goal?

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.

A company has locations in multiple countries and regions across four continents.

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

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

Proposed solution:

Create a custom rollup field of type currency on the country/region table that aggregates all the total amounts for the orders from that country/region and display this rollup field in a Power BI chart.

Does the solution meet the goal?

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.

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?

Reveal Solution Hide Solution

DRAG DROP

You are developing a Power BI report for a company.

The Power BI report must display company performance metrics in Power BI service. The report must include three fields in a visualization. The data for the report exists in a dataset.

The company will display the report on a large television screen during team meetings.

You need to create the report.

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

Reveal Solution Hide Solution

Correct Answer:

Explanation:

Box 1: Select a dataset

Sign in to your Power BI online account, or sign up, if you don’t have an account yet.

Open the Power BI service.

Get some data and open it in report view.

Box 2: Create a report

Use that data to create visualizations and save it as a report.

Box 3: Add a visualization to the report

Box 4: Add the report to a new dashboard

Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. In the Power BI service, visuals can be pinned from reports to dashboards.

Reference:

https://docs.microsoft.com/en-us/power-bi/fundamentals/service-get-started

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-report-visualizations

DRAG DROP

The company is adding a multi-stream interactive dashboard to a model-driven app.

The company requires configuration of the dashboard to filter the table data based on modified accounts over the last month.

You need to configure the filters for the model-driven app dashboard.

Which configuration should you use? To answer, drag the appropriate locations to the correct requirements. Each configuration 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: Filter table

Filter Table: The visual filters and global filter attributes are based on this table.

Box 2: Filter By

Filter By: The column that the time frame filter applies to.

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

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

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

You have a Power Platform solution that uses Common Data Service. You need to secure all fields that support field-level security.

Which field can you secure?

Reveal Solution Hide Solution

You create a dashboard in Power BI. You share the dashboard with the sales team.

Sales team members report that they can see information for the entire company.

You need to ensure that the team is able to see only data for their team.

Where must you configure this restriction?

Reveal Solution Hide Solution

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

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

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

What should you do?

Reveal Solution Hide Solution

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

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

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

What should you do?

Reveal Solution Hide Solution

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

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

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

What should you do?

Reveal Solution Hide Solution

You are creating an app for a company.

You need to evaluate the default solution.

Which two behaviors should you expect from the default solution? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.

Reveal Solution Hide Solution

DRAG DROP

A company has the following divisions: wholesale and retail.

The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.

You need to ensure that each user sees data only for the team to which the user is assigned.

How should you secure the report? To answer, drag the appropriate options to the correct action. Each option 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: Power BI Desktop

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.

To define security roles, follow these steps.

✑ Import data into your Power BI Desktop report, or configure a DirectQuery connection.

✑ From the Modeling tab, select Manage Roles.

✑ From the Manage roles window, select Create.

✑ Etc.

Box 2: Power BI Service

After you save your report in Power BI Report Server, you manage security and add or remove members on the server.

DRAG DROP

A company has the following divisions: wholesale and retail.

The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.

You need to ensure that each user sees data only for the team to which the user is assigned.

How should you secure the report? To answer, drag the appropriate options to the correct action. Each option 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: Power BI Desktop

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.

To define security roles, follow these steps.

✑ Import data into your Power BI Desktop report, or configure a DirectQuery connection.

✑ From the Modeling tab, select Manage Roles.

✑ From the Manage roles window, select Create.

✑ Etc.

Box 2: Power BI Service

After you save your report in Power BI Report Server, you manage security and add or remove members on the server.

DRAG DROP

A company has the following divisions: wholesale and retail.

The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.

You need to ensure that each user sees data only for the team to which the user is assigned.

How should you secure the report? To answer, drag the appropriate options to the correct action. Each option 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: Power BI Desktop

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.

To define security roles, follow these steps.

✑ Import data into your Power BI Desktop report, or configure a DirectQuery connection.

✑ From the Modeling tab, select Manage Roles.

✑ From the Manage roles window, select Create.

✑ Etc.

Box 2: Power BI Service

After you save your report in Power BI Report Server, you manage security and add or remove members on the server.

DRAG DROP

A company has the following divisions: wholesale and retail.

The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.

You need to ensure that each user sees data only for the team to which the user is assigned.

How should you secure the report? To answer, drag the appropriate options to the correct action. Each option 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: Power BI Desktop

You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.

To define security roles, follow these steps.

✑ Import data into your Power BI Desktop report, or configure a DirectQuery connection.

✑ From the Modeling tab, select Manage Roles.

✑ From the Manage roles window, select Create.

✑ Etc.

Box 2: Power BI Service

After you save your report in Power BI Report Server, you manage security and add or remove members on the server.

HOTSPOT

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.

Reveal Solution Hide Solution

Correct Answer:

Explanation:

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

HOTSPOT

Rangers in national parks report wildlife they encounter during patrols. The rangers record observations in a notebook when they are on patrol. The rangers manually enter observation data when they are in the office. You are designing an app that allows rangers to record their observations while they are on patrol.

The wildlife is modeled as a custom table named Wildlife. The model has relationships to the annotation entity and to a custom entity named Wildlife Details. In the Wildlife Details entity, rangers capture more information as they observe an animal’s habitat. When observing wildlife, rangers must indicate whether an animal requires medical attention. The app must synchronize and save data to Common Data Service when connectivity is available.

You need to design the app.

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: Enable the Wildlife entity and the annotation entity for mobile offline

Note: As part of the 2020 Wave 2 release, we made generally available offline capabilities for model driven apps for users of Power Apps. Makers and administrators can now configure apps to be available offline on a user’s device, and users can continue to complete their tasks against the local cache on their phone even with intermittent or no network connectivity. When the network is re-established, the users’ changes are seamlessly synchronized back to the cloud.

Box 2: Enable attachments on the Wildlife Details entity and enable Wildlife Details entity for mobile offline.

Box 3: Create a business process.

Business process flows. Ensure that people enter data consistently and follow the same steps every time they work in an app by creating a business process flow.

Note: Power Automate includes several types of processes, each designed for a different purpose:

✑ Automated flows. Create a flow that performs one or more tasks automatically after it’s triggered by an event.

✑ Button flows.

✑ Scheduled flows. Create a flow that performs one or more tasks on a schedule such as once a day, on a specific date, or after a certain time.

✑ Business process flows. Ensure that people enter data consistently and follow the same steps every time they work in an app by creating a business process flow.

✑ Workflows and actions. Dynamics 365 customizers may be familiar with the classic Microsoft Dataverse processes, which are workflows and actions.

Reference:

https://powerapps.microsoft.com/en-us/blog/mobile-offline-for-power-apps/

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/guide-staff-through-common-tasks-processes