Topic 3 - Question Set 3

Question 1

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?

A. In the OnChange property of TIC1, set the value of the Text property for TIC1 to a context variable that stores the duration value. Assign the value of the variable to the OnTimerStart property for TIM1.

B. Assign the Text property of TIC1 to the Duration property of TIM1.

C. Assign the Text property of TIC1 to the OnSelect property of a TIM1.

D. Add the clock icon to the app and use the OnSelect property to set the Duration property for TIM1.

Answer 1

D. Add the clock icon to the app and use the OnSelect property to set the Duration property for TIM1.

Question 2

HOTSPOT -

A company is building a Power Apps app to track key project tasks.

Users assign three tasks a risk status on a scale of 0 to 100 by using slider input controls named RiskStatus on the app. The highest risks use the risk status value of 100.

If the combined value of all the tasks is 150 or above, a header bar on the screen must display the text HIGH RISK.

You need to configure a solution to change the text on the header bar.

How should you configure the app? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Hot Area:

Answer 2

Box 1: On each RiskStatus slider input

You can change the value based on input.

Box 2: Updateif(..)

Use the UpdateIf function to modify one or more values in one or more records that match one or more conditions. The condition can be any formula that results in a true or false and can reference columns of the data source by name. The function evaluates the condition for each record and modifies any record for which the result is true.

Question 3

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?
A. Create a business process flow.
B. Create a data policy template.
C. Create a UI flow.
D. Use an existing data connector.

Answer 3

D. Use an existing data connector.

Question 4

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.
Select and Place:

Actions:
Add a gallery control
Add an input property
Create a component
Add a screen
Create a form
Add an output property

Answer 4

Create a component
Add an input property
Add a gallery control

Question 5

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?
A. When an item is created
B. When an item is created or modified
C. When a file is created (properties only)
D. For a selected item

Answer 5

Correct Answer: A
Trigger - When an item is created
Triggers when an item is created.
MS Flow will trigger when an item is created in the list. It will return all list item properties which can be used in the Flow.

Question 6

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.
A. Power Platform Admin center
B. Power Apps solution explorer
C. Power Apps Maker portal
D. SQL Server Management Studio
E. Visual Studio Code

Answer 6

B. Power Apps solution explorer
C. Power Apps Maker portal

There are two designers you can use to create and edit 1:N (one-to-many) or N:1 (many-to-one) relationships:
✑ You can create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships in Power Apps portal
✑ You can create and edit create and edit 1:N (one-to-many) or N:1 (many-to-one) entity relationships using solution explorer

Question 7

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?
A. Flow button for mobile
B. Power Apps
C. Office 365 Outlook
D. Common Data Service

Answer 7

A. Flow button for mobile

Question 8

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:

Collect(
Toolbox,
{Tool: “Hammer”, Quantity: 1.},
{Tool: “Screwdriver”, Quantity 2})

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.
Hot Area:

The formula will update multiple records in a data source named Toolbox if the record exists

A local collection is created to store data if a data source named Toolbox does not already exist.

If a collection named Toolbox exists the formula will clear any existing records before making any changes.

Answer 8

The formula will update multiple records in a data source named Toolbox if the record exists. NO

A local collection is created to store data if a data source named Toolbox does not already exist. YES

If a collection named Toolbox exists the formula will clear any existing records before making any changes. NO

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 ג€” 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.

Question 9

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?
A. The default solution does not contain all components and customizations from all solutions in the environment.
B. The prefix used when creating components as part of the default solution can be set to a specific value.
C. The default solution cannot be exported and distributed to another environment.

Answer 9

C. The default solution cannot be exported and distributed to another environment.

This is a special solution that contains all components in the system. The default solution is useful for discovering all the components and configurations in your system.
Why you shouldn’t use the default solutions to manage customizations
There are a few reasons why you shouldn’t create apps and make customizations in either of the default solutions:
✑ The default solution can’t be exported; therefore, you can’t distribute the default solution to another environment.
The default solution contains all components and customizations from all solutions in the environment.
By default, all enabled users can create apps and customize components in the Common Data Services Default Solution.
It’s difficult to locate or identify the customizations you’ve made in the environment by using either default solution.
When you use either default solution to create components, you’ll also use the default publisher assigned to the solution. This often results in the wrong publisher prefix being applied to some components.

Question 10

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

