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.
DRAG DROP
A call center manager monitors incoming phone calls. The manager analyzes the performance of phone reps by using a custom view. The view contains a custom field named Phone call Duration in Minutes.
The call center manager must present an Excel spreadsheet daily to upper management. The spreadsheet must contain the call center performance for further trending analysis and corrective actions.
You need to create the spreadsheet.
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.
Answer:
Explanation:
Timeline
Description automatically generated with low confidence
Step 1: Export the custom view to an Excel dynamic pivot table
You can export app data to an Office Excel PivotTable to see patterns and trends in data. An Excel PivotTable is a great way to summarize, analyze, explore, and present your app data.
Step 2: Create a pivot table, and then use the Phone Rep field as a category and the Phone call Duration in Minutes as field as series
Step 3: Set the formula for phone call duration in minutes to Average and add a pie chart linked to the pivot table
Step 4: Save the spreadsheet and upload it back to the system.
Question 62Written Answer
DRAG DROP
You are creating entities in a Common Data Service database to capture sales data.
You create an entity named Sales that includes the following fields:
You create a new entity that includes a field named TotalSales. The field is used to capture the aggregated sales for each salesperson.
You need to configure the fields for the entities.
Which field types should you use? To answer, drag the appropriate field types to the correct field names. Each field 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: Calculated
Calculated columns are calculated in real-time when they are retrieved. Calculated columns can be composed using different data types. For example, an Integer calculated column may reference values from Decimal or Currency columns.
Box 2: Simple
A simple column isn’t defined as a calculated or rollup column.
Box 3: Rollup
Because rollup columns persist in the database, they can be used for filtering or sorting just like regular columns.
Question 63Written Answer
DRAG DROP
You are Designing a Power Virtual Agents chatbot in Microsoft Teams. You create an outline to describe how a conversation should be structured.
You need to configure the chatbot.
Which chatbot component should you use? To answer, drag the appropriate components to the correct conversation elements. Each component may be used once, more than once, or not at all. You may need to drag the spirt bar between panes or scroll to view content. NOTE: Each correct selection is worth one point.
Answer:
Question 64Selectable 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.
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?
Answer: Explanation:
Instead use a calculated field.
Need to calculate the exchange rate in USD.
Calculated columns are calculated in real-time when they are retrieved.
Reference: https://docs.microsoft.com/en-us/powerapps/developer/data-platform/calculated-rollup-attributes
Question 65Selectable Answer
You need to provide all app components of the application to Tailwind Traders.
What should you do?
Answer: Explanation:
Scenario: When identifying versions of the app solution, all dependencies, entities, and user interfaces components must be identified to avoid any unintentional issues caused by reverting individual components to a previous version.
Power Apps has added components to the rule set that encourages best practices in the Power Apps Checker. You can check your canvas apps and flows that are included in solutions and then review all issues in a single, consolidated report.
Reference: https://docs.microsoft.com/en-us/power-platform-release-plan/2019wave2/microsoft-powerapps/checker-includes-rules-canvas-apps-flows
Question 66Written Answer
HOTSPOT
You need to create a flow for sending required emails to the regional manager.
How should you create the flow? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Graphical user interface, text, application, email
Description automatically generated
Box 1: Business Process
Scenario: If a sales representative submits a status report and assigns the At Risk status to a process, the app must prompt the sales representative to enter a detailed description for the risk. This information must be emailed to the regional manager.
Business process flows provide a guide for people to get work done. They provide a streamlined user experience that leads people through the processes their organization has defined for interactions that need to be advanced to a conclusion of some kind. This user experience can be tailored so that people with different security roles can have an experience that best suits the work they do.
Box 2: Common Data Service when a record is created
The Microsoft Dataverse (Common Data Service) connector provides the following triggers to help you define when your flows start:
✑ When a row is created, updated, or deleted
✑ When an action is performed
✑ When a flow step is run from a business process flow
Question 67Written Answer
DRAG DROP
A company stores sales orders in a Microsoft Excel workbook. The company stores customer data in a SQL Server database.
You must import the data into a Microsoft Dataverse instance.
You need to define the mapping for the migration.
Which component should you use? To answer, drag the appropriate components to the correct data type. Each component 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.
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?
Answer: Explanation:
In Power Apps, add a data connection to an existing canvas app or to an app that you're building from scratch. Your app can connect to SharePoint, Common Data Service, Salesforce, OneDrive, or many other data sources.
Note:
Add data source
Question 69Written Answer
DRAG DROP
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.
Answer:
Question 70Written Answer
HOTSPOT
You need to create the solution assets.
What should you use to create the visualizations? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.
Answer:
Explanation:
Box 1: PowerBI Desktop
The Sales dashboard must reside in the Sales channel and must include information about active quotes, sales pipeline, and year-to-date sales KPIs for sales quotas by region.
PowerBI Desktop to support many data source.
Box 2: PowerBI Desktop or Power BI Service on
A dashboard that shows a capacity Heat map by month as well as expected sales that are likely to close for the next month.
Both support visualizations.
Question 71Selectable Answer
You need to implement logic in the app for lost sales.
What should you do?
Answer: Explanation:
Scenario: Requests for quotes are currently stored in a Sales Log workbook.
The workbook includes the following information:
✑ Status of the Request for Quote (RFQ) with the values of Won, Lost, No Bid, and Cancelled Salespeople often do not set status of RFQs in the Sales Log to Won when a sale is closed and the customer purchase order is received.
You can create business rules and recommendations to apply logic and validations without writing code or creating plug-ins. Business rules provide a simple interface to implement and maintain fast-changing and commonly used rules.
Business rules defined for an entity apply to both canvas apps and model-driven apps if the entity is used in the app.
Reference: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/data-platform-create-business-rule
Question 72Selectable 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?
A company is consolidating communications processes by using Microsoft Teams and Microsoft Power Platform technologies.
A Power Automate flow monitors social media channels to identify high-impact trends.
When the Power Automate flow identifies the trends, consistently formatted and standardized feedback must be collected from the channel members within Teams.
You need to streamline the Power Automate and Teams communication process.
What should you use?
Answer: Explanation:
"Microsoft Power Platform and AI Builder components allowed us to quickly deliver an innovative and well-integrated solution within our Dynamics 365 platform for our marketing and sales business partners. The platform is a game-changer in this new world of rapid app delivery."
Jim Parker: Web and Collaboration Services Manager
Reference: https://customers.microsoft.com/en-au/story/810656-hexion-manufacturing-power-platform
Question 74Written Answer
DRAG DROP
You need to modify the app design to meet the accessibility needs of the sales associates.
Which properties should you configure? To answer, drag the appropriate properties to the correct restrictions. Each property 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:
Graphical user interface, text, application
Description automatically generated
Box 1: AccessibleLabel
Scenario: Before deploying the app to production, you must ensure that the app conforms to Microsoft accessibility and performance guidelines. User2 is visually impaired and cannot see images.
AccessibleLabel is a label for screen readers.
An empty value for Image, Icon, and Shape controls will hide the controls from screen reader users.
Box 2: TabIndex
User3 is unable to use a mouse.
TabIndex determines if the control participates in keyboard navigation.
Keyboard navigation is an important aspect of any app. For many, the keyboard is more efficient than using touch or a mouse.
The navigation order should:
Mirror what is seen visually.
Only have a tab stop at controls that are interactive.
Follow either an intuitive across and then down "Z" order or a down and then across "reverse-N" order.
Question 75Written Answer
DRAG DROP
You need to select a design approach for the required features.
Which app type should you use? To answer, drag the appropriate app types to the correct requirements. 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.
