PL-900 Practice Questions 2 — 50 Questions

Question 1

You are a Power Platform administrator at Contoso Ltd. The company uses a Power Automate flow that monitors a SharePoint list for new items. When a new item is added, the flow retrieves data from an external CRM system via an HTTP request, then updates a second SharePoint list. Recently, the flow has been failing with a '400 Bad Request' error from the HTTP action. The CRM API endpoint and authentication are correct. The flow works for some items but fails for others. You need to identify the root cause and fix the flow. What should you do?

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

Accepted Answer

Add a 'Compose' action to sanitize the input data before the HTTP request. The 400 Bad Request error typically indicates malformed request syntax, such as invalid characters in the payload. Adding a 'Compose' action to sanitize the input data (e.g., encode special characters, remove illegal XML characters) before the HTTP request can resolve the issue. Option A is wrong because the endpoint is confirmed correct, so changing it is unnecessary and would break integration. Option C is wrong because checking for existing items addresses duplication, not malformed requests. Option D is wrong because increasing retry count only re-attempts the same failing request; it does not fix the underlying data quality issue.

Answer

Change the HTTP action to use a different API endpoint

Answer

Add a 'Condition' to check if the item already exists

Answer

Increase the retry count for the HTTP action

Question 2

A Power Pages site uses Entity Lists to display data from a Dataverse table. The requirement is that users should be able to click a row and navigate to a detail page for that record. What must be configured to enable this navigation?

Accepted Answer

Details page setting in the Entity List. The Entity List configuration includes a 'Details page' setting that allows you to specify the page to navigate to when a user clicks a row. This is commonly used to open a detail or edit form for the selected record. Option A (Page permissions) is incorrect because page permissions control access to pages, not navigation behavior. Option B (List forms) is incorrect because list forms are used for inline editing or creating new records directly within the list, not for linking to a separate detail page. Option D (Web roles) is incorrect because web roles control user access and permissions, not navigation.

Answer

Page permissions

Answer

List forms

Answer

Web roles

Question 3

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 4

An administrator reviews the JSON output from a Power Platform environment. What should the administrator be concerned about based on the data?

Accepted Answer

The API rate limit is approaching its maximum. The JSON output shows the 'RateLimitRemaining' field approaching zero, indicating that the API rate limit is nearly exhausted. Power Platform enforces per-tenant and per-user API limits to ensure fair resource usage, and hitting the limit will throttle or block further API calls, disrupting integrations and automated workflows.

Answer

The Dataverse URL is incorrect

Answer

The admin email is not configured

Answer

The environment is out of storage

Question 5

An organization has several Power Platform environments used for development and testing. They want to prevent accidental deletion of important data. What strategy should they implement?

Accepted Answer

Use the Power Platform admin center to configure environment backups and enable solution checker.. The Power Platform admin center provides automated daily backups (with a 28-day retention for production environments) and allows manual backups, which directly protects against accidental data loss. Enabling solution checker is a separate best practice for quality assurance, but the core strategy for preventing accidental deletion is leveraging the built-in backup and restore capabilities.

Answer

Regularly export all data to Excel files and store them in OneDrive.

Answer

Set environment capacity limits to prevent storage of excessive data.

Answer

Enable versioning on all SharePoint lists used by Power Apps.

Question 6

Refer to the exhibit. You see a Power Automate flow definition in JSON. What does this flow do?

Accepted Answer

It creates a lead in Dataverse when a new email arrives in the inbox.. The flow trigger is 'When a new email arrives' (inbox trigger), and the action is 'Create a new lead' in Dataverse. This means the flow automatically creates a lead record in Dataverse whenever a new email arrives in the specified inbox, without requiring any manual intervention.

Answer

It updates a lead record when an email is received.

Answer

It deletes emails after creating leads.

Answer

It sends an email when a new lead is created in Dataverse.

Question 7

You need to create a flow that runs every hour to check a SharePoint list for items with a 'Due Date' that has passed and sends a reminder email to the assigned person. Which type of flow should you create?

Accepted Answer

