PL-900 Practice Test 12 — 15 Questions

Question 1

You are a Power BI administrator for a large retail company. The company has a Power BI workspace that contains a dashboard named 'Sales Overview'. The dashboard is shared with the sales team. Recently, users have reported that the dashboard is loading slowly, and some visuals show 'Data is not available' errors. The dashboard uses a DirectQuery connection to an on-premises SQL Server database. The database team confirms that the server is not under heavy load. You need to troubleshoot and resolve the issue. What should you do first?

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

Accepted Answer

Check the on-premises data gateway performance and logs for errors. The on-premises data gateway is the critical bridge between Power BI and the on-premises SQL Server when using DirectQuery. Slow loading and 'Data is not available' errors often stem from gateway performance issues, connectivity problems, or errors logged by the gateway service. Checking the gateway logs and performance metrics is the first logical troubleshooting step before making architectural changes.

Answer

Replace the DirectQuery connection with an Import connection

Answer

Ask the database team to add more indexes to the SQL Server tables

Answer

Increase the scheduled refresh frequency to every 15 minutes

Question 2

Refer to the exhibit. You are reviewing an ARM template that creates a Power Platform environment. The deployment fails with an error stating that the 'Microsoft.PowerApps/environments' resource type is not supported in the current subscription. What is the most likely reason?

Accepted Answer

The Microsoft.PowerApps resource provider is not registered in the subscription.. The error 'resource type is not supported in the current subscription' indicates that the Azure Resource Manager (ARM) deployment cannot find the Microsoft.PowerApps resource provider. This provider must be explicitly registered at the subscription level before any Power Platform environment resources can be created via ARM templates. Without registration, ARM rejects the resource type as unsupported, regardless of other template parameters.

Answer

The environment name parameter contains invalid characters.

Answer

The environmentSku 'Production' is not a valid SKU.

Answer

The location parameter is set to an unsupported region.

Question 3

Which TWO of the following are valid trigger types in Power Automate?

Accepted Answer

Instant. In Power Automate, Instant is a valid trigger type (option A): it starts a flow on demand via a manual action such as clicking a button, running from the mobile app, or invoking an HTTP request, and it is one of the three official trigger categories. Automated is also a valid trigger type (option C): it starts a flow automatically when a specified event occurs, such as a new item being added to SharePoint or a new email arriving in Outlook. The remaining options are not recognized Power Automate trigger types: Event (B) is not a trigger category (events are what automated triggers listen for), Manual (D) is not a distinct category since manual initiation falls under Instant, and Calendar (E) is not a trigger type (scheduled recurrence is configured via the Recurrence trigger, not a 'Calendar' category).

Answer

Event

Answer

Manual

Answer

Calendar

Question 4

A sales team wants to automate follow-up emails after a lead is created in Dynamics 365 Sales. Which Power Platform component should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is designed to create automated workflows that trigger actions based on events, such as sending a follow-up email when a new lead is created in Dynamics 365 Sales. It uses connectors to integrate with Dynamics 365 and email services, enabling a no-code automation that runs without manual intervention.

Answer

Power BI

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 5

Your company wants to use AI to analyze customer feedback from surveys and identify common themes. The solution should be built using Microsoft Power Platform. Which capability should you use?

Accepted Answer

AI Builder. AI Builder in Microsoft Power Platform provides prebuilt AI models, including sentiment analysis and text classification, which can analyze customer feedback from surveys to identify common themes. It integrates with Power Apps and Power Automate, enabling no-code AI capabilities.

Answer

Power Virtual Agents with a topic

Answer

Power BI with natural language queries

Answer

Power Automate with a custom connector

Question 6

A model-driven app uses a custom business process flow. Users report that they cannot progress beyond a stage even after completing all required fields. What should you check?

Accepted Answer

Whether the stage has a condition that is not being met. Business process flow stages can have conditions that must be satisfied before progressing. If a condition is not met, the user cannot move to the next stage. Option A is incorrect because stages are not locked by administrators in standard configurations. Option B is incorrect because required fields on the form may not be part of the stage condition; the condition could involve other criteria. Option C is incorrect because security roles control access to records, not the progression within a business process flow.

Answer

Whether the stage is locked by an administrator

Answer

Whether the required fields on the form are marked as business required

Answer

Whether the user has the correct security role to update the stage

Question 7

Match each solution type in Power Platform to its description.

Accepted Answer

Managed solution: A solution that is deployed to production environments and cannot be directly edited.. Managed solutions are production-ready and non-editable, while unmanaged solutions are for development and editable. The distractors swap these definitions.

Answer

Managed solution: A solution that is used for development and can be directly edited.