FlowA: Send email to the HR manager when a new document is uploaded to Microsoft SharePoint

FlowB: Send email to the HR manager after a user selects a document in Microsoft OnDrive for Business and runs the flow

FlowC: Send email to the HR manager at 8 AM daily if new documents are uploaded in Microsoft OneDrive for Business since the previous day

FlowD: Send email to the HR manager when a new employee record is added.

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.
A. FlowA
B. FlowB
C. FlowC
D. FlowD

Answer 10

FlowA: Send email to the HR manager when a new document is uploaded to Microsoft SharePoint
FlowD: Send email to the HR manager when a new employee record is added.

Question 11

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.
A. Set the scope of the business rule to Entity.
B. Add a Recommendation action and configure it to enter the order type.
C. Set the scope of the business rule to All Forms.
D. Use the following condition expression: (OrderType Does not begin with [test]) AND (Modified By Does not contain data)

Answer 11

A. Set the scope of the business rule to Entity.
D. Use the following condition expression: (OrderType Does not begin with [test]) AND (Modified By Does not contain data)

Question 12

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.
Select and Place:

Create an entity in the new solution
Enter the entity Display Name for using the existing prefix
Add a new solution
Enter the entity Display Name and modify the prefix xyz
Add a new publisher with the prefix xyz

Answer 12

Add a new publisher with the prefix xyz

Add a new solution

Create an entity in the new solution

Enter the entity Display Name for using the existing prefix

Question 13

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.
Select and Place:

Select Add relationship.
Select the BusinessAccounts entity as the related entity.
Open the relationship tab of the BusinessContracts entity.
Choose the Relationship Name and Relationship Entity Prefix

Answer 13

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.

Question 14

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.

Groups:
Reception area and staff
Medical Staff
Cleaning Staff

Comments:
Reception: Users will access the app only from desktop devices in the office

Medical: Users will access the app from tablet devices

Cleaning: Users will access the app only from mobile phone devices

Requirements:
Reception: Users must be able to access contacts and display activities as a doughnut chart.

Medical: Users must be able to access activities and business process flows

Cleaning: Users must be able to interact with a checklist to mark cleaning tasks as completed.

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.

App Types:
Canvas App
Model-driven App
Embedded canvas app

Answer 14

Reception area and staff - Canvas App
Medical Staff - Embedded canvas app
Cleaning Staff - Model-driven App

Question 15

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.
Select and Place:

Tools:
Power Virtual Agents bot
Power Automate
Canvas App
Model-Driven App

Requirement:
Create an app with a customized user interface that allows users to quickly create support tickets

Create an app that uses a guided business process to navigate through all records associated with a support ticket.

Send an email to a customer support manager every time a support ticket is created

Create an automated chat tool that guides a customer through the support ticket creation process

Answer 15

Create an app with a customized user interface that allows users to quickly create support tickets - Canvas App

Create an app that uses a guided business process to navigate through all records associated with a support ticket. - Model-Driven App

Send an email to a customer support manager every time a support ticket is created - Power Automate

Create an automated chat tool that guides a customer through the support ticket creation process - Power Virtual Agents bot

Question 16

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.
A. You are not assigned the Power Platform Admin role.
B. You placed all connectors into the Business group within the DLP policy.
C. You placed all connectors into the Non-Business group within the DLP policy.
D. You are not assigned the Environment Admin role.

Answer 16

B. You placed all connectors into the Business group within the DLP policy.

D. You are not assigned the Environment Admin role.

Question 17

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.
A. pie
B. area
C. funnel
D. column
E. line

Answer 17

A. pie
B. area
E. line

Question 18

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?
A. Yes
B. No

Answer 18

A. Yes

Question 19

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?
A. Yes
B. No

Answer 19

B. NO

Question 20

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?
A. Yes
B. No

Answer 20

A. Yes

Question 21

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 ג€” 1 Year
✑ College ג€” 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.
Select and Place:

Open the maker app and navigate to the student table
Publish Student entity
Save the student table
Open settings in the Power Platform admin center
Create new options for College - 1 year and College - 2 Years

Answer 21

Open the maker app and navigate to the student table

Create new options for College - 1 year and College - 2 Years

Publish Student entity

