PL-900 Practice Test 1 — 25 Questions

Question 1

A Power Pages site uses a custom liquid template to display data from a Dataverse table named 'Courses'. The template iterates over a list of courses and displays their names. However, the site loads slowly because the template retrieves all courses without filtering. What is the most efficient way to limit the courses displayed to only those with a status of 'Active'?

Accepted Answer

Create a new view in Dataverse that filters by 'Active' and reference it in the Liquid template.. Creating a new view in Dataverse that filters by 'Active' status and referencing that view in the Liquid template with the `table` tag and `view` parameter is the most efficient approach because filtering is performed at the database level, minimizing data transfer. Option A is incorrect because while a web API call can filter, it introduces additional overhead and complexity compared to using a view. Option B is incorrect because basic forms are used for data entry and are not designed for displaying data in Liquid templates. Option C is incorrect because adding a Liquid if condition inside the loop still retrieves all records from Dataverse, defeating the purpose of filtering before retrieval.

Answer

Use a web API call to fetch filtered courses from Dataverse.

Answer

Use a basic form configured with a filter on the Courses table.

Answer

Add a Liquid if condition inside the for loop to skip inactive courses.

Question 2

A sales team wants to track customer interactions and automate follow-up emails without custom development. What Microsoft Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it enables the sales team to create automated workflows that trigger follow-up emails based on customer interactions, such as when a new contact is added or a meeting ends. It integrates with common data sources like Dynamics 365, SharePoint, or Outlook, and uses prebuilt connectors to send emails without any custom code.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 3

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

Accepted Answer

Reduces need for custom coding. Option A is correct because Microsoft Power Platform provides low-code and no-code tools like Power Automate and Power Apps, enabling users to create automated workflows and applications without writing custom code. This reduces reliance on professional developers and accelerates business process automation.

Answer

Requires dedicated IT team for every automation

Answer

Only works on-premises

Answer

Requires deep knowledge of programming languages

Question 4

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 5

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?

Accepted Answer

IoT connector. The IoT connector is specifically designed to ingest and process data from Internet of Things devices, including real-time GPS streams from fleet telematics. It provides built-in triggers and actions for handling device telemetry, making it the correct choice for integrating live GPS data into a Power Apps fleet management solution.

Answer

SharePoint connector

Answer

Dynamics 365 connector

Answer

Office 365 Users connector

Question 6

A company wants to automate a business process that requires approval from a manager before an expense report is submitted. Which Microsoft Power Platform component should be used?

Accepted Answer

Power Automate. Power Automate is the correct component because it is designed to create automated workflows that can include approval steps. In this scenario, a Power Automate flow can be triggered when an expense report is submitted, route the request to the manager for approval, and then proceed with submission only after approval is granted.

Answer

Power BI

Answer

Power Apps

Answer

Power Virtual Agents

Question 7

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?

Accepted Answer

Power BI. Power BI is the correct tool because it is designed specifically for data visualization and business analytics, capable of connecting directly to a SQL database to create real-time dashboards. It supports DirectQuery or live connections to SQL Server, enabling near-real-time updates without requiring data to be imported into a separate store.

Answer

Power Apps

Answer

Power Automate

Answer

AI Builder

Question 8

A company uses Power BI to monitor manufacturing efficiency. The dataset includes a column 'RunTime' (in minutes) and 'DownTime' (in minutes). A user wants to calculate 'Availability' as (RunTime / (RunTime + DownTime)) * 100. Which DAX measure should be used?

Accepted Answer

Availability = DIVIDE(SUM([RunTime]), SUM([RunTime])+SUM([DownTime])) * 100. Option A is correct because it uses the DIVIDE function to safely handle division by zero, and multiplies by 100 to express the result as a percentage. The formula sums RunTime and DownTime across all rows, then computes Availability = (Total RunTime / (Total RunTime + Total DownTime)) * 100, which matches the user's requirement exactly.

Answer

Availability = DIVIDE(SUM([RunTime]), SUM([RunTime])+SUM([DownTime]))

Answer

Availability = AVERAGE(Table[RunTime]) / (AVERAGE(Table[RunTime])+AVERAGE(Table[DownTime])) * 100

Answer

Availability = SUMX(Table, [RunTime]/([RunTime]+[DownTime])) * 100

Question 9

A business analyst wants to create a dashboard that displays real-time sales data from a SQL database and share it with the team. Which Power Platform component is best suited?

