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

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

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

HOTSPOT

You need to create the solution for subscriber orders.

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

Reveal Solution Hide Solution

Correct Answer:

DRAG DROP

You 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

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

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:

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

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