PL-900 Microsoft Power Platform Fundamentals Exam — Questions and Answers

Question 1: What does the decomposition tree visual in Power BI help users do?

Identify duplicate rows in a dataset
Interactively break down a metric across multiple dimensions (Correct answer)
Compare two date ranges side by side
Map hierarchical organizational data to org charts

Correct answer: Interactively break down a metric across multiple dimensions

The decomposition tree lets users drill down into a measure by selecting different dimensions to understand what drives the values.

Question 2: In model-driven apps, what is a 'form' used for?

Creating automated workflows on record save
Configuring security roles for the app
Defining the layout of a list of records
Displaying and editing the details of a single record (Correct answer)

Correct answer: Displaying and editing the details of a single record

Forms in model-driven apps present the fields and related data for a single record, allowing users to view or edit its details.

Question 3: Which Power Automate feature allows you to extract structured data from documents such as invoices and receipts using AI?

Power Automate RPA recorder
AI Builder – Form Processing model (Correct answer)
Dataverse File column
Azure Cognitive Search connector

Correct answer: AI Builder – Form Processing model

AI Builder's Form Processing model uses machine learning to extract key fields (e.g., total amount, vendor name) from structured documents like invoices.

Question 4: Which connector type in Power BI imports data into the model and stores a snapshot?

Streaming
Import (Correct answer)
DirectQuery
Live Connection

Correct answer: Import

Import mode loads a copy of the data into the Power BI dataset, enabling fast performance at the cost of data freshness between refreshes.

Question 5: In Power Automate, what does 'run after' configuration control?

The order in which parallel branches execute
The delay between retrying a failed action
Under which conditions (success, failure, timeout, skip) a subsequent action should execute (Correct answer)
The scheduled start time for a recurring flow

Correct answer: Under which conditions (success, failure, timeout, skip) a subsequent action should execute

'Run after' lets you configure an action to execute only when the preceding action has a specific outcome — success, failure, skipped, or timed out.

Question 6: What type of Power Automate flow runs automatically based on a trigger event?

Automated flow (Correct answer)
Scheduled flow
Desktop flow
Instant flow

Correct answer: Automated flow

Automated flows are triggered automatically by an event, such as a new email arriving or a record being created in Dataverse.

Question 7: What is a Power BI dataset?

A shared folder containing .pbix files
A curated connection to one or more data sources with a defined data model (Correct answer)
A scheduled export of report data to Excel
A collection of visuals arranged on a single page

Correct answer: A curated connection to one or more data sources with a defined data model

A Power BI dataset is a data model containing connections, relationships, and measures that reports can be built on top of.

Question 8: What is the purpose of Row-Level Security (RLS) in Power BI?

To encrypt data at rest within the Power BI Service
To prevent report editing by non-authors
To restrict data access so users see only the rows relevant to them (Correct answer)
To limit the number of rows that can be imported into a dataset

Correct answer: To restrict data access so users see only the rows relevant to them

RLS uses DAX filter rules to ensure that different users see only the data they are authorized to access within the same report.

Question 9: John utilizes Dynamics 365 Sales at TPT Ltd. He must create a Power BI report with client office locations so that the report's City and State columns are combined into a single column. <br> <br> Which of the following options is best suited to meet the requirement?

Export data to Microsoft Excel.
Use Power Query Editor to merge columns. (Correct answer)
Import the data.
Create a view.

Correct answer: Use Power Query Editor to merge columns.

The Power Query Editor in Power BI is the ideal tool for data transformation tasks, including combining columns. John can use its 'Merge Columns' feature to combine the 'City' and 'State' columns into a single new column. This allows him to create a unified location field directly within the Power BI data model, meeting the report's requirement.

Question 10: What analytics capability does Copilot Studio provide out of the box?

Google Analytics integration for web-based channels
Real-time conversation monitoring via Azure Monitor only
Power BI Embedded reports that must be manually configured
Built-in dashboards showing session volume, resolution rate, escalation rate, and top topics (Correct answer)

