Microsoft PL-900 Microsoft Power Platform Fundamentals Free Practice Test — 30 Questions

Question 1

A data analyst is working on a sales report using Power BI Desktop. The report includes a measure that calculates the total sales amount using the formula:

Accepted Answer

ext{Total Sales} = \sum_{i=1}^{n} 	ext{Sales Amount}_i $$

Question 2

A company is looking to automate their invoice processing workflow using Power Automate. They want to create a flow that triggers when a new invoice is received in their email inbox. The flow should extract key information from the invoice, such as the invoice number, amount, and due date, and then store this information in a SharePoint list for tracking purposes. Additionally, the company wants to send a notification to the finance team whenever a new invoice is added to the SharePoint list. Which of the following steps should be included in the flow to achieve this automation effectively?

Accepted Answer

Use the "When a new email arrives" trigger, followed by the "Extract text from image" action, then the "Create item" action for SharePoint, and finally the "Send an email" action to notify the finance team.

Question 3

A company is developing a Power App to streamline its inventory management process. The app needs to allow users to input new inventory items, update existing items, and generate reports on inventory levels. The development team is considering using a combination of SharePoint lists and Power Automate flows to achieve this functionality. Which approach would best ensure that the app maintains data integrity and provides real-time updates to users?

Accepted Answer

Utilize a SharePoint list as the primary data source and implement Power Automate flows to trigger updates and notifications whenever changes are made to the list.

Question 4

A company is using Microsoft Power Platform to automate its sales process. They want to create a Power Automate flow that triggers when a new lead is added to their Dynamics 365 CRM. The flow should then send an email notification to the sales team and create a task in Microsoft To Do for the assigned salesperson. Which of the following best describes the components involved in this automation process?

Accepted Answer

The flow consists of a trigger (new lead), actions (send email and create task), and connectors (Dynamics 365 and Microsoft To Do).

Question 5

A company is developing a model-driven app to manage customer relationships. The app needs to include various entities such as Contacts, Accounts, and Opportunities. The development team is considering the use of business rules to enhance user experience and enforce data integrity. Which of the following statements best describes the role of business rules in model-driven apps, particularly in the context of managing data across these entities?

Accepted Answer

Business rules can be used to apply logic that automatically updates fields, shows or hides sections, and enforces data validation without requiring custom code.

Question 6

In a corporate environment, a data analyst is tasked with creating a report that includes sensitive customer information. The organization uses Microsoft Power Platform, which has various security roles and permissions. The analyst needs to ensure that only authorized personnel can access this report while maintaining compliance with data protection regulations such as GDPR. Which approach should the analyst take to effectively manage data security and permissions for this report?

Accepted Answer

Implement row-level security to restrict data access based on user roles and ensure that only users with specific permissions can view sensitive information.

Question 7

In a company utilizing Microsoft Power Platform, the IT department is tasked with implementing role-based security to manage access to sensitive data within a Power App. The company has three distinct roles: Admin, User, and Guest. Each role has different permissions regarding data access and manipulation. The Admin role can create, read, update, and delete records, while the User role can only read and update records. The Guest role is limited to read-only access. If a User attempts to delete a record, what will be the outcome based on the role-based security model, and how does this reflect the principles of role-based access control (RBAC)?

Accepted Answer

The User will receive an error message indicating insufficient permissions to delete the record.

Question 8

In a scenario where a company is utilizing Microsoft Power Apps to create a custom application for managing customer feedback, the development team is tasked with designing a user-friendly interface. They need to decide how to best present the feedback data to users. Which approach would most effectively utilize views and forms to enhance user experience and data interaction?

Accepted Answer

Create a gallery view that displays feedback summaries with the option to drill down into detailed forms for each entry.

Question 9

A retail company is analyzing its sales data using Power BI Desktop. The dataset includes sales figures for different products across various regions. The company wants to create a measure that calculates the total sales amount for a specific product category, but only for the last quarter of the year. The sales data is structured in a table named `Sales`, which includes columns for `ProductCategory`, `SalesAmount`, and `SalesDate`. Which DAX formula should the company use to achieve this?

Accepted Answer

`TotalSalesLastQuarter = CALCULATE(SUM(Sales[SalesAmount]), Sales[SalesDate] >= DATE(YEAR(TODAY()), MONTH(TODAY()) - 3, 1), Sales[SalesDate] < DATE(YEAR(TODAY()), MONTH(TODAY()), 1))`

Question 10