Scheduled cloud flow. A scheduled cloud flow runs on a recurring schedule and can include actions to query SharePoint and send email. Automated flows trigger on events, not time. Desktop flows are for desktop automation. Business process flows guide users.

Answer

Desktop flow

Answer

Automated cloud flow

Answer

Business process flow

Question 8

A company has a Power Platform environment used for development. The development team needs to deploy a solution to a test environment. What is the recommended approach?

Accepted Answer

Export a managed solution from the development environment and import it into the test environment. Managed solutions are the recommended approach for deploying to non-development environments (e.g., test, UAT, production). A managed solution locks components to prevent direct editing in the target environment, supports lifecycle management (upgrades, patches, and removal), and ensures that only the intended customizations are deployed. Exporting an unmanaged solution (Option A) would leave components editable in the test environment, breaking the managed lifecycle pattern.

Answer

Export an unmanaged solution from the development environment and import it into the test environment

Answer

Manually recreate all components in the test environment

Answer

Copy the entire development environment to the test environment

Question 9

Which TWO of the following are capabilities of Power Apps? (Choose TWO.)

Accepted Answer

Create custom business apps with low-code. Options B and D are correct. Power Apps enables users to create custom business applications with low-code or no-code development, and these apps can be embedded directly into Microsoft Teams for easy access. Option A is incorrect because building interactive dashboards and reports is a capability of Power BI, not Power Apps. Option C is incorrect as running serverless code in the cloud is done via Azure Functions. Option E is incorrect as workflow automation is the domain of Power Automate.

Answer

Build interactive dashboards and reports

Answer

Run serverless code in the cloud

Answer

Automate workflows and processes

Question 10

A sales manager wants to create a dashboard that shows sales by region and product category. The data is stored in an Excel file that is updated weekly. What is the most efficient way to ensure the dashboard reflects the latest data?

Accepted Answer

Publish the report from Power BI Desktop and schedule a daily data refresh in Power BI service. It separates the report creation (in Power BI Desktop) from the data refresh schedule (in the Power BI service). By publishing the report once and configuring a daily scheduled refresh, the dashboard automatically reflects the latest data from the Excel file without manual intervention, which is the most efficient approach for weekly updates.

Answer

Use Power BI Desktop to connect to the Excel file and publish a new report weekly

Answer

Use Power Query to merge data from the Excel file and create a composite model

Answer

Upload the Excel file to the Power BI service each week

Question 11

A company wants to enable employees to ask questions about HR policies using a conversational interface. The system should be built with minimal code. Which Power Platform capability should they use?

Accepted Answer

Microsoft Copilot Studio. Microsoft Copilot Studio (D) is the correct choice because it enables the creation of conversational AI agents with minimal code, specifically designed for building chatbots that can answer HR policy questions. It integrates with Power Platform and uses prebuilt templates and natural language understanding to handle employee queries without requiring extensive development.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate

Question 12

You are troubleshooting a canvas app that loads slowly. The app uses over 50 data sources and many formulas. Which action is most likely to improve performance?

Accepted Answer

Use delegable queries to filter data at the source. Delegable queries process filtering on the data source server, reducing the amount of data transferred to the app and improving load time. Option A is incorrect because increasing the data row limit can actually increase the amount of data loaded, worsening performance. Option C is incorrect because disabling formula-level error checking does not affect performance and can hide issues. Option D is incorrect because removing unused data sources helps reduce app size but may not be the most impactful action for slow loading due to excessive data retrieval.

Answer

Increase the data row limit for each data source

Answer

Disable the formula-level error checking

Answer

Remove unused data sources from the app

Question 13

Refer to the exhibit. You are reviewing the app definition XML for a model-driven app. Based on the exhibit, which tables are included in the app?

Accepted Answer

Account, contact, opportunity. The <component> elements list account, contact, and opportunity, which are the tables included in the app. Option A is incorrect because 'lead' is not listed among the components; Option B is incorrect because it omits 'opportunity'; Option D is incorrect because 'salesDashboard' is a dashboard component, not a table.

Answer

Account, contact, opportunity, lead

Answer

Account, contact

Answer

Account, contact, opportunity, salesDashboard

Question 14

You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?

