PL-900 Describe the business value of Microsoft Power Platform Practice Test 8 — 15 Questions

Question 1

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 2

A company wants to build a custom app that allows field technicians to view and update work orders on their mobile devices, with data stored in Dataverse. Which approach minimizes development effort?

Accepted Answer

Create a canvas app in Power Apps. Using Power Apps to create a canvas app provides a low-code solution that can connect to Dataverse and be deployed on mobile devices quickly.

Answer

Use Power Automate to generate a mobile app

Answer

Build a custom iOS app using Swift and Xcode

Answer

Create a model-driven app in Power Apps

Question 3

Refer to the exhibit. You are troubleshooting a Power Automate flow that fails when trying to access an on-premises SQL Server database. The flow uses the SQL connector. Based on the exhibit, what is the most likely cause of the failure?

Accepted Answer

The flow is using the cloud SQL connector without an on-premises data gateway.. The exhibit shows a Power Automate flow using the SQL connector to access an on-premises SQL Server database. The SQL connector in Power Automate is a cloud-based connector that, by default, cannot directly reach on-premises resources. To bridge this gap, an on-premises data gateway must be installed and configured on a machine within the same network as the SQL Server, and the connector must be associated with that gateway. Without this gateway, the flow will fail with a connection error, making option B the correct answer.

Answer

The Office 365 connector is conflicting with the SQL connector.

Answer

The environment type is Production, which restricts access to on-premises data.

Answer

The region 'eastus' does not support on-premises connectivity.

Question 4

A non-profit organization wants to track donations and manage volunteers using a single system. They have limited IT staff and budget. Which Power Platform solution is most suitable?

Accepted Answer

Custom app built with Power Apps connected to Dataverse. Option B is correct because Power Apps allows building a custom app that integrates donations and volunteer management in a single system using Dataverse as the underlying data platform. This provides a low-code solution that minimizes the need for extensive IT resources and budget, while still offering relational data storage, security, and scalability suitable for a non-profit's needs.

Answer

Dynamics 365 Sales

Answer

Power Automate flows to send emails

Answer

Power BI dashboards connected to Excel

Question 5

A healthcare provider needs to ensure that only authorized users can access patient data in a Power Apps app. The app uses Dataverse. What should the administrator configure?

Accepted Answer

Assign Dataverse security roles to users. Dataverse security roles control access to tables and records. Column-level security can be used for sensitive fields. Power Platform admin center manages environments but not fine-grained data access. SharePoint permissions are irrelevant.

Answer

Configure SharePoint permissions for the app

Answer

Set environment as restricted in Power Platform admin center

Answer

Use Microsoft Entra ID conditional access policies

Question 6

Refer to the exhibit. A Power Automate flow runs hourly to retrieve new accounts from Dataverse. However, it sometimes misses records created at the exact hour boundary. What is the most likely reason?

Accepted Answer

The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs.. Option A is correct because the flow is configured to run on a recurring schedule (e.g., every hour), not as an instant trigger on record creation. When a record is created at the exact boundary between two scheduled runs, it may not be captured by the previous run (which already completed) and may not yet exist when the next run begins, especially if the flow uses a filter query based on a timestamp. This is a classic limitation of scheduled polling compared to event-driven triggers like 'When a row is added, modified, or deleted' in Dataverse.

Answer

The accounts table has a security filter that hides records from the flow owner.

Answer

The API connection to Dataverse is not authenticated properly.

Answer

The filter query uses utcNow() which may not be precise across time zones.

Question 7

A retail company wants to analyze sales data from multiple stores and create interactive reports for regional managers. Which Power Platform component should they use?

Accepted Answer

Power BI. Power BI is the correct choice because it is Microsoft's business analytics service designed for visualizing data and sharing interactive reports. The scenario requires analyzing sales data from multiple stores and creating interactive reports for regional managers, which aligns directly with Power BI's core capabilities of data integration, interactive dashboards, and report sharing.

Answer

