PL-900 Practice Test 19 — 15 Questions

Question 1

Your Power Automate flow uses an HTTP action to call a REST API. The API returns a JSON array of objects. You need to process each object and create a record in a SQL Server database. Which actions should you use?

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

Accepted Answer

Use 'Parse JSON' to define the schema, then 'Apply to each' with 'Insert row' inside.. To process a JSON array of objects from an HTTP response, you first use 'Parse JSON' to define the schema so Power Automate understands the structure, then use 'Apply to each' to iterate over the array, placing the 'Insert row' action inside the loop to create a SQL record per object. This is the standard pattern for iterating and inserting.

Answer

Use 'Filter array' to select objects, then 'Insert row'.

Answer

Use 'Compose' to store the JSON, then 'Insert row' directly.

Answer

Use 'Select' to transform the array, then 'Insert row' with a batch.

Question 2

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

Accepted Answer

Create a record in Dataverse. 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 3

A hospital uses Power BI to monitor patient wait times. The data source is an on-premises SQL Server database. To ensure real-time reporting, what should the hospital deploy?

Accepted Answer

On-premises data gateway. The on-premises data gateway (Option C) is the correct choice because it acts as a bridge between Power BI in the cloud and the on-premises SQL Server database, enabling real-time or near-real-time data refreshes for dashboards. Without this gateway, Power BI cannot directly connect to on-premises data sources, making it impossible to achieve real-time reporting from the hospital's local database.

Answer

Azure Data Factory

Answer

Power BI Report Server

Answer

Power BI Desktop

Question 4

Which TWO of the following are capabilities of Power Apps that help organizations build custom business applications without writing traditional code?

Accepted Answer

Integration with Common Data Service (Microsoft Dataverse). Option A is correct because Power Apps natively integrates with Microsoft Dataverse (formerly Common Data Service), providing a built-in, scalable data platform with standardized tables, relationships, and security that lets makers build apps using data connectors and formulas instead of writing traditional code. Option B is correct because Power Apps ships with pre-built templates for common business scenarios (e.g., inspection, expense tracking, onboarding), which makers can customize through a visual designer, accelerating no-code app development. Option C is not correct for this scenario because conversational bots are built with Power Virtual Agents, not Power Apps, even though it is part of the Power Platform. Option D is not correct because event-driven automated workflows are the domain of Power Automate, not Power Apps. Option E is not correct because real-time dashboards with drill-down analytics are provided by Power BI, not Power Apps.

Answer

Natural language processing to create conversational bots

Answer

Automated workflows triggered by business events

Answer

Real-time data dashboards with drill-down analytics

Question 5

An organization plans to build a Power App that will be used by external partners. The app must allow partners to log in with their own credentials (Azure AD B2B). Which feature should be configured?

Accepted Answer

Set up Azure AD B2B guest user access. Microsoft Entra B2B (Business-to-Business) is Microsoft's feature for inviting external users as guest accounts into the organization's tenant, allowing them to authenticate with their own credentials while accessing internal resources. Configuring Microsoft Entra B2B guest user access enables external partners to sign in to Power Apps using their existing organizational identities. This matches the requirement exactly.

Answer

Use SharePoint external sharing settings

Answer

Enable anonymous access in Power Apps

Answer

Configure Azure AD B2C for the app

Question 6

A sales team uses a Canvas app to track leads. Users report that the app loads slowly when accessing on mobile devices. Which component should be optimized to improve performance?

Accepted Answer

Optimize data source connections and queries. Optimizing data source connections and queries directly reduces the amount of data transferred and the number of round trips between the Canvas app and its data source (e.g., Dataverse, SharePoint, SQL). On mobile devices, network latency and bandwidth are often constrained, so inefficient queries (e.g., loading all records instead of using filters) cause significant slowdowns. This is the primary performance lever for Canvas apps, as per Microsoft's guidance on app optimization.

Answer

Update the app version number

Answer

Increase the app icon size

Answer

Change the app's background color

Question 7

Which THREE capabilities are provided by Microsoft Dataverse? (Select three.)

Accepted Answer

Data storage with role-based security. Option A is correct because Microsoft Dataverse provides secure data storage with role-based security, including business units, security roles, and record-level sharing that control access to tables and rows. Option B is correct because Dataverse supports data integration with external systems through connectors, virtual tables, Dataflows, and the Dataverse Web API/OData endpoints, allowing data to flow in and out of external applications. Option E is correct because Dataverse enforces business logic via Power Automate flows, classic workflows, business rules, and plug-ins registered on table events, ensuring consistent processing at the platform level. Option C is not correct because AI model building is primarily provided by Azure Machine Learning and AI Builder, not as a core Dataverse capability. Option D is not correct because interactive dashboard creation is a Power BI and model-driven app feature, not a capability delivered by Dataverse itself.

Answer

AI model building

Answer

Interactive dashboard creation

Question 8