Answer

Unmanaged solution: A solution that is deployed to production environments and cannot be directly edited.

Question 8

Which TWO components are part of the Microsoft Power Platform? (Choose two.)

Accepted Answer

Power Virtual Agents. Power Virtual Agents (A) is a component of the Microsoft Power Platform that enables users to create intelligent chatbots using a no-code graphical interface, without requiring developers or data scientists. It integrates with Power Automate and Power Apps to extend bot capabilities, making it a core part of the platform's low-code AI offerings.

Answer

Azure DevOps

Answer

Microsoft 365

Answer

Dynamics 365

Question 9

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. A canvas app is ideal for building a simple expense report app without writing code. It allows the maker to drag and drop controls, connect to data sources, and design a custom user interface. Canvas apps are well-suited for task-specific apps like expense submission and approval.

Answer

Power Pages

Answer

Copilot Studio

Answer

Model-driven app

Question 10

A company uses Power BI to visualize sales data from Dynamics 365 Sales. A new policy requires that all data must be stored in the US region only. The Power BI tenant is currently in the default region (home region). What should the admin do to comply with the policy?

Accepted Answer

Provision Power BI Premium capacity in the US region. Provisioning Power BI Premium capacity in the US region and assigning workspaces to that capacity enforces data residency in the US. Option A is incorrect because Microsoft Entra ID location does not control Power BI data storage. Option B is incorrect because data classification labels do not enforce physical data location. Option C is incorrect because setting the workspace region is only available with Premium capacity, but without Premium capacity, the workspace region defaults to the tenant home region and cannot be changed.

Answer

Change the Microsoft Entra ID location to US

Answer

Apply a data classification label to restrict storage

Answer

Set the workspace region to US in Power BI settings

Question 11

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 Dataverse run server-side on the table regardless of which client (model-driven app, canvas app, API, or import) touches the record, so the 50% discount constraint is enforced consistently. They also work in model-driven forms without custom code and can show validation errors directly on the form. This is the standard low-code way to enforce cross-field validation on a Dataverse table.

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 12

An organization wants to build a Power Apps solution that uses AI to extract information from invoices automatically. Which feature should they use?

Accepted Answer

AI Builder. AI Builder is the correct feature because it provides prebuilt and custom AI models that can be trained to extract structured data from documents like invoices. It integrates directly into Power Apps, allowing users to add AI-powered invoice processing without writing code or managing machine learning infrastructure.

Answer

Power BI

Answer

Power Automate

Answer

Common Data Service

Question 13

A retail company uses Power Apps to build a mobile app for store managers to approve discount requests. The app must work offline and sync when connected. Which type of app should the developer choose?

Accepted Answer

Canvas app. Canvas apps are the correct choice because they support offline capability by leveraging the Power Apps offline sync feature, which allows data to be cached locally on the device and synchronized with the data source (e.g., Dataverse or SharePoint) when connectivity is restored. This makes them ideal for mobile scenarios like store managers approving discount requests in areas with intermittent connectivity.

Answer

Portal

Answer

Model-driven app

Answer

Power Automate

Question 14

A company wants to build a Power Apps solution that integrates with Microsoft Teams. They want to embed the app directly into a Teams channel. Which type of app should they build?

Accepted Answer

Canvas app. Canvas apps can be embedded directly into a Teams channel using the Power Apps app in Teams. Option B is incorrect because AI Builder is not an app type; it is a feature for adding AI models to apps. Option C is incorrect because model-driven apps are designed for data-centric business applications and, while they can be added to Teams as a tab, they are not typically embedded directly into a Teams channel like a canvas app. Option D is incorrect because Power Virtual Agents are chatbots, not the type of app needed for embedding into Teams.

Answer

AI Builder

Answer

Model-driven app

Answer

Power Virtual Agents

Question 15

An app maker creates a canvas app that uses Microsoft Dataverse as the data source. The app includes a gallery that displays all accounts. The app maker wants to filter the gallery to show only accounts where the 'City' field equals 'Seattle'. Which formula should be used in the Items property of the gallery?

Accepted Answer

Filter(Accounts, City = "Seattle"). The Filter function in Power Apps returns a table of records that satisfy a Boolean condition, which is exactly what the gallery's Items property requires. Filter(Accounts, City = "Seattle") evaluates each record in the Accounts table and returns only those where the City column equals 'Seattle'. This is the canonical delegation-friendly pattern for Dataverse-backed galleries.

Answer

Accounts(City = "Seattle")

Answer

LookUp(Accounts, City = "Seattle")

Answer

Search(Accounts, "Seattle", "City")