PL-900 Describe the business value of Microsoft Power Platform — 20 Questions

Question 1

A logistics company uses Power Apps to build a fleet management app. They need to integrate real-time GPS data from IoT devices. Which connector should they use?

Accepted Answer

IoT connector. The IoT connector is specifically designed to ingest and process data from Internet of Things devices, including real-time GPS streams from fleet telematics. It provides built-in triggers and actions for handling device telemetry, making it the correct choice for integrating live GPS data into a Power Apps fleet management solution.

Answer

SharePoint connector

Answer

Dynamics 365 connector

Answer

Office 365 Users connector

Question 2

Which THREE components are part of Microsoft Power Platform?

Accepted Answer

Power Apps. The three core components of Microsoft Power Platform are Power Apps, Power Automate, and Power BI. While Power Virtual Agents is also a component, the question asks for only three, and these three are the traditional pillars.

Answer

Power Virtual Agents

Answer

Azure DevOps

Question 3

A company's IT department is overwhelmed with password reset requests. They want to allow employees to reset passwords themselves using a conversational interface. Which Power Platform tool should they use?

Accepted Answer

Power Virtual Agents. Power Virtual Agents (C) is the correct tool because it enables the creation of conversational AI chatbots that can handle password reset requests through natural language interactions. It integrates with Microsoft Entra ID and other identity systems to allow employees to securely reset their own passwords without IT intervention, reducing the helpdesk workload.

Answer

Power BI

Answer

Power Apps

Answer

Power Automate

Question 4

A non-profit organization needs to collect feedback from event attendees via a form that automatically populates a SharePoint list. Which Power Platform component should they use?

Accepted Answer

Power Apps (canvas app). The requirement is to collect feedback via a form that automatically populates a SharePoint list. Power Apps (canvas app) is the correct component because it allows building custom forms that can directly write data to a SharePoint list. Power Virtual Agents is a chatbot platform, not a form builder, so it is not suitable. Power Automate can automate workflows but does not provide a user-facing form interface, and Power BI is for analytics.

Answer

Power Virtual Agents

Answer

Power Automate

Answer

Power BI

Question 5

Match each Microsoft Dataverse security concept to its definition.

Accepted Answer

Role-based security: Controls access based on a user's role membership.. Dataverse uses role-based security as its foundation. Role-based security controls access via user roles, field-level security restricts specific attributes, row-level security governs records, and team-based security applies roles to groups. Common mistakes include confusing field-level with row-level or mixing definition of role-based security.

Answer

Role-based security: Restricts access to specific records in an entity.

Answer

Field-level security: Controls access based on user's role membership.

Question 6

A company wants to build a custom app to track inventory across multiple warehouses. The app must use existing data from a SQL Server database and provide real-time updates. Which Power Platform component should they use to connect the app to the data source?

Accepted Answer

Power Apps with a connector. Power Apps connectors provide pre-built integration with SQL Server, enabling the app to read and write data directly from the existing database. This allows real-time updates by using the SQL Server connector, which supports live queries and triggers without requiring data migration.

Answer

Microsoft Dataverse

Answer

Power BI

Answer

Power Automate

Question 7

A Power Automate flow fails when it tries to update a row in Dataverse that was modified by another user. The error indicates a 'concurrency conflict'. What is the likely cause and best solution?

Accepted Answer

The flow lacks 'Enable Retry' setting; enable it and implement retry logic. Concurrency conflicts occur when multiple users or processes attempt to update the same Dataverse record at the same time. Power Automate flows can handle these conflicts gracefully by enabling the 'Enable Retry' setting on the action and implementing appropriate retry logic. When a conflict is detected, the flow can retry the operation after a brief delay, allowing the conflicting update to complete. Option A is correct because retry logic directly addresses the concurrency conflict. Option B is incorrect because changing triggers from asynchronous to synchronous does not resolve concurrency conflicts. Option C is incorrect because increasing timeout does not prevent or resolve the conflict. Option D is incorrect because Dataverse does not have a 'Concurrency' field that can be set to 'None'; concurrency control is built-in and cannot be disabled.

Answer

The flow uses asynchronous triggers; change to synchronous

Answer

Increase the flow's timeout duration

Answer

The Dataverse table has a 'Concurrency' field; set it to 'None'

Question 8

Which THREE components are included in the Microsoft Power Platform? (Select three.)

Accepted Answer

