PL-900 Practice Test 23 — 15 Questions

Question 1

A user created a canvas app to collect feedback. The app writes data to an Excel file stored in OneDrive. When multiple users submit feedback simultaneously, some entries are lost. What is the most likely cause?

Choose an answer to begin — your selection is scored in the full session.

Accepted Answer

Excel is not designed for concurrent multi-user writes. Excel files stored in OneDrive are not designed for concurrent multi-user writes; when multiple users submit simultaneously, the file locking and sync behavior can cause writes to overwrite each other or fail silently, leading to lost entries. This is a fundamental limitation of using Excel as a database for multi-user apps.

Answer

The app has a performance issue

Answer

The Excel file is locked by OneDrive sync

Answer

A Power Automate flow is delaying the write

Question 2

A retail company uses Power Pages to host a customer portal where users can view their order history and return items. The portal uses Dataverse for data storage and Microsoft Entra ID (formerly Azure AD) for authentication. The company wants to add a chatbot on the portal to answer common questions about returns and shipping. The chatbot should be able to look up order details from Dataverse when the user is authenticated. You need to implement this with minimal custom development. What should you do?

Accepted Answer

Create a chatbot in Microsoft Copilot Studio, connect it to Dataverse, and embed it into the Power Pages site using the chatbot component.. Microsoft Copilot Studio (formerly Power Virtual Agents) provides a low-code chatbot builder that natively integrates with Dataverse and can be embedded into Power Pages using the chatbot component. It supports authenticated user context, so the bot can query Dataverse for order details without custom code, meeting the 'minimal custom development' requirement.

Answer

Build a custom chat interface using Power Apps and Power Automate to respond to queries.

Answer

Use QnA Maker to create a knowledge base from FAQ documents and embed it as a web chat control.

Answer

Develop a custom Azure Bot Service bot using the Bot Framework SDK and integrate it with Dataverse.

Question 3

You are building a Power Automate flow that automatically creates a calendar event in Outlook when a customer booking is confirmed in a third-party system. The flow uses a trigger that polls the third-party system every 5 minutes. Which type of trigger is this?

Accepted Answer

Polling trigger. A polling trigger is one where Power Automate periodically checks the source system for new data at a defined interval — in this case, every 5 minutes. The trigger does not receive a push notification from the third-party system; instead, Power Automate initiates the request on a schedule and evaluates whether new bookings exist. This is the defining characteristic of a polling trigger.

Answer

Webhook trigger

Answer

Manual trigger

Answer

Scheduled trigger

Question 4

Which TWO data sources can be used directly in a canvas app without a gateway? (Choose two.)

Accepted Answer

Microsoft Dataverse. Option C, Microsoft Dataverse, is correct because it is a cloud-hosted service that canvas apps connect to natively through the built-in Dataverse connector, so no on-premises data gateway is required. Option D, SharePoint, is correct because SharePoint Online is a cloud service and canvas apps use the standard SharePoint connector to read and write lists and libraries directly without a gateway. Options A (SQL Server on-premises) and B (Oracle database on-premises) are not correct because on-premises databases are only reachable from Power Platform via the on-premises data gateway. Option E (SAP on-premises) is also not correct because on-premises SAP systems require the on-premises data gateway (or an equivalent secure bridge) to be accessed from a canvas app.

Answer

SQL Server on-premises

Answer

Oracle database on-premises

Answer

SAP on-premises

Question 5

A company wants to build a custom app for field technicians to log maintenance reports offline and sync when connected. Which Power Platform component should be used?

Accepted Answer

Power Apps. Power Apps is the correct component because it allows building custom canvas or model-driven apps that can run offline on mobile devices using the Power Apps mobile app. Field technicians can log maintenance reports without connectivity, and the app automatically syncs data to Dataverse or other data sources when a network connection is restored, leveraging the offline-first capability.

Answer

Power Pages

Answer

Power Automate

Answer

Power BI

Question 6

Which THREE of the following are core components of Microsoft Power Platform? (Select three.)

Accepted Answer

Power Automate. Power Automate (A) is a core Power Platform component, providing workflow automation and RPA capabilities (cloud flows and desktop flows) that connect services via connectors. Power BI (D) is also a core component, delivering business analytics, interactive dashboards, and reports over data from many sources. Power Apps (E) is the third core component, enabling low-code/no-code app development with canvas, model-driven, and portal apps. Azure Logic Apps (B) is a separate Azure service for integration workflows, not part of Power Platform, and Dynamics 365 (C) is a family of business applications that can integrate with Power Platform but is not one of its core components.

Answer

Azure Logic Apps

Answer

Dynamics 365

Question 7

A user wants to edit the fields displayed in a model-driven app form. Where should they go to customize the form?

Accepted Answer

Power Apps maker portal. The Power Apps maker portal (make.powerapps.com) is the central environment for customizing model-driven apps, including editing forms. Within the maker portal, you can navigate to the specific app, open the form designer, and add, remove, or rearrange fields. This is the only option that provides the necessary design-time tools for form customization.

Answer

From the app itself by selecting Edit

Answer

Power Automate

Answer

SharePoint list settings

Question 8

A company is migrating a complex Power Apps solution from a development environment to production. The solution includes custom connectors, flows, and Dataverse tables. Which THREE steps should the administrator take to ensure a successful migration?

Accepted Answer