Question 22

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?
A. In the OnChange property of TIC1, set the value of the Text property for TIC1 to a context variable that stores the duration value. Assign the value of the variable to the OnTimerStart property for TIM1.
B. Assign the Text property of TIC1 to the Duration property of TIM1.
C. Assign the Text property of TIC1 to the OnSelect property of a TIM1.
D. Write code in the OnChange property of TIC1 that assigns the value of the Duration property of the Timer control to Text property of the TIC1. In the OnChange property of TIC1, assign the value to the Duration property for TIM1.

Answer 22

D. Write code in the OnChange property of TIC1 that assigns the value of the Duration property of the Timer control to Text property of the TIC1. In the OnChange property of TIC1, assign the value to the Duration property for TIM1.

Question 23

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.
Select and Place:

Select Create my database
Configure currency and language settings
Configure database collation settings
Set the environment type to Production
Select an existing environment

Answer 23

Step 1: Select an existing environment
Step 2: Select Create my database
Step 3: Configure currency and language settings

Question 24

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.
Hot Area:

The filter expression yields a result if the array contains the color orange

The filter expression yields a result if the array contains the color red

The filter expression yields a result if the array contains the color sky blue

Answer 24

The filter expression yields a result if the array contains the color orange - NO

The filter expression yields a result if the array contains the color red - YES

The filter expression yields a result if the array contains the color sky blue - YES

Question 25

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?
A. Export the updated component library and instruct the co-worker to import the updated version into the canvas app
B. Inform the co-worker to edit the canvas app and manually add the updated version of the component library
C. Instruct the co-worker to edit the canvas app and update the component library

Answer 25

C. Instruct the co-worker to edit the canvas app and update the component library

Question 26

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.
A. Collect
B. Patch
C. Navigate
D. Set
E. UpdateContext

Answer 26

Patch: Use the Patch function to modify records in complex situations. Such as, when you do updates that require no user interaction or use forms that span multiple screens.
Navigate & UpdateContext: Context variables are scoped for Screen. They are great for passing values to a screen, much like parameters to a procedure in other languages. Can be referenced from only one screen.
Functions available for context variables:
✑ UpdateContext
✑ Navigate

Question 27

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.
Select and Place:

Add a Subgrid component to a form
Select Show related records and then select the related entity and default view for the subgrid
Save and publish the form
Select the Allow users to change view option

Answer 27

Step 1: Add a Subgrid component to a form
Step 2: Select Show related records and then select the related entity and default view for the subgrid
Step 3: Select the Allow users to change view option
Step 4: Save and publish the form

Question 28

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 counseling 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.
Select and Place:

Financial Adviser Types:
Office-based financial advisors
Remote financial advisors only
Office-based and remote financial advisors

Business Rules:
Set a field value with the scope set to Entity
Clear a field value with the scope set to All Forms
Set visibility of a field with the scope set to Entity

Answer 28

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

Question 29

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:

Collect(
colProducList,{
Product: txtProductName.Text, Color: drpColors.Selected.Value});
Set(
vStatusMessage, “Added ‘” & txtProductName.Text & “’”);
timStatusMessage.Start;

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

You must explicitly declare the collection before you can add product names and colors to the collection

The formula stores the product name and the color in a collection

vStatusMessage is a context variable that is used to store the status message

Answer 29

You must explicitly declare the collection before you can add product names and colors to the collection. - NO

The formula stores the product name and the color in a collection - YES

vStatusMessage is a context variable that is used to store the status message - NO.

Question 30

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?
A. SaveData, LoadData
B. Set, Patch
C. Patch, Collect
D. Set, Collect

Answer 30

A. SaveData, LoadData

Question 31

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.
A. Add a drop-down field in the app
B. Create a Global Option Set
C. Add a new business rule
D. Add a component to the component library

Answer 31

A. Add a drop-down field in the app
B. Create a Global Option Set

Question 32

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.
Select and Place:

Objects:
Display
Screens
Components

Action:
Import a custom control from a file

Add an alignment to the custom control to display it in the middle of the Power Apps app screen

Answer 32

Import a custom control from a file - Components

Add an alignment to the custom control to display it in the middle of the Power Apps app screen - Display

Question 33

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?
A. Yes
B. No

Answer 33

Correct Answer: B
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.

Question 34

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?
A. Yes
B. No

Answer 34

Correct Answer: B
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.

Question 35

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?
A. Yes
B. No

Answer 35

Correct Answer: A

Question 36

