Microsoft Power Platform Fundamentals PL-900 (PL-900) — Questions 76–150

Refer to the exhibit. A Power Apps canvas app uses the Filter function as shown. What does this expression do?

Which TWO of the following are key benefits of using Microsoft Dataverse? (Choose two.)

A company wants to ensure that changes to a Power Platform solution are tracked and can be rolled back if necessary. The development team uses source control. What should the administrator configure to enable solution lifecycle management?

You are designing a Power Pages site for a non-profit organization. The site will have multiple sections, each managed by different departments. The IT department wants to ensure that only authorized users can edit the site's content. Which approach should you recommend?

A small business wants to create a custom app to track inventory without hiring developers. Which Microsoft Power Platform tool should they use?

A retail company is building a Power Apps canvas app for store managers to review sales performance. The app connects to a SQL database and displays real-time sales data. The managers need to be able to filter data by store and date range, and view the data in a chart. The company wants to minimize licensing costs while ensuring scalability and performance. Which TWO features should you recommend?

A Power Automate flow uses an 'Apply to each' loop to iterate over a large dataset. The flow is running slowly and sometimes times out. Which approach should the administrator recommend to improve performance?

An organization has a model-driven app that uses a custom connector to an on-premises SQL Server database via an on-premises data gateway. Recently, users reported that the app is slow when loading data from the SQL Server. The network team confirms that the gateway server has sufficient resources. Which factor is most likely causing the performance degradation?

A user wants to create a flow that automatically copies attachments from incoming Outlook emails to a OneDrive folder. Which trigger and action should be used?

A manufacturing company uses Microsoft Power Platform to manage its inventory. They have a Power Apps app that allows warehouse staff to scan items and update quantities in a SharePoint list. Recently, the app has been slow to load and occasionally times out when scanning multiple items in quick succession. The IT team suspects the issue is related to the data source connection. They want to improve performance without changing the user interface. The company has a Microsoft 365 E3 subscription and all data resides in SharePoint Online. What should the IT team do first?

A non-profit organization needs to collect feedback from event attendees via a form that automatically populates a SharePoint list. Which Power Platform component should they use?

A Power Automate flow is triggered when a new file is added to a SharePoint document library. The flow should then copy the file to a different library. However, the flow fails when the file name contains a colon (:). What is the most likely reason?

Which TWO are benefits of using model-driven apps over canvas apps for enterprise data management?

Which TWO of the following are valid data sources for Power Apps?

A global organization uses Power Platform with Microsoft Dataverse as the data source. They need to ensure that users in different regions only see data relevant to their region. What should they implement?

Which TWO are benefits of using Power BI for business analytics? (Select two.)

An insurance company wants to automate claims processing. They receive claims via email attachments (PDFs) and need to extract key information (policy number, date, amount) and enter it into a Dataverse table. Then, a workflow should evaluate the claim amount: if under $5000, auto-approve and notify the customer; if over $5000, assign to a human adjuster. The solution must be low-code and use AI where beneficial. Which combination should they use?

Which TWO permissions must be configured to allow authenticated users to submit a support ticket form in Power Pages?

A Power Pages site includes a form that submits data to a Dataverse table. The form has a lookup field to select a related record. The related table has over 10,000 records. What is the best practice to optimize the lookup field's performance?

A Power Platform administrator notices that a production environment has exceeded its storage quota. The administrator needs to free up storage without impacting active solutions. Which action should the administrator take first?

A user wants to create a flow that automatically sends a thank-you email when a customer fills out a Microsoft Forms survey. Which trigger should the user select?

A manufacturing company uses Power Automate to monitor equipment sensors. When a temperature sensor exceeds a threshold, a flow sends an alert to the maintenance team. However, duplicate alerts are being sent for the same event. What should the flow developer implement to prevent duplicates?

Which TWO of the following are valid ways to connect to data in Power BI Desktop?

