PL-900 Practice Test 3 — 25 Questions

Question 1

You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.

Accepted Answer

Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.. Option B is correct. By creating a custom security role with record-level security, you can configure sharing so that doctors only see appointments where the Doctor field equals themselves. Option A: Field-level security hides the Doctor field from the form but does not filter records; doctors could still see all appointments. Option C: Creating a team and sharing the app provides app access but does not restrict data visibility; all doctors would see all appointments. Option D: Hierarchy security is for manager-subordinate relationships, not for filtering by a specific field like Doctor.

Answer

Configure field-level security to hide the Doctor field.

Answer

Create a team with all doctors and share the app with the team.

Answer

Use hierarchy security to limit access based on the Doctor field.

Question 2

You have a Power Automate flow that sends a notification to a Teams channel when a high-priority ticket is created in Dynamics 365. The flow works correctly for most tickets, but occasionally a ticket is missed. Upon checking the flow runs, you see that some runs show 'Skipped' status. What is the most likely cause?

Accepted Answer

The trigger has a condition that filters out tickets with priority lower than 'High'.. The 'Skipped' status in Power Automate indicates that the flow was triggered but the trigger condition evaluated to false. In this scenario, the trigger has a condition that only allows high-priority tickets to proceed. When a ticket is created with a priority lower than 'High', the condition fails and the run is skipped. Option A correctly identifies this filter. Option B is incorrect because licensing issues would typically cause errors, not skips. Option C is wrong because high concurrency leads to queuing not skipping. Option D is incorrect as expired connections would cause failure, not skip.

Answer

The flow requires a premium license, but some users have standard licenses.

Answer

The flow's concurrency setting is too high, causing some triggers to be ignored.

Answer

The flow uses a connection that has expired or lacks permissions.

Question 3

A user wants to build an app that allows field technicians to view work orders and capture photos offline. Which type of Power App should be chosen?

Accepted Answer

Canvas app with offline capability enabled.. Canvas apps can be enabled for offline use via the mobile app, allowing field technicians to view work orders and capture photos without connectivity. Option A is incorrect because Power Pages sites are public-facing websites, not designed for offline field worker scenarios. Option B is incorrect because AI Builder is a service for adding AI capabilities, not an app type; embedding it does not provide native offline support. Option C is incorrect because model-driven apps have limited offline capabilities and are not as flexible for offline data capture as canvas apps.

Answer

Power Pages site with offline access.

Answer

AI Builder model embedded in a canvas app.

Answer

Model-driven app because it natively supports offline.

Question 4

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?

Accepted Answer

The trigger uses a polling interval that may not capture items created shortly after enablement.. Option B is correct because the SharePoint trigger in Power Automate uses a polling interval; when the flow is enabled, it may not immediately capture items created before the first poll completes. This is a common cause of missing recent items. Option A is incorrect because utcNow() is evaluated dynamically at each poll, not static. Option C is incorrect because there is no evidence the $filter expression is invalid. Option D is incorrect because the site ID is typically correct if the flow connects successfully.

Answer

The utcNow() function returns a static time.

Answer

The $filter expression is invalid.

Answer

The site ID is incorrect.

Question 5

Fabrikam, Inc. uses Power Apps to create a canvas app for expense reporting. The app is connected to a SharePoint list named Expenses. The app allows users to submit expenses, attach receipts, and view their history. The manager wants to add a feature where users can scan a receipt using the mobile app camera and automatically extract the amount and date using AI Builder. The extracted data should be populated into the form fields. The development team needs to implement this feature. Which steps should they take?

Accepted Answer

Use AI Builder's receipt processing model in Power Apps. The correct answer is A because AI Builder provides a prebuilt receipt processing model that can be directly integrated into a Power Apps canvas app. This model allows users to scan a receipt using the camera, automatically extract the amount and date, and populate those values into form fields. Option B is incorrect because while a Power Automate flow could also process the image, it is an unnecessary extra step when AI Builder can be used directly within Power Apps. Option C is incorrect because the Camera control alone cannot extract text from an image; it requires additional processing like AI Builder. Option D is incorrect because Microsoft Copilot Studio is designed for building chatbots, not for receipt scanning and data extraction.

Answer

Create a Power Automate flow that processes the image and returns the data

Answer

Use the Camera control to capture the image and use a custom formula to extract text

Answer

