- (Exam Topic 3)
You store data about products in two Microsoft Excel worksheets. The data contains duplicate rows.
You need to consolidate data from the two worksheets into a Microsoft Dataverse custom table.
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.
Solution:
Graphical user interface, text, application, email Description automatically generated
Step 1: Upload the worksheets to OneDrive
A data source needs to be specified. The data needs to be available. Step 2: Create a dataflow
Step 3: Create queries for the worksheets
You can shape your data selection into a form that works best for your table using a Power Query editing experience, similar to the Power Query Editor in Power BI Desktop.
Step 4: Add conditional columns to perform checks on the data Step 5: Append the output of the queries
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-and-use-dataflows https://docs.microsoft.com/en-us/power-query/dataflows/add-data-power-query
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 2)
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.
Solution:
Graphical user interface, text, application, email Description automatically generated
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
Does this meet the goal?
Correct Answer:
A
- (Exam Topic 2)
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?
Correct Answer:
D
Scenario: 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.
- (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.
You are creating a canvas app.
You need to automatically detect bicycles in pictures taken with the camera. Proposed solution:
Create a Prediction custom model in AI Builder. Train the model with pictures of bicycles and then publish the trained model. Add the Object Detector control to your canvas app.
Does the solution meet the goal?
Correct Answer:
B
Instead create an Object Detection custom model
Note: AI Builder prediction models analyze patterns in historical data that you provide. Prediction models learn to associate those patterns with outcomes. Then, we use the power of AI to detect learned patterns in new data, and use them to predict future outcomes.
Reference:
https://docs.microsoft.com/en-us/ai-builder/prediction-overview
- (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 custom action that has defined dataflows.
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
