- (Exam Topic 3)
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.
Correct Answer:
AD
The on-premises data gateway acts as a bridge to provide quick and secure data transfer between onpremises data (data that isn't in the cloud) and several Microsoft cloud services. These cloud services include Power BI, PowerApps, Power Automate, Azure Analysis Services, and Azure Logic Apps. By using a gateway, organizations can keep databases and other data sources on their on-premises networks, yet securely use
that on-premises data in cloud services.
Can use the Power Platform dataflows to load entity in CDS with the option to transform data. Reference:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem https://nishantrana.me/2020/07/07/load-data-from-sql-on-premise-to-cds-common-data-service-using-powerplat
- (Exam Topic 3)
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.
Solution:
Graphical user interface, text, application, email Description automatically generated
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
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 3)
DRAG DROP
You are designing several new Microsoft Power Platform apps for a company. You have the following requirements:
All apps must be able to run from the Power Apps mobile app.
You need to determine which app type to create for each department.
Which app type should you use? To answer, drag the appropriate app types to the correct departments. 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.
Solution:
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 3)
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 is deploying Microsoft Power Platform components to streamline a job candidate screening process.
The human resources (HR) representatives of the company plan to attend school career fairs. The HR representatives must qualify and enter potential job candidates into a Power Apps app. The HR representatives must enter the following information for each candidate:
If a candidate is currently unqualified for a job position but would eventually qualify based on follow-up criteria, the follow-up checkbox must be selected or cleared in the system immediately.
The company plans to create a similar Power Apps app that will contain the same business use case, but for internal employees and promotions.
You need to create a Power Apps app solution to automatically mark the candidate for follow up. Proposed solution: Create a business rule on the appropriate data entity with a scope of entity. Does the solution meet the goal?
Correct Answer:
B
Instead use Common Data Service workflow with a PowerQuery on the data entity.
Note: Process (Workflow) table/entity reference is a set of logical rules that define the steps necessary to automate a specific business process, task, or set of actions to be performed.
Common Data Service workflow support: Filter triggers based on which attributes change - You can control which field changes trigger your automated flows. For example, trigger your flow only when the status field changes while ignoring all other fields that may change.
Reference:
https://docs.microsoft.com/en-us/business-applications-release-notes/april19/microsoft-flow/automated-parity-cl
- (Exam Topic 3)
HOTSPOT
A company uses Power Apps. The company has a model-driven app that accesses a Microsoft Dataverse table. The app is shared with ail users who all have the Basic User security role.
You must prevent the users from running and sharing the app.
What should you do? To answer, select the appropriate options in the answer area NOTE: Each correct selection is worth one point.
Solution:
Does this meet the goal?
Correct Answer:
A