Integrate Microsoft Copilot Studio to handle the receipt scanning

Question 6

Refer to the exhibit. The JSON shows permissions for a user in a Power Apps environment. What can be inferred?

Accepted Answer

The user is an administrator of the environment. The correct answer is D because the JSON shows the user has the Environment Admin role, which grants full administrative permissions over the environment. Option A is incorrect because the maker role is separate and not indicated. Option B is incorrect because having an admin role implies access. Option C is incorrect because an admin can perform actions beyond viewing.

Answer

The user is a maker who can create apps

Answer

The user has no access to any app

Answer

The user can only view apps

Question 7

Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?

Accepted Answer

Business rule. Business rules can show or hide fields based on conditions without requiring code. Option A is correct because business rules are designed for declarative logic in model-driven apps, such as showing the Approved field only when Amount > 1000. Option B is incorrect because form scripting requires JavaScript, which is not necessary here. Option C is incorrect because workflow processes handle backend logic, not form behavior. Option D is incorrect because Power Automate flows are for automation outside of forms.

Answer

Form scripting

Answer

Workflow process

Answer

Power Automate flow

Question 8

A company uses Power Automate to send approval requests. The flow is triggered when a new item is added to a SharePoint list. However, the flow fails when the item contains a large attachment. What is the most likely cause?

Accepted Answer

The attachment exceeds the maximum file size allowed by Power Automate. Power Automate imposes a maximum file size limit for attachments processed within flows. When a SharePoint list item includes a large attachment that exceeds this limit, the flow fails during the approval action because the attachment data cannot be transmitted. This is a known constraint in Power Automate, typically around 100 MB for standard connectors, and is the most direct cause of the failure described.

Answer

The flow is using the wrong trigger

Answer

The approval action is not configured for attachments

Answer

The SharePoint list is not properly configured for large files

Question 9

A company has a Power Automate flow that processes incoming emails and creates tasks in Microsoft Planner. The flow includes a 'Parse JSON' action to extract information from the email body. The flow has been working correctly, but after a recent update to the email template, the flow fails with a 'BadRequest' error at the 'Parse JSON' action. What is the most likely cause?

Accepted Answer

The email body structure changed and no longer matches the JSON schema. The most likely cause is that the email body structure changed and no longer matches the JSON schema defined in the 'Parse JSON' action. The 'BadRequest' error indicates that the input provided to the action is not in the expected format, which would happen if the email template was updated. Option A is incorrect because expired credentials would cause an authentication error (e.g., 'Unauthorized'). Option C is incorrect because lack of permissions would result in a 'Forbidden' or 'Unauthorized' error. Option D is incorrect because Planner API unavailability would cause errors at the task creation step, not at the parse step.

Answer

The email connection credentials have expired

Answer

The flow does not have permission to read emails

Answer

The Microsoft Planner API is unavailable

Question 10

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

Accepted Answer

Business logic such as calculated columns and business rules. Option A is correct because Microsoft Dataverse includes built-in business logic capabilities such as calculated columns (which compute values based on other columns) and business rules (which enforce conditions or actions without custom code). These features allow creators to implement data validation and automation directly within the data platform, reducing the need for external workflows or plugins.

Answer

Ability to store unstructured data like videos

Answer

Direct embedding in Microsoft Teams without any integration

Answer

Real-time analytics dashboards

Question 11

An organization uses Power Apps to manage inventory. The app uses a SharePoint list as the data source. Users report that when two employees update the same item simultaneously, data is lost. What is the best solution?

Accepted Answer

Enable versioning on the SharePoint list and modify the app to check the last modified timestamp before update. Option D is correct because it directly addresses the root cause of data loss: concurrent updates overwriting each other. By enabling versioning on the SharePoint list, the app can retrieve the last modified timestamp before performing an update. If the timestamp has changed since the record was loaded, the app can detect a conflict and prompt the user to refresh, preventing silent overwrites. This pattern is known as optimistic concurrency control and is the standard approach for SharePoint-based Power Apps.

Answer

Switch the data source to Microsoft Dataverse

Answer

Restrict editing to one user at a time using permissions

Answer

Use Power Automate to create a flow that queues updates

Question 12

Refer to the exhibit. Which Power Platform component is being described?

Accepted Answer

