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

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

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

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 2: 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 3: Which Power BI license allows a user to publish and share content within an organization?

Power BI Free
Power BI Student
Power BI Pro (Correct answer)
Power BI Viewer

Correct answer: Power BI Pro

Power BI Pro is required to publish, share, and collaborate on content with other users in the Power BI Service.

Question 4: What is Power Automate Process Mining used for?

Analyzing event logs to visualize and optimize business processes (Correct answer)
Automating data migration between on-premises and cloud databases
Extracting text data from scanned PDF documents
Mining cryptocurrency using idle compute resources

Correct answer: Analyzing event logs to visualize and optimize business processes

Process Mining analyzes event log data to visualize how processes actually run, identify bottlenecks, and find automation opportunities.

Question 5: What is the maximum number of rows that Power BI's default Import mode can handle per dataset?

1 billion rows — with no practical limit in Import mode
100,000 rows
1 million rows
The limit depends on the Premium capacity or shared capacity tier (Correct answer)

Correct answer: The limit depends on the Premium capacity or shared capacity tier

Power BI dataset size limits depend on the license tier: shared capacity has a 1 GB compressed limit, while Premium capacities allow much larger datasets.

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

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

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 7: What is the role of the Common Data Model (CDM) in the Power Platform ecosystem?

It is Microsoft's cloud storage service for large binary files
It manages user authentication across Power Platform services
It provides a standardized set of schemas for business data to enable interoperability (Correct answer)
It is the programming language used in Power Fx

Correct answer: It provides a standardized set of schemas for business data to enable interoperability

The Common Data Model defines a shared set of standard data schemas (entities and relationships) that promote consistency and interoperability across Microsoft and partner applications.

Question 8: A developer wants to extend a model-driven app with custom business logic that runs on the server side regardless of the client used. What should they use?

Power Automate instant flows
Plug-ins registered in Dataverse (Correct answer)
JavaScript web resources
Power Fx formulas

Correct answer: Plug-ins registered in Dataverse

Dataverse plug-ins are server-side code executed by the platform on data events, running regardless of whether the user accesses data through an app, API, or flow.

Question 9: What is a Dataverse 'calculated column'?

A column whose value is computed by a DAX formula at report time
A column whose value is automatically derived by a formula based on other column values in the same row (Correct answer)
A column that sums child record values from a related table
A column populated by a Power Automate flow on record save

Correct answer: A column whose value is automatically derived by a formula based on other column values in the same row

A calculated column in Dataverse uses a formula to automatically compute its value from other fields in the same record, updated whenever the source fields change.

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

To prevent report editing by non-authors
To restrict data access so users see only the rows relevant to them (Correct answer)
To encrypt data at rest within the Power BI Service
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 11: In Power Apps, what is a 'gallery' control used for?

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

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 12: Which connector type in Power BI imports data into the model and stores a snapshot?

Live Connection
Streaming
Import (Correct answer)
DirectQuery

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 13: What is a Power BI dataset?

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

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 14: Which Copilot Studio feature allows a topic to redirect to another topic mid-conversation?

Go to another topic node (Correct answer)
Variable assignment node
HTTP Request action
Condition node

Correct answer: Go to another topic node

The 'Go to another topic' node immediately transfers the conversation flow to a different topic, enabling modular and reusable conversation design.

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

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

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 16: What is a Power BI workspace?

A local folder on your PC where .pbix files are saved
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 template for report layout and branding

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 17: What is the purpose of the 'OnStart' property in a Power Apps canvas app?

It triggers a Power Automate flow on app open
It runs formulas when the app is first launched, used for loading global variables or collections (Correct answer)
It sets the default screen displayed after login
It defines what happens when the user taps a button control

Correct answer: It runs formulas when the app is first launched, used for loading global variables or collections

OnStart executes Power Fx formulas when the app launches, commonly used to initialize variables and load data into collections for better performance.

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

Desktop flow (RPA) (Correct answer)
Scheduled cloud flow
Instant cloud flow
Automated 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 19: Which Power Apps feature allows a maker to run an app in a browser without publishing it?

