Microsoft PL-100 Microsoft Power Platform App Maker Free Practice Test — 30 Questions

Question 1

A company is using Microsoft Power Apps to create a custom application for tracking employee performance metrics. The application needs to calculate the average performance score of employees based on their quarterly evaluations. Each employee\'s score is derived from three different categories: Sales Performance, Customer Feedback, and Team Collaboration. The scores for these categories are weighted differently: Sales Performance contributes 50%, Customer Feedback contributes 30%, and Team Collaboration contributes 20%. If an employee has the following scores: Sales Performance = 80, Customer Feedback = 90, and Team Collaboration = 70, what is the employee\'s overall performance score?

Accepted Answer

80

Question 2

A company is looking to optimize its workflow in Microsoft Power Automate to reduce the time taken for processing customer feedback forms. Currently, the process involves multiple manual approvals and data entry tasks that are prone to delays. The team is considering implementing a flow that automatically routes feedback forms to the appropriate department based on keywords detected in the form responses. Which strategy would best enhance the efficiency of this flow while ensuring that the feedback is processed in a timely manner?

Accepted Answer

Implementing conditional logic to route forms based on keywords and using parallel branches for simultaneous processing.

Question 3

A company utilizes Microsoft Power Platform to manage its sales data, which is updated daily in a SQL database. The sales team relies on a Power App that pulls this data to generate reports. The app is set to refresh its data every hour. However, the sales team notices that the reports are not reflecting the most recent sales figures. After investigating, they discover that the scheduled refresh is not functioning as intended. What could be the most likely reason for this issue, considering the data refresh settings and the nature of the SQL database?

Accepted Answer

The scheduled refresh is set to a frequency that exceeds the data update frequency of the SQL database.

Question 4

A company is developing a Power App that needs to connect to multiple data sources, including a SQL Server database and a SharePoint list. The app is intended to display data from both sources in a unified interface. The development team is considering the best approach to ensure that the app can efficiently retrieve and display data from these sources while maintaining performance and security. Which strategy should the team prioritize to achieve this goal?

Accepted Answer

Utilize a Common Data Service (CDS) to integrate data from both sources into a single model for the app.

Question 5

In a scenario where a company needs to automate the process of sending weekly sales reports to its management team, which trigger would be most appropriate to use in Power Automate to ensure that the reports are sent every Monday at 9 AM? Additionally, consider the implications of using this trigger in terms of resource management and execution frequency.

Accepted Answer

Recurrence trigger set to weekly on Mondays at 9 AM

Question 6

In a Power Apps application, you are tasked with creating a form that dynamically adjusts its behavior based on user input. You decide to implement context variables to manage the visibility of certain fields based on the user\'s role. If a user selects \"Admin,\" additional fields should appear, while for \"User,\" those fields should remain hidden. Given that context variables are scoped to the screen they are created in, what is the best approach to ensure that the visibility of these fields is maintained across different screens in the app?

Accepted Answer

Use global variables to store the user's role and control visibility across all screens.

Question 7

A company is using Microsoft Power Automate to streamline its customer support process. They want to create a flow that triggers when a new support ticket is created in their system. The flow should then send an email notification to the support team and update a SharePoint list with the ticket details. Which combination of flow triggers and actions would best achieve this goal?

Accepted Answer

Trigger: "When an item is created" in the support ticket list; Action: "Send an email" and "Update item" in SharePoint

Question 8

A company is looking to automate its employee onboarding process using Power Automate. The HR department wants to ensure that when a new employee is added to the system, a series of actions are triggered, including sending a welcome email, creating a task list in Microsoft To Do, and updating a SharePoint list with the new employee\'s details. Which of the following best describes the approach to achieve this automation effectively?

Accepted Answer

Create a flow that triggers on the creation of a new employee record in the database, using connectors for email, Microsoft To Do, and SharePoint to perform the necessary actions sequentially.

Question 9

A company is developing a Power Apps application to manage customer feedback. The app includes a form that captures customer details, feedback type, and comments. The development team wants to ensure that the form is user-friendly and captures data accurately. They decide to implement validation rules for the feedback type field, which can either be \"Positive,\" \"Negative,\" or \"Neutral.\" The team also wants to ensure that the comments field is mandatory only when the feedback type is \"Negative.\" Which approach should the team take to implement these requirements effectively?

Accepted Answer

Set the feedback type field as a dropdown with the three options and create a conditional rule that makes the comments field mandatory only when "Negative" is selected.

Question 10

In designing a mobile application for a healthcare provider, the UX team is tasked with ensuring that the app is both user-friendly and accessible to a diverse patient population, including those with disabilities. The team decides to implement a color contrast ratio of at least 4.5:1 for text against its background to enhance readability. If the text color is represented in RGB as (255, 255, 255) and the background color is (0, 0, 0), what is the color contrast ratio, and does it meet the accessibility standard?