Power Apps. Power Apps (A) is a core Power Platform component that lets users build low-code custom business apps with connectors to data sources like Dataverse and SharePoint. Power BI (B) is included in the Power Platform as its business analytics and visualization service, enabling interactive dashboards and reports. Power Automate (C) is also a core component, providing workflow and robotic process automation across services via triggers and actions. Microsoft Entra ID (D) is a separate identity and access management service (formerly Azure AD) used for authentication and conditional access, not a Power Platform component. Microsoft 365 (E) is a productivity suite that hosts and integrates with Power Platform apps, but it is not itself one of the platform's components.

Answer

Microsoft Entra ID

Answer

Microsoft 365

Question 9

A company uses Microsoft Dataverse to store customer data. They want to create a unified view of sales and support interactions for each customer. Which feature should they use?

Accepted Answer

Microsoft Dataverse. Microsoft Dataverse is the correct choice because it provides a unified, relational data store that can combine sales and support interaction data into a single customer entity. By using Dataverse tables and relationships, you can create a 360-degree view of each customer without moving data to external systems, enabling real-time insights within Power Apps or model-driven apps.

Answer

Power BI

Answer

Microsoft Copilot Studio

Answer

Power Automate

Question 10

An organization wants to implement AI-driven insights for sales forecasting using historical data. Which Power Platform capability should they use?

Accepted Answer

Power Automate with AI Builder. AI Builder within Power Automate provides prebuilt AI models (e.g., prediction models) that can analyze historical sales data to generate forecasts. This capability is specifically designed for integrating AI-driven insights into automated workflows without requiring custom machine learning development.

Answer

Power BI Quick Insights

Answer

Microsoft Copilot Studio

Answer

Power Apps with Dataverse

Question 11

You are reviewing a Power Automate flow definition. The flow should send an email when a new invoice file is added to a SharePoint folder. However, the flow is not triggering. What is the most likely cause?

Accepted Answer

The folder path '/documents/invoices' is incorrect or the flow lacks permissions.. The most likely cause is that the folder path '/documents/invoices' is incorrect or the flow lacks permissions. Power Automate triggers for SharePoint require exact folder paths and appropriate access rights to monitor file additions. If the path is misspelled, uses a relative path instead of a server-relative path, or the service account does not have read permissions on the folder, the trigger will not fire.

Answer

The email action uses an incorrect dynamic expression.

Answer

The flow needs a 'Get file content' action before sending email.

Answer

The SharePoint trigger requires a 'When a file is created or modified' trigger instead.

Question 12

A Power BI report shows a measure 'Sales Growth %' defined as above. The measure returns blank for some months even though sales data exists. What is the most likely cause?

Accepted Answer

The date table is not marked as a date table in Power BI.. When a date table is not marked as a date table in Power BI, time intelligence functions like SAMEPERIODLASTYEAR may not correctly identify the date context, causing them to return blank for certain periods even when data exists. Marking the table as a date table ensures that Power BI uses its built-in date hierarchy and calendar logic, which is required for functions that shift or compare date ranges.

Answer

The measure should use TOTALYTD instead of SAMEPERIODLASTYEAR.

Answer

The Sales table has no relationship with the Date table.

Answer

The DIVIDE function requires a third argument for alternate result.

Question 13

An organization wants to analyze customer sentiment from social media data and create interactive dashboards. Which combination of Power Platform tools should they use?

Accepted Answer

Power BI and AI Builder. Power BI can connect to data sources and create dashboards, while AI Builder can analyze sentiment. Power Automate is for workflows, and Power Apps for apps.

Answer

Power BI and Power Apps

Answer

Power Automate and Power Virtual Agents

Answer

Power Apps and Power Automate

Question 14

Refer to the exhibit. You are building a Power BI report to analyze sales performance. You create a measure named 'Total Sales' using the DAX expression shown. However, the measure returns a value that is much higher than expected. What is the most likely issue?

Accepted Answer

The measure is using SUMX without an appropriate filter context, leading to incorrect row iteration.. The DAX expression shown uses SUMX, which iterates over each row of the Sales table and sums the product of Quantity and Price. Without an appropriate filter context (e.g., from a Date table or slicer), SUMX may aggregate over the entire table, including rows that should be excluded, leading to a much higher total than expected. The issue is not a missing relationship but rather the lack of a proper filter context to restrict the rows being iterated.

Answer

The Sales table lacks a relationship to the Date table, causing incorrect time-based calculations.

Answer