Power Apps Embedded
Power Apps Player
Power Apps Preview (Play mode in Studio) (Correct answer)
Power Apps Sandbox

Correct answer: Power Apps Preview (Play mode in Studio)

Within Power Apps Studio, makers can press the Play button to preview and test the app in the browser before publishing it to users.

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

Camera control
Pen input control (Correct answer)
Text input control
Barcode scanner 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 21: Which of the following is a valid use case for Power BI Dataflows?

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

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 22: In Power BI, what is a 'workspace'?

A type of visual layout within a single report
A premium feature for paginated report hosting
A collaborative area in the Power BI service where reports and dashboards are shared and managed (Correct answer)
A local folder on your PC where Power BI Desktop files are saved

Correct answer: A collaborative area in the Power BI service where reports and dashboards are shared and managed

A Power BI workspace is a cloud-based container in the Power BI service where teams can collaborate on datasets, reports, dashboards, and dataflows.

Question 23: Which Power Automate trigger would you use to start a flow when a new file is added to a SharePoint document library?

When a file is created (SharePoint trigger) (Correct answer)
When an HTTP request is received
Recurrence (scheduled trigger)
When a record is created (Dataverse trigger)

Correct answer: When a file is created (SharePoint trigger)

The SharePoint 'When a file is created' trigger fires automatically when a new document is added to a specified library or folder.

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

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

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 25: Which license allows users to build and run unlimited canvas and model-driven apps within the Power Platform?

Power Automate per-flow plan
Dynamics 365 Team Member license
Microsoft 365 (Office 365) license
Power Apps per-user plan (Correct answer)

Correct answer: Power Apps per-user plan

The Power Apps per-user plan grants one user the right to create and run unlimited canvas and model-driven apps, including full Dataverse access.

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

Power Apps Studio
Power Apps Mobile
Power Apps Portal
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 27: What is the purpose of the 'Apply to each' action in Power Automate?

Executing a subflow for every user in an Azure AD group
Iterating over each item in an array and performing actions on each one (Correct answer)
Applying a theme to all screens in a connected Power App
Applying a data transformation to a single field in a record

Correct answer: Iterating over each item in an array and performing actions on each one

'Apply to each' is a loop action that iterates through an array (e.g., a list of email attachments) and runs the contained actions for every item.

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

Default environment
Developer environment
Trial 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 29: What is the difference between a 'scheduled' flow and an 'automated' flow in Power Automate?

Scheduled flows run on a time-based recurrence; automated flows run in response to an event trigger (Correct answer)
Scheduled flows run in the background; automated flows send notifications when complete
Scheduled flows require a premium license; automated flows are free
Automated flows can only run on weekdays; scheduled flows run any time

Correct answer: Scheduled flows run on a time-based recurrence; automated flows run in response to an event trigger

Scheduled flows run at a defined frequency (e.g., every day at 8 AM), while automated flows are triggered by an event in a connected service.

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

Configuring security roles for the app
Creating automated workflows on record save
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 31: 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 32: What does the decomposition tree visual in Power BI help users do?

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

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 33: What does the 'Delegation' concept mean in Power Apps canvas apps?

Delegating UI rendering to the browser engine
Sharing an app with a group of users
Assigning app ownership to another maker
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 34: What does the 'End conversation' node do in a Copilot Studio topic?

Transfers the user to a live human agent immediately
Signals the end of the conversational interaction, optionally showing a satisfaction survey (Correct answer)
Resets all variables and restarts the copilot from the greeting topic
Deletes the conversation transcript from the system

Correct answer: Signals the end of the conversational interaction, optionally showing a satisfaction survey

The 'End conversation' node terminates the current conversation, and makers can optionally present a CSAT survey to gather user satisfaction data.

Question 35: A logistics company processes thousands of invoices monthly. Which combination of Power Platform tools would create the most business value for automating invoice processing?

Power BI + Power Pages
Dataverse + Power Pages
Power Apps + Power Virtual Agents
AI Builder (document processing) + Power Automate (Correct answer)

Correct answer: AI Builder (document processing) + Power Automate