Which TWO of the following are benefits of using Microsoft Power Platform for citizen developers? (Select two.)

Your model-driven app uses a custom entity 'Project' with a 1:N relationship to 'Task'. You need to add a subgrid on the Project form that shows related tasks, but only tasks assigned to the current user. How should you achieve this?

You are the Power Platform administrator for your organization. A user reports that they cannot create a new environment. What is the most likely cause?

Which tool is used to create and manage a Power Pages site from start to finish?

You are designing a Power Automate flow that processes orders. The flow must wait for a manager's approval if the order amount exceeds $10,000. If the approval is rejected, the flow should notify the salesperson and stop processing. Which actions should be used?

Refer to the exhibit. A developer created a Power Automate flow based on the JSON. The flow is not updating the item status even when the manager approves. What is the most likely reason?

Drag and drop the steps to deploy a solution from a development environment to a production environment in Power Platform in the correct order.

A healthcare organization is deploying Power Apps for patient intake. They must ensure that the app complies with HIPAA regulations. Which feature should they use to protect patient data at rest?

A small business wants to adopt Power Apps to create a custom inventory management app. They have a single Microsoft 365 Business Basic subscription which includes Power Apps and Power Automate capabilities. The IT manager, who is not a dedicated administrator, needs to set up the environment. They want to ensure that the app's data is stored securely and that only authorized employees can access it. The IT manager plans to create a new environment for the app. What should the IT manager do first to ensure proper governance and security?

Which THREE actions can be performed using Power Apps AI Builder?

A user reports that a Power App button does nothing when clicked. The button's OnSelect property contains: Navigate(Screen2). What is the most likely cause?

Which TWO authentication providers are natively supported by Power Pages for external user access?

Which THREE components are part of a Power Automate cloud flow? (Select THREE.)

A company wants to add a chatbot to its Power Pages site to handle common customer inquiries. The chatbot should answer questions based on a knowledge base and escalate to a human agent if needed. Which Power Platform capability integrates with Power Pages for this purpose?

A marketing team needs to create a public event registration page that captures attendee information and stores it in Dataverse. They want to design the page using drag-and-drop components without writing code. Which feature of Power Pages should they use?

A company wants to allow external partners to submit support tickets via a web interface. The data should be stored in Dataverse. Which type of app should they build?

You need to restrict access to a specific page on a Power Pages site to only authenticated users from your organization. Which authentication provider should you configure?

Refer to the exhibit. An organization is configuring IP address and domain restrictions for a Power Pages site. The policy JSON allows traffic from the 131.107.0.0/16 IP range and from contoso.com domain. A user from IP 192.168.1.10 with an email user@fabrikam.com tries to access the site. What will happen?

A sales team needs to create a custom app to track leads and manage follow-ups, but they have no coding experience. Which Power Platform tool should they use?

Which THREE of the following are valid connectors in Power Automate?

An organization has multiple Power Platform environments. They need to ensure that all environments have consistent DLP policies and that any changes are tracked. What should the administrator implement?

A manufacturing company is deploying Microsoft Power Platform for its sales team. The environment must be segregated from production to allow experimentation without affecting live data. The solution must also support automated deployment pipelines. What should the administrator create?

Match each connector type in Power Automate to its description.

A company uses Microsoft Power Apps to build a leave request application. The app uses SharePoint as the data source. Users report that when they submit a leave request, the app sometimes fails to save the data and shows a generic error. Which should you investigate first?

Which THREE are valid data sources for a canvas app? (Choose three.)

A company uses Power BI to analyze customer feedback from surveys. The data is stored in Excel on SharePoint. They want to refresh the report daily without manual intervention. Which feature should they use?

An administrator is reviewing an ARM template for deploying a Power Platform environment. Based on the exhibit, what type of environment will be created?

A company wants to automatically send a welcome email to new customers when they submit a form on the company website. Which Power Platform tool should be used?