Correct answer: Built-in dashboards showing session volume, resolution rate, escalation rate, and top topics

Copilot Studio includes built-in analytics dashboards that show key metrics like the number of sessions, resolution rates, topic trigger counts, and escalations without additional configuration.

Question 11: Which control in Power Apps allows users to capture a handwritten signature?

Text input control
Barcode scanner control
Pen input control (Correct answer)
Camera control

Correct answer: Pen input control

The Pen input control captures stylus or touch input, making it suitable for capturing signatures or freehand drawings in an app.

Question 12: In Power Automate, what is a 'condition' action used for?

Branching the flow logic based on whether an expression evaluates to true or false (Correct answer)
Sending an approval request to a manager
Pausing a flow for a set period before continuing
Looping through items in a list

Correct answer: Branching the flow logic based on whether an expression evaluates to true or false

A condition action evaluates an expression and routes the flow down a 'yes' or 'no' branch depending on the result.

Question 13: Most employees of a corporation utilize its Power Apps app. The business is growing into new nations and areas. You must suggest a method for quickly translating text produced by the Power Apps. What ought to you suggest?

Common Data Service connector
Microsoft Azure Cognitive Services (Correct answer)
Power BI
Microsoft Azure Synapse Analytics

Correct answer: Microsoft Azure Cognitive Services

Microsoft Azure Cognitive Services includes powerful AI capabilities, such as the Translator Text API, which can quickly and accurately translate text between numerous languages. Integrating this service with Power Apps allows for on-demand translation of app content. This makes it an efficient solution for expanding into new regions and supporting diverse linguistic needs without manual translation efforts.

Question 14: What is 'Dataverse for Teams' and how does it differ from full Dataverse?

Dataverse for Teams is only available in government cloud environments
Dataverse for Teams is a separate Microsoft product with its own licensing, unrelated to Microsoft 365
Dataverse for Teams supports all Dataverse features plus Teams-specific ones like channel messaging
Dataverse for Teams is a limited, Teams-embedded version of Dataverse with lower capacity caps and no premium connector access, included with Microsoft 365 (Correct answer)

Correct answer: Dataverse for Teams is a limited, Teams-embedded version of Dataverse with lower capacity caps and no premium connector access, included with Microsoft 365

Dataverse for Teams is a lightweight version of Dataverse built into Microsoft Teams, included with select Microsoft 365 plans, but has capacity limits and doesn't support premium features like plug-ins.

Question 15: Your team has grown impatient with how frequently they must start a project with simple data entry. There are numerous divisions that require the information, and occasionally inaccuracies are due to human error, making it more challenging to interpret your data. Which program would be most beneficial in this circumstance?

Power Apps
Power BI
Power Automate (Correct answer)

Correct answer: Power Automate

Power Automate is specifically designed for automating repetitive tasks and workflows, which directly addresses the problem of frequent, simple data entry and potential human error. By automating these processes, it reduces manual effort, improves data accuracy, and frees up team members to focus on more complex tasks. It can connect to various data sources and applications to streamline data flow and minimize inaccuracies.

Question 16: What is the primary purpose of Power BI Desktop?

To manage user permissions for datasets
To create and publish reports and dashboards (Correct answer)
To host and share reports online
To write DAX scripts for Azure

Correct answer: To create and publish reports and dashboards

Power BI Desktop is used to create reports and data models that can then be published to the Power BI service.

Question 17: What is a connector in Power Apps?

A component for connecting screens within an app
A network cable linking on-premises servers
A subscription plan for premium data sources
A pre-built integration that allows Power Apps to interact with external services and data sources (Correct answer)

Correct answer: A pre-built integration that allows Power Apps to interact with external services and data sources

Connectors are wrappers around APIs that allow Power Apps (and other Power Platform tools) to communicate with services like SharePoint, SQL Server, or Salesforce.

Question 18: Which type of Power App is built on a data table and automatically generates screens based on a Dataverse table?