Accepted Answer

21:1

Question 11

In a community forum dedicated to Microsoft Power Platform, a user is seeking advice on how to optimize their app\'s performance. They mention that their app is experiencing slow load times and unresponsive behavior during peak usage hours. Which community resource would be most beneficial for them to consult in order to find best practices and optimization techniques for their app?

Accepted Answer

The official Microsoft Power Platform Community Blog

Question 12

In the design of a mobile application for a healthcare provider, the UX team is tasked with improving the user experience for patients scheduling appointments. They decide to implement a feature that allows users to see available time slots in real-time and receive reminders for their appointments. Which of the following principles of UX design is most critical to ensure that this feature is effective and user-friendly?

Accepted Answer

Consistency in design elements and interactions

Question 13

In a scenario where a company is looking to streamline its operations and improve data management, they decide to implement Microsoft Power Platform. They want to create a solution that integrates data from various sources, automates workflows, and provides insights through analytics. Which of the following components of the Power Platform would be most suitable for building a custom application that allows users to interact with data and perform actions based on that data?

Accepted Answer

Power Apps

Question 14

In a scenario where a company is developing a customer relationship management (CRM) application using Microsoft Power Platform, they need to define the entities and attributes that will capture customer interactions effectively. The company wants to track not only basic customer information but also interactions such as calls, emails, and meetings. Which of the following approaches best describes how to structure the entities and attributes to ensure comprehensive data capture and maintain relationships between different types of interactions?

Accepted Answer

Create a primary entity for "Customer" with attributes for name, contact information, and a related entity for "Interactions" that includes attributes for type (call, email, meeting), date, and notes, establishing a one-to-many relationship between "Customer" and "Interactions."

Question 15

A company is developing a Power App that integrates data from multiple sources, including SharePoint lists, SQL databases, and Excel files stored in OneDrive. The app needs to display a dashboard that aggregates sales data from these sources. The sales data includes the following fields: `SalesAmount`, `SalesDate`, and `Region`. To ensure that the dashboard updates in real-time as new data is added, the app maker decides to implement a data connection strategy. Which approach would best facilitate real-time data updates across these diverse data sources while maintaining performance and reliability?

Accepted Answer

Use Power Automate to create a flow that triggers on data changes in each source and updates a centralized data source that the app connects to.

Question 16

In a scenario where a company is developing a Power Apps application for managing customer feedback, the app\'s layout must be intuitive and user-friendly. The design team is considering various navigation strategies to enhance user experience. Which approach would best facilitate seamless navigation while ensuring that users can easily access different sections of the app, such as feedback submission, review, and analytics?

Accepted Answer

Implement a tabbed navigation layout that categorizes sections clearly and allows users to switch between them without losing context.

Question 17

A company is developing a Power Apps application that will be used by employees across various departments. The app is expected to handle a significant amount of data and user interactions. To ensure optimal performance and user experience, which of the following best practices should the development team prioritize during the app\'s design and implementation phase?

Accepted Answer

Implementing delegation for data queries to ensure that only the necessary data is processed and returned from the data source.

Question 18

A company is developing a chatbot to assist customers with their inquiries about product returns. After creating the initial version of the chatbot, the development team needs to conduct testing to ensure that the bot can handle various scenarios effectively. They decide to implement a series of tests, including unit testing, integration testing, and user acceptance testing (UAT). Which of the following testing strategies should the team prioritize to ensure that the chatbot meets user expectations and functions correctly in real-world scenarios?

Accepted Answer

Conducting user acceptance testing with a diverse group of end-users to gather feedback on the chatbot's performance and usability.

Question 19

In a community forum dedicated to Microsoft Power Platform, a user is seeking advice on how to optimize their app\'s performance. They mention that their app is experiencing slow load times and unresponsive behavior during peak usage hours. Which community resource would be most beneficial for them to consult in order to find best practices and performance optimization techniques specific to Power Apps?

Accepted Answer

The Microsoft Power Apps Community Blog

Question 20

In a Power Apps application, you are tasked with creating a form that dynamically adjusts its behavior based on user input. You decide to implement context variables to manage the visibility of certain fields based on the user\'s selection. If a user selects \"Yes\" from a dropdown, you want to display additional fields for further information. However, you also want to ensure that these fields are hidden when the user selects \"No.\" Given this scenario, which approach would best facilitate the management of these dynamic behaviors while ensuring that the application remains efficient and responsive?

Accepted Answer

Use context variables to store the user's selection and control the visibility of the fields based on that variable.

Question 21

