Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 901–975

You are a Power Platform administrator for a large multinational company that uses Microsoft Power Platform to manage its sales operations. The company has a Power App for sales representatives to log customer meetings and a Power Automate flow that sends a summary email to the sales manager after each meeting is logged. Recently, sales representatives have reported that the app is slow to load and sometimes times out. The IT team has checked network connectivity and server performance and found no issues. The app uses Dataverse as its data source and includes several lookup fields to related tables. The Power Automate flow runs immediately after a meeting is created and queries additional data from the Dataverse. You suspect the issue is related to the flow's trigger and subsequent queries. What course of action should you take to improve performance?

Based on the exhibit, what is the result of the TotalQuantity measure?

A Power Automate flow runs on a schedule and exports data from Microsoft Dataverse to a CSV file in SharePoint. Recently, the flow has been taking longer than expected and sometimes times out. Which approach should you take to improve performance?

A model-driven app uses a custom button that runs a Power Automate flow to send an email notification. Users report that the button sometimes does not appear on the command bar. The app maker checks the form customizations and confirms the button is configured correctly. What is the most likely cause?

A Power Platform administrator needs to ensure that only certain users can create Power Apps in the 'Production' environment. What is the recommended approach?

Your Power Automate flow uses an HTTP action to call a REST API. The API returns a JSON array of objects. You need to process each object and create a record in a SQL Server database. Which actions should you use?

Your organization is a multi-national corporation using Microsoft Power Platform. The compliance team requires that all Power Apps apps be auditable: every data modification (create, update, delete) must be logged with the user, timestamp, and old/new values. Additionally, the app must enforce that only users from the same business unit can view each other's records. The app uses Dataverse as the data source. You need to design the solution. Which approach should you take?

A large retail chain uses Power Platform to manage store operations. They have 500 stores, each with a tablet running a Power Apps canvas app for inventory management. The app connects to Dataverse. Recently, store managers reported that the app is slow during peak hours. The IT team suspects that the issue is due to the number of concurrent users and the design of the app. They need to improve performance without rewriting the app. What should they do first?

A logistics company uses Power Apps to build a fleet management app. They need to integrate real-time GPS data from IoT devices. Which connector should they use?

The exhibit shows a JSON snippet used to create a Power Platform environment via the Power Platform API. The administrator runs the script but the environment is created with the default language and currency instead of the specified values. What is the most likely reason?

Refer to the exhibit. A developer created an approval flow using Power Automate. The flow is triggered manually but the approval email never sends. What is the most likely cause?

Which TWO data sources can be directly connected to a canvas app without using an on-premises data gateway?

A company has a legacy on-premises SQL Server database and wants to build a Power BI report that refreshes daily. However, the database is behind a firewall. What should they use to securely access the data?

Northwind Traders uses Power Apps to build a simple help desk ticketing system. The app uses Microsoft Dataverse as the data source. The help desk team wants to ensure that only members of the 'Help Desk Agents' security role can edit tickets, while all employees can view tickets. The app is a model-driven app. The administrator needs to configure the appropriate security. Which two actions should the administrator take? (Choose two.)

A Power Pages site uses the out-of-the-box authentication with local contacts. The security team requires that user passwords expire every 90 days. How can this be configured?

Which TWO of the following are types of apps you can create with Power Apps?

A software company uses Power Platform to build customer-facing portals. They have a dedicated production environment and a sandbox environment for development. The developer needs to copy the entire production environment (including all apps, flows, and data) to the sandbox environment for performance testing. The developer wants to ensure that the sandbox environment is an exact copy, including all data. What should the developer do?

A manufacturing company wants to use Power Platform to improve operational efficiency. Which TWO benefits of using Microsoft Power Platform are most relevant?

A company is building a canvas app to track inventory. The app needs to display the current stock level from a SharePoint list and allow users to update quantities via a form. Which connector should be used to read and write data?

You are developing a canvas app that uses a SQL Server database as a data source. The app needs to display a list of orders and allow users to filter by date range. The SQL table has millions of rows. To ensure optimal performance, which approach should you use? A) Use the 'Filter' function in Power Apps to filter the data on the client side. B) Use a SQL view that filters data server-side and call it via the SQL connector. C) Use Power Automate to retrieve data and pass it to the app. D) Use the 'Search' function on the gallery.

Refer to the exhibit. A Power Automate flow definition is shown. The flow is supposed to trigger when a high-importance email with attachments arrives in the inbox, and then send a notification email to support. However, the flow does not trigger for emails that have attachments but are not marked as high importance. What is the most likely reason?

