PL-900 Practice Test 18 — 15 Questions

Question 1

Which THREE components are part of Power Apps Studio for building Canvas apps? (Choose three.)

Accepted Answer

Formula bar. Options A, C, and D are correct because Power Apps Studio for building canvas apps includes the Formula bar, Tree view, and Property pane. Option B (Solution Explorer) is incorrect because it is a component of Power Apps for model-driven apps, not canvas apps. Option E (Report Designer) is incorrect because it is a component of Power BI, not Power Apps Studio.

Answer

Solution Explorer

Answer

Report Designer

Question 2

A small marketing team wants to automate the process of capturing leads from their website into a Dataverse table. Currently, the website sends an email notification when a lead submits a form, and a team member manually enters the data into a Power Apps app. The team wants to eliminate manual data entry. They also want to automatically send a confirmation email to the lead and create a task in Microsoft To Do for the sales representative to follow up. You need to recommend a Power Platform solution. What should you do?

Accepted Answer

Use Power Automate to monitor the website's email inbox, parse the lead data, add it to Dataverse, send confirmation email, and create a task in Microsoft To Do.. It directly addresses the requirement to eliminate manual data entry by using Power Automate to monitor the website's email inbox (via a trigger like 'When a new email arrives'), parse the lead data from the email body or attachments, add it to a Dataverse table, send a confirmation email, and create a task in Microsoft To Do. This solution automates the entire workflow without requiring changes to the existing website form or manual intervention.

Answer

Replace the website form with a Power Apps portal form, and use Power Automate for emails and tasks.

Answer

Use Microsoft Forms to collect leads, and Power Automate to add to Dataverse and send emails.

Answer

Create a Power Apps app on the website to capture leads, and use Power Automate to send emails and create tasks.

Question 3

A retail company wants to analyze sales data from multiple stores and create interactive reports for regional managers. Which Power Platform component should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is Microsoft's business analytics service designed for visualizing data and sharing interactive reports. The scenario requires analyzing sales data from multiple stores and creating interactive reports for regional managers, which aligns directly with Power BI's core capabilities of data integration, interactive dashboards, and report sharing.

Answer

Power Automate

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 4

A company uses Power Apps to manage customer service cases. They want to implement a business rule that automatically sets the priority to 'High' when the customer is a VIP. Where should the business rule be defined?

Accepted Answer

In the Dataverse table's business rules settings. Business rules are defined on Dataverse tables and apply to model-driven apps. Option C is correct because business rules are created in the Power Apps portal under the Dataverse table settings. Option A is incorrect because SharePoint lists do not support Power Apps business rules; they rely on SharePoint's own workflows or Power Automate. Option B is incorrect because Power Automate is for creating automated workflows, not business rules that apply directly to table records in Dataverse. Option D is incorrect because the canvas app's OnStart property handles app initialization logic, not data validation or business rules that should enforce behavior at the data layer.

Answer

In the SharePoint list settings

Answer

In a Power Automate flow

Answer

In the canvas app's OnStart property

Question 5

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. Model-driven app forms are customized using the form designer in the Power Apps maker portal (make.powerapps.com). Option A is incorrect because editing from within the app only changes data, not the form layout. Option C is incorrect because Power Automate is for automation, not form design. Option D is incorrect because SharePoint list settings are unrelated to model-driven app form customization.

Answer

From the app itself by selecting Edit

Answer

Power Automate

Answer

SharePoint list settings

Question 6

Which TWO actions can be performed using Power Apps? (Choose two.)

Accepted Answer

Create a mobile app to capture customer feedback.. Power Apps allows users to create custom apps with minimal code. Option D (create a mobile app to capture customer feedback) is a core use case for Power Apps, enabling rapid development of data-driven mobile applications. Option E (build a custom portal for external users to submit support tickets) can be achieved using Power Apps portals, which extend app capabilities to external audiences. Option A describes Power BI (dashboards and visualizations). Option B is Power Virtual Agents (chatbots). Option C is Power Automate (workflow automation). Therefore, the correct choices are D and E.

Answer

Build interactive dashboards with visualizations.

Answer

Create a chatbot to answer common questions.

Answer

Automate a business process to send email notifications.

Question 7

A company wants to create a mobile app for field service technicians to log work orders. The app must use a SharePoint list as the data source and include offline capability. Which type of Power App should they build?

Accepted Answer

Canvas app. A canvas app allows custom layout and offline support via Power Apps mobile. Model-driven apps (C) are primarily for data management and require online connectivity. Power Pages (A) is for external websites. Power Automate (B) is for workflow automation.