Accepted Answer

Power BI. Power BI is the correct choice because it is specifically designed for data visualization and business intelligence, enabling real-time dashboards from SQL databases via DirectQuery or live connections. It allows sharing dashboards with the team through Power BI Service, meeting the requirement for real-time sales data display and collaboration.

Answer

Power Automate

Answer

Power Virtual Agents

Answer

Power Apps

Question 10

A canvas app uses the formula shown in the exhibit to display the name of the most recently created account named 'Contoso'. The formula always shows 'No records found' even though there are accounts named 'Contoso'. What is the likely issue?

Accepted Answer

The column name in the formula uses a space and may be incorrect.. Option D is correct because the formula references a column name with a space ('Account Name') without using single-quote delimiters. In Power Apps, when a column name contains a space, it must be enclosed in single quotes (e.g., 'Account Name') to be parsed correctly. Without the quotes, Power Apps interprets the space as a separator, causing the lookup to fail and the condition to evaluate as false, always falling back to 'No records found'.

Answer

The SortByColumns function is used incorrectly.

Answer

The First function cannot be used on a filtered result.

Answer

The formula is not delegable and returns incomplete data.

Question 11

Which THREE are common uses of connectors in Power Automate? (Choose three.)

Accepted Answer

Create a record in Dataverse. Option B is correct because connectors in Power Automate provide pre-built actions and triggers to interact with external services. The Dataverse connector includes a 'Create a new record' action, enabling automated creation of rows in Dataverse tables without custom code, directly from a flow.

Answer

Build a custom user interface

Answer

Create a real-time dashboard

Question 12

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?

Accepted Answer

The users lack write permissions on the SharePoint list.. The 'Access denied' error when submitting new items in a canvas app connected to a SharePoint list indicates that the user lacks write permissions on the underlying data source. Even though the app is shared with the user, the SharePoint list itself enforces its own permission model. Without Contribute or Edit permissions on the list, the user cannot create new items, resulting in the generic access denied error.

Answer

The connection reference is not shared with the users.

Answer

The SharePoint list has exceeded its item limit.

Answer

The app is shared with 'Can edit' permission but not 'Can view'.

Question 13

A Power Automate flow uses the trigger shown. Users report that the flow does not trigger for emails with attachments. What is the most likely cause?

Accepted Answer

The trigger does not check for attachments by default. Option C is correct because the trigger shown in the question is likely a 'When a new email arrives' trigger, which by default does not include attachments. To process emails with attachments, you must explicitly configure the trigger to include attachments by enabling the 'Include Attachments' option or by using the 'Get attachments' action. Without this, the flow will not trigger for emails that have attachments.

Answer

The path should include '/attachments'

Answer

The connection name is incorrect

Answer

The method should be 'post' instead of 'get'

Question 14

You are the Power Platform administrator for Contoso Ltd., a retail company with 500 employees. The company uses Microsoft 365 and has recently adopted Power Platform. The IT department manages a Power Apps canvas app used by the sales team to track customer interactions. The app connects to a Microsoft Dataverse table named 'Customer Interactions' with columns: CustomerID (text), InteractionDate (date), Notes (text), and SalesPerson (text). The app was working fine for three months, but starting last week, users report that the app loads slowly, sometimes timing out, and the 'Customer Interactions' table shows duplicate records. Upon investigation, you find that the app uses a 'Patch' function to create records, and the 'OnStart' property loads all records from the table using 'Filter(Customer Interactions, SalesPerson = User().FullName)' to show only the current user's records. The Dataverse table has grown to 50,000 rows. Additionally, some users have accidentally created multiple submissions by double-clicking the submit button. You need to resolve the performance and duplicate issues with minimal disruption. What should you do?

Accepted Answer

Modify the 'Submit' button to set its 'DisplayMode' to 'Disabled' after the first click to prevent double submission, and change the 'OnStart' filter to delegate by ensuring the 'SalesPerson' column is indexed in Dataverse and using 'Filter(Customer Interactions, SalesPerson = User().FullName)' with delegation enabled.. Option D is correct because it addresses both performance and duplicate issues directly. Disabling the submit button after the first click prevents double submissions, a common cause of duplicates in canvas apps. Indexing the SalesPerson column in Dataverse ensures the Filter function delegates, meaning the query runs on the server side and only returns relevant rows, drastically reducing data transfer and load times compared to pulling all 50,000 rows client-side.