A Power Pages site is experiencing slow load times for authenticated users. The site has many pages with complex Liquid templates and multiple data lookups. What is the most effective first step to improve performance?

A business analyst wants to create a real-time dashboard showing sales performance from Dynamics 365 Sales data. Which tool should they use?

An administrator needs to ensure that only users from a specific Microsoft Entra ID group can access a Power Platform environment. What should the administrator configure?

Your organization uses Power Automate to automatically create a task in Microsoft Planner when a new sales opportunity is closed in Dynamics 365. The flow triggers on a new opportunity but fails to create the task. You check the run history and see an error: 'Invalid template specification' in the 'Create a task' action. How should you resolve this?

An administrator needs to assign user roles in a Power Platform environment. Which TWO roles can be assigned to allow users to create and edit Power Apps and flows, but not manage environments?

A developer is troubleshooting a canvas app that uses a SharePoint list as a data source. The app works for some users but fails for others with the error 'Access denied.' All users have read access to the SharePoint list. What could be the issue?

A Power Platform admin receives a request to allow a group of developers to create and manage environments within a tenant. What is the minimum role assignment required?

A company uses Power BI dashboards to monitor real-time production metrics. The dashboards use DirectQuery to a SQL Server database. Users report that the dashboards are slow during peak hours. What is the most effective first step to improve performance?

A business analyst creates a model-driven app to manage customer service cases. The app includes a custom form with a field called 'Priority' that has three options: Low, Medium, High. The analyst wants to ensure that only users in the 'Service Managers' security role can change the priority of a case. What should the analyst do?

An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?

You are troubleshooting a Power Pages site where authenticated users in the 'Partner' web role cannot see any records from a Dataverse table, even though the table permission is set to 'Read' with 'Contact' scope. The site uses a custom page that retrieves data via a Liquid template. What is the most likely cause?

Which TWO of the following are prerequisites for creating a Power Pages site?

Which TWO actions are necessary to enable AI Builder in a Power Apps environment? (Select 2)

An administrator is planning to deploy a solution across multiple environments. Which THREE practices should they follow?

You are troubleshooting a Power Automate flow that uses the 'Send an email' action. The flow runs successfully, but recipients report not receiving the email. What is the most likely cause?

Your organization uses Microsoft Teams for collaboration. You want to create a flow that sends a welcome message to a new member when they are added to a specific team. The flow should be triggered automatically without manual intervention. Which type of flow should you create?

A flow uses a 'When an item is created' trigger for a SharePoint list. The flow needs to access the item's title and the user who created it. Which dynamic values should be used?

A Power Pages site needs to display a chart showing sales data from a Dataverse table. The chart must update automatically when data changes. Which component should you use?

Refer to the exhibit. An administrator wants to enforce a mobile app management policy that prevents screen capture in Power Apps. Which Microsoft service should the administrator use to deploy this policy?

A company wants to use Power Platform to streamline its expense reporting process. Which TWO components can be used together to create a complete solution that allows employees to submit expenses, managers to approve them, and finance to analyze trends?

A non-profit organization wants to track donations and manage volunteers using a single system. They have limited IT staff and budget. Which Power Platform solution is most suitable?

A user reports that a canvas app is loading slowly. The app connects to a large SharePoint list with over 10,000 items. Which change would most improve performance?

A company wants to create a custom app to track inventory in their warehouse. The app needs to integrate with their existing SQL Server database and allow users to scan barcodes to update stock levels. Which type of Power Apps should they use?

A Power Platform administrator is configuring a data loss prevention (DLP) policy for a production environment. The policy must block the use of the SharePoint connector but allow the use of the SQL Server connector. The administrator creates a policy and assigns it to the environment. However, users can still use the SharePoint connector. What is the most likely reason?

A sales team needs an app to track customer interactions. The app should display a list of accounts, and when an account is selected, show related opportunities and contacts. Which type of app is best suited?

A Power Apps canvas app that uses Dataverse is being migrated from a development environment to a production environment. After migration, the app fails to load data. The developer checks the connection and finds that the Dataverse connector is pointing to the development environment. What should the developer do?

An organization needs to create a centralized repository of business data that can be used by Power Apps, Power Automate, and Power BI. Which data storage option is designed for this purpose?

