Microsoft Power Platform App Maker (PL-100) Free Practice Test
Question 1
A company uses Microsoft Power Platform. You create a solution with components You deploy the solution in the production environment Users report issues with a process. You open the last imported solution. You need to troubleshoot the issue. What should you view?
Correct Answer: A
Question 2
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?
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: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 3
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.

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.

Correct Answer:

Explanation:
Graphical user interface, application Description automatically generated

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.
1. In Power BI Desktop, save the report to Power BI Report Server. You need to use the version of Power BI Desktop for Power BI Report Server.
2. In Power BI Report Service, select the ellipsis (...) next to the report.
3. Select Manage > Row-level security.
Graphical user interface, text, application, email Description automatically generated

On the Row-level security page, you add members to a role you created in Power BI Desktop.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls
Question 4
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.

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

Correct Answer:

Explanation:
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
Question 5
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.

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.

Correct Answer:

Explanation:
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
Question 6
You create a Microsoft Power BI report with multiple visualizations displayed together. The report must be available to users in all security roles. You need to display the report in a model-driven app. What should you embed?
Correct Answer: B
Question 7
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?
You need to secure all fields that support field-level security.
Which field can you secure?
Correct Answer: C
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 8
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?
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?
Correct Answer: A
Explanation: Only visible for TestSimulate members. You can sign-up / login (it's free).
Question 9
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.

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.

Correct Answer:

Explanation:
