PL-900 Practice Test 5 — 25 Questions

Question 1

A company uses Dynamics 365 Sales and wants to automatically send a follow-up email to a customer when an opportunity is marked 'Closed Won'. They need a solution that requires no custom code. What should they use?

Accepted Answer

Power Automate. Power Automate is the correct choice because it provides a no-code workflow automation platform that can trigger a flow when an opportunity's status changes to 'Closed Won' in Dynamics 365 Sales. It uses a prebuilt connector to Dynamics 365 to send an email via the Office 365 Outlook connector, requiring no custom code or development effort.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 2

A company wants to use Power Automate to automate a business process that involves manual data entry from emails into a SharePoint list. Which component of Power Platform should be used to extract the relevant data from the email body?

Accepted Answer

AI Builder. AI Builder is the correct component because it provides prebuilt models for extracting structured data from unstructured text, such as email bodies. The 'Key Phrase Extraction' or 'Entity Extraction' models can parse email content and map relevant fields directly into a SharePoint list, eliminating manual data entry.

Answer

Power Apps

Answer

Power BI

Answer

Power Virtual Agents

Question 3

Which TWO actions are supported by Power BI to share a report with external users who do not have an Azure Active Directory (Azure AD) account in the tenant?

Accepted Answer

Publish the report to the web (embed code) and share the link.. Option C is correct because Power BI's 'Publish to web' feature generates an embed code that creates a publicly accessible URL, allowing anyone with the link to view the report without requiring an Azure AD account. This bypasses tenant-level authentication entirely, making it suitable for sharing with external users who lack Azure AD credentials in the organization's tenant.

Answer

Share the report directly by entering the external user's email address.

Answer

Export the report to PDF and share the file via a shared drive.

Answer

Send the report as an email attachment to the external user.

Question 4

Which Power Platform component allows users to create automated workflows between apps and services?

Accepted Answer

Power Automate. Power Automate is the correct answer because it is the Power Platform component specifically designed to create automated workflows between apps and services. It enables users to build flows that trigger actions across hundreds of connectors, such as sending an email when a new SharePoint item is added, without writing code.

Answer

Power BI

Answer

Power Virtual Agents

Answer

Power Apps

Question 5

A company needs to create a mobile app for field service technicians to view and update work orders. The app should work offline and sync when connected. Which type of Power App should they build?

Accepted Answer

Canvas app. A Canvas app is the correct choice because it supports offline capability via the Power Apps mobile player, which can cache data locally and sync changes when connectivity is restored. This is ideal for field service technicians who need to view and update work orders without constant internet access, as Canvas apps allow custom UI tailored to mobile scenarios and can leverage the Offline-first pattern with explicit sync logic.

Answer

SharePoint list app

Answer

Power Automate flow

Answer

Model-driven app

Question 6

A company wants to create a custom app that allows field technicians to view and update work orders from their mobile devices. The app must work offline and sync data when connectivity is restored. Which Power Platform component should be used?

Accepted Answer

Power Apps. Power Apps is the correct component because it enables the creation of custom canvas or model-driven apps that can run on mobile devices. Power Apps supports offline capability through the use of the offline profile feature, which allows users to view and update work orders without connectivity and sync changes to the underlying Microsoft Dataverse when the connection is restored.

Answer

Power Automate

Answer

Power BI

Answer

Power Virtual Agents

Question 7

Refer to the exhibit. You are reviewing an Azure Resource Manager template for a Power Platform connector. Which component is being configured?

Accepted Answer

A Dataverse connector. The exhibit shows an Azure Resource Manager (ARM) template defining a connection resource of type 'Microsoft.PowerPlatform/connectors'. This resource type specifically configures a Dataverse connector, which enables Power Platform components to connect to Microsoft Dataverse. The template includes properties like 'environment', 'apiId', and 'connectionParameters' that are unique to connector definitions, not to apps, flows, or datasets.

Answer

A Power Apps canvas app

Answer

A Power Automate flow

Answer

A Power BI dataset

Question 8

A business wants to create a chatbot that answers common IT support questions and can escalate to a human agent if needed. Which Power Platform component should be used?

Accepted Answer

Power Virtual Agents. Power Virtual Agents (D) is the correct choice because it is a Power Platform component specifically designed to create conversational AI chatbots with minimal code. It allows you to build a bot that answers common IT support questions using prebuilt topics and can seamlessly escalate to a human agent via a handoff to a live chat system or Dynamics 365 Customer Service.

Answer

Power Apps

Answer

Power BI

Answer

Power Automate

Question 9

Refer to the exhibit. A Power Automate flow fails with the error shown. What is the most likely cause?

Accepted Answer

The SharePoint connection used in the flow does not have write permissions. The error message indicates a permission issue when the flow attempts to write to the SharePoint list. Since the flow trigger and HTTP request URL are validated at design time and the SharePoint site is accessible (the flow runs but fails), the most likely cause is that the SharePoint connection used in the flow lacks write permissions on the target list or library.

Answer

The flow trigger is misconfigured

Answer

The SharePoint site is offline

Answer

The HTTP request URL is malformed

Question 10

Which data platform in Power Platform provides a secure, scalable database with built-in business logic and security?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse is the correct answer because it is the underlying data platform for Power Platform that provides a secure, scalable database with built-in business logic (such as business rules, workflows, and calculated fields) and role-based security. Unlike other options, Dataverse is designed specifically to store and manage business data with features like column-level security, auditing, and a rich metadata-driven architecture.