Answer

Power Pages site

Answer

Power Automate flow

Answer

Model-driven app

Question 8

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

Accepted Answer

SharePoint list. SharePoint lists are supported. Option C is correct because SQL Server is supported. Option D is correct because Excel files stored in OneDrive are supported. Option A is wrong because Azure DevOps is not a direct canvas app data source (use connectors). Option E is wrong because Power BI datasets are not data sources; you can embed reports but not use as source.

Answer

Azure DevOps work items

Answer

Power BI dataset

Question 9

You are designing a Power Apps model-driven app for a sales team. The app must enforce that a discount field cannot exceed 50% of the total price. Where should you implement this validation?

Accepted Answer

Create a business rule on the table.. Business rules in model-driven apps provide real-time validation on forms. Option B is correct. Option A is wrong because the formula bar is for canvas apps. Option C is wrong because Power Automate is for backend automation, not instant form validation. Option D is wrong because JavaScript can be used but is not the recommended low-code approach.

Answer

In the canvas app formula bar.

Answer

Use a Power Automate flow triggered on record creation.

Answer

Write JavaScript in the form customisation.

Question 10

A Power Apps app uses a Dataverse table with a choice column 'Priority' (Low, Medium, High, Critical). The app must display the priority as a color-coded badge in a gallery. Which method is most efficient?

Accepted Answer

Use the Switch function in the gallery's Fill property to map each choice value to a color.. The Switch function in the gallery's Fill property directly maps each priority choice value to a color without requiring additional tables, flows, or nested conditions. Option A adds an unnecessary lookup table, option B involves an external flow which is overkill for simple color mapping, and option D uses multiple If conditions which is less efficient and harder to maintain than a Switch function.

Answer

Add a second table with colors and use LookUp in the gallery.

Answer

Create a Power Automate flow to update a color field on the record.

Answer

Use an If function with multiple conditions to set the Fill property.

Question 11

Which TWO of the following are valid data sources for a Canvas app? (Choose TWO.)

Accepted Answer

SharePoint Online list. Options A and E are correct. Canvas apps can connect to SharePoint Online lists and Microsoft Dataverse, both of which are valid data sources. Option D (Microsoft Entra ID) is an identity service, not a data source. Option B (Power Automate flow) is an automation service, not a data source. Option C (Microsoft Intune) is a device management service and not a data source.

Answer

Power Automate flow

Answer

Microsoft Intune

Answer

Microsoft Entra ID

Question 12

A model-driven app has a subgrid showing related opportunities. Users want to be able to edit opportunity fields directly in the subgrid without opening the record. Which feature should be enabled?

Accepted Answer

Change the subgrid type from 'Standard' to 'Editable'.. Editable subgrid (C) allows inline editing. A is for charts. B is for custom views. D is for read-only subgrids.

Answer

Enable the 'Chart' option on the subgrid properties.

Answer

Set the subgrid's 'Default view' to a custom view.

Answer

Set the subgrid's 'View Selector' to show multiple views.

Question 13

Which TWO data sources can be directly connected to a canvas app without using a premium connector?

Accepted Answer

Excel (OneDrive/SharePoint). SharePoint and Excel are standard connectors included with Power Apps. Dataverse and SQL Server require premium licenses, and Salesforce is premium.

Answer

Microsoft Dataverse

Answer

SQL Server

Answer

Salesforce

Question 14

A business analyst wants to create a simple expense report app without writing code. The app should allow users to submit expenses and managers to approve or reject them. Which type of Power App should the analyst use?

Accepted Answer

Canvas app. Canvas apps (Option A) are the correct choice because they allow business analysts to build custom apps without writing code, using drag-and-drop interfaces. They are ideal for simple forms like expense reports. Option B (Power Pages) is for creating external-facing websites, not apps. Option C (Copilot Studio) is for building conversational AI chatbots. Option D (Model-driven apps) requires a Dataverse database and schema, which adds complexity and is not necessary for a simple expense report app.

Answer

Power Pages

Answer

Copilot Studio

Answer

Model-driven app

Question 15

Which TWO data sources can be used directly in a canvas app without a premium connector? (Select two.)

Accepted Answer

SharePoint list. SharePoint is a standard connector in Power Apps canvas apps. Option E is correct because Excel files stored in OneDrive for Business can be used through the standard OneDrive for Business connector. Option B is incorrect because SQL Server requires a premium connector. Option C is incorrect because Dataverse requires a premium license. Option D is incorrect because Salesforce requires a premium connector.

Answer

SQL Server database

Answer

Dataverse

Answer

Salesforce