You are creating a canvas app for a small business to manage customer orders. The orders are stored in an Excel file on OneDrive for Business. The app needs to display a list of orders and allow users to add new orders. Which data source should you use? A) Import Excel data into Dataverse. B) Connect to the Excel file stored on OneDrive using the OneDrive for Business connector. C) Create a SharePoint list and import the Excel data. D) Use the Excel connector with a SharePoint document library.

You have a canvas app that uses a Microsoft Dataverse table. Users need to see only their own records. What is the most efficient method to implement this security?

A global organization has multiple geographic regions and needs to comply with data residency requirements. Each region must have its own Power Platform environment with data stored locally. What is the recommended approach to manage these environments?

Refer to the exhibit. You are configuring a conditional access policy in Microsoft Entra ID to restrict access to Microsoft 365 services. The policy uses the 'approved client app' condition with the above JSON. What will this policy enforce?

A company wants to use Power Apps to digitize a paper-based approval process. Managers will review and approve requests through a mobile-friendly interface. Which feature should be used to notify managers of pending approvals?

A large enterprise uses Microsoft Power Platform with a centralized Center of Excellence (CoE). They have over 200 environments, each assigned to different business units. The security team requires that all environments enforce multi-factor authentication (MFA) for makers and admins. Additionally, they want to ensure that environment creation is limited to a specific security group. The current setup uses Microsoft Entra ID for identity. The admin needs to implement these requirements with minimal impact on existing users. What should the admin do?

A company wants to create a public-facing website for customers to submit support tickets, view their ticket history, and update their profile information. Non-authenticated users should only see a welcome page and login option. Which Power Pages feature should be used to control access to pages based on authentication status?

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

A Power Pages site needs to display a dynamic banner that changes based on the user's language preference. The banner text is stored in multiple languages. Which Power Pages feature should be used to manage the multilingual content?

Which TWO of the following are valid reasons to create multiple Power Platform environments?

You are a Power Automate administrator for Contoso Corporation. The company uses Microsoft 365 E5 licenses. The sales team uses a SharePoint Online list named 'Leads' to track potential customers. The list has columns: Title (single line of text), Email (single line of text), Status (choice: New, Contacted, Qualified, Lost), and Score (number). The sales manager wants to automate the following process: When a new lead is added with Status = 'New' and Score > 50, an approval request should be sent to the manager. If approved, the lead Status should be updated to 'Contacted' and an email should be sent to the lead's email address. If rejected, the lead Status should be updated to 'Lost'. Additionally, if the lead is not approved within 7 days, the flow should automatically set Status to 'Lost'. The manager is often on leave, so the flow should also send a reminder to the manager every 2 days if the approval is pending. You need to design the flow using Power Automate. Which of the following designs best meets the requirements?

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Refer to the exhibit. The JSON shows a trigger definition for a Power Automate flow. What will cause the flow to trigger?

An organization has several Power Platform environments used for development and testing. They want to prevent accidental deletion of important data. What strategy should they implement?

A company needs to create a dashboard that shows real-time sales data from a SQL database. Which Microsoft Power Platform tool should be used?

Refer to the exhibit. You see a Power Automate flow definition in JSON. What does this flow do?

Refer to the exhibit. The JSON describes a Power Apps function. Which call to this function will return a table of records where the 'Status' column equals 'Active'?

Which THREE elements are required to create a multilingual Power Pages site?

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

Refer to the exhibit. The JSON shows a Power Platform environment's properties in an ARM template. Based on the exhibit, which statement about this environment is true?

A company has a canvas app that uses a SharePoint list as its data source. The app works fine for most users but a few users report that they cannot submit new items. They receive a generic 'Access denied' error. What is the most likely cause?

Which THREE of the following are valid connectors in Power Automate? (Choose three.)

An administrator is managing a Power Platform environment that uses Microsoft Entra ID for authentication. The company wants to enforce multi-factor authentication (MFA) for all users accessing Power Apps. Which THREE configurations should the administrator implement? (Choose three.)

Your organization uses Power Automate to integrate with Microsoft 365 services. You need to create a flow that automatically creates a contact in Outlook when a new lead is added to Dynamics 365. The flow should run immediately when the lead is created. Which connector should you use as the trigger?

An administrator needs to ensure that a Canvas app can only be used by licensed users within the organization. What should they configure?

Your team needs to build a custom app that connects to Microsoft 365 and third-party services like Salesforce. Which Power Platform feature enables this?

Which TWO of the following are valid authentication providers for Power Pages? (Choose two.)