Canvas app
Model-driven app (Correct answer)
Portal app
Custom page

Correct answer: Model-driven app

Model-driven apps are driven by your Dataverse data model and automatically generate forms, views, and navigation based on the underlying tables.

Question 19: What does DAX stand for in the context of Power BI?

Dashboard Analytics XML
Data Analysis Expressions (Correct answer)
Dynamic Aggregation Extensions
Data Access eXchange

Correct answer: Data Analysis Expressions

DAX (Data Analysis Expressions) is the formula language used in Power BI to create calculated columns, measures, and tables.

Question 20: Which Power Automate flow type is used to automate tasks on a local PC, such as interacting with legacy desktop applications?

Scheduled cloud flow
Automated cloud flow
Desktop flow (RPA) (Correct answer)
Instant cloud flow

Correct answer: Desktop flow (RPA)

Desktop flows (Robotic Process Automation) use Power Automate Desktop to record and replay UI interactions on local or virtual machines.

Question 21: What is Microsoft Dataverse?

A relational database service available only to enterprise customers
A cloud data warehouse for big data analytics in Azure Synapse
A file storage system for Power BI report assets
A low-code cloud-based data platform that securely stores and manages data used by Power Platform applications (Correct answer)

Correct answer: A low-code cloud-based data platform that securely stores and manages data used by Power Platform applications

Microsoft Dataverse is the underlying data platform for Power Platform, providing tables, relationships, business logic, and security for apps and flows.

Question 22: What does the 'Delegation' concept mean in Power Apps canvas apps?

Assigning app ownership to another maker
Delegating UI rendering to the browser engine
Sharing an app with a group of users
Pushing data processing to the data source instead of locally, enabling handling of large datasets (Correct answer)

Correct answer: Pushing data processing to the data source instead of locally, enabling handling of large datasets

Delegation allows supported data sources (like SharePoint or Dataverse) to process filter and sort operations server-side, bypassing the 500/2000 record local limit.

Question 23: Which of the following is a key difference between canvas apps and model-driven apps?

Model-driven apps can only run on mobile; canvas apps are desktop-only
Canvas apps use DAX; model-driven apps use Power Fx
Canvas apps give makers pixel-level layout control; model-driven apps derive layout from the data model (Correct answer)
Canvas apps require a Dataverse table; model-driven apps support any data source

Correct answer: Canvas apps give makers pixel-level layout control; model-driven apps derive layout from the data model

Canvas apps let makers drag and drop controls anywhere on the screen, while model-driven apps generate their UI automatically based on the Dataverse schema.

Question 24: Given that you have a Power App for data updates and use Power BI for data visualization in the database, how can you immediately update the data in your corporate database from the Power BI report?

You should add the PowerApps custom visual to the Power BI report to update the data directly (Correct answer)
You want to incorporate the Power BI report inside the Power App so that users may examine the data and then directly change it.
You could select Analyse in Excel from Power BI, update the data in the Excel workbook, and import the updates using the Power app
You cannot update data from a Power BI report

Correct answer: You should add the PowerApps custom visual to the Power BI report to update the data directly

The PowerApps custom visual in Power BI allows users to embed a Power App directly into a Power BI report. This enables interactive data updates from within the report itself. Users can view data in Power BI and then use the embedded Power App to modify the underlying data in the corporate database immediately, providing a seamless experience for data analysis and modification.

Question 25: In Power Automate Desktop, what is the 'recorder' feature used for?

Capturing user interactions on screen to generate automation steps automatically (Correct answer)
Logging all keyboard and mouse inputs to a compliance audit trail
Recording API response payloads for replay testing
Recording audio narrations for onboarding videos

Correct answer: Capturing user interactions on screen to generate automation steps automatically

The recorder in Power Automate Desktop watches a user perform actions on screen and converts those clicks and keystrokes into an editable automation script.

Question 26: Which of the following is a valid use case for Power BI Dataflows?