Answer

Replace the 'Patch' function with 'Collect' in the app and use the 'Distinct' function to remove duplicates from the table every night via a Power Automate flow.

Answer

Increase the 'Data row limit' for the 'Customer Interactions' table in the app settings to 500 and add a 'Remove duplicates' step in the app's 'OnStart'.

Answer

Remove the 'Filter' from 'OnStart' and load all records into a collection, then use 'Filter' on the collection to show current user's records.

Question 15

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

Accepted Answer

Direct connection to a SQL Server database. Option D is correct because Power BI Desktop includes a native SQL Server connector that allows direct query or import mode connections to on-premises or cloud SQL Server databases. This enables real-time or scheduled data retrieval using T-SQL queries, supporting both Windows and SQL Server authentication.

Answer

Connection to a SharePoint Online list using the SharePoint connector

Answer

Connecting to a Power Apps canvas app as a data source

Answer

Using Power Automate to extract data from a website

Question 16

A company wants to build a Power Apps app that uses a SQL Server database as its data source and requires complex business logic validation before saving data. Which type of app should they use?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they allow full control over the user interface and can incorporate complex business logic validation using Power Fx formulas before data is written to the SQL Server database. Unlike model-driven apps, which rely on predefined forms and server-side business rules, canvas apps enable custom validation logic directly in the app's formulas, such as checking multiple field conditions or calling custom connectors.

Answer

Model-driven app

Answer

Power Automate

Answer

Portal

Question 17

A healthcare organization needs a Power Apps app to track patient visit data. The data must be stored in Microsoft Dataverse, and the app should automatically generate a timeline of visits for each patient. Which app type is most suitable?

Accepted Answer

Model-driven app. A model-driven app is the most suitable choice because it is designed for complex, data-centric business applications that require rich relational data modeling, automated business logic, and built-in timeline controls. Dataverse provides the underlying relational storage, and model-driven apps natively support timeline components that automatically aggregate and display patient visit records in chronological order without custom development.

Answer

Portal

Answer

Power Automate

Answer

Canvas app

Question 18

A company deploys a model-driven app that uses a custom table 'Project' with a status choice column. The app includes a business rule that shows a warning message when the status is set to 'Completed' but the 'End Date' is blank. The business rule works on the main form but not when records are updated via a Power Automate flow. Which THREE actions should the administrator take to enforce the rule regardless of update method?

Accepted Answer

Use a synchronous plug-in that runs on the Update message of the Project table.. Option A is correct because a synchronous plug-in runs on the Update message of the Project table, executing immediately within the database transaction. This ensures the validation logic (checking that End Date is not blank when Status is 'Completed') is enforced regardless of the update method, including Power Automate flows, which bypass client-side business rules.

Answer

Configure an asynchronous workflow that runs after the update.

Answer

Modify the business rule to run on all forms.

Question 19

Which TWO are valid ways to share a canvas app with other users in your organization? (Select two.)

Accepted Answer

Add users to a security group that has been granted access to the app. Option B is correct because adding users to a security group that has been granted access to the app is a valid way to share. Option C is correct because sharing the app directly with individual users or Microsoft Entra ID groups is the primary sharing method. Option A is wrong because the app must be published before sharing a link. Option D is wrong because Power Apps does not generate public URLs for sharing. Option E is wrong because exporting as a .msapp file is for transferring between environments, not for sharing with users.

Answer

Send a direct link to the app via email before publishing

Answer

Generate a public URL that anyone in the organization can use

Answer

Export the app as a .msapp file and email it to users

Question 20

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?

Accepted Answer

The email was sent to the flow owner's mailbox due to configuration. Option C is correct. In Power Automate, if the 'Send an email' action is configured to send to the flow owner or there is a misconfiguration in the recipient field, the email might be sent to the flow owner's mailbox instead of the intended recipients. Run history shows success because the action completed, but the email was delivered to the wrong address. Option A is incorrect because a 30-day delay would cause the flow to timeout, not silently deliver to the wrong mailbox. Option B is incorrect because the run history shows success, not failure. Option D is incorrect because exceeding API limits would cause the flow to fail or be suspended, not deliver to the wrong recipient.

Answer

The flow took longer than 30 days to complete

Answer

The flow run history shows a failed run

Answer

The flow was suspended due to exceeding API limits