PL-900 Identify foundational components of Power Platform Practice Test 1 — 15 Questions

Question 1

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 2

A business analyst wants to create a dashboard that displays real-time sales data from a SQL database and share it with the team. Which Power Platform component is best suited?

Accepted Answer

Power BI. Power BI is the correct choice because it is specifically designed for data visualization and business intelligence, enabling real-time dashboards from SQL databases via DirectQuery or live connections. It allows sharing dashboards with the team through Power BI Service, meeting the requirement for real-time sales data display and collaboration.

Answer

Power Automate

Answer

Power Virtual Agents

Answer

Power Apps

Question 3

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 4

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 5

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 6

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 7

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 8

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 9

A Power Apps app uses a canvas and connects to multiple data sources. Users complain that the app loads slowly. What is the best practice to improve performance?

Accepted Answer

Use the 'ClearCollect' function to cache data in a collection. Option A is correct because the ClearCollect function allows you to cache data from external sources into a local collection within the app. This reduces the number of round trips to the data source during user interactions, significantly improving load and response times by minimizing network latency and data source throttling.

Answer

Add more screens to distribute the load

Answer

Increase the timeout settings

Answer

Use a single data source

Question 10

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 11

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 12

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 13

Which THREE of the following are valid connectors in Power Automate? (Choose three.)

Accepted Answer

SQL Server. SQL Server is a valid connector in Power Automate because it allows direct integration with on-premises or cloud-hosted SQL Server databases via the on-premises data gateway or Azure SQL. This connector supports triggers like 'When an item is created or modified' and actions such as 'Get rows' or 'Insert row', enabling automated workflows that read and write data to SQL tables.

Answer

Google Drive

Answer

Dropbox

Question 14

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

Accepted Answer

Power Apps. Power Apps is a core component of Microsoft Power Platform, enabling users to build custom low-code applications for web and mobile without extensive programming. It integrates with other Power Platform services like Power Automate and Power BI to create end-to-end business solutions.

Answer

SharePoint

Answer

Teams

Answer

Excel

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