Building chatbot conversation flows
Reusing ETL logic across multiple Power BI datasets (Correct answer)
Scheduling email alerts for KPI thresholds
Managing row-level security policies

Correct answer: Reusing ETL logic across multiple Power BI datasets

Power BI Dataflows allow organizations to define reusable data preparation logic (ETL) that multiple datasets can consume.

Question 27: What does 'co-authoring' in Power Apps canvas apps allow?

Merging two separate apps into one
Two users running the app simultaneously on the same screen
Multiple makers editing the same canvas app at the same time (Correct answer)
Sharing an app with external guest users

Correct answer: Multiple makers editing the same canvas app at the same time

Co-authoring enables multiple makers to open and edit the same canvas app concurrently without overwriting each other's changes.

Question 28: Which license is required to use premium connectors in Power Automate?

Power Automate Premium (per-user or per-flow) (Correct answer)
Azure Active Directory P1
Power Automate Free
Microsoft 365 E3

Correct answer: Power Automate Premium (per-user or per-flow)

Premium connectors like SQL Server, Salesforce, or HTTP require a Power Automate Premium license beyond the standard Microsoft 365-included entitlements.

Question 29: What is a Power BI workspace?

A template for report layout and branding
A collaborative area in the Power BI Service for teams to manage and share content (Correct answer)
A dashboard embedded in a third-party application
A local folder on your PC where .pbix files are saved

Correct answer: A collaborative area in the Power BI Service for teams to manage and share content

A workspace in the Power BI Service is a shared environment where teams can organize and collaborate on datasets, reports, and dashboards.

Question 30: What is a Dataverse 'environment'?

A deployment region selected when purchasing Power Platform licenses
An isolated container that holds Dataverse databases, apps, flows, and other Power Platform components (Correct answer)
A virtual machine in Azure dedicated to running Power Platform
A sandbox mode for testing dangerous data operations

Correct answer: An isolated container that holds Dataverse databases, apps, flows, and other Power Platform components

A Dataverse environment is an isolated instance that contains its own database, apps, flows, and configurations, used to separate dev, test, and production workloads.

Question 31: What is a Power Apps Portal (now called Power Pages)?

An internal employee-only app deployed on SharePoint
A dashboard for monitoring app usage analytics
A gallery of pre-built Power Apps templates
An externally facing website that allows unauthenticated or authenticated external users to interact with Dataverse data (Correct answer)

Correct answer: An externally facing website that allows unauthenticated or authenticated external users to interact with Dataverse data

Power Pages (formerly Power Apps Portals) allows organizations to build secure, externally accessible websites connected to Dataverse for external users like customers or partners.

Question 32: Which Power BI component allows users to view and interact with reports in a browser?

Power BI Desktop
Power BI Mobile
Power BI Gateway
Power BI Service (Correct answer)

Correct answer: Power BI Service

The Power BI Service (app.powerbi.com) is the cloud-based platform where reports and dashboards are shared and consumed in a browser.

Question 33: Rico is employed with PTG Ltd. He is to create a Power Automate flow to manage sales activities. He notices that the sales team keeps quotes in a Microsoft OneDrive folder using PDF files. Rico creates a Microsoft SharePoint list to make it easier for follow-ups on quotes.

language detection
text recognition (Correct answer)
sentiment analysis
key phrase extraction

Correct answer: text recognition

Rico needs to extract information from PDF files containing quotes to populate a SharePoint list. Text recognition, often referred to as Optical Character Recognition (OCR), is the AI Builder capability that allows Power Automate to read and extract text from images or PDF documents. This enables the automation of data entry from unstructured documents into structured lists.

Question 34: Which action would you use in Power Automate to pause a flow until a specific date and time?

Wait action
Delay action
Delay until action (Correct answer)
Timer trigger

Correct answer: Delay until action

'Delay until' pauses the flow execution until a specified date and time is reached, unlike 'Delay' which pauses for a fixed duration.

Question 35: Which environment type in Power Apps is recommended for production business use?