Answer

SharePoint

Answer

SQL Server

Answer

Excel

Question 11

A company wants to automate the process of sending a welcome email to new employees after their HR record is created in Dataverse. Which component should be used?

Accepted Answer

Power Automate. Power Automate is the correct choice because it is designed to create automated workflows that trigger on events in Dataverse, such as the creation of a new HR record. It can then perform actions like sending a welcome email via connectors (e.g., Office 365 Outlook) without manual intervention.

Answer

Power Apps

Answer

Power Virtual Agents

Answer

Power BI

Question 12

A Power BI report contains a measure that calculates year-over-year growth. The measure works correctly in Power BI Desktop but shows blank values after publishing to the service. What is the most likely cause?

Accepted Answer

The time zone settings in the service differ from Desktop. Option C is correct because time zone settings in the Power BI service can cause date-based measures like year-over-year growth to return blank values. When a measure uses functions such as SAMEPERIODLASTYEAR or DATEADD, the service may interpret date boundaries differently than Power BI Desktop, especially if the dataset uses a different time zone or if the service applies UTC conversion. This mismatch can result in no matching dates for the calculation, leading to blank results.

Answer

The dataset was deleted from the service

Answer

The user does not have permission to view the measure

Answer

The scheduled refresh is not configured

Question 13

Which TWO are valid Power BI visualization types?

Accepted Answer

Waterfall chart. Power BI includes Waterfall, Funnel, and Treemap as built-in visualization types. Waterfall charts show the cumulative effect of sequentially introduced positive or negative values, Funnel charts illustrate stages in a linear process, and Treemaps display hierarchical data as nested rectangles. Gantt charts and Scatter maps are not native Power BI visuals.

Answer

Gantt chart

Answer

Scatter map

Question 14

A sales manager wants to create a Power BI report that shows monthly sales trends and allows drilling down from year to quarter to month. Which feature should they use?

Accepted Answer

Hierarchy. A hierarchy in Power BI allows users to create a parent-child relationship between fields (e.g., Year → Quarter → Month) that enables automatic drill-down and drill-up actions in visuals. This directly supports the sales manager's requirement to view monthly trends and drill from year to quarter to month without manual configuration.

Answer

Drill-through

Answer

Bookmarks

Answer

Slicers

Question 15

Which THREE of the following are capabilities of Power Virtual Agents? (Choose three.)

Accepted Answer

Use prebuilt templates for common scenarios. Option A is correct because Power Virtual Agents provides a library of prebuilt templates for common chatbot scenarios, such as customer support or FAQ handling, which accelerates development by offering starter content and dialog structures. These templates are designed to be customized, allowing creators to quickly build functional bots without starting from scratch.

Answer

Generate interactive reports from conversation data

Answer

Automate complex workflows with conditions

Question 16

A company has a Power BI dashboard that displays real-time data from Azure Stream Analytics. Which connection type should they use?

Accepted Answer

Push dataset. Push datasets are designed for real-time streaming scenarios where data is pushed into Power BI via APIs, such as from Azure Stream Analytics. Unlike Import or DirectQuery, Push datasets support automatic refresh of streaming data without requiring a scheduled refresh, making them ideal for real-time dashboards.

Answer

Import

Answer

DirectQuery

Answer

Composite model

Question 17

A marketing team wants to share a Power BI dashboard with external partners who do not have Power BI licenses. What is the recommended approach?

Accepted Answer

Use Publish to web (public embedding). Option B is correct because 'Publish to web' creates a public embed code that allows anyone on the internet to view the dashboard without requiring a Power BI license or authentication. This is the only built-in method in Power BI that enables sharing with external users who have no Power BI Pro or Premium Per User (PPU) licenses, as it bypasses the license requirement entirely by making the report publicly accessible.

Answer

Give each partner a Power BI Pro license

Answer

Embed the dashboard in a SharePoint Online page

Answer

Share the report link directly via email

Question 18

A data analyst needs to combine data from two Excel tables that have a common column 'ProductID'. Which Power BI tool should they use?

Accepted Answer

Merge Queries. Merge Queries is the correct tool because it combines two tables by matching rows based on a common column (ProductID), similar to a SQL JOIN. This allows the analyst to bring in additional columns from one table into the other, which is exactly what is needed when data from two Excel tables must be integrated on a shared key.

Answer

Append Queries

Answer

Pivot Column

Answer

Group By

Question 19

Based on the exhibit, what is the result of the TotalQuantity measure?

Accepted Answer

45. The TotalQuantity measure uses the SUM function on the Quantity column, which aggregates all numeric values in that column. Given the data in the exhibit, the sum of the Quantity values (10, 15, 5, 15) equals 45, making option D correct.

Answer

15

Answer

50

Answer

30

Question 20

A Power BI report uses a calculated column that shows [Sales Amount] * 1.1. Users notice the column shows incorrect values after a data refresh. What is the most likely cause?

Accepted Answer

The DAX formula was edited to multiply by 1.2 instead of 1.1. Option A is correct because if the DAX formula was edited to multiply by 1.2 instead of 1.1, the calculated column would produce values 9.09% higher than expected after the refresh. This directly explains the discrepancy users observe, as calculated columns are recomputed during data refresh based on the current formula definition.

Answer

The dataset was refreshed in Import mode instead of DirectQuery

Answer

The data type of 'Sales Amount' changed from decimal to integer

Answer

The source column name changed from 'Sales Amount' to 'SalesAmt'