AI Builder can extract data from invoices automatically, and Power Automate can route that data through approval workflows, eliminating manual processing.

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

Two users running the app simultaneously on the same screen
Multiple makers editing the same canvas app at the same time (Correct answer)
Merging two separate apps into one
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 37: What is the primary business value of Power Platform's pre-built connectors to services like SharePoint, Salesforce, and SAP?

They automatically migrate all data to Azure
They replace the need for licensed third-party software
They eliminate the need for any data storage
They dramatically reduce integration time by providing ready-made connections to existing business systems (Correct answer)

Correct answer: They dramatically reduce integration time by providing ready-made connections to existing business systems

Pre-built connectors let citizen developers integrate with existing systems without writing custom APIs, accelerating solution delivery.

Question 38: Which Power BI licensing model allows external users (outside your organization) to view published reports without a Power BI Pro license?

Power BI Premium capacity with embed for your organization
Power BI Free
Power BI Premium Per User (PPU)
Power BI Embedded (Azure) (Correct answer)

Correct answer: Power BI Embedded (Azure)

Power BI Embedded is an Azure service that allows ISVs and developers to embed Power BI content for external users who do not need their own Power BI licenses.

Question 39: What is a Power BI App?

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

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 40: What is a Power Apps Portal (now called Power Pages)?

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

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 41: What does DAX stand for in the context of Power BI?

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

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 42: 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 require a Dataverse table; model-driven apps support any data source
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)

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 43: What is the role of Power BI Gateway?

To allow the Power BI Service to access on-premises data sources (Correct answer)
To convert Power BI reports into PDF format
To deploy Power BI reports to mobile devices
To manage Power BI Pro licenses

Correct answer: To allow the Power BI Service to access on-premises data sources

The Power BI Gateway acts as a bridge, allowing the cloud-based Power BI Service to securely refresh data from on-premises sources.

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

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

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 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)
Restricting which users can trigger the flow
Limiting the flow to run only within business hours
Defining the geographic region where the flow runs

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 the primary purpose of Power BI Desktop?

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

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 47: What is a child flow in Power Automate?

A reusable flow that can be called from other flows as a subflow (Correct answer)
A flow that runs with reduced permissions inherited from a parent flow
A flow triggered by a child record being created in Dataverse
A mobile-only flow accessible to child (minor) user accounts

Correct answer: A reusable flow that can be called from other flows as a subflow

A child flow is a cloud flow that is invoked by another flow using the 'Run a Child Flow' action, enabling reuse of common logic across multiple parent flows.

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

Run history is only available for flows older than 30 days
Run history must be manually exported to SharePoint to be viewed
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

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 49: Which of the following statements best describes how the Microsoft Power Platform works?

They stand for a series of automated processes that are initiated by a trigger and may involve sophisticated branching logic.
They stand for a collection of business rules, relationships, and tables that provide a standard organized data storage for business applications.
They stand for a method of connecting to a data source.
They use business logic, security, and integrations to help launch application development. (Correct answer)
They stand for a group of services that make the data tables accessible.
They represent a set of rows used to store data

Correct answer: They use business logic, security, and integrations to help launch application development.

The Microsoft Power Platform is a suite of low-code tools designed to enable rapid application development, automation, and data analysis. It leverages business logic, robust security features, and seamless integrations with various data sources and services to empower users to build custom applications, automate workflows, and analyze data efficiently, thereby accelerating application development.

Question 50: In Power Apps canvas apps, which language is used to write formulas and expressions?

Power Fx (Correct answer)
DAX
JavaScript
M Query

Correct answer: Power Fx

Power Fx is the low-code formula language used in Power Apps canvas apps, inspired by Excel functions.

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

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

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 52: In Power BI, what does the term 'row-level security' (RLS) mean?

Preventing users from adding new rows to Dataverse tables
Restricting data returned in reports based on the logged-in user's role (Correct answer)
Encrypting individual rows in a dataset
Limiting the number of rows imported from a data source

Correct answer: Restricting data returned in reports based on the logged-in user's role

Row-level security (RLS) in Power BI filters data at the row level so different users see only the records they are authorized to view within the same 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