HOTSPOT -
A company is building a Power Apps app to track key project tasks.
Users assign tasks a risk status on a scale of 0 to 100 by using a slider input control named RiskStatus on the app. The highest risks use the risk status value of
100.
For each task, the user selects a button named RiskLevel to send the name of the task and RiskStatus number to key project stakeholders. The color of the button must change to the color listed in the following table based on the value of the RiskStatus control. The default color for the button is green.

0-50 No/Low risk Green
51-100 High risk Red

Where do you enter the formula to change the button color:

1. On the RiskStatus Slider
2. On the RiskLevel button
3. In the variables on the Power Apps app
4. On the OnStart property of the Power Apps app
5. If(RiskStatus.Value>75)(return Red;)
6. If(RiskStatus.Value>75, Red:Green)
7. If(RiskStatus.Value>75?Red:Green
8. RiskLevel.Fill=RiskStatus.value>75?Red:Green

Answer 36

Where do you enter the formula to change the button color: On the RiskLevel button

Which formula would you use?
RiskLevel.Fill=RiskStatus.value>75?Red:Green

Question 37

HOTSPOT -
A company creates a Power Apps app that allows service representatives to record information about on-site client visits. Service representatives perform a one- hour site visit with each client each quarter.
Service representatives use the app to perform the following activities:
✑ View their scheduled visits for the day.
✑ Record notes from service visits.
✑ Schedule service technicians for issues uncovered during site visits.
✑ Scan and upload service quote forms to a folder named Service Quote folder on Microsoft OneDrive once the customer has signed a service quote.
Service quotes that are over $10,000 are automatically sent to the service manager for review and approval.
Visits that are not closed at the end of the day are automatically moved to the following day unless it is the last day of the quarter. All client visits not performed for the quarter are escalated to the service manager for follow-up.
You need to create flows to meet the requirements.
Which type of flows should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Hot Area:

Requirement:
Move client visits not completed for the day

Type of Flow:
Scheduled flow
Automated flow
Adaptive card flow
Team flow

Requirement:
Approve service Quote

Type of flow:
Automated flow
Button flow
Scheduled flow
Team flow

Answer 37

Move client visits not completed for the day: Adaptive card flow

Approve service Quote: Button flow

Question 38

You complete work on a new canvas app in a development environment and add the app to a solution. You export the solution from the development environment and import the solution into a production environment.
After several days you notice that the background color for the canvas app in the production environment has changed from white to gray.
You need to determine why the background color changed.
What are two possible causes for the background color change? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. You recently changed the Office 365 theme.
B. You exported a managed copy of the solution and imported the solution as an unmanaged solution. You modified the canvas app in the unmanaged solution.
C. You exported and imported an unmanaged copy of the solution and a co-worker modified the canvas app.
D. You chose a different theme from the Theme menu inside the canvas app.

Answer 38

A. You recently changed the Office 365 theme.
C. You exported and imported an unmanaged copy of the solution and a co-worker modified the canvas app.

Question 39

DRAG DROP -
You create a canvas app for a store.
The logo must appear as the background image for the app. A loading spinner must display on the screen as the app loads.
You need to add the features to the app.
What should you modify? To answer, drag the appropriate form areas to the correct requests. Each form area 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.
Select and Place:

Screen Areas:
Form
Gallery
Screen

Feature Request
Add Logo
Add loading spinner

Answer 39

Add Logo: Screen
Add loading spinner: Screen

Question 40

You have a Power Automate flow that processes files in a Microsoft SharePoint document library. The flow only needs to be run as required. You add steps to the flow to process the files.
Before leaving the office for the day, the manager must initiate the flow. The flow must not start processing files before 11:00 PM.
You need to configure the flow.
Which two actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Add a recurrence trigger and configure to run daily at 11:00 PM.
B. Add a Condition action. If the time greater than 11:00 PM use a Terminate action prevent further processing.
C. Manually trigger the flow.
D. Add a Delay Until action and enter the timestamp for 11:00 PM.

Answer 40

C. Manually trigger the flow.
D. Add a Delay Until action and enter the timestamp for 11:00 PM.

Question 41

DRAG DROP -
You are creating a model-driven app for onboarding new employees.
You need to implement business logic for the app.
Which tool 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.
Select and Place:

Tools:
Business rule
Power Automate
Business process flow

Requirement:
Guide a user through the set of steps needed for onboarding a new employee

Make a date of birth mandatory when creating a new employee record

Implement an approval flow for expense reports submitted by employees

Answer 41

Requirement:
Guide a user through the set of steps needed for onboarding a new employee: Business process flow

Make a date of birth mandatory when creating a new employee record: Business rule

Implement an approval flow for expense reports submitted by employees: Power Automate

Question 42

HOTSPOT -
You create a canvas app for a service company.
Using the Tree view, you navigate to the ViewServices screen. The screen contains a form named DetailForm1 that only contains Label controls. You add the
People icon to the header of the ViewServices screen

When you select the icon a new Activity form opens. You must set the value of the Name field on the new Activity form to the value of the name field from
DetailForm1.
Use the drop-down menus to select the answer choice that answers each question based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.
Hot Area:

Which formula must you enter in the Name field on the Activity form to default the Name from DetailForm1?

Name_DataCard1.Default
Name_DataCardKey1.Default
Name_DataCardValue1.Default

Which action should you perform on the People icon?

In the On Select property, set the Activity form to Edit Mode
In the On Select property, set the Activity form to View mode
Move the icon to the Activity form and set the On Select property to the Activity Screen.
Move the icon to the DetailForm1 and set the on Select property to open the Activity Screen

Answer 42

Which formula must you enter in the Name field on the Activity form to default the Name from DetailForm1: Name_DataCardValue1.Default

Which action should you perform on the People icon: Move the icon to the Activity form and set the On Select property to the Activity screen.

Question 43

You are creating a canvas app for a company that delivers packages. The app will display one screen for each delivery attempt.
Drivers must make three attempts to deliver a package before returning the package back to a warehouse. Drivers must enter details about delivery on a second screen in the app.
You need to display a list of delivery attempts on the delivery screen.
Which two components can you add to the app to display details about the delivery attempts? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. Data table
B. Vertical gallery
C. Display form
D. Drop-down

Answer 43

A. Data table
C. Display form

Question 44

SEE PDF TOPIC 3

HOTSPOT -
A user named Bill Jones creates a canvas app and shares it with other users in his company as shown in SharePowerUsers and ShareJimSmith exhibits. (Click the SharePowerUsers tab and the ShareJimSmith tab.)

There are multiple versions of the app. Users must only be able to run the most recently published version of the app as shown in the table below:

You need to ensure that sharing is configured correctly.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
Hot Area:

Answer 44

Box 1: No -
They can only use the app.

Box 2: Yes -

Box 3: No -

Box 4: Yes -

Question 45

You create an automated flow by using Power Automate. The flow appears under My Flows and is connected to the development environment. The development environment has a solution to move components into a production environment.
You need to ensure that you can transfer the flow to another environment.
What should you do?
A. Add the flow to the default solution of the development environment and export as a managed solution.
B. Change the environment for the flow.
C. Add the flow to the existing solution.
D. Add the flow to the default solution of the production environment.

Answer 45

A. Add the flow to the default solution of the development environment and export as a managed solution.

Question 46

DRAG DROP -
You have a canvas app that uses multiple inputs for calculations.
You must use Test Studio to create automated tests and confirm that the app works as expected.
You need to organize your test scenarios into a hierarchy.
In which order should you create the objects? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:

Test assertions
Test steps
Test suites
Test cases

Answer 46

Step 1: Test suites -
By default, a test suite and test case are created for you in Test Studio. Test suites are used to organize your test cases. An app can contain one or more test suites.

Step 2: Test cases -
Depending on how you want to organize or group your tests, you can create multiple test cases in a test suite. Each case can test a specific feature or a subset of functionalities in your app.

Step 3: Test steps -

Step 4: Test assertions -

Question 47

A company is implementing the Microsoft Power Platform to assist with consolidation of onsite inspections and audits of retail stores. Currently, the data used by the retail store inspections is located across multiple systems.
The canvas app must use one database to view and record all data used in the inspection process.
You need to design the solution.
Which three capabilities should you implement? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
A. Use an embedded access management framework for user security.
B. Execute real-time data operations against external data sources through virtual entities.
C. Use Azure Active Directory for access management.
D. Store data used by a Power Apps app on both iOS and Android mobile platforms.
E. Use Azure Data Lake storage to host the transactional data.

Answer 47

B. Execute real-time data operations against external data sources through virtual entities.
C. Use Azure Active Directory for access management.
E. Use Azure Data Lake storage to host the transactional data.