In a corporate environment, a company is implementing Microsoft Power Platform to streamline its operations. The IT department is particularly concerned about data security and compliance with regulations such as GDPR. They want to ensure that sensitive data is protected while allowing users to create applications and automate workflows. Which security feature should the IT department prioritize to effectively manage user access and protect sensitive information?

Accepted Answer

Role-based access control (RBAC)

Question 11

A company is implementing Microsoft Dataverse to manage its customer data across various departments. They want to ensure that the data is not only stored efficiently but also accessible for reporting and analytics. The company has multiple entities, including Customers, Orders, and Products, and they want to establish relationships between these entities. If the company decides to create a one-to-many relationship between Customers and Orders, which of the following statements best describes the implications of this relationship in Dataverse?

Accepted Answer

Each customer can have multiple orders, but each order can only be associated with one customer.

Question 12

A company is looking to enhance its Power Platform applications by integrating custom connectors to streamline data access from an external API. The API requires OAuth 2.0 for authentication and returns data in JSON format. The development team needs to create a custom connector that not only authenticates successfully but also handles the JSON response effectively. Which approach should the team take to ensure that the custom connector is both secure and efficient in processing the API data?

Accepted Answer

Implement OAuth 2.0 authentication in the custom connector and use the built-in JSON parsing capabilities of Power Automate to handle the API response.

Question 13

A company is looking to integrate its existing customer relationship management (CRM) system with Microsoft Power Platform to enhance its data analytics capabilities. The CRM system stores customer interactions and sales data, while the Power Platform will be used to create dashboards and reports. Which approach would best facilitate this integration while ensuring data consistency and real-time updates across both systems?

Accepted Answer

Utilize Power Automate to create automated workflows that trigger data synchronization between the CRM and Power Platform in real-time.

Question 14

A company is looking to automate its employee onboarding process using Power Automate. They want to create a flow that triggers when a new employee record is added to their SharePoint list. The flow should send a welcome email, create a task in Microsoft Planner for the HR team, and update a status field in the SharePoint list. Which of the following steps should be included in the flow to ensure that the onboarding process is efficient and meets the company\'s requirements?

Accepted Answer

Use the "When an item is created" trigger for the SharePoint list, followed by actions to send an email, create a Planner task, and update the SharePoint item.

Question 15

A company is implementing a Power Apps Portal to allow external users to submit support tickets and track their status. The portal needs to authenticate users through Azure Active Directory (AAD) and also provide a seamless experience for users who are already logged into the company’s internal applications. Which configuration should the company prioritize to ensure that users can access the portal without needing to log in again, while also maintaining security and user data integrity?

Accepted Answer

Configure Azure Active Directory B2C for single sign-on (SSO) to allow external users to authenticate seamlessly.

Question 16

A company has implemented several automated workflows using Microsoft Power Automate to streamline its operations. Recently, they noticed that one of their flows, which processes customer feedback submissions, has been failing intermittently. The IT team is tasked with monitoring and managing the flows to ensure they operate smoothly. Which of the following strategies would be the most effective for the IT team to identify and resolve issues with the failing flow?

Accepted Answer

Utilize the built-in analytics and monitoring tools in Power Automate to review the flow's run history and error messages, and set up alerts for failures.

Question 17

A retail company is analyzing its sales data using Power BI Desktop. They have a dataset that includes sales figures for different products across various regions. The company wants to create a measure that calculates the total sales amount, but only for products that have a sales quantity greater than 10. Which DAX formula would correctly achieve this?

Accepted Answer

`Total Sales = SUMX(FILTER(Sales, Sales[Quantity] > 10), Sales[Amount])`

Question 18

A company is implementing a new customer relationship management (CRM) system that integrates with Microsoft Power Platform. The IT security team is tasked with ensuring that only authorized users can access sensitive customer data. They decide to implement role-based access control (RBAC) and multi-factor authentication (MFA) to enhance security. Which of the following strategies would best ensure that the security measures are effectively enforced while maintaining user productivity?

Accepted Answer

Implement RBAC to assign permissions based on user roles and enforce MFA for all users accessing the CRM system.

Question 19

In a large organization utilizing Microsoft Power Platform, the governance team is tasked with implementing a strategy to manage the lifecycle of applications developed by citizen developers. They need to ensure that applications are compliant with organizational policies, secure, and maintainable over time. Which governance strategy should the team prioritize to effectively manage these applications while balancing innovation and risk?

Accepted Answer

Establishing a centralized approval process for application deployment that includes security assessments and compliance checks.

Question 20