A company is developing a customer service bot using Microsoft Power Virtual Agents. The bot needs to handle multiple intents, including answering FAQs, booking appointments, and providing product recommendations. The development team is considering how to structure the bot\'s conversation flow to ensure it can effectively manage these intents while maintaining a seamless user experience. Which approach should the team prioritize to optimize the bot\'s performance and user satisfaction?

Accepted Answer

Implement a hierarchical structure for intents, where general intents lead to more specific ones, allowing for better context management and user guidance throughout the conversation.

Question 22

A company is analyzing its sales data using DAX in Power BI. They have a table named `Sales` with the following columns: `ProductID`, `QuantitySold`, and `SalesAmount`. The company wants to calculate the total revenue generated from products that have sold more than 100 units. Which DAX formula would correctly achieve this?

Accepted Answer

`CALCULATE(SUM(Sales[SalesAmount]), Sales[QuantitySold] > 100)`

Question 23

A company is implementing a Power Virtual Agent to assist customers with their inquiries about product features and troubleshooting. The bot is designed to handle multiple intents, including product information, technical support, and order tracking. During the testing phase, the development team notices that the bot is not accurately identifying user intents when the queries are phrased in a complex manner. What approach should the team take to improve the bot\'s intent recognition capabilities?

Accepted Answer

Enhance the bot's training phrases by including a diverse set of examples that cover various ways users might express the same intent.

Question 24

A company is developing a chatbot to assist customers with their inquiries about product availability and order status. The chatbot needs to handle various user intents, such as checking product stock, tracking orders, and providing shipping information. The development team decides to implement a natural language processing (NLP) model to improve the chatbot\'s understanding of user queries. Which of the following approaches would best enhance the chatbot\'s ability to accurately interpret and respond to diverse customer inquiries?

Accepted Answer

Implementing a machine learning model trained on a diverse dataset of customer interactions to recognize patterns in user intents.

Question 25

In a scenario where a company is developing a Power Apps application to manage customer feedback, the development team decides to use a Gallery control to display the feedback entries. The Gallery is set to show a list of feedback items, each containing a rating (1 to 5 stars), a comment, and the date submitted. The team wants to implement a feature that allows users to filter the displayed feedback based on a minimum rating threshold and sort the results by the date submitted in descending order. Which of the following approaches would best achieve this functionality?

Accepted Answer

Use the Filter function to filter the Gallery items based on the rating and the Sort function to order the results by date submitted.

Question 26

In the development of a mobile application aimed at enhancing productivity for visually impaired users, which of the following considerations is most critical to ensure accessibility and usability for this demographic?

Accepted Answer

Implementing screen reader compatibility and ensuring all interactive elements are keyboard navigable

Question 27

In a Power Apps application, you are tasked with creating a function that calculates the total price of items in a shopping cart. Each item has a price and a quantity. The function should take two parameters: a collection of items, where each item is represented as a record with fields `Price` and `Quantity`, and it should return the total price as a decimal number. If the collection is empty, the function should return 0. Which of the following expressions correctly implements this functionality?

Accepted Answer

`If(IsEmpty(Items), 0, Sum(Items, Price * Quantity))`

Question 28

A retail company is analyzing its sales data using Power Query to prepare a report for the last quarter. The dataset includes columns for Product ID, Sales Amount, and Sales Date. The company wants to transform the data to calculate the total sales per product for the last quarter and then filter out products that had sales below $500. Which of the following steps should be taken to achieve this transformation effectively?

Accepted Answer

Group the data by Product ID, sum the Sales Amount, filter the results to include only those with a total greater than or equal to $500, and ensure the date filter is applied to include only the last quarter's sales.

Question 29

A retail company wants to analyze its sales data to understand the performance of its products over the last year. They have a table named `Sales` with the following columns: `ProductID`, `SalesAmount`, `SalesDate`, and `QuantitySold`. The company wants to create a measure that calculates the total sales amount for the last quarter of the previous year. Which DAX expression would correctly achieve this?

Accepted Answer

`TotalSalesLastQuarter = CALCULATE(SUM(Sales[SalesAmount]), FILTER(Sales, Sales[SalesDate] >= DATE(YEAR(TODAY())-1, 10, 1) && Sales[SalesDate] < DATE(YEAR(TODAY())-1, 12, 31)))`

Question 30

A company is looking to streamline its operations by utilizing the Microsoft Power Platform. They want to create a solution that integrates data from multiple sources, automates workflows, and provides insights through analytics. Which combination of components from the Power Platform would best achieve this goal, considering the need for data integration, automation, and reporting?

Accepted Answer

Power Apps, Power Automate, and Power BI

Microsoft PL-100 Microsoft Power Platform App Maker Free Practice Test — 30 Questions

A lot more is already mapped out

About the Microsoft PL-100 Microsoft Power Platform App Maker Certification