Power Automate

Answer

Power Apps

Answer

Microsoft Copilot Studio

Question 8

An organization uses Power Automate to approve expense reports. Managers want to approve via Microsoft Teams. Which connector should be used?

Accepted Answer

Microsoft Teams. The Microsoft Teams connector allows sending approval requests and receiving responses directly within Teams. Office 365 Outlook is for email, SharePoint is for document management, and Dataverse is for data storage.

Answer

Office 365 Outlook

Answer

Dataverse

Answer

SharePoint

Question 9

A company has a Power Apps portal for external partners to submit support tickets. Partners report that they cannot see the tickets they created. The portal uses Dataverse. What is the most likely cause?

Accepted Answer

Entity permissions for the ticket table are not configured for portal users.. In Power Apps portals, visibility of Dataverse records is governed by entity permissions, not by the portal being published or the browser used. When partners cannot see tickets they created, the most likely cause is that the entity permissions for the ticket table are not configured to grant 'Read' access to the appropriate portal web roles (e.g., 'Authenticated Users' or a custom role). Without these permissions, the portal cannot query and display the records, even though the data exists in Dataverse.

Answer

The partners are using an unsupported browser.

Answer

The portal is not published to the external network.

Answer

The Dataverse environment is in maintenance mode.

Question 10

Which TWO benefits does Power Platform offer to organizations? (Choose two.)

Accepted Answer

Provides seamless integration with Microsoft 365 and Azure. Power Platform is designed to integrate deeply with Microsoft 365 and Azure, allowing organizations to extend their existing investments. For example, Power Apps can use Microsoft 365 data (like SharePoint lists or Outlook contacts) and Azure services (such as Azure Functions or Logic Apps) as connectors, enabling seamless workflows and data sharing without custom middleware.

Answer

Is free for all users with an Office 365 license

Answer

Eliminates the need for any custom development

Question 11

Which THREE components are part of Microsoft Power Platform? (Choose three.)

Accepted Answer

Power BI. Power BI is a core component of Microsoft Power Platform, providing data visualization, business analytics, and interactive dashboard capabilities. It allows users to connect to hundreds of data sources, create reports, and share insights across the organization, directly supporting the platform's goal of enabling data-driven decision-making without extensive coding.

Answer

Dynamics 365

Answer

Microsoft Copilot Studio

Question 12

Which TWO scenarios are appropriate for using Power Automate? (Choose two.)

Accepted Answer

Copying files from one SharePoint folder to another when a new file is added. Option B is correct because Power Automate includes a trigger for 'When a file is created' in SharePoint, which can initiate an automated workflow to copy that file to another folder. This demonstrates Power Automate's core strength in automating repetitive tasks across Microsoft services without manual intervention.

Answer

Creating a dashboard to visualize sales trends

Answer

Building a custom user interface for data entry

Question 13

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 14

An organization needs to create a centralized repository of business data that can be used by Power Apps, Power Automate, and Power BI. Which data storage option is designed for this purpose?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse is the correct choice because it is a low-code data platform specifically designed to securely store and manage business data used by Power Apps, Power Automate, and Power BI. It provides a common data schema, built-in business logic, role-based security, and seamless integration with the Power Platform, making it the centralized repository for business data.

Answer

SharePoint lists

Answer

Azure SQL Database

Answer

Excel Online

Question 15

Refer to the exhibit. You are reviewing a Power Apps app definition. Based on the exhibit, which connector does the app use?

Accepted Answer

Microsoft Dataverse. The exhibit shows a Power Apps app definition that includes a reference to a Microsoft Dataverse table (e.g., 'Accounts' or 'Contacts') as the data source. Dataverse is the native data platform for Power Apps, providing relational tables, business logic, and security directly within the Power Platform. The connector used is Microsoft Dataverse, which is the default connector when building canvas or model-driven apps with Dataverse tables.

Answer

Office 365 Users

Answer

SQL Server

Answer

SharePoint