In a recent project, a company developed a web application aimed at providing services to users with disabilities. The development team is tasked with ensuring that the application complies with the Web Content Accessibility Guidelines (WCAG) 2.1. They need to implement features that not only meet the minimum accessibility standards but also enhance the overall user experience for individuals with various disabilities. Which of the following strategies would best ensure compliance with accessibility standards while also improving usability for all users?

Accepted Answer

Implementing keyboard navigation and ensuring all interactive elements are accessible via keyboard shortcuts, while also providing alternative text for images and ensuring color contrast meets the recommended ratios.

Question 21

In designing a user interface for a mobile application aimed at elderly users, which of the following design principles should be prioritized to enhance usability and accessibility?

Accepted Answer

Utilizing larger touch targets and high-contrast color schemes

Question 22

A retail company is analyzing its sales data using Power BI to identify trends and forecast future sales. The dataset includes sales figures from the last three years, segmented by product category and region. The company wants to create a measure that calculates the year-over-year growth percentage for each product category. If the sales for the previous year are represented as $ S_{previous} $ and the sales for the current year as $ S_{current} $, which of the following formulas correctly calculates the year-over-year growth percentage?

Accepted Answer

$ \text{Growth Percentage} = \frac{S_{current} - S_{previous}}{S_{previous}} \times 100 $

Question 23

In a collaborative project using Microsoft Power Platform, a team of data analysts needs to share a Power BI report with stakeholders who do not have access to the Power BI service. The analysts want to ensure that the stakeholders can view the report without requiring them to have a Power BI account. Which method should the analysts choose to effectively share the report while maintaining data security and compliance with organizational policies?

Accepted Answer

Publish the report to the web and share the link with stakeholders.

Question 24

A company is analyzing user engagement metrics for its newly launched mobile application. They have collected data over a month and found that the average session duration is 8 minutes, with a total of 1,200 sessions recorded. Additionally, the app has 300 active users during this period. To evaluate the overall engagement, the company wants to calculate the Average Session Duration (ASD) per active user. What is the ASD per active user, and how does this metric help in understanding user engagement?

Accepted Answer

32 minutes

Question 25

A company is developing a custom component for their Power Apps application using the Power Apps Component Framework (PCF). The component needs to interact with the app\'s data and respond to user inputs dynamically. The development team is considering various lifecycle methods provided by the PCF. Which lifecycle method should they implement to ensure that their component can respond to changes in the data context and update the UI accordingly?

Accepted Answer

`updateView`

Question 26

A company is using Microsoft Power Apps to create a custom application for managing inventory. They want to calculate the total value of their stock based on the quantity of items and their respective prices. The formula they plan to use is:

Accepted Answer

ext{Total Value} = \sum_{i=1}^{n} (	ext{Quantity}_i 	imes 	ext{Price}_i) $$

Question 27

In a scenario where a company is analyzing customer data to improve its marketing strategies, they decide to implement a relational database to store customer information. The database is designed with multiple tables, including Customers, Orders, and Products. Each table has a primary key, and the Orders table includes foreign keys that reference the Customers and Products tables. If the company wants to retrieve a list of all customers who have purchased a specific product, which of the following data structure concepts is most critical for efficiently executing this query?

Accepted Answer

The use of foreign keys to establish relationships between tables

Question 28

In a scenario where a company is looking to streamline its business processes, 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 best facilitate the integration of data from disparate systems and allow for the creation of custom applications?

Accepted Answer

Power Apps

Question 29

A company is developing a Canvas app to manage its inventory. The app needs to display a list of products, allowing users to filter by category and search by product name. The app also requires a feature to calculate the total inventory value based on the quantity and price of each product. If the company has 150 products, each with an average price of $20 and an average quantity of 30, what formula should be used to calculate the total inventory value, and how can this be implemented in the app using Power Apps functions?

Accepted Answer

Total Inventory Value = Sum(Products.Quantity * Products.Price)

Question 30

A retail company is analyzing its sales data to improve inventory management. They have a dataset containing sales transactions, including product IDs, quantities sold, and timestamps. The company wants to identify the top three products sold in the last quarter and calculate the total revenue generated from these products. If the average price of the top-selling product is $25, the second product is $15, and the third product is $10, how would you approach the data management process to achieve this goal?

Accepted Answer

Aggregate the sales data by product ID, filter for the last quarter, and then sort the results to find the top three products based on total quantity sold. Calculate total revenue by multiplying the quantity sold by the average price for each of these products.

Microsoft PL-900 Microsoft Power Platform Fundamentals Free Practice Test — 30 Questions

A lot more is already mapped out

About the Microsoft PL-900 Microsoft Power Platform Fundamentals Certification