904 questions total · 13pages · All types, answers revealed
Drag and drop the steps to create a custom connector in Power Automate in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Custom connectors start from blank, define info, configure endpoints, test, then create.
Which THREE components are part of a model-driven app in Power Apps? (Choose three.)
Views define how records are listed.
Why this answer
Views, tables, and forms are core components of a model-driven app in Power Apps. Views define how records in a table are displayed in lists, tables store the data, and forms provide the user interface for viewing and editing records. These components are built on Microsoft Dataverse and are essential for structuring the app's data and user experience.
Exam trap
The trap here is that candidates often confuse canvas app components (like galleries and screens) with model-driven app components, because both are part of Power Apps but serve different app types and design paradigms.
A company plans to deploy Power Apps for field service technicians. The IT department requires that all users authenticate using their corporate credentials and that access to the Power Apps environment is restricted to users from the company's tenant only. Which configuration should the administrator use?
This ensures only tenant users can access.
Why this answer
Setting the environment security group to 'Only internal users' and disabling external sharing ensures that only authenticated users from the company's own Microsoft Entra ID (formerly Azure AD) tenant can access the Power Apps environment. This meets the IT requirement of restricting access to corporate credentials and the company's tenant only, preventing any external guest or user from another tenant from signing in.
Exam trap
The trap here is that candidates often confuse user-level security groups with tenant-level access controls, mistakenly thinking that assigning a specific security group (Option C) alone is sufficient to block external users, when in fact the environment's tenant restriction setting is required to prevent cross-tenant authentication entirely.
How to eliminate wrong answers
Option A is wrong because enabling 'Allow users from other tenants' would explicitly permit external users from different Microsoft Entra ID tenants to access the environment, violating the requirement to restrict access to the company's tenant only. Option B is wrong because setting the security group to 'All users' includes both internal and external users (if external sharing is enabled), and enabling external sharing further opens the environment to guest accounts, which contradicts the restriction policy. Option C is wrong because while assigning a security group with only specific technicians limits access to those users, it does not inherently prevent users from other tenants from being added to that group or from authenticating if external sharing is enabled; the environment-level tenant restriction is still needed to block cross-tenant access.
A Power Apps developer needs to store an image uploaded by a user in a canvas app. The app uses Microsoft Dataverse. Which column type should be used for the image?
Image columns store image data in Dataverse.
Why this answer
Image column (B) in Dataverse is designed to store images. A is for text. C is for files.
D is binary but not directly accessible.
Your company uses Power Automate to handle approvals for purchase orders. You need to create a flow that triggers when an item is added to a SharePoint list, checks if the amount exceeds $10,000, and if so, sends an approval request to the finance manager. If approved, the item status should be updated to 'Approved'. Which type of flow should you use?
Automated flows can trigger on item creation, include conditions and approvals.
Why this answer
An automated cloud flow can trigger on new SharePoint item, include a condition to check amount, use an approval action, and conditionally update the item. Desktop flows are for desktop automation. Business process flows guide users.
Instant flows need manual trigger.
The exhibit shows an action in a Power Automate flow. What does this action accomplish?
The operation is PostMessageToChannel with specified team and channel.
Why this answer
The action posts a message to the 'General' channel of the 'Marketing' team, including dynamic content from the trigger. Option A is wrong because it does not send an email. Option B is wrong because it is not a chat.
Option D is wrong because it does not create a channel.
A company has a Power BI dashboard that displays real-time data from Azure Stream Analytics. Which connection type should they use?
Push datasets allow real-time data ingestion via API.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse DirectQuery with real-time capabilities, but DirectQuery is for querying large datasets on demand, not for ingesting streaming data pushed from Azure Stream Analytics.
How to eliminate wrong answers
Option A is wrong because Import requires a scheduled refresh to pull data from a source, which cannot achieve true real-time updates from Azure Stream Analytics. Option B is wrong because DirectQuery issues queries directly to the source for each visual interaction, but it does not support streaming data from Azure Stream Analytics and is not optimized for real-time push scenarios. Option C is wrong because Composite models combine Import and DirectQuery but still rely on those underlying connection types, not supporting the push-based streaming required for real-time data from Azure Stream Analytics.
Which TWO Microsoft Power Platform solutions are designed to be used together to build a complete customer feedback analysis system that collects feedback from multiple channels, processes sentiment, and provides actionable insights?
Can process sentiment analysis from text feedback.
Why this answer
AI Builder (D) is correct because it provides pre-built AI models for sentiment analysis, which can process feedback text from multiple channels to determine positive, negative, or neutral sentiment. Power Automate (E) is correct because it orchestrates the collection of feedback from various sources (e.g., email, forms, social media) and triggers actions based on sentiment results, enabling a complete automated feedback analysis pipeline.
Exam trap
The trap here is that candidates often confuse the role of Power BI (visualization) with the need for actual sentiment processing and automation, leading them to select Power BI instead of AI Builder or Power Automate, when the question specifically requires solutions that collect, process, and provide insights—not just display them.
An organization is preparing for a Power Platform rollout. They need to ensure that only licensed users can create new environments, and that environment creation is audited. Additionally, they want to restrict which connectors can be used in production environments. Which THREE capabilities should they use?
DLP policies can block specific connectors in production environments.
Why this answer
Data Loss Prevention (DLP) policies allow administrators to block or restrict specific connectors (e.g., HTTP, custom connectors) in production environments, ensuring sensitive data is not exposed through unauthorized integrations. This directly addresses the requirement to restrict which connectors can be used in production environments.
Exam trap
The trap here is that candidates may confuse Power Virtual Agents bot (Option D) as a governance tool, but it is solely a chatbot builder with no administrative role in environment management or connector restrictions.
A Power Platform administrator needs to restrict data loss prevention (DLP) policies to prevent sensitive data from being shared with non-approved connectors. Which scope should the administrator apply?
Environment-level policies can be applied to specific environments, allowing precise control over connector use.
Why this answer
Environment-level DLP policies allow administrators to apply data loss prevention rules to specific environments, ensuring that sensitive data is not shared with non-approved connectors within that environment. This granular control is necessary when different environments have different compliance requirements, such as separating development from production data flows.
Exam trap
The trap here is that candidates often confuse environment-level with tenant-level scope, assuming that a single tenant-wide policy is sufficient, but the question specifically requires restricting only certain environments, making environment-level the precise answer.
How to eliminate wrong answers
Option A is wrong because group-level DLP policies do not exist in Power Platform; DLP policies can be scoped to environments or tenants, not to security groups. Option B is wrong because tenant-level DLP policies apply to all environments in the tenant, which is too broad if the administrator needs to restrict only specific environments while allowing others to use non-approved connectors. Option D is wrong because user-level DLP policies are not supported; DLP policies are scoped to environments or tenants, not individual users.
You have a Power Automate flow that monitors a SharePoint list for new items and then sends a custom email notification using the 'Send an email (V2)' action. The email includes an attachment from the SharePoint item. Some users report that the attachment is missing from the email. What should you check first?
Correct. The 'Get file content' action is required to retrieve the attachment binary data before passing it to the email action. Without it, the attachment will be missing.
Why this answer
The most common reason for missing attachments in a Power Automate email is that the file content has not been retrieved separately from the SharePoint list item. The 'Send an email (V2)' action does not automatically include attachments from the triggering item. You must use the 'Get file content' action to retrieve the attachment's binary data and then pass it to the email action.
Option B is not the first check because the trigger being correct does not guarantee the attachment is retrieved. Option C, while permissions can be a factor, is not the most direct cause—the flow usually has permissions, but the content needs to be explicitly fetched. Option D is incorrect because 'Send an email with options' is for approvals, not a fix for missing attachments.
A company wants to build a public-facing website that allows external users to register and submit support tickets. The site must integrate with Dataverse and support custom workflows. Which Power Platform component should they use?
Power Pages is the modern solution for external business websites.
Why this answer
Power Pages is designed for external-facing websites with low-code capabilities and seamless Dataverse integration.
A Power Automate flow runs daily to copy data from a SQL Server database to a SharePoint list. The flow fails with a 'GatewayTimeout' error. What is the most likely cause?
GatewayTimeout indicates the request exceeded the timeout limit.
Why this answer
Gateway timeout indicates the SQL query took too long. Option A is wrong because connection issues cause different errors. Option C is wrong because permission errors are 401/403.
Option D is wrong because throttling returns 429.
A marketing team wants to create a public Power Pages site to showcase upcoming events. They need to update event details frequently without developer assistance. What is the recommended approach?
Dataverse tables can be managed by business users via model-driven apps.
Why this answer
Storing events in a Dataverse table and using a list component allows non-developers to manage data directly through a model-driven app or the portal's frontend, without needing to edit code. Option A is wrong because hardcoding event details in the page source requires manual code changes each time. Option C is wrong because while a SharePoint list could be used, it is not the recommended approach for Power Pages; Dataverse is the native data source and provides better integration with Power Platform.
Option D is wrong because editing the Liquid template requires developer skills and is not a sustainable solution for frequent updates.
A company wants to automate the approval process for purchase orders. Which Power Platform component should they use?
Power Automate is the correct tool for automating approval workflows.
Why this answer
Power Automate is the correct component because it is designed to automate workflows, including approval processes for purchase orders. It can trigger actions based on events, route documents for approval, and integrate with various data sources, making it ideal for streamlining business processes like purchase order approvals.
Exam trap
The PL-900 exam often tests the distinction between building an app (Power Apps) and automating a process (Power Automate), leading candidates to mistakenly choose Power Apps because they think an approval 'app' is needed, when the actual requirement is workflow automation.
How to eliminate wrong answers
Option A is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating approval workflows. Option B is wrong because Power Virtual Agents is used to build conversational AI chatbots, not to automate backend approval processes. Option C is wrong because Power Apps is a low-code platform for building custom applications, but it does not natively handle workflow automation or approval routing; that requires Power Automate or a separate workflow engine.
Which TWO authentication providers can be configured natively in Power Pages for external user access without custom development?
Built-in enterprise identity provider.
Why this answer
Microsoft Entra ID and Microsoft account are built-in providers.
You are designing a Power Automate flow that processes approvals for expense reports. If an expense exceeds $5,000, the flow must require approval from both the manager and the finance director. If the expense is between $1,000 and $5,000, only manager approval is needed. For expenses under $1,000, no approval is required. Which control structures should you use?
Conditions allow branching based on amount ranges.
Why this answer
The scenario requires conditional logic to evaluate the expense amount and branch accordingly. A Condition action is ideal for the primary split (above/below thresholds), and nested conditions handle the sub-branches (e.g., condition for >$5,000 with nested approval actions, else condition for $1,000-$5,000, else no approval). Option A is incorrect because a Switch action is suitable for discrete values, not numerical ranges.
Option B is incorrect because Apply to each is used for iterating over arrays, not for conditional branching. Option D is incorrect because Parallel branches execute actions concurrently and do not implement decision-based branching logic.
Refer to the exhibit. This Power Automate flow is triggered manually via HTTP request. The action 'Send_approval_email' sends an email. What is a potential issue with this flow design?
There is no 'Start and wait for an approval' action; it directly sends an email.
Why this answer
The flow lacks an approval action; it only sends an email notification. To implement an approval process, a 'Start and wait for an approval' action must be included. Option A is wrong because the 'When an HTTP request is received' trigger can be used for manual or external triggers.
Option B is wrong because email actions in Power Automate authenticate via the connection, not explicit authentication parameters. Option D is wrong because the 'Send an email' action supports required parameters like To, Subject, and Body, which are not deprecated.
A model-driven app uses a custom table 'Service Request' with a status field. The business requires that when a status changes to 'Resolved', the app automatically sends an email to the requester. Which approach should be used?
This flow runs automatically when the status field changes.
Why this answer
The correct approach is to create a Power Automate flow with a trigger 'When a record is updated' and a condition on the status change to 'Resolved'. This automates the email sending when the status is updated. Option A (PCF control) requires custom development and does not automatically trigger on status change.
Option C (manual button) requires user interaction and does not trigger automatically. Option D (business rule) cannot send emails directly; business rules only modify fields or show messages.
Which THREE components are required to build a model-driven app in Power Apps? (Select three.)
Tables store the data
Why this answer
Dataverse tables provide the data foundation for model-driven apps. Option C is correct because views define which records to display and in what format. Option D is correct because forms define how data is presented for viewing or editing.
Option B is incorrect because Power Automate flows are automations, not core components of a model-driven app. Option E is incorrect because canvas app screens belong to canvas apps, not model-driven apps.
A company wants to analyze customer feedback from surveys stored in Excel and create interactive reports. Which combination of Power Platform components is best?
Power BI for reports, Power Automate for automation (e.g., refresh).
Why this answer
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.
Exam trap
The trap here is that candidates often confuse Power Apps (for building apps) with Power BI (for analytics), or assume Power Automate alone can generate reports, when in fact Power BI is the only component designed for interactive data visualization and reporting.
How to eliminate wrong answers
Option A is wrong because Power Virtual Agents is a chatbot builder for conversational interfaces, not a tool for analyzing survey data or creating interactive reports. Option B is wrong because Power Apps is for building custom applications, not for data analysis or interactive reporting; it lacks the native analytics and visualization capabilities of Power BI. Option D is wrong because Power Apps and Power Automate together can handle data entry and workflows but cannot produce interactive reports or dashboards; Power BI is essential for the reporting requirement.
Refer to the exhibit. A Power Platform admin creates a DLP policy with this JSON configuration. What is the effect?
The policy applies to environments with type Production and blocks the SharePoint connector.
Why this answer
The JSON configuration sets the SharePoint connector to 'Blocked' with the scope 'Environment', meaning it applies to all production environments. Therefore, the SharePoint connector is blocked in all production environments, including the default one, making option A correct. Option B is incorrect because the policy only blocks the SharePoint connector, not all SharePoint Online and on-premises connectors.
Option C is incorrect because the connector is blocked, not restricted to the business data group. Option D is incorrect because the policy applies to all production environments, not just the default environment.
Exam trap
The trap here is that candidates assume 'Blocked' only applies to the default environment, but the 'Environment' scope in the JSON applies the policy to all production environments, not just the default one.
How to eliminate wrong answers
Option B is wrong because the JSON configuration specifically targets the SharePoint connector, not differentiating between SharePoint Online and SharePoint on-premises; however, the policy blocks the connector entirely, not both types separately. Option C is wrong because the JSON does not assign the SharePoint connector to the business data group; it explicitly sets it to 'Blocked', which removes it from any data group. Option D is wrong because the policy applies to all production environments, not just the default environment, as indicated by the 'Environment' scope.
You want to automate a business process that requires human interaction for approval. Which type of Power Automate flow should you use?
Approval actions enable human interaction.
Why this answer
A cloud flow with an approval action (commonly called an approval flow) is designed to incorporate human approval steps in an automated process. Option A (Automated cloud flow) is triggered automatically without any manual intervention, so it does not fit the requirement for human interaction. Option B (Business process flow) provides a guided experience for users to follow a standard process but does not handle approvals.
Option C (Desktop flow) automates tasks on the desktop (RPA) and is not intended for approval workflows.
Drag and drop the steps to create a security role in Dataverse in the correct order.
Drag steps to the numbered slots on the right, or tap a step then tap a slot.
Why this order
Security roles are created in admin center, named, permissions set, then saved and assigned.
A user wants to build a chatbot to answer common IT support questions, such as password reset and software installation steps. Which Power Platform tool should they use?
Power Virtual Agents creates chatbots with minimal code.
Why this answer
Power Virtual Agents (D) is the correct tool because it is specifically designed to create conversational AI chatbots without requiring coding. It enables users to build a bot that can handle common IT support queries like password resets and software installation steps by defining topics, trigger phrases, and dialog flows, integrating with backend systems via Power Automate or connectors.
Exam trap
The trap here is that candidates may confuse Power Virtual Agents with Power Automate, thinking a chatbot requires workflow automation, but Power Automate handles backend processes, not the conversational front-end itself.
How to eliminate wrong answers
Option A is wrong because Power Apps is a low-code platform for building custom business applications (canvas or model-driven apps), not for creating chatbots. Option B is wrong because Power Automate is a workflow automation tool for orchestrating processes and integrating services, not for building conversational interfaces. Option C is wrong because Power BI is a business analytics and visualization tool for creating reports and dashboards, not for chatbot development.
A user wants to create a flow that runs when a specific button is clicked in a mobile app. Which type of flow should be used?
Correct. An instant flow is triggered manually, e.g., by a button in a mobile app.
Why this answer
An instant flow (also known as a button flow) is triggered manually by a user, such as by clicking a button in a mobile app. Option B (business process flow) is a guided process, not a manual trigger. Option C (scheduled flow) runs on a predefined schedule.
Option D (automated flow) is triggered automatically by events like email arrival or file creation, not by user interaction.
A canvas app uses a SharePoint list as its data source. The list contains over 5000 items. Users can only see the first 500 items in the app. What is the most likely solution?
Correct: Delegable filters allow querying all items.
Why this answer
Power Apps has a default delegation limit of 500 items for non-delegable queries. Using a delegable query (e.g., Filter with column that supports delegation) solves this. Changing to gallery doesn't help; increasing list size limit is not possible; switching to Dataverse avoids the issue but is a bigger change.
A marketing team wants to create a Power Pages site to allow external users to register for events. They need users to be able to sign in with their social media accounts. Which identity provider should they configure in Power Pages?
Azure AD B2C is the identity provider that supports social sign-up using Facebook, Google, and other social accounts, making it the correct choice.
Why this answer
Power Pages relies on Azure AD B2C to enable social identity providers like Facebook and Google. Configuring Azure AD B2C allows external users to sign in with social media accounts. Option C (Facebook or Google) is not directly configurable in Power Pages; instead, these providers are integrated through Azure AD B2C.
Option A (Microsoft Entra ID) is for enterprise identities, not social sign-up. Option B (Windows Server Active Directory) is an on-premises directory, unsuitable for external social logins.
Exam trap
Candidates often assume social providers like Facebook are directly configurable in Power Pages, but Power Pages requires Azure AD B2C to enable them.
A company has a legacy system that exposes a REST API. They want to build a Power App that displays data from this API and allows users to update records. Which connector should they use?
Allows calling any REST API with Azure AD authentication.
Why this answer
The HTTP with Azure AD connector can call any REST API and supports authentication, making it suitable for integrating with a legacy system that exposes a REST API. Option B is wrong because the Office 365 Users connector is designed for retrieving user profiles from Microsoft 365, not for calling custom REST APIs. Option C is wrong because the SQL Server connector is used to connect to SQL databases, not REST APIs.
Option D is wrong because the SharePoint connector is intended for interacting with SharePoint lists and documents, not for consuming REST APIs.
Which THREE of the following are core components of Microsoft Power Platform? (Select three.)
Power Automate is a core component for automation.
Why this answer
Power Automate is a core component of Microsoft Power Platform because it provides low-code workflow automation capabilities that integrate seamlessly with other Power Platform services like Power Apps and Power BI. It enables users to create automated workflows across hundreds of connectors without writing code, directly supporting the platform's goal of empowering citizen developers.
Exam trap
The trap here is that candidates often confuse Azure Logic Apps with Power Automate because both offer workflow automation, but the PL-900 exam specifically tests that Logic Apps is an Azure service, not a Power Platform core component.
A company wants to allow external users to access a Power Pages site without requiring them to sign in. Which authentication setting should be configured?
Anonymous access allows public users to view pages without signing in.
Why this answer
Enabling anonymous access in the site settings allows users to browse the Power Pages site without signing in. Option A is incorrect because configuring Microsoft Entra ID as the identity provider requires authentication. Option B is incorrect because local authentication also requires sign-in.
Option D is incorrect because creating a web role for everyone still requires authentication; web roles are for authorization after authentication.
Which Power Platform component provides a low-code platform to build custom business applications that can be embedded in Microsoft Teams?
Power Apps is the low-code app platform.
Why this answer
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.
Exam trap
The trap here is that candidates may confuse Power Automate (automation) or Power BI (analytics) with app building, but only Power Apps provides the low-code application development capability required for custom business apps in Teams.
How to eliminate wrong answers
Option A is wrong because Power BI is a business analytics and visualization tool, not an application builder; it creates reports and dashboards, not custom business apps. Option C is wrong because Power Virtual Agents is a chatbot service for creating conversational AI agents, not for building custom business applications. Option D is wrong because Power Automate is a workflow automation service for creating automated processes between apps and services, not for building custom business applications.
Which TWO of the following are benefits of using Microsoft Power Platform for business process automation? (Choose two.)
Power Platform connectors allow integration with many Microsoft services.
Why this answer
Microsoft Power Platform is designed with native connectors and deep integration with Microsoft 365 (e.g., SharePoint, Teams, Outlook) and Azure services (e.g., Azure Logic Apps, Azure Functions, Azure SQL). This allows business users to automate workflows and build apps that directly leverage existing Microsoft cloud investments without custom coding or third-party middleware.
Exam trap
The trap here is that candidates may assume Power Platform is limited to on-premises or cloud-only (Option B) or that it completely eliminates manual work (Option C), but the exam tests the understanding that it supports both environments and reduces—not eliminates—manual data entry.
Which TWO capabilities are provided by Power Automate flows?
Cloud flows automate cloud services.
Why this answer
Power Automate includes cloud flows for automating cloud services and desktop flows for legacy/desktop automation. Business process flows are part of model-driven apps, not Power Automate flows. Approval flows are a type of flow, but the question asks for capabilities, not types.
Match each Power Virtual Agents feature to its purpose.
Drag a concept onto its matching description — or click a concept then click the description.
Conversation path for a specific user goal
Extracts specific information from user input
Default response when bot doesn't understand
Transfers conversation to a human agent
Phrases that initiate a topic
Why these pairings
Power Virtual Agents uses Topics to define conversation flows, Entities to extract data, Actions to interact with external systems, and Triggers to initiate topics based on user keywords. Common confusions include swapping the roles of Topics and Entities, or Entities and Actions.
Refer to the exhibit. A Power Platform administrator creates a DLP policy as shown. What is the effect of this policy?
The policy blocks these three connectors at the tenant level.
Why this answer
The exhibit shows a Data Loss Prevention (DLP) policy configured with the 'Social media' category set to 'Blocked' for all environments. This means the Facebook, Twitter, and LinkedIn connectors are explicitly blocked tenant-wide, preventing their use in any environment (production, sandbox, or default). Option C correctly identifies this outcome.
Exam trap
The trap here is that candidates may confuse 'Blocked' with 'Non-Business' or assume the policy only applies to production environments, when the exhibit explicitly shows 'All environments' selected.
How to eliminate wrong answers
Option A is wrong because the policy blocks these connectors in all environments, not allows them. Option B is wrong because the policy only blocks the specific social media connectors listed (Facebook, Twitter, LinkedIn), not all social media connectors (e.g., Instagram or YouTube are not included). Option D is wrong because the policy is set to apply to 'All environments' (as shown in the exhibit), not just production environments.
You need to design a Power Automate flow that sends a welcome email to a new user immediately after their account is created in Microsoft Entra ID. Which trigger should you use?
This trigger fires when a new user is created.
Why this answer
'When a user is added' triggers when a new user is created. Option A is wrong because it triggers when a user is deleted, not created. Option B is wrong because it triggers when a group is added, not a user.
Option C is wrong because it triggers when a user is updated, not created.
Which TWO scenarios are appropriate for using Power Automate? (Choose two.)
Automating file management is a typical Power Automate flow.
Why this answer
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.
Exam trap
The trap here is that candidates confuse Power Automate with Power BI or Power Apps, mistakenly selecting options that involve visualization or UI creation, when the exam specifically tests the ability to identify automation scenarios that rely on event-driven triggers and actions.
A Power Pages site uses a custom Liquid template to display a list of upcoming events. The events are stored in a Dataverse table with a date field. The template should only show events that occur in the future. Which Liquid filter or condition is most appropriate?
This allows you to filter events by comparing each event's date to the current date using Liquid operators.
Why this answer
Liquid does not have a built-in date comparison filter like 'where_exp'. Instead, you can use the `assign` tag to store the current date/time, then use an `if` condition inside a `for` loop to compare each event date to the current date. Option C is correct because this approach allows dynamic comparison within the loop.
Option A is incorrect because the `where` filter does not support dynamic date comparisons; it can only compare static values. Option B is incorrect because the `date` filter is used for formatting dates, not for filtering. Option D is incorrect because `group_by` groups events by a field but does not filter based on date.
A retail company uses Power Pages to host a customer portal where users can view their order history and return items. The portal uses Dataverse for data storage and Microsoft Entra ID (formerly Azure AD) for authentication. The company wants to add a chatbot on the portal to answer common questions about returns and shipping. The chatbot should be able to look up order details from Dataverse when the user is authenticated. You need to implement this with minimal custom development. What should you do?
Correct. Copilot Studio provides a low-code chatbot creation experience with native Dataverse connectivity and Power Pages embedding, meeting the requirement for minimal custom development.
Why this answer
Microsoft Copilot Studio is the recommended low-code solution for creating chatbots that can be embedded directly into Power Pages. It supports Dataverse as a data source and respects existing Microsoft Entra ID authentication. This approach requires minimal custom development.
Option C (QnA Maker) is deprecated and does not provide native Dataverse integration for dynamic data retrieval—it only handles static FAQ content. Option B (Power Apps and Power Automate) would require building a custom chat interface from scratch, significantly increasing complexity. Option D (Azure Bot Service with Bot Framework SDK) involves extensive development, which contradicts the requirement for minimal custom development.
Exam trap
The question specifies 'minimal custom development'. Candidates often incorrectly choose Azure Bot Service (Option D) because it is a common chatbot technology, but it requires significant SDK development. Copilot Studio is the correct low-code solution that integrates seamlessly with Power Pages.
You are a Power Apps developer at Contoso Ltd. The company uses Microsoft 365 E5 licenses and has a complex environment with multiple departments. The HR department needs a canvas app to manage employee onboarding. The app must connect to a SharePoint Online list containing employee records, and also to the Microsoft Graph API to retrieve manager information. The app should be accessible to HR staff only, who are in a security group named 'HR-Staff'. You need to design the app to ensure data security and minimize licensing costs. The app will be used by 50 HR staff members. You have the following options: A) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with the 'HR-Staff' security group. B) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with individual users. C) Create a canvas app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the HTTP connector with custom authentication. Share the app with individual users. D) Create a model-driven app using Power Apps, connect to SharePoint via the SharePoint connector and to Microsoft Graph via the Microsoft Graph connector provided in Power Apps. Share the app with the 'HR-Staff' security group. Choose the best option.
Incorrect. This is a canvas app with HTTP connector and individual user sharing, which is inefficient and complex. The Microsoft Graph connector is not used.
Why this answer
Model-driven apps support sharing with security groups natively, simplifying access management for the 50 HR staff members. The Microsoft Graph connector provided in Power Apps offers a simpler and more secure integration than the HTTP connector with custom authentication. Option C (model-driven app with Microsoft Graph connector and security group sharing) meets both requirements efficiently.
Option D (model-driven app with individual sharing) is less efficient for managing 50 users. Option A (canvas app with HTTP connector and individual users) introduces complexity and lacks native group sharing. Option B (canvas app with HTTP connector and security group) requires premium licensing for group sharing and uses a custom connector, increasing cost and complexity.
Exam trap
Candidates may be tempted to choose a model-driven app with individual sharing (Option D) thinking that model-driven is sufficient, but the requirement for simplifying access management for 50 users makes sharing with the HR-Staff security group essential. Option C is the best practice.
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?
Year-over-year calculations often depend on date functions that are sensitive to time zone.
Why this answer
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.
Exam trap
The trap here is that candidates often assume blank values are caused by missing data or permissions, but the real issue is the subtle difference in time zone handling between Power BI Desktop and the Power BI service, which is a frequent source of confusion in PL-900 exam questions.
How to eliminate wrong answers
Option A is wrong because if the dataset were deleted from the service, the report would not load at all or would show a data source error, not just blank values in a specific measure. Option B is wrong because permission settings control access to the report or dataset, not the visibility of individual measures; if a user lacks permission, they would typically see an error or be unable to open the report, not blank measure values. Option D is wrong because scheduled refresh affects data freshness, not the correctness of measure calculations; a measure that works in Desktop will still compute correctly in the service even without refresh, as long as the data is present.
You are creating a flow that should run only when a button is pressed in a mobile app. The flow will send an email to a manager with the current location of the user. Which type of flow should you create?
Instant flows can be triggered from a button or app.
Why this answer
An instant cloud flow can be triggered from a button or app. Automated flows trigger on events. Scheduled flows run on schedule.
Desktop flows are for desktop automation.
A company uses Power BI to visualize sales data from Dynamics 365. The sales team needs to see real-time updates when a deal is closed. Which Power Platform component should be used to trigger a notification when a deal is won?
Power Automate can be triggered by a Dynamics 365 event and send a notification.
Why this answer
Power Automate can trigger a flow when a deal is won in Dynamics 365 (e.g., using the 'When a record is updated' trigger filtered to the 'Close Date' field or status change to 'Won'). The flow can then send a real-time notification (e.g., email, Teams message, or push notification) to the sales team, meeting the requirement for immediate updates without manual intervention.
Exam trap
The trap here is that candidates often confuse Power BI's real-time dashboard capability (which can refresh data every few seconds) with the ability to trigger notifications, but Power BI lacks event-driven automation—only Power Automate can initiate actions based on a record change.
How to eliminate wrong answers
Option A is wrong because Power BI real-time dashboards display data visualizations that refresh automatically, but they cannot trigger notifications or send alerts based on a specific event like a deal being won; they are passive reporting tools. Option B is wrong because Copilot Studio chatbots provide conversational AI interactions but lack native event-driven triggers to monitor Dynamics 365 records and send notifications upon status changes; they require an external trigger (e.g., Power Automate) to initiate actions. Option D is wrong because Power Apps canvas apps are custom user interfaces for data entry or display, but they cannot autonomously monitor database changes and push notifications; they rely on Power Automate or other services for event-driven alerts.
A company wants to build a public-facing website for citizens to submit permit applications and check status. They need to integrate with an existing Microsoft Dataverse database and support anonymous access for browsing but require authentication for submissions. Which TWO features of Power Pages should they use?
Power Pages supports anonymous access for public-facing pages.
Why this answer
Power Pages offers two key features for this scenario. Anonymous page access (Option A) allows public browsing without authentication, and Dataverse as the backend data source (Option B) enables storing and retrieving permit applications and statuses. Azure AD B2C (Option C) is an optional identity provider but not required because Power Pages includes built-in authentication for submissions.
Power Automate (Option D) is a separate automation tool, not a page feature. Power BI (Option E) is for analytics, not form submission. Therefore, only Options A and B are correct.
A team is building a customer service solution using Power Apps and Dataverse. They need to ensure that customer data is synchronized with Dynamics 365 Customer Service. Which approach should they use?
Dataverse is the underlying data platform for Dynamics 365 and Power Apps, providing native synchronization.
Why this answer
Using Dataverse as the common data store and connecting both Power Apps and Dynamics 365 to it ensures real-time synchronization. Direct integration via custom APIs is possible but not best practice. Power Automate flows can also sync, but Dataverse is the recommended approach for Dynamics 365.
You have a canvas app that uses a SharePoint list as its data source. The app needs to filter records based on the current user's email. Which function should you use in the Items property of the gallery?
User().Email returns the current user's email address.
Why this answer
The User() function returns a record with the current user's details, including Email. Option A is incorrect because the Search function is used for searching text across multiple columns, not for filtering by exact match. Option B is incorrect because CurrentUser is not a valid function; the correct syntax is User().Email.
Option D is incorrect because Lookup returns a single record, not a filtered set of records.
You need to automatically send an email notification when a new file is added to a SharePoint document library. Which trigger should you use in a Power Automate cloud flow?
Correct. This trigger fires when a new file is created in the SharePoint document library.
Why this answer
The 'When a file is created' trigger is designed to start a flow when a new file appears in a SharePoint library. Option A is wrong because 'When a file is deleted' triggers on file removal, not creation. Option B is wrong because 'When a file is modified' triggers on updates, not new files.
Option D is wrong because 'When a file is created or modified' includes modification events, which are not required for the specified requirement.
A real estate agency wants to provide a portal where tenants can submit maintenance requests online. The portal should allow tenants to track the status of their requests. The agency staff should be able to update the status and assign work orders to contractors. The agency uses Microsoft 365 and has Power Platform licenses. What should they use?
Power Pages allows anonymous external access, model-driven app for staff, Dataverse for data, Power Automate for notifications.
Why this answer
It uses Power Pages to create an external-facing portal for tenants to submit and track maintenance requests, Dataverse as the underlying data store for all request data, Power Automate to send notifications (e.g., status updates), and a Power Apps model-driven app for staff to manage requests and assign work orders. This combination provides a secure, low-code solution that leverages the existing Microsoft 365 and Power Platform licenses.
Exam trap
The trap here is that candidates often confuse Power Apps canvas apps (for internal users) with Power Pages (for external users), and overlook that Dataverse is the required common data platform for both the portal and the staff app.
How to eliminate wrong answers
Option A is wrong because a Power Apps canvas app for tenants would require each tenant to have a Power Apps license or be part of the same tenant, which is not practical for external users; Power Pages is designed for external-facing portals. Option B is wrong because AI Builder is not needed for simple request tracking and status updates, and Power Automate alone cannot provide a user interface for tenants to submit and track requests. Option C is wrong because Power BI is a reporting tool, not a portal for tenants to submit requests or track status interactively; it also lacks the ability for tenants to create new records.
Which Power Platform component allows users to create automated workflows between apps and services?
Power Automate automates workflows.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse Power Automate with Power Apps, thinking both can automate workflows, but Power Apps is for building user interfaces and logic within an app, not for cross-service automation.
How to eliminate wrong answers
Option B is wrong because Power BI is a business analytics tool for visualizing data and creating reports, not for automating workflows. Option C is wrong because Power Virtual Agents is used to create conversational AI chatbots, not to build automated workflows between apps and services. Option D is wrong because Power Apps is a low-code platform for building custom applications, not for creating automated workflows.
Match each Common Data Service (Dataverse) term to its description.
Drag a concept onto its matching description — or click a concept then click the description.
Logical structure that stores data
Field that holds a specific type of data
Individual record in a table
Link between tables
Container for apps, flows, and data
Why these pairings
The correct matches are Entity with 'container for records' and Attribute with 'field in an entity'. Common confusions include swapping Entity with Attribute and Relationship with Solution.
You are creating a canvas app for expense reporting. The app must allow managers to approve or reject expenses using a dropdown. Which control should you use for the approval action?
Dropdown works well for a short list of options.
Why this answer
A dropdown is ideal for selecting from a short list. Option A is wrong because radio buttons are better for 2-3 options. Option C is wrong because text input is for free text.
Option D is wrong because slider is for numeric ranges.
Refer to the exhibit. A developer is creating a model-driven app based on a custom Dataverse table defined by this JSON. The app needs a form that shows the Approved field only when the amount is greater than 1000. Which feature should the developer use?
Correct. Business rules allow showing/hiding fields based on conditions without code.
Why this answer
Business rules can show or hide fields based on conditions without requiring code. Option A is correct because business rules are designed for declarative logic in model-driven apps, such as showing the Approved field only when Amount > 1000. Option B is incorrect because form scripting requires JavaScript, which is not necessary here.
Option C is incorrect because workflow processes handle backend logic, not form behavior. Option D is incorrect because Power Automate flows are for automation outside of forms.
A healthcare organization is developing a Power Apps model-driven app for patient case management. The app uses Microsoft Dataverse as the data source and includes a custom table named 'Patient Cases' with columns: Patient Name, Case Type (choice: Consultation, Procedure, Follow-up), Assigned Doctor, Status (choice: New, In Progress, Completed), and Priority (choice: Low, Medium, High, Critical). The organization requires that when a case is created with Priority = 'Critical', an immediate notification must be sent to the Assigned Doctor via Microsoft Teams and the case must be automatically escalated to the manager if not resolved within 4 hours. Additionally, the app must use a Copilot to summarize patient history when a case is opened. The security team mandates that only doctors and managers can view cases assigned to them, and that all data access must be audited. Which combination of features should you implement to meet all requirements with minimal custom development?
Correct: Owner teams restrict access to assigned records, JavaScript calls Power Automate for notifications/escalation, custom Copilot page provides summarization, and auditing is enabled via settings. This uses minimal custom development.
Why this answer
It uses owner teams to provide record-level security, ensuring that doctors and managers only see cases assigned to them. JavaScript can call a Power Automate flow to send immediate Teams notifications when Priority is Critical, and the flow can implement a 4-hour escalation timer. Adding a custom Copilot page provides patient history summarization.
Auditing can be enabled via Power Apps settings. This combination meets all requirements with minimal custom development. Option B is incorrect because field-level security profiles control access to specific fields, not record visibility; they cannot restrict users to only seeing records assigned to them.
Option C is incorrect because sharing permissions are not designed for role-based, record-level access control; they are for ad-hoc sharing. Option D is incorrect because business rules cannot trigger notifications or set timers; they are for simple logic within forms.
A company uses Power Platform with Microsoft Dataverse. The administrator notices that a user can create a new environment without approval. The company wants to enforce a process where all environment creation requires administrator approval. What should the administrator configure?
Disabling this setting prevents users from creating environments without administrator action.
Why this answer
The 'Create personal productivity environments' setting in the Power Platform admin center controls whether users can create their own environments without requiring administrator approval. Disabling this setting enforces a process where all environment creation must go through an administrator, aligning with the company's requirement for approval-based environment provisioning.
Exam trap
The trap here is that candidates often confuse environment creation controls with capacity management or security policies, leading them to select DLP policies or conditional access instead of recognizing that the specific admin setting for personal productivity environments directly addresses the approval requirement.
How to eliminate wrong answers
Option A is wrong because Data Loss Prevention (DLP) policies are used to control data movement between connectors and prevent data leakage, not to manage environment creation permissions. Option C is wrong because conditional access policies in Microsoft Entra ID control user authentication and access to applications based on conditions like location or device compliance, not environment creation within Power Platform. Option D is wrong because reducing tenant-level environment capacity limits restricts the total storage or database capacity available across environments but does not prevent users from creating new environments or enforce an approval workflow.
A developer is creating a custom control using Power Apps Component Framework (PCF). After importing the solution, the control appears but does not show any data. What is the most likely issue based on the exhibit?
Correct: The control expects data but no dataset property is configured.
Why this answer
The 'abilities' section indicates the control expects a dataset, but the only property defined is a single line of text. The control likely needs a dataset property to receive data. The version, namespace, and display key are not causing data issues.
A Power Pages site allows external vendors to register and submit invoices. The site uses Microsoft Entra ID for authentication. Recently, some vendors reported they cannot log in and receive an error about insufficient permissions. What is the most likely cause?
Guest users must be added to the tenant to authenticate.
Why this answer
When using Microsoft Entra ID, the vendor must be invited as a guest user in the tenant, and if not, they will get an access error. Option A is wrong because the issue is about authentication, not licensing. Option C is wrong because cookies are not the primary issue.
Option D is wrong because the identity provider is configured.
Which THREE of the following are capabilities of AI Builder within Power Platform? (Choose three.)
AI Builder can recognize text using OCR.
Why this answer
AI Builder includes a prebuilt model for text recognition (OCR) that can extract printed and handwritten text from images and PDFs. This capability is part of the AI Builder category of prebuilt models, which are ready to use without requiring custom training.
Exam trap
The trap here is that candidates may confuse AI Builder's ability to train custom models (which is limited to specific templates) with full custom machine learning model development from scratch, which is not supported.
Refer to the exhibit. A Power BI developer imported the JSON data into a Power BI data model. When creating a report, they notice that the 'Sales' table does not display the product name. What is the most likely cause?
The relationship must be active and correctly set to retrieve related product names.
Why this answer
The most likely cause is that the relationship between the Sales and Product tables is either inactive or misconfigured. In Power BI, even when a relationship exists, if it is set to inactive (e.g., using a bidirectional filter or a different cardinality), the report will not automatically propagate the ProductName from the Product table to the Sales table. This prevents the product name from displaying in the report, even though the data is present in the model.
Exam trap
The trap here is that candidates often assume any defined relationship automatically works for all visuals, but Power BI requires the relationship to be active (solid line) for implicit measures and visual filters to propagate correctly, and inactive relationships are a common source of missing data in reports.
How to eliminate wrong answers
Option A is wrong because if no relationship were defined, Power BI would not allow any cross-filtering between tables, but the question states the Sales table exists and the issue is specifically with the product name not displaying, implying a relationship likely exists but is not functioning correctly. Option B is wrong because Power BI can combine data from different sources (e.g., SQL Server and Excel) into a single data model without issue, as long as relationships are properly defined; the source origin does not inherently prevent a column from displaying. Option C is wrong because if the ProductName column were missing from the Product table, the column would not appear in the field list at all, but the question implies the column exists (the developer expects it to display), so the problem is with the relationship, not the column's existence.
A government agency needs to modernize a paper-based permit approval process. The solution must enforce strict access control, provide an audit trail, and allow citizens to submit applications online. The agency uses Microsoft 365 and has a Power Platform license. Which approach should they take?
Power Pages handles external submissions, Dataverse provides audit and security, Power Automate manages approvals.
Why this answer
It combines Power Pages for external citizen-facing submission portals, Dataverse for secure, auditable data storage with role-based access control, and Power Automate for automated approval workflows. This architecture meets all requirements: strict access control (Dataverse roles), audit trail (Dataverse change tracking and auditing), and online citizen submissions (Power Pages).
Exam trap
The trap here is that candidates often assume Power Apps canvas apps can serve as an external citizen portal, but they require internal user licenses and cannot be accessed anonymously, whereas Power Pages is specifically designed for external-facing, authenticated self-service portals.
How to eliminate wrong answers
Option A is wrong because AI Builder for paper forms does not address the need for online citizen submissions or provide a built-in audit trail; SharePoint lacks the granular access control and auditing capabilities of Dataverse. Option B is wrong because a model-driven app for staff and a canvas app for citizens still requires a separate data source and does not inherently provide a secure external submission portal; Power Apps canvas apps are not designed for anonymous external user access without additional licensing and configuration. Option C is wrong because Power BI is a visualization tool, not a submission or storage platform, and Power Automate alone cannot enforce strict access control or provide a persistent audit trail without a backing data store like Dataverse.
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?
Copilot Studio enables building no-code chatbots.
Why this answer
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.
Exam trap
The trap here is that candidates may confuse Power Apps' low-code app-building capability with conversational interfaces, but Power Apps is designed for form-based and canvas apps, not for natural language dialog flows like those built with Copilot Studio.
How to eliminate wrong answers
Option A is wrong because Power BI is a business analytics tool for data visualization and reporting, not for building conversational interfaces. Option B is wrong because Power Apps is a low-code platform for building custom applications with user interfaces and logic, but it is not optimized for conversational AI or chatbot creation without significant additional components. Option C is wrong because Power Automate is a workflow automation tool for orchestrating processes and integrations, not for creating conversational agents that understand natural language.
Which THREE of the following are true about model-driven apps? (Choose THREE.)
Security is enforced through Dataverse roles.
Why this answer
Options B, C, and D are correct. Model-driven apps are built on Microsoft Dataverse, have built-in role-based security, and are responsive across devices. Option A is incorrect because model-driven apps do not require custom formulas; they use declarative logic and business rules.
Option E is incorrect because model-driven apps work on both web browsers and mobile devices.
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?
Hierarchy allows users to drill down from year to quarter to month in a visual.
Why this answer
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.
Exam trap
The trap here is that candidates often confuse drill-down (hierarchy-based expansion within a visual) with drill-through (page-level navigation), leading them to select drill-through when the question explicitly asks for drilling down from year to quarter to month.
How to eliminate wrong answers
Option B is wrong because drill-through is used to navigate from one report page to another filtered by a specific data point, not to drill down within a single visual across hierarchical levels. Option C is wrong because bookmarks capture a specific state of a report page (e.g., filters, slicers, visual selections) for navigation or storytelling, but they do not create a hierarchical drill-down path. Option D is wrong because slicers are visual filters that allow users to filter data by selecting values, but they do not provide a drill-down capability from year to quarter to month within a chart.
You are building a model-driven app for a healthcare organization to manage patient appointments. The app uses a Dataverse table 'Appointments' with columns: Patient (lookup to Contact), Doctor (lookup to User), AppointmentDate, Status (Scheduled, Completed, Cancelled). You need to ensure that doctors cannot view appointments of other doctors. Doctors belong to a security role 'Doctor'. Which approach should you use? A) Create a team with all doctors and share the app with the team. B) Configure field-level security to hide the Doctor field. C) Use hierarchy security to limit access based on the Doctor field. D) Create a custom role with record-level security and configure sharing to only allow doctors to see their own appointments.
Record-level security can restrict access to records where the user is the owner or a related user.
Why this answer
By creating a custom security role with record-level security, you can configure sharing so that doctors only see appointments where the Doctor field equals themselves. Option A: Field-level security hides the Doctor field from the form but does not filter records; doctors could still see all appointments. Option C: Creating a team and sharing the app provides app access but does not restrict data visibility; all doctors would see all appointments.
Option D: Hierarchy security is for manager-subordinate relationships, not for filtering by a specific field like Doctor.
Your organization uses Power Automate to synchronize data between Salesforce and Dataverse. The flow runs successfully for most records, but some records fail with a 'duplicate record' error in Dataverse. You need to prevent duplicate records from being created. What should you do?
Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates.
Why this answer
Configuring duplicate detection rules in Dataverse and using the 'Create a new record' action with duplicate detection enabled will prevent duplicates. Option B is wrong because the 'Compose' action is used to create variables and does not check for duplicates. Option C is wrong because using 'Update a record' requires an existing record; it does not prevent creation of duplicates.
Option D is wrong because using 'Delete a record' before creating a new one is not a standard method to handle duplicate detection and may cause data loss.
A user wants to create a simple app to track personal expenses using an Excel file stored in OneDrive. Which Power Apps approach should they use?
Correct: Canvas apps can use Excel as a data source.
Why this answer
A canvas app can be created directly from an Excel file stored in OneDrive using the Power Apps 'Start from data' option. This generates a three-screen app (browse, detail, edit) that connects to the Excel table via the OneDrive for Business connector, making it ideal for simple personal expense tracking without requiring Dataverse or custom development.
Exam trap
The trap here is confusing Power Automate's mobile app trigger (e.g., button in Power Automate mobile) with the ability to build a full mobile app interface, leading candidates to choose D instead of recognizing that only canvas apps provide a user-facing UI from Excel.
How to eliminate wrong answers
Option B is wrong because Power Pages is designed for external-facing websites with authentication and complex data sources, not for creating a simple personal app from an Excel file. Option C is wrong because model-driven apps require Dataverse, which is overkill for a single Excel file and demands a premium license and structured data modeling. Option D is wrong because Power Automate is an automation platform, not an app-building tool; it cannot create a mobile app interface—it can only trigger flows or generate notifications.
A Power Automate flow uses the 'Parse JSON' action to process incoming webhook data. The flow fails with the error 'Invalid JSON' when the webhook sends data. You review the sample payload used to generate the schema and notice the webhook sometimes includes additional optional fields. What is the most likely cause?
Extra fields cause schema mismatch.
Why this answer
The 'Parse JSON' action uses a schema generated from a sample payload. If the sample did not include optional fields that the webhook sometimes sends, those fields are not defined in the schema, causing the action to fail with 'Invalid JSON'. Option B is incorrect because the flow receives the data before parsing; the issue is with the schema, not timing.
Option C is incorrect because the webhook is sending valid JSON—the error occurs only when the JSON contains fields not in the schema. Option D is incorrect because a missing nested object would cause a different error related to missing property, not 'Invalid JSON'.
A company uses a Power App to track inventory. The app displays a gallery of items filtered by a dropdown. When the user selects 'Electronics', the gallery shows all electronics items. However, after the user clears the dropdown, the gallery remains empty. What is the most likely reason?
When no selection, Dropdown.Selected.Value is blank, filter returns no items
Why this answer
When the dropdown is cleared, Dropdown.Selected.Value becomes blank. The gallery's Items property uses a filter that references this value, so the filter returns blank (no items), causing the gallery to be empty. Option A is incorrect because AllowEmptySelection set to false would prevent clearing, not cause emptiness after clearing.
Option B is incorrect because the data source does not require a refresh; the issue is the filter logic. Option D is incorrect because OnStart is not involved in the clearing behavior.
Refer to the exhibit. The JSON shows a table permission configuration for a Dataverse table in Power Pages. A user who is authenticated but not assigned to any custom web role visits the site. What operations can this user perform on the table?
All three operations are allowed for Authenticated Users.
Why this answer
The 'Authenticated Users' web role is granted to all authenticated users by default, so the user has Create, Read, and Update permissions.
A data analyst needs to combine data from two Excel tables that have a common column 'ProductID'. Which Power BI tool should they use?
Merge Queries joins tables based on a common column, similar to SQL JOIN.
Why this answer
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.
Exam trap
The trap here is that candidates confuse Append (stacking rows) with Merge (joining columns), often choosing Append because they think 'combining' always means adding rows, not realizing the requirement is to align data horizontally on a shared key.
How to eliminate wrong answers
Option A is wrong because Append Queries stacks rows from two tables on top of each other, requiring identical column structures, and does not combine data based on a common column. Option C is wrong because Pivot Column transforms unique values from a column into new columns, aggregating data, not merging two separate tables on a key. Option D is wrong because Group By aggregates rows based on a column, creating summary statistics, and does not combine data from two different tables.
Which THREE actions can be performed in the Power Query Editor?
Power Query Editor allows changing data types.
Why this answer
The Power Query Editor is specifically designed for data transformation and cleaning tasks. Changing data types (e.g., from text to number) is a fundamental transformation that ensures data is correctly formatted for analysis in Power BI.
Exam trap
The trap here is that candidates confuse the Power Query Editor's data transformation role with the data modeling and DAX capabilities of Power BI Desktop, leading them to incorrectly select options like creating measures or relationships.
Which TWO components of Microsoft Power Platform are primarily used to create and deploy custom business applications without writing code?
Power Apps is a core component for building custom app interfaces without code, making it correct.
Why this answer
Power Apps is a low-code platform for building custom app interfaces with drag-and-drop, while Power Pages enables creating external-facing websites (e.g., customer portals) as custom business applications. Both allow creation and deployment without writing code, whereas Power Automate is for workflow automation, not app creation.
Exam trap
Candidates often mistakenly include Power Automate as a primary app-creation tool, but it is an automation service; Power Pages is the correct component for external-facing apps.
A financial analyst creates a Power BI report to compare quarterly revenue across years. The data has a 'Date' column and a 'Revenue' column. The analyst wants to display year-over-year growth for each quarter. Which visual and configuration would best achieve this?
Matrix allows side-by-side comparison and custom measures.
Why this answer
A Matrix visual allows you to place years as columns and quarters as rows, then define a DAX measure for year-over-year (YoY) growth (e.g., (Current Year Revenue - Previous Year Revenue) / Previous Year Revenue). This directly compares each quarter’s revenue across years in a structured, tabular format, which is the most effective way to display YoY growth for each quarter.
Exam trap
The trap here is that candidates often choose a chart option (like a line chart with trend lines) thinking it visually shows growth, but the question specifically asks for displaying year-over-year growth for each quarter, which requires a tabular or matrix format to show exact percentage changes per quarter across years.
How to eliminate wrong answers
Option A is wrong because a line chart with a date hierarchy and a year-over-year trend line does not inherently calculate or display the exact YoY growth percentage for each quarter; it only shows a trend line that may misrepresent quarterly comparisons. Option C is wrong because a stacked bar chart with quarters on the axis and year as legend shows the composition of revenue by year within each quarter, not the growth rate between years. Option D is wrong because a scatter plot with revenue on both axes and date as detail does not provide a clear comparison of quarterly revenue across years; it would plot revenue against itself, which is meaningless for YoY growth analysis.
A company wants to provide a self-service portal where customers can check their order status. Which Power Platform tool is best suited for this?
Power Pages is designed for secure external websites.
Why this answer
Power Pages is the correct choice because it is a low-code, secure, enterprise-grade platform designed specifically for creating external-facing websites. It allows customers to log in and view their order status without requiring internal system access, making it ideal for self-service portals.
Exam trap
The trap here is that candidates often confuse Power Apps (which can be shared externally with guest users) with Power Pages, but Power Apps requires users to have a license or be invited as guests, whereas Power Pages is purpose-built for anonymous or authenticated external access without requiring internal licenses.
How to eliminate wrong answers
Option B is wrong because Power Automate is a workflow automation tool for creating automated processes between apps and services, not for building customer-facing web portals. Option C is wrong because Power BI is a business analytics and visualization tool used for dashboards and reports, not for providing interactive customer self-service interfaces. Option D is wrong because Power Apps is primarily for building custom internal business applications (canvas or model-driven) that run on mobile or web, but it lacks the native public-facing website capabilities and authentication features that Power Pages provides for external users.
You need to design a solution that sends a notification to a manager when an employee submits a time-off request in a SharePoint list. Which Power Platform component should you use?
Power Automate can trigger on SharePoint events and send emails.
Why this answer
Power Automate is the correct component because it is designed to create automated workflows that trigger on events, such as when an item is created or modified in a SharePoint list. In this scenario, you would configure a Power Automate flow with a SharePoint 'When an item is created' trigger to send an email notification to the manager, without requiring manual intervention or custom code.
Exam trap
The trap here is that candidates may confuse Power Apps (which can display notifications within an app) with the ability to send automated external notifications, but Power Automate is the dedicated workflow engine for such event-driven tasks.
How to eliminate wrong answers
Option A is wrong because Power Virtual Agents is a chatbot-building tool for conversational AI, not for automating backend workflows like sending notifications based on SharePoint list changes. Option B is wrong because Power Apps is used to build custom user interfaces and apps, not to automate event-driven notifications; it would require additional components like Power Automate to handle the notification logic. Option D is wrong because Power BI is a data visualization and analytics tool, not a workflow automation platform; it cannot trigger actions such as sending emails based on list item changes.
Practice PL-900 by domain
Target a specific domain to shore up weak areas.