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

Question 1: How does Power Platform's low-code approach contribute to faster digital transformation compared to traditional pro-code development?

It automatically integrates with all third-party software without configuration
It removes the need for any testing before deployment
It enables business subject-matter experts to build and iterate on solutions without waiting for developer availability (Correct answer)
It generates code automatically that is always more optimized than hand-written code

Correct answer: It enables business subject-matter experts to build and iterate on solutions without waiting for developer availability

Low-code empowers domain experts to build their own solutions, removing the bottleneck of limited developer resources and accelerating transformation initiatives.

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

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

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.

Question 3: Which Power BI report type is best suited for pixel-perfect, paginated printing and PDF export?

Power BI Paginated Report (Correct answer)
Power BI Scorecard
Power BI Dashboard
Power BI Streaming Dataset report

Correct answer: Power BI Paginated Report

Power BI Paginated Reports (built with Report Builder) are designed for formatted, multi-page output ideal for printing or exporting to PDF.

Question 4: What is a connector in Power Apps?

A subscription plan for premium data sources
A component for connecting screens within an app
A network cable linking on-premises servers
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 5: What type of Power Automate flow runs automatically based on a trigger event?

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

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 6: What is Power BI Embedded used for?

Embedding Power BI reports into custom applications or websites for external users (Correct answer)
Importing embedded images into Power BI visuals
Enabling offline report access on mobile devices
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 7: What is a 'scope' action in Power Automate used for?

Defining the geographic region where the flow runs
Limiting the flow to run only within business hours
Grouping a set of actions together, often used with 'run after' for error handling (Correct answer)
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 8: What is the 'Data workspace' in the Power Pages design studio primarily used for?

Designing site navigation menus
Managing Dataverse tables, columns, and views connected to the site (Correct answer)
Configuring authentication and domain settings
Creating and arranging web page layouts

Correct answer: Managing Dataverse tables, columns, and views connected to the site

The Data workspace lets makers view, create, and configure the Dataverse tables, columns, forms, and views that power the data-driven features of the website.

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

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

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

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

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

To convert Power BI reports into PDF format
To allow the Power BI Service to access on-premises data sources (Correct answer)
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 14: In Power Automate, what does 'run after' configuration control?

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

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

A flow triggered by a child record being created in Dataverse
A mobile-only flow accessible to child (minor) user accounts
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

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 16: How does Power Platform's integration with Microsoft 365 add business value to organizations already using Office tools?

It allows employees to build and use apps within familiar tools like Teams and SharePoint (Correct answer)
It provides free Power Platform licenses to all Microsoft 365 subscribers
It replaces Microsoft 365 apps with more powerful alternatives
It automatically migrates all Excel data to Dataverse

Correct answer: It allows employees to build and use apps within familiar tools like Teams and SharePoint

Power Platform integrates natively with Teams, SharePoint, and other M365 tools, so employees can adopt new capabilities within their existing workflow.

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

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

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 18: Which Power Platform feature allows organizations to set policies that control which connectors can be used together in Power Automate flows?

Managed Environments
Connector filtering
Environment variables
Data Loss Prevention (DLP) policies (Correct answer)

Correct answer: Data Loss Prevention (DLP) policies

Data Loss Prevention (DLP) policies classify connectors into groups to prevent mixing of business and personal data connectors within the same flow.

Question 19: What is a Power BI dataset?

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

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 20: Which type of Power App is built on a data table and automatically generates screens based on a Dataverse table?

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

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

Data Access eXchange
Dashboard Analytics XML
Data Analysis Expressions (Correct answer)
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 22: What is the purpose of the Power Apps component framework (PCF)?

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

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 23: 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 24: 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.

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

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 25: 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 26: 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
Delay action
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 27: Which feature in Power BI allows you to create a single report that automatically adjusts its layout for different screen sizes?

Power BI Embedded
Power BI Paginated Reports
Responsive layout / Mobile layout (Correct answer)
Composite models

Correct answer: Responsive layout / Mobile layout

Power BI's mobile layout feature lets report authors design an optimized view that adapts to phone or tablet screen sizes.

Question 28: Which Dataverse table ownership type makes records accessible to all users in the organization without owner-based restrictions?

User or team owned
Business unit owned
Public owned
Organization owned (Correct answer)

Correct answer: Organization owned

Organization-owned tables store records accessible to all users with appropriate security role privileges, without per-record ownership tracking.

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

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

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 30: In model-driven apps, what is a 'form' used for?

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)
Configuring security roles for the app

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: Which Power Automate feature allows you to extract structured data from documents such as invoices and receipts using AI?

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

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 32: In Power Automate, what is the purpose of a 'Condition' action?