The measure is being filtered by a disconnected slicer, causing overfiltering.

Answer

The measure should use DISTINCTCOUNT instead of SUMX to count sales.

Question 15

A sales team wants to track their deals in a shared workspace without using Excel. They need a solution that can be customized quickly and accessed from mobile devices. Which Power Platform component should you recommend?

Accepted Answer

Microsoft Lists. Microsoft Lists is the correct recommendation because it is a shared workspace specifically designed for tracking information like deals. It is highly customizable with columns, views, and rules, and is accessible from mobile devices through the Microsoft Lists mobile app. While it is not a core Power Platform service, it is often integrated with Power Platform solutions and is the best fit for the described scenario. Power Automate is for workflows, not for providing a shared workspace.

Answer

Power Automate

Answer

Power BI

Answer

Power Virtual Agents

Question 16

You are a Power Platform administrator. A user reports that they cannot create a new environment in the Power Platform admin center. The user has a Power Apps per user plan license. What is the most likely reason?

Accepted Answer

The user does not have a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2.. Creating environments in the Power Platform admin center requires a license that includes environment creation rights, such as Power Apps Plan 2 or Power Automate Plan 2. The user's Power Apps per user plan license only allows them to use apps and flows, not to create or manage environments. Without the appropriate license, the environment creation option is disabled in the admin center.

Answer

The user does not have access to the Power Platform admin center.

Answer

The user is not a global administrator in Microsoft Entra ID.

Answer

The user has not assigned the license to themselves.

Question 17

Refer to the exhibit. A Power Platform environment uses Data Loss Prevention (DLP) policy with this JSON snippet. What is the effect of this policy rule?

Accepted Answer

It blocks all connectors for accounts in Seattle.. The JSON snippet defines a DLP policy rule that applies to the 'Seattle' environment. It sets the connector classification to 'Blocked' for all connectors, meaning no connectors can be used in that environment. Therefore, the correct effect is that all connectors are blocked for accounts in Seattle, making option D correct.

Answer

It requires approval for connectors accessing Seattle accounts.

Answer

It allows all connectors for accounts outside Seattle.

Answer

It classifies connectors as Business for accounts in Seattle.

Question 18

An organization uses Power BI to analyze sales data. They notice that the report takes over a minute to load, and they need to improve performance quickly without changing the data source. Which action should they take?

Accepted Answer

Reduce the number of visuals on the dashboard.. Reducing the number of visuals on a Power BI dashboard directly decreases the number of queries sent to the data model and the rendering workload, which can significantly improve load times without altering the data source. This is the quickest performance optimization available when the data source cannot be changed, as each visual typically triggers separate DAX queries and rendering processes.

Answer

Change the data source to use DirectQuery instead of Import.

Answer

Implement data aggregations in Power BI.

Answer

Create a new composite model.

Question 19

Which TWO of the following are advantages of using Power BI dashboards over Power BI reports?

Accepted Answer

Dashboards can show data from multiple reports on one page.. Option A is correct because a Power BI dashboard is a single canvas that can be composed of tiles pinned from many different reports and datasets, letting you consolidate visuals from multiple sources onto one page, whereas a report is bound to a single dataset. Option C is correct because dashboards natively include the Q&A experience, allowing users to ask natural-language questions and get visuals, a capability tied to the dashboard surface rather than the report canvas. Option B is not an advantage specific to dashboards: drill down (and drill through) is a report feature, and dashboards generally offer limited interactivity such as tile focus and Q&A rather than full drill-down hierarchies. Option D is not a dashboard-only advantage because reports can also be exported to PDF, so it does not distinguish dashboards from reports.

Answer

Dashboards allow users to drill down into details.

Answer

Dashboards can be exported to PDF.

Question 20

An organization has deployed a Power Automate flow that processes sensitive customer data. The security team requires that the flow's connections use managed identities instead of user credentials. What should the administrator do?

Accepted Answer

Use managed identities for the connections where supported.. Managed identities in Power Automate allow connections to authenticate to Azure resources without storing credentials, directly addressing the security team's requirement to avoid user credentials. Managed identities are a secure, Microsoft Entra ID-backed identity that can be assigned to a flow or environment, eliminating the need for shared secrets or user context.

Answer

Share the flow with the security team and have them modify the connections.

Answer

Use a service principal with a certificate and store the certificate in the flow's environment.

Answer

Store the user credentials in Azure Key Vault and reference them in the flow.