Default environment
Trial environment
Developer environment
Production environment (Correct answer)

Correct answer: Production environment

A production environment is the appropriate type for deploying business-critical apps and data, with proper governance and backup policies.

Question 36: What is an 'environment variable' in the context of Power Automate solutions?

A variable that persists its value across multiple flow runs
A solution component that stores configurable values (e.g., URLs, email addresses) separately from flow logic (Correct answer)
A Dataverse column that automatically updates based on the current environment
A system environment variable stored on the Power Automate server OS

Correct answer: A solution component that stores configurable values (e.g., URLs, email addresses) separately from flow logic

Environment variables in solutions store configuration values that can be changed per environment (dev/test/prod) without modifying the flow itself.

Question 37: What is Power BI Embedded used for?

Embedding Power BI reports into custom applications or websites for external users (Correct answer)
Enabling offline report access on mobile devices
Importing embedded images into Power BI visuals
Connecting Power BI to embedded SQL databases

Correct answer: Embedding Power BI reports into custom applications or websites for external users

Power BI Embedded is an Azure service that lets developers integrate Power BI reports and dashboards into their own applications without requiring users to have Power BI licenses.

Question 38: What is a Power BI App?

A packaged collection of dashboards and reports distributed to end users (Correct answer)
A custom connector built with Power Query M
A mobile application for viewing reports offline
The standalone desktop installer for Power BI Desktop

Correct answer: A packaged collection of dashboards and reports distributed to end users

A Power BI App is a curated bundle of dashboards and reports published from a workspace and distributed to a broad audience in the organization.

Question 39: Which of the following best describes the target audience for websites built with Power Pages?

External users such as customers and business partners (Correct answer)
Only licensed Dynamics 365 users
Only users with Power Platform licenses
Only internal Microsoft employees

Correct answer: External users such as customers and business partners

Power Pages is built for external audiences — customers, partners, citizens, and community members — who need to interact with an organization's data and services via a website.

Question 40: What is the purpose of the Power Apps component framework (PCF)?

To connect Power Apps to Azure Functions
To manage environment-level security roles
To allow developers to build custom UI controls for canvas and model-driven apps (Correct answer)
To automate data imports from Excel

Correct answer: To allow developers to build custom UI controls for canvas and model-driven apps

PCF enables professional developers to create reusable, custom code components that extend the UI capabilities of Power Apps beyond built-in controls.

Question 41: In Power Apps, what is a 'gallery' control used for?

Showing a scrollable list of records from a data source (Correct answer)
Displaying a collection of images from Azure Blob Storage
Managing navigation between app screens
Grouping multiple input controls into a reusable template

Correct answer: Showing a scrollable list of records from a data source

The gallery control displays a repeating list of items from a data source, allowing users to browse and select records.

Question 42: Which Power Apps plan is required to use premium connectors such as SQL Server or Salesforce?

Microsoft 365 included Power Apps
Power Apps Developer Plan
Power Apps Premium (per-user or per-app plan) (Correct answer)
Power Apps Community Plan

Correct answer: Power Apps Premium (per-user or per-app plan)

Premium connectors require a Power Apps Premium license (per-user or per-app), as they go beyond the standard connectors included with Microsoft 365.

Question 43: How does Power Automate handle flow run history?

Each flow stores a log of recent runs showing status, inputs, and outputs for troubleshooting (Correct answer)
Only failed runs are logged; successful runs are not recorded
Run history must be manually exported to SharePoint to be viewed
Run history is only available for flows older than 30 days

Correct answer: Each flow stores a log of recent runs showing status, inputs, and outputs for troubleshooting

Power Automate automatically records each flow run with its overall status and a detailed log of each action's inputs and outputs, retained for 28 days by default.

Question 44: Which expression function in Power Automate returns the current date and time?

now() (Correct answer)
getTimestamp()
currentDate()
today()

Correct answer: now()

The now() function in Power Automate expressions returns the current UTC date and time as a timestamp string.