To loop through a list of items
To branch a flow based on a true/false evaluation (Correct answer)
To send an HTTP request to an external service
To pause a flow for a set time period

Correct answer: To branch a flow based on a true/false evaluation

A Condition action evaluates a logical expression and splits the flow into 'Yes' and 'No' branches based on whether the condition is true or false.

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

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

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 34: What is an 'environment variable' in the context of Power Automate solutions?

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 variable that persists its value across multiple flow runs
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 35: 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 defines what happens when the user taps a button control
It sets the default screen displayed after login

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 36: Which Power Platform tool would you use to analyze adoption metrics such as active makers, flow runs, and app sessions across your tenant?

Power BI Embedded
Azure Monitor
Microsoft Defender for Cloud Apps
Power Platform Admin Center analytics (Correct answer)

Correct answer: Power Platform Admin Center analytics

The Power Platform Admin Center includes built-in analytics dashboards that display tenant-wide usage metrics for Power Apps, Power Automate, and Power Virtual Agents.

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

Showing a scrollable list of records from a data source (Correct answer)
Grouping multiple input controls into a reusable template
Managing navigation between app screens
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 38: In Copilot Studio, what is a 'variable' used for?

Storing a piece of information captured during the conversation for later use in that session (Correct answer)
Mapping user intents to specific topics
Defining configurable environment settings for the copilot
Setting the temperature parameter for the AI language model

Correct answer: Storing a piece of information captured during the conversation for later use in that session

Variables store data (such as a user's name or account number) collected during the conversation so it can be referenced and reused in later nodes.

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

A flow that requires admin sign-off before it can be activated
A flow that checks data quality before inserting records into Dataverse
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 verifies connector credentials before running

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 40: 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 41: Which of the following is a key difference between canvas apps and model-driven apps?

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

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 42: What is a Power BI App?

A custom connector built with Power Query M
The standalone desktop installer for Power BI Desktop
A packaged collection of dashboards and reports distributed to end users (Correct answer)
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 43: Which expression function in Power Automate returns the current date and time?

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

Correct answer: now()

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

Question 44: Which of the following capabilities does Power Pages support for global organizations?

Multiple languages on a single site (Correct answer)
English language only
Only one language per website
Up to three languages maximum

Correct answer: Multiple languages on a single site

Power Pages supports multi-language websites, allowing content to be translated and served in a visitor's preferred language from a single site.

Question 45: Which data platform does Power Pages natively integrate with to store and retrieve website data?

SharePoint Lists
Azure SQL Database
Microsoft Access
Microsoft Dataverse (Correct answer)

Correct answer: Microsoft Dataverse

Power Pages natively integrates with Microsoft Dataverse, the same data platform used by Power Apps model-driven apps, to power data-driven websites.

Question 46: What is the maximum number of data sources a canvas app can connect to simultaneously?

255 (Correct answer)
5
Unlimited
10

Correct answer: 255

A single canvas app can connect to up to 255 data sources simultaneously, giving makers broad flexibility in combining multiple services.

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

To prevent report editing by non-authors
To limit the number of rows that can be imported into a dataset
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

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 48: What is 'AI Builder' in the context of Power Platform?

Microsoft's tool for training large language models
A tool to design chatbot conversation flows using AI suggestions
An Azure service for deploying machine learning pipelines
A service that lets makers add pre-built or custom AI models to Power Apps and Power Automate (Correct answer)

Correct answer: A service that lets makers add pre-built or custom AI models to Power Apps and Power Automate

AI Builder provides pre-built AI capabilities (like form processing, object detection, and sentiment analysis) that makers can add to apps and flows without data science expertise.

Question 49: What is the purpose of a 'relationship' in Dataverse?

Defining user security roles and team memberships
Linking records across two tables so related data can be accessed together (Correct answer)
Creating a calculated column that references data from another table
Establishing a network connection between two Dataverse environments

Correct answer: Linking records across two tables so related data can be accessed together

Relationships define how records in one table relate to records in another (e.g., a Contact belongs to an Account), enabling navigation and lookup across tables.

Question 50: Which Power BI Service feature lets you pin a visual from multiple reports onto a single page?

Dataflow
Dashboard (Correct answer)
Workspace
Report

Correct answer: Dashboard

A Power BI Dashboard is a single canvas where you can pin tiles from multiple different reports to create a unified monitoring view.

Question 51: 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 local folder on your PC where .pbix files are saved
A dashboard embedded in a third-party application

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 52: 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.

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