Power Automate. The exhibit describes a tool that automates workflows between applications and services, such as sending notifications or synchronizing files, without requiring custom code. This is the core function of Power Automate, which uses triggers and actions to create automated processes across hundreds of connectors.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Apps

Question 13

Which Power Platform component provides a low-code platform to build custom business applications that can be embedded in Microsoft Teams?

Accepted Answer

Power Apps. Power Apps is the correct answer because it is the low-code platform within Microsoft Power Platform specifically designed for building custom business applications. These apps can be directly embedded into Microsoft Teams via the 'Power Apps' tab or personal app, allowing users to interact with the app without leaving the Teams interface.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Automate

Question 14

A company wants to analyze customer feedback from surveys stored in Excel and create interactive reports. Which combination of Power Platform components is best?

Accepted Answer

Power BI and Power Automate. Option C is correct because Power BI is the primary tool for creating interactive reports and dashboards from data sources like Excel, while Power Automate can be used to automate the ingestion or refresh of survey data from Excel into Power BI, enabling scheduled updates. Together, they directly address the requirement to analyze feedback and build interactive reports without needing custom app development.

Answer

Power Virtual Agents and Power BI

Answer

Power Apps and Power BI

Answer

Power Apps and Power Automate

Question 15

A manager wants to see a Power BI report on their mobile phone while offline. What should they do?

Accepted Answer

Use the Power BI mobile app and download the report for offline viewing. Option B is correct because the Power BI mobile app supports downloading reports for offline viewing. This feature allows users to cache a report on their device, enabling access without an internet connection. The manager can simply open the report in the mobile app and select the download option to make it available offline.

Answer

Export the report to PDF on a desktop computer

Answer

Share the report via email

Answer

Subscribe to the report to receive email updates

Question 16

A company has a Power BI dataset that refreshes daily. Users report that the report shows stale data from two days ago. What is the most likely cause?

Accepted Answer

The scheduled refresh has failed for the past two days. The most likely cause is that the scheduled refresh has failed for the past two days. Power BI datasets that rely on scheduled refresh must complete successfully to update the data; if the refresh fails, the dataset retains the last successful refresh’s data, which in this case is from two days ago. Users seeing stale data from two days ago directly indicates that the refresh has not succeeded since then.

Answer

The dataset uses DirectQuery mode

Answer

Incremental refresh is configured incorrectly

Answer

The on-premises data gateway is offline

Question 17

Which THREE actions can be performed in the Power Query Editor?

Accepted Answer

Change data types. Option B is correct because the Power Query Editor is specifically designed for data transformation and cleaning tasks. Changing data types (e.g., from text to number) is a fundamental transformation that ensures data is correctly formatted for analysis in Power BI.

Answer

Create measures

Answer

Create relationships between tables

Question 18

A user sees the exhibit error when opening a Power BI report in the service. What is the most likely cause?

Accepted Answer

The data source connection in the service was modified. The error shown in the exhibit is a typical 'Couldn't load the data for this visual' message that occurs when the data source connection defined in the Power BI service has been changed (e.g., server name, database name, or authentication method) but the report's underlying dataset still references the old connection. This mismatch prevents the service from retrieving data, even if the gateway is online and credentials are valid. Option D is correct because modifying the data source connection in the service without updating the dataset's connection string breaks the data retrieval pipeline.

Answer

The scheduled refresh failed due to credentials

Answer

The on-premises data gateway is offline

Answer

The dataset was deleted from the workspace

Question 19

Which TWO features can be used to secure data in Power BI?

Accepted Answer

Row-level security (RLS). Row-level security (RLS) is correct because it restricts data access at the row level based on user roles and filters, ensuring that users only see data relevant to them. This is a core Power BI security feature that controls data visibility without duplicating reports or datasets.

Answer

Q&A visuals

Answer

Bookmarks

Answer

Drill-through

Question 20

A retail chain uses Power Apps for an inventory management app. Employees report that the app loads slowly. What is the most likely cause?

Accepted Answer

The app uses a non-delegable query on a large data source. The most likely cause of slow loading in a Power Apps inventory management app is a non-delegable query on a large data source. When a query cannot be delegated, Power Apps retrieves all records from the data source to the client device, then filters locally, causing significant performance degradation with large datasets. This is a common issue when using functions like `Filter` with unsupported operators or columns on large tables.

Answer

The app has too many controls per screen

Answer

The app uses too many screens

Answer

The app has complex formulas in OnStart