Question 45: What is a 'scope' action in Power Automate used for?

Grouping a set of actions together, often used with 'run after' for error handling (Correct answer)
Limiting the flow to run only within business hours
Defining the geographic region where the flow runs
Restricting which users can trigger the flow

Correct answer: Grouping a set of actions together, often used with 'run after' for error handling

A scope groups actions logically and enables structured error handling by running subsequent scopes only after a previous scope succeeds, fails, or times out.

Question 46: What is an 'approval' flow in Power Automate?

A flow that routes items to one or more people for review and response, then continues based on their decision (Correct answer)
A flow that requires admin sign-off before it can be activated
A flow that verifies connector credentials before running
A flow that checks data quality before inserting records into Dataverse

Correct answer: A flow that routes items to one or more people for review and response, then continues based on their decision

Approval flows send actionable requests to approvers, who can approve or reject directly from email or Teams, and the flow continues based on their response.

Question 47: Which Power BI feature enables a report consumer to ask questions about data using plain English?

Decomposition tree
Q&A visual (Correct answer)
Power Query Editor
Smart narrative

Correct answer: Q&A visual

The Q&A visual lets users type natural language questions (e.g., 'total sales by region') and automatically generates a matching visualization.

Question 48: Which node type in a Copilot Studio topic allows the bot to ask the user a question and store their response?

Go to another topic node
Condition node
Ask a question node (Correct answer)
Send a message node

Correct answer: Ask a question node

The 'Ask a question' node sends a prompt to the user, waits for their reply, and saves the input to a variable for use later in the conversation.

Question 49: What is 'generative answers' in Microsoft Copilot Studio?

Creating image responses within chatbot conversations
Generating Power Automate flows from natural language descriptions
Automatically generating conversation topics from existing SharePoint content
Using a large language model to dynamically answer user questions from connected knowledge sources without pre-authoring topics (Correct answer)

Correct answer: Using a large language model to dynamically answer user questions from connected knowledge sources without pre-authoring topics

Generative answers allow a copilot to answer questions on the fly using AI grounded in connected knowledge sources (websites, SharePoint, files), without requiring manually authored topics.

Question 50: Which Power Apps feature allows makers to build apps directly within Microsoft Teams?

Power Apps Portal
Power Apps Studio
Power Apps Mobile
Power Apps for Teams (Dataverse for Teams) (Correct answer)

Correct answer: Power Apps for Teams (Dataverse for Teams)

Power Apps for Teams (backed by Dataverse for Teams) lets users build and deploy apps within the Teams environment without leaving the collaboration tool.

Question 51: How does Copilot Studio integrate with Power Automate?

By deploying the copilot via a Power Automate scheduled flow
By calling Power Automate flows as actions within a topic to retrieve data or perform operations (Correct answer)
By importing Power Automate flows as topics
By automatically generating flows from conversation transcripts

Correct answer: By calling Power Automate flows as actions within a topic to retrieve data or perform operations

Within a topic, makers can add an 'Action' node that calls a Power Automate cloud flow, allowing the copilot to fetch live data or trigger backend processes.

Question 52: In Power BI, what does the term 'measure' refer to?

A dynamic calculation defined using DAX that is evaluated at query time (Correct answer)
A visual element placed on a report canvas
A column imported directly from a data source
A scheduled data refresh configuration

Correct answer: A dynamic calculation defined using DAX that is evaluated at query time

A measure is a DAX formula that performs aggregations or calculations dynamically based on the current filter context of the report.

PL-900 Microsoft Power Platform Fundamentals Exam

The PL-900 Microsoft Power Platform Fundamentals Exam validates foundational knowledge of the Microsoft Power Platform, covering Power BI for data analytics, Power Apps for low-code app development, Power Automate for workflow automation, and Power Virtual Agents for chatbot creation.

Questions

65 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

learn.microsoft.com — Renewal, score validity, passing score, exam format, test delivery, time limit, exam information · verified Nov 2026