Test the solution in a staging environment first. To ensure a successful migration, the administrator should test the solution in a staging environment first (A) to validate functionality, export it as a managed solution (C) to maintain component relationships and support future upgrades, and run the solution checker (E) to identify and fix issues before migration. Deleting the development environment after export (B) is risky because it removes the source before the migration is verified. Manually recreating the solution in production (D) is error-prone and not recommended.

Answer

Delete the development environment after export

Answer

Manually recreate the solution in production

Question 9

You are reviewing a FetchXML query used in a Power Apps component. The exhibit shows the query. What data will this query return?

Accepted Answer

Active accounts created in the last 30 days, returning name, accountid, and createdon.. The FetchXML query includes a filter on statecode equal to 0 (Active) and a condition on createdon within the last 30 days, and it specifies only the name, accountid, and createdon attributes. Therefore, it returns active accounts created in the last 30 days with only those three attributes.

Answer

All inactive accounts created in the last 30 days, including all attributes.

Answer

All accounts created in the last 30 days, only name, accountid, and createdon.

Answer

All accounts regardless of state, returning all attributes.

Question 10

A non-profit organization wants to automate donation receipt emails and track donor engagement. Which Microsoft Power Platform tool should they use?

Accepted Answer

Power Automate. Power Automate is the correct tool because it enables the non-profit to create automated workflows that can trigger donation receipt emails when a new donation is recorded, and it can also update donor engagement metrics in a connected data source like Dataverse or SharePoint. This directly addresses the need for automating email notifications and tracking engagement without manual intervention.

Answer

Power Virtual Agents

Answer

Power BI

Answer

Power Apps

Question 11

A company plans to build a public-facing website for customer support using Power Pages. They need to enable customers to view their open support tickets and submit new ones. What must be configured in the Power Pages design studio?

Accepted Answer

Add a list and a form component bound to a Dataverse table. Power Pages design studio provides list and form components that can be bound directly to a Dataverse table to display and submit data. Option A is incorrect because embedding a canvas app is not a built-in component in Power Pages design studio; it would require custom development. Option B is incorrect because while you can use custom web templates with Dataverse connectors, it is not the standard or recommended approach for simple view/submit scenarios, and it is not a configuration in the design studio. Option D is incorrect because Power Automate flows are not components in the Power Pages design studio; they can be triggered but are not used for direct data viewing or submission.

Answer

Embed a canvas app

Answer

Configure a Dataverse connector in a custom web template

Answer

Create a Power Automate flow

Question 12

Your organization uses Power Automate to send a welcome email to new employees. The flow is triggered when a new row is added to a Dataverse table named 'NewEmployees'. The flow retrieves the manager's email from a related table and sends an email via Outlook. Managers are reporting that they receive the welcome email but it contains placeholder text instead of the employee's name. The flow runs successfully. What is the most likely cause?

Accepted Answer

The dynamic content token for the employee name is not correctly inserted in the email body. If the email body uses a dynamic content token that is not mapped correctly, the flow will output the token name as placeholder text. Option A is wrong because the trigger is working (flow runs). Option B is wrong because the email is sent successfully. Option D is wrong because there is no mention of permissions.

Answer

The trigger is not firing for all new employees

Answer

The Outlook connection is expired

Answer

The Dataverse table does not have the necessary permissions

Question 13

You create a Power Automate flow that uses AI Builder to process invoices. The flow needs to extract text from PDFs and store it in Dataverse. What is the recommended approach?

Accepted Answer

Use AI Builder's Form Processing model to extract fields and then add a 'Create a new row' action for Dataverse.. AI Builder's Form Processing model is purpose-built to extract structured fields such as invoice number, date, and total from PDFs and images. Pairing it with a Dataverse 'Create a new row' action stores the extracted data in the target table, which is the recommended end-to-end pattern.

Answer

Use AI Builder's Entity Extraction model on the raw PDF text.

Answer

Use AI Builder's Object Detection model to identify text regions.

Answer

Use AI Builder's Text Classification model to categorize invoices.

Question 14

A company is designing a copilot using Microsoft Copilot Studio. The copilot must handle sensitive employee data. Which TWO actions should the administrator take to ensure data security and compliance?

Accepted Answer

Configure data loss prevention (DLP) policies to restrict data movement. Option B is correct because configuring data loss prevention (DLP) policies in the Power Platform admin center lets the administrator control which connectors and actions the Copilot Studio copilot can use, preventing sensitive employee data from being moved to unauthorized services or external endpoints. Option D is correct because turning off the 'Data for training' option ensures that conversation content and user inputs are not used to train or improve Microsoft's underlying AI models, which is essential when handling sensitive employee data under privacy and compliance requirements. Options A and C are wrong because enabling anonymous access or disabling authentication would expose sensitive data to unauthenticated users, directly violating security and compliance goals. Option E is wrong because adding public websites as knowledge sources could pull untrusted external content into the copilot and does not protect sensitive employee data.

Answer

Enable anonymous access to allow external users

Answer

Disable authentication to simplify access

Answer

Add public websites as knowledge sources

Question 15

A retail company uses Power BI to monitor sales performance. They notice that the report data refreshes only once daily, but business users need near-real-time insights. What should they recommend?

Accepted Answer

Configure a streaming dataset in Power BI.. Streaming datasets in Power BI are designed for real-time or near-real-time data ingestion, allowing dashboards to update continuously as new data arrives. This directly addresses the requirement for near-real-time insights without relying on scheduled refreshes.

Answer

Export the data to Excel for manual updates.

Answer

Create a Power Automate flow to refresh the dataset every minute.

Answer

Increase the scheduled refresh frequency to every 15 minutes.