Which TWO actions can you take to improve the performance and reliability of a Power Automate cloud flow? (Choose 2)

Accepted Answer

Use parallel branches for independent actions.. Option A is correct because parallel branches let independent actions execute concurrently instead of waiting on each other, reducing overall flow run duration and improving throughput in Power Automate cloud flows. Option D is correct because 'Configure Run After' settings allow an action to run even when a previous action fails, times out, or is skipped, enabling error handling, retry logic, and graceful failure recovery that directly improves reliability. Option B is incorrect because forcing all actions to run sequentially increases run time and does not inherently prevent conflicts, so it degrades rather than improves performance. Option C is incorrect because using 'Apply to each' loops for all list operations adds unnecessary iteration overhead and can hit concurrency and throttling limits, hurting performance. Option E is incorrect because adding approval steps to all flows introduces manual delays and does not improve performance or reliability.

Answer

Set all actions to run sequentially to avoid conflicts.

Answer

Use 'Apply to each' loops for all list operations.

Answer

Add approval steps to all flows for accountability.

Question 9

Refer to the exhibit. A Power Automate flow uses the 'Microsoft Forms' connector with this output. Which AI Builder model should be used to categorize this feedback as 'AppFeedback'?

Accepted Answer

Category classification. The 'Category classification' AI Builder model is designed to assign predefined categories to text, such as classifying feedback as 'AppFeedback'. This model uses a custom trained classifier to map input text to specific labels, making it the correct choice for categorizing form responses into distinct categories like 'AppFeedback'.

Answer

Language detection

Answer

Sentiment analysis

Answer

Entity extraction

Question 10

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 11

A company has a Power Platform environment that is running low on storage. The administrator needs to free up storage without deleting important data. What should they do first?

Accepted Answer

Review storage analytics in the Power Platform admin center to identify large entities. The first step in freeing up storage without deleting important data is to identify which entities consume the most space. The Power Platform admin center provides storage analytics that break down storage usage by entity, allowing administrators to make informed decisions about data cleanup or archiving. This approach ensures that only non-essential data is targeted, preserving critical business data.

Answer

Disable auditing for all environments

Answer

Delete all audit logs

Answer

Purchase additional storage capacity

Question 12

You are a Power Platform administrator for a non-profit organization. The organization has a single environment used by volunteers and staff. A new volunteer needs to be able to run a specific Power App that manages event registrations, but should not be able to modify the app or access any other resources in the environment. The volunteer has a valid Power Apps license. You need to provide the volunteer with the minimum permissions necessary. What should you do?

Accepted Answer

Share the app directly with the volunteer. Sharing the app directly with the volunteer grants run-only access to that specific app without granting environment-wide privileges. The volunteer can use the app but cannot modify it or access other resources, satisfying the least-privilege requirement.

Answer

Create a new environment and add the volunteer there

Answer

Assign the volunteer the Environment Maker role and share the app

Answer

Add the volunteer to the System Administrator role

Question 13

A company uses Power Apps to build a canvas app for field technicians to report equipment issues. The app includes a GPS location control and requires offline capability. During a pilot, technicians report that the app fails to load data when they are in remote areas with no internet. Which design change should the app maker implement to address this issue?

Accepted Answer

Enable offline use and configure the app to cache data locally.. Enabling offline use in canvas apps allows users to load data while connected and work with cached data when disconnected. Option A is wrong because adjusting GPS settings does not affect offline data availability. Option B is wrong because Power Automate flows require connectivity and do not enable offline data storage. Option D is wrong because converting to a model-driven app does not inherently solve offline requirements unless specifically configured.

Answer

Adjust the GPS control to use high accuracy mode.

Answer

Add a Power Automate flow to sync data periodically.

Answer

Convert the canvas app to a model-driven app.

Question 14

Which TWO are common use cases for Power Automate?

Accepted Answer

Automating approval workflows. Power Automate is used for automating business processes and integrating apps. Building custom apps is Power Apps, creating dashboards is Power BI, and managing user identities is Microsoft Entra ID.

Answer

Creating interactive dashboards

Answer

Managing user access to Microsoft 365

Answer

Building custom mobile applications

Question 15

A university uses Power Apps for student registration. The app is built on Dataverse and shared with all students. Recently, a student reported that they cannot access the app and receive an error that they do not have permission. The app was working earlier. The admin checks the environment and finds that the app's sharing settings have been changed. The admin needs to restore access for all students quickly. What should the admin do?

Accepted Answer

Share the app with the 'All Students' security group in the Power Apps maker portal.. Sharing the app with the 'All Students' security group in the Power Apps maker portal restores access for all students quickly and correctly. Security groups are the recommended way to manage access at scale in Dataverse-backed apps.

Answer

Contact Microsoft Support to restore the previous sharing settings.

Answer

Assign the 'Environment Maker' role to all students.

Answer

Re-create the app from a backup.