Test Online Free Microsoft PL-100 Exam Questions and Answers
Practice a live sample before buying full access. This page keeps the free PL-100 question set organized by page so visitors and search engines can reach the canonical -questions.html URL directly.
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?
Answer: Explanation:
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-classic-common-data-service-workflows
Question 122Written Answer
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.
Answer:
Explanation:
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 Business Accounts entity as the related entity.
Question 123Selectable Answer
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.
Answer: Explanation:
The Data table control shows a dataset.
In a canvas app, add and configure a Display form control to show all fields in a record.
Reference:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-data-table
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/working-with-form-layout
Question 124Written Answer
HOTSPOT
A production line app maker at a manufacturing company creates a canvas app that looks for available inventory in a SQL database. The production line workers use the inventory app across all work centers.
The production line workers report the following app issues from the shop floor:
✑ The app reports a delegation warning.
✑ Voice command functionality is unreliable.
You have minimal information about the issues. You are not allowed to enter the production facility.
You need to troubleshoot the issues.
How should you troubleshoot the issues? To answer, select the appropriate options in the answer area.
Answer:
Explanation:
Graphical user interface
Description automatically generated
Box 1: Check the number of items in the collection
If the data in your data source exceeds 500 records and a function can't be delegated, Power Apps might not be able to retrieve all of the data, and your app may have wrong results.
Note: Delegation is where the expressiveness of Power Apps formulas meets the need to minimize data moving over the network. In short, Power Apps will delegate the processing of data to the data source, rather than moving the data to the app for processing locally.
Box 2: Use the Advanced Tools/Monitor feature
Monitor is available by default for all canvas apps. Using Monitor, you can trace events as they occur in a canvas app during the authoring experience in Power Apps Studio, or you can use Monitor to debug the published version of a canvas app.
Example: Consider the scenario where an app has been deployed, and the initial version of the app experiences performance degradation. The app also intermittently generates errors with no clear pattern. Loading data in the app succeeds most of the time, but fails sometimes.
When you check Monitor, you see data operations as expected. However, you also see several responses that have HTTP status code 429, indicating that there have been too many requests in a specific timeframe.
Question 125Written Answer
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.
Answer:
Explanation:
A picture containing graphical user interface
Description automatically generated
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.
Question 126Selectable Answer
A clothing retailer is creating a Power Virtual Agents chatbot in Microsoft Teams. The chatbot will use Microsoft Dataverse for Teams to provide sales metrics by store.
A user wants to be able to ask the chatbot to see all the sales for pants.
You need to configure the chatbot to provide sales data for pants even when a user enters the terms jeans, slacks, or trousers.
Which chatbot component should you use?
DRAG DROP
A company has 500 products. Each product is referenced by a product ID. Each product belongs to one of eight product categories.
You are creating an app to manage requests for new products.
The product categories will never change. Categories are defined in the column itself, not in a separate table. The data must be structured in a way that does not allow for misspellings.
Only two new tables should be created in Microsoft Dataverse:
✑ Products: Holds the products that can be requested.
✑ Requests: Holds the requests for the product ID and quantity.
The products are filtered by product category.
You need to identify the data types to use when building the table columns in Dataverse.
Which data type should you use? To answer, drag the appropriate data types to the correct requirements. Each data 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.
Answer:
Explanation:
Box 1: Text
Text columns can contain text characters. This column type has several format options that will change the presentation of the text.
Box 2: Lookup
When you create a new lookup column you are creating a new Many-to-One (N:1) table relationship between the table you’re working with and the Target Row Type defined for the lookup.
Box 3: Choice
You can customize forms (main, quick create, and quick view) and email templates by adding multi-select columns that are called Choices. When you add a choices column, you can specify multiple values that will be available for users to select. When users fill out the form, they can select one, multiple, or all the values displayed in a drop-down list.
Question 128Selectable Answer
You are creating an app for a company.
You need to evaluate the default solution.
Which two behaviors should you expect from the default solution? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Answer: Explanation:
The default solution in Power Apps is the Common Data Service Default Solution, which is associated with the Microsoft Dataverse Default Publisher. The default publisher prefix will be randomly assigned for this publisher, for example it might be cr8a3. This means that the name of every new item of metadata created in the default solution will have this prepended to the names used to uniquely identify the items. If you create a new entity named Animal, the unique name used by Dataverse will be cr8a3_animal. The same is true for any new fields (attributes), relationships, or option-set options. If you'll be customizing this special solution, consider changing the publisher prefix.
Reference:
https://docs.microsoft.com/en-us/power-platform/alm/use-solutions-for-your-customizations
https://docs.microsoft.com/en-us/powerapps/maker/data-platform/create-solution
Question 129Selectable Answer
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 developing a model-driven app that uses a Common Data Service database. App users will have a variety of different security roles.
Development and testing must be performed using production data. Multiple testers must be used at each testing stage.
You need to provision and configure new environments for development and testing.
Solution:
✑ Provision a trial environment named T1 and a sandbox environment named S1.
✑ Copy the production environment to T1 and S1.
✑ Use T1 for development and S1 for testing.
Does the solution meet the goal?
Answer: Explanation:
Using trial environments, companies and customers can try out new features and solutions.
Do not use a trial environment for development.
A sandbox environment is any non-production environment of Microsoft Dataverse. Isolated from production, a sandbox environment is the place to safely develop and test application changes with low risk.
Reference: https://docs.microsoft.com/en-us/power-platform/admin/trial-environments
https://docs.microsoft.com/en-us/power-platform/admin/sandbox-environments
Question 130Written Answer
HOTSPOT
You need to roll back the mobile app to an earlier version.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: View the sessions details page for the app in Power Apps Studio
Use PowerApps Studio, select the App, and choose and you will be directed to the app’s
Versions tab in PowerApps portal. There should be one version marked Live.
Box 2: Select Restore on the previous version of the app.
Restore an app from your account
✑ Open powerapps.com, and then click or tap Apps in the left navigation bar.
✑ Near the right edge, click or tap the info icon for the app that you want to restore.
✑ Click or tap the Versions tab, and then click or tap Restore for the version that you want to restore.
Question 131Selectable Answer
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.
Answer: Explanation:
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-powerplatform-dataflows-in-power-apps/
Question 132Selectable Answer
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.
Answer: Explanation:
You can use line charts, pie charts, and bar charts to display your data in a canvas app.
Add a bar chart to display your data:
Question 133Selectable Answer
You need to configure functionality for submitting status reports.
What should you do?
Answer: Explanation:
Scenario: The app must be able to run both online and offline. If the mobile device on which the app runs is connected to the internet, the app must immediately submit the status report.
When data is submitted offline, the data must be stored in the app until the app is back online.
Mobile users often need to be productive even when they have limited or no connectivity. LoadData and SaveData combine to form a simple mechanism to store small amounts of data on a local device. By using these functions, you can add simple offline capabilities to your app.
The SaveData function stores a collection for later use under a name.
The LoadData function reloads a collection by name that was previously saved with SaveData. You can't use this function to load a collection from another source.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-savedata-loaddata
Question 134Written Answer
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 as shown below:
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.
Answer:
Explanation:
Graphical user interface, text, application
Description automatically generated
Box 1: Name_DataCardValue1.Default
Box 2: Move the icon to the Activity form and set the On Select property to the Activity screen.
The Select function simulates a select action on a control as if the user had clicked or tapped the control. As a result, the OnSelect formula on the target control is evaluated.
Question 135Written Answer
HOTSPOT
A company uses a model-driven app. You create a Power BI sales report.
The executive of the company wants all users to see tiles from the report in the model-driven app.
You need to ensure all users can see the tiles.
What should you do? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Graphical user interface, text
Description automatically generated
Box 1: Power Platform Environment settings
Before users can embed Power BI visualizations on personal dashboards, the organization-wide setting must be enabled.
✑ In the Power Platform admin center, select an environment.
✑ Select Settings > Product > Features.
✑ Under Embedded content set Power BI visualization embedding to On to enable or Off to disable.
✑ Select Save.
Box 2: Create a personal dashboard
You can embed Power BI tiles on your personal dashboard.
✑ Open your app and go to Dashboards.
✑ Select an existing personal dashboard or select New to create one.
✑ On the dashboard, select an area where you want the tile to appear, and then select Power BI Tile on the toolbar.
✑ Add new Power BI tile.
✑ In the Power BI Tile dialog, select the workspace and then select the Power BI tile that you want to display on your dashboard. Select Enable for mobile if you want to make the tile available for Dynamics 365 for tablets and Dynamics 365 for phones.
✑ Select another area of the dashboard and repeat this step to add another Power BI tile, or other component, such as a chart or list, to your dashboard.
✑ Select Save to save your dashboard.
Box 3: Share report and share dashboard.
To share your personal dashboard that contains Power BI visualizations you must configure sharing in both Dataverse and Power BI, and the user or group must have the same credentials and appropriate level of access in both services. To share your personal dashboard in your app, go to Dashboards. In the list of dashboards, select the personal dashboard you want, and then select SHARE DASHBOARD.