Accepted Answer

Condition action with nested conditions. The scenario requires conditional logic to evaluate the expense amount and branch accordingly. A Condition action is ideal for the primary split (above/below thresholds), and nested conditions handle the sub-branches (e.g., condition for >$5,000 with nested approval actions, else condition for $1,000-$5,000, else no approval). Option A is incorrect because a Switch action is suitable for discrete values, not numerical ranges. Option B is incorrect because Apply to each is used for iterating over arrays, not for conditional branching. Option D is incorrect because Parallel branches execute actions concurrently and do not implement decision-based branching logic.

Answer

Switch action with cases for each range

Answer

Apply to each with a condition inside

Answer

Parallel branches for both approval paths

Question 15

Match each Power Automate trigger type to its description.

Accepted Answer

Manual: A flow that runs when a user clicks a button or selects an action.. Correct matches: Manual triggers are user-initiated, scheduled triggers run on a time schedule, and automated triggers react to events. Common confusions arise between event-driven (automated) and time-based (scheduled) triggers, as well as between manual and other types.

Answer

Manual: A flow that runs on a recurring schedule.

Answer

Scheduled: A flow that starts automatically when a new file is created.

Question 16

Refer to the exhibit. You see a configuration snippet for a Microsoft Copilot Studio bot. What is the purpose of 'triggerPhrases'?

Accepted Answer

They identify which topics the bot should use when a user says those phrases.. Trigger phrases are the phrases that activate a specific topic in a Copilot Studio bot.

Answer

They define the bot's fallback behavior.

Answer

They define the responses the bot will give.

Answer

They are used for analytics reporting.

Question 17

Which TWO actions can a Power Platform administrator perform in the Power Platform Admin Center to manage environments?

Accepted Answer

Backup an environment. The Power Platform Admin Center provides a built-in backup feature that allows administrators to create manual backups of environments. This is essential for disaster recovery and data preservation before making significant changes. Backups can be triggered on-demand and are stored for a limited retention period.

Answer

Increase the storage limit of an environment

Answer

Change an environment from production to sandbox

Answer

Add a custom connector to an environment

Question 18

A company wants to create a public-facing website for citizens to submit permit applications and track their status. The site must allow anonymous access and integrate with Dataverse for backend storage. Which Power Platform component should the company use?

Accepted Answer

Power Pages. Power Pages is designed for external-facing websites with anonymous access capabilities and Dataverse integration. Power Apps is for internal apps, Power Automate for workflows, and Power BI for analytics.

Answer

Power Automate

Answer

Power BI

Answer

Power Apps

Question 19

Refer to the exhibit. The JSON represents a Power BI dataset refresh configuration. After deployment, the refresh fails with an error indicating that the data source credentials are missing. Which step must be taken to resolve the issue?

Accepted Answer

Configure the data source credentials in the Power BI service under dataset settings. The error indicates that the data source credentials are missing in the Power BI service, not in the JSON configuration. The JSON only defines the refresh schedule and dataset parameters; credentials must be configured separately in the Power BI service under dataset settings because they are sensitive and not stored in deployment artifacts. Option B is correct because you must manually enter or update the credentials in the Power BI service to authenticate against the data source.

Answer

Add the credentials to the JSON configuration and redeploy

Answer

Set the data source privacy level to Organizational

Answer

Change the connection string to use SQL Server authentication

Question 20

Refer to the exhibit. The JSON shows a Power Platform environment's properties in an ARM template. Based on the exhibit, which statement about this environment is true?

Accepted Answer

This environment is a Production environment linked to a Sandbox environment.. The exhibit shows an ARM template with properties including 'environmentType': 'Production' and 'linkedEnvironmentId' referencing a Sandbox environment. This indicates the Production environment is linked to a Sandbox environment for data synchronization or development purposes, which is a common configuration in Power Platform for lifecycle management. The presence of a linked environment ID confirms it is not standalone, and the environment type is Production, not Sandbox.

Answer

This environment is a Standalone environment without any linked environments.

Answer

This environment is a Sandbox environment linked to a Dynamics 365 instance.

Answer

This environment is a Production environment with no data storage.