A financial services firm uses Power Platform in a highly regulated environment. They have a production environment that contains sensitive customer data. The compliance officer requires that all changes to apps and flows in production be approved before deployment. The development team uses a separate sandbox environment. The admin needs to implement a change management process that ensures only approved solutions are deployed to production. What should the admin do?

Refer to the exhibit. The JSON shows the definition of a Power App. What can be concluded?

A company is implementing Microsoft Power Platform. The administrator needs to prevent users from creating personal productivity environments. What should they configure?

A Power Automate flow uses the trigger configuration shown. Users report that the flow does not start when a new order is added with Status = 'Pending'. What is the most likely cause?

Refer to the exhibit. You are reviewing an ARM template for deploying a Power Pages site. The template sets the 'AllowedExternalDomains' to 'contoso.com'. What is the purpose of this setting?

Which THREE capabilities does Microsoft Power Platform include to help organizations achieve digital transformation?

A Power Platform administrator wants to delegate the responsibility of managing environments to regional leads without granting them full admin privileges. Which role should the administrator assign?

A company has a Power Platform environment that contains several unmanaged solutions. The administrator wants to promote a solution to production. Which action should the administrator take to ensure the solution can be deployed to other environments?

Your organization uses Microsoft Power Platform to manage customer support tickets. The current process: when a ticket is created in Dataverse, a Power Automate flow sends an email to the support team. The team then updates the ticket status manually in a Power Apps canvas app. However, the team often forgets to update the status, leading to delayed responses. The manager wants an automated solution that sends a reminder if the status is not changed within 24 hours. Additionally, if the status is not changed within 48 hours, the ticket should be escalated to the manager. You need to design a solution using Power Automate and Power Apps. Which approach should you take?

You are designing a Power Automate cloud flow that processes customer feedback from Microsoft Forms. The flow should send an email to the customer if their feedback rating is less than 3, and also post a message to a Microsoft Teams channel for all feedback. The flow works correctly for rating 2, but for rating 1 it sends two emails instead of one. What is the most likely cause?

A company is implementing Microsoft Power Platform and needs to ensure that only licensed users can create environments. Which setting should be enabled?

A team is designing a model-driven app for customer service. They need to ensure that only agents in the 'Premium Support' role can see a custom field named 'SLA Level'. What is the best way to implement this security requirement?

A company uses a model-driven app to manage customer service cases. The team wants to automatically assign cases to the appropriate queue based on the case category. What feature should they use?

A company has multiple Power Platform environments. The administrator notices that a production environment is running low on storage. The administrator needs to free up space without disrupting active users. What should the administrator do FIRST?

Which TWO are benefits of using Microsoft Power Platform for business process automation?

Which TWO of the following are valid trigger types in Power Automate?

Which THREE components are part of a model-driven app? (Choose three.)

A Power Pages site displays a list of job openings from a Dataverse table. The HR team wants to add a new column for 'Salary Range' and have it appear on the site. What is the simplest way to achieve this?

Which THREE of the following are capabilities of AI Builder within Power Platform? (Select three.)

A company uses Power Virtual Agents (now Copilot Studio) to handle customer inquiries. They want to escalate complex issues to a human agent when the bot cannot resolve them. What should they configure?

Refer to the exhibit. A Power Automate flow triggers when an item is created in a SharePoint list. The flow does not trigger for items created immediately after the flow is enabled. What is the most likely cause?

A retail company uses Power Apps to manage inventory. The app allows store managers to scan barcodes and update stock levels in real time. The company wants to extend this capability to suppliers so they can view stock levels but not modify them. Which Power Platform component should be used to create the supplier-facing interface?

A data analyst notices that a Power BI report takes a long time to load when filtering by a specific date range. The data source is a SQL Server view that contains millions of rows. What is the most effective way to improve performance?

Which TWO triggers are available for Power Automate flows that start from a Dataverse table? (Choose 2)