All Microsoft exams
Free PL-900 practice test: 30 questions with answers
30 original questions for Microsoft Power Platform Fundamentals, drawn from every topic area. Answer each one to see whether you got it right and why. No sign-up.
- Free questions
- 30
- Full bank
- 100 questions
All 30 PL-900 questions with answers
The same questions as the test above, grouped by exam topic. Open any question to see the answer and explanation.
Describe Power Platform security (5 questions)
Question 1
A company wants users to see only the records of their own region in a Dataverse table. Which feature enforces this?
- AGiving every user the System Administrator role in every business unit with complete access
- BSharing a single login for each team member via a shared desktop session with a PIN
- CSecurity roles with record-level access based on the business unit or owner
- DMaking the table public on the internet via an anonymous web endpoint with no login
Show answer and explanationHide answer
Correct answer: CDataverse security roles control access to records by business unit, owner or hierarchy, which limits what each user sees. System Administrator access is too broad, shared logins remove accountability, and public tables expose data.
Question 2
Users in different departments must use the same Power Platform environment but keep their data and apps separate. Which concept helps separate them?
- AA single environment with the same name for each app and one data store
- BA separate laptop for each user with its own local copy of Dataverse and its own login
- CTurning off Dataverse in the default environment to reduce cost
- DEnvironments, with separate environments for different purposes or departments
Show answer and explanationHide answer
Correct answer: DEnvironments isolate apps, flows and data, and they can be created for different departments or stages such as development and production. Naming alone does not separate data, laptops do not provide tenant isolation, and turning off Dataverse removes its features.
Question 3
An administrator wants to block certain connectors, such as an unapproved file sharing service, from being used in apps and flows across the organization. Which feature does this?
- ACanvas app backgrounds set per screen in the Power Apps Studio to match brand
- BPower BI themes applied to report visuals with custom color palettes and fonts
- CData loss prevention (DLP) policies that classify connectors and block unapproved ones
- DA reminder e-mail to every maker in the environment that asks them to review their connectors each month
Show answer and explanationHide answer
Correct answer: CDLP policies in Power Platform group connectors and can block combinations that are not allowed, which enforces data controls. Themes and backgrounds are visual settings, and reminder emails are not enforcement.
Question 4
A maker needs to share a canvas app with a colleague so that the colleague can use it but not edit it. Which sharing permission is appropriate?
- AShare the app with the Co-owner role for editing tasks
- BShare the app with the User role rather than the Co-owner role
- CProvide the colleague the environment administrator role
- DSend the editing source file by email as an attachment now
Show answer and explanationHide answer
Correct answer: BSharing with the User permission lets a colleague run the app without editing it, while co-owners can change it. Environment administrator and emailed source files grant more access than needed.
Question 5
Which two practices help secure data in a Power Platform solution? (Choose two.)
- AUse security roles and DLP policies to limit data access and connector use
- BShare one administrator account among all makers
- CTurn off auditing to improve performance
- DGrant environment access only to the users who need it
- EStore passwords in plain text inside flows
Show answer and explanationHide answer
Correct answer: A, DSecurity roles and DLP policies restrict what data and connectors each user can reach, and granting environment access only to people who need it limits exposure. Shared administrator accounts remove accountability, turning off auditing hides misuse, and plain-text passwords in flows expose credentials.
Describe Power Platform (5 questions)
Question 6
A business wants a single set of tools for building apps, automating workflows, analysing data and creating chatbots. Which product family provides these together?
- AMicrosoft Teams Calling Plans
- BMicrosoft Power Platform
- CMicrosoft Project Standard
- DMicrosoft Visio Plan 1 Viewer
Show answer and explanationHide answer
Correct answer: BMicrosoft Power Platform combines Power Apps, Power Automate, Power BI and Power Virtual Agents or Copilot Studio for low-code solutions. Teams is a collaboration tool, Project manages plans, and Visio draws diagrams.
Question 7
A company's staff with little programming experience want to build business applications quickly. Which description best fits Power Platform?
- AA compiled language that requires a full on-premises development team
- BA low-code platform that lets users build apps and automations with visual tools
- CA social network for employees that hosts discussion forums and webinars
- DA rack-mounted hardware appliance for storing backups with mirrored RAID
Show answer and explanationHide answer
Correct answer: BPower Platform uses visual, low-code tools so that business users and developers can build solutions faster. It is not a compiled language, a hardware appliance or a social network.
Question 8
An organization wants to store business data for its Power Platform apps in a managed, secure database with built-in security roles. Which service is this?
- AMicrosoft Forms
- BMicrosoft Stream
- CMicrosoft Whiteboard
- DMicrosoft Dataverse
Show answer and explanationHide answer
Correct answer: DDataverse is the managed data platform for Power Platform, with tables, relationships and security roles. Forms collects responses, Stream hosted video, and Whiteboard is a canvas for collaboration.
Question 9
A team wants a connector-based way to move data between an email service and a spreadsheet when a new message arrives, without writing code. Which product should they use?
- APower BI Desktop
- BPower Pages
- CPower Apps Studio only
- DPower Automate
Show answer and explanationHide answer
Correct answer: DPower Automate uses triggers and connectors to automate workflows across services without code. Power BI visualizes data, Power Pages builds websites, and Power Apps Studio builds apps rather than running automations.
Question 10
Which two statements about Power Platform are correct? (Choose two.)
- APower Platform products share connectors and the Dataverse data platform
- BPower Apps and Power Automate can use the same connectors
- CEach Power Platform product requires its own separate tenant
- DPower Platform is designed only for professional developers
- EPower Platform can be used only on Windows computers
Show answer and explanationHide answer
Correct answer: A, BPower Platform products share connectors and data through Dataverse, and apps and flows can use the same connectors. Products do not need separate tenants, the platform is designed for business makers as well as developers, and it is available in browsers and on mobile devices.
Describe Power Apps (5 questions)
Question 11
A company wants a mobile app for field staff to record inspections, working even with limited connectivity. Which product should be used?
- APower Apps canvas app
- BPower BI report
- CPower Automate flow with no interface
- DMicrosoft Forms survey
Show answer and explanationHide answer
Correct answer: ACanvas apps let makers design the screen layout freely for mobile or desktop, and they can work with connectors and offline data. A report is for analysis, a flow has no user interface, and Forms is for surveys.
Question 12
A business wants an app that is built from a data model, with forms, views and a consistent layout generated from its tables. Which type of Power Apps app fits?
- AModel-driven app
- BCanvas app with no data source
- CPower BI dashboard
- DPower Automate flow
Show answer and explanationHide answer
Correct answer: AModel-driven apps are generated from the Dataverse data model and provide forms, views and dashboards based on the tables. Canvas apps focus on screen layout, dashboards are for analysis, and flows automate processes.
Question 13
A developer wants to add a custom button in a Power Apps canvas app that sends data to an external REST API. Which feature connects the app to the API?
- AA Power BI theme
- BA SharePoint list view
- CA custom connector
- DA Teams channel tab
Show answer and explanationHide answer
Correct answer: CA custom connector describes an external API so that Power Apps and flows can call it securely. A theme changes visuals, list views display data, and channel tabs embed content in Teams.
Question 14
Which two statements about model-driven apps and canvas apps are correct? (Choose two.)
- AModel-driven apps can be designed pixel by pixel on a blank canvas
- BCanvas apps can only use Dataverse tables as their data source
- CModel-driven apps cannot be used on mobile devices
- DCanvas apps give makers control over the layout of each screen
- EModel-driven apps are generated from the Dataverse data model and its forms and views
Show answer and explanationHide answer
Correct answer: D, EModel-driven apps are built from the data model, which provides forms and views automatically, while canvas apps give makers freedom over the screen layout. Canvas apps connect to many data sources, not just Dataverse, and model-driven apps also run on mobile devices.
Question 15
A maker wants to store reusable components such as a standard header and footer that several canvas apps can use. Which feature supports this reuse?
- AComponent libraries
- BA Dataverse business process flow
- CA Power BI dataset
- DA separate copy of each app with the header pasted manually
Show answer and explanationHide answer
Correct answer: AComponent libraries let makers create components once and reuse them across canvas apps. Manual copies drift over time, a Power BI dataset holds data for reports, and business process flows guide stages.
Describe Power Automate (5 questions)
Question 16
A team wants a flow to start automatically whenever a new file is added to a SharePoint library. Which flow type should be used?
- AInstant flow started by a button in an app only
- BDesktop flow with no triggers
- CScheduled flow that runs only once a year
- DAutomated cloud flow with a SharePoint trigger
Show answer and explanationHide answer
Correct answer: DAn automated cloud flow starts when an event such as a file creation occurs, so it reacts without manual action. Instant flows need a user to start them, scheduled flows run on a timer, and desktop flows automate local applications.
Question 17
A user wants to run a flow manually from a mobile phone whenever they need to submit an expense. Which flow type matches this?
- AInstant cloud flow with a manual trigger
- BAutomated flow triggered by a file upload
- CScheduled flow at midnight
- DBusiness process flow only
Show answer and explanationHide answer
Correct answer: AAn instant flow with a manual trigger is started by the user on demand, including from the mobile app. Automated and scheduled flows start from events or timers, and business process flows guide stages rather than run on demand.
Question 18
A process automation needs to click through a legacy desktop application that has no API. Which Power Automate capability is designed for this?
- ADesktop flows using robotic process automation
- BDataverse business rules on the forms
- CPower Pages website templates for portals
- DPower BI on-premises data gateway for SSAS tabular
Show answer and explanationHide answer
Correct answer: ADesktop flows automate user interface actions on Windows applications, which is robotic process automation. Business rules validate data in Dataverse, the data gateway connects on-premises sources, and Pages templates build websites.
Question 19
Which two statements about Power Automate flows are correct? (Choose two.)
- ADesktop flows can automate user interface actions in Windows applications
- BInstant flows can be started manually by a user, including from a mobile device
- CScheduled flows always require a button press to start
- DAutomated flows start when a defined event occurs, such as an item being created
- EFlows cannot use connectors to reach other services
Show answer and explanationHide answer
Correct answer: A, DAutomated flows react to events, and desktop flows automate the user interface of Windows applications through robotic process automation. Instant flows are user-started, scheduled flows run on a timer, and flows rely on connectors to reach other services.
Question 20
A flow uses a SharePoint connector and needs to create an item only if the value in an earlier step is greater than 100. Which flow element implements this decision?
- AA scheduled trigger that runs at fixed times with no branching
- BA desktop recorder that captures keystrokes
- CA condition action with an if-yes and if-no branch
- DA Power BI bookmark that saves a report view state for later
Show answer and explanationHide answer
Correct answer: CA condition action evaluates an expression and runs different branches depending on the result. A schedule does not branch on data, the desktop recorder automates screens, and bookmarks belong to Power BI reports.
Describe Power BI (5 questions)
Question 21
A sales manager wants interactive charts that refresh from company data sources and that can be shared with colleagues in the browser. Which product should be used?
- AMicrosoft Excel desktop without any sharing
- BPower BI
- CMicrosoft Access only
- DMicrosoft Publisher
Show answer and explanationHide answer
Correct answer: BPower BI creates interactive reports and dashboards that refresh from data sources and can be shared in the browser. Excel desktop without sharing, Access and Publisher are not designed for interactive shared business reporting.
Question 22
A report must be visible to a department only after a dashboard is published to a workspace. Which concept provides shared, collaborative content in Power BI?
- AWorkspaces
- BDataverse tables
- CCanvas app screens
- DPower Automate flows
Show answer and explanationHide answer
Correct answer: AWorkspaces are containers where teams create and share reports, dashboards and datasets with defined roles. Flows, tables and app screens are part of other Power Platform products.
Question 23
Data in an on-premises SQL Server database must be refreshed in a Power BI service dataset on a schedule. Which component connects the cloud service to the on-premises data?
- AA Power Apps canvas screen
- BA public IP address on the database
- CA copy of the data emailed weekly
- DThe on-premises data gateway
Show answer and explanationHide answer
Correct answer: DThe on-premises data gateway securely connects the Power BI service to data sources inside the network for scheduled refresh. Public IPs weaken security, emailed copies are manual, and canvas screens are not data connectors.
Question 24
A report designer wants to build visuals and data models on a computer before publishing the report to the cloud service. Which application is used for this?
- APower Pages design studio
- BPower BI Desktop
- CMicrosoft Teams
- DPower Automate mobile app
Show answer and explanationHide answer
Correct answer: BPower BI Desktop is the Windows application for creating reports and data models before publishing. Pages, Teams and the mobile flow app are not used to build reports.
Question 25
A report should be refreshed from a cloud database every morning before staff arrive. Which Power BI capability schedules the refresh?
- AManual refresh in Power BI Desktop on the author's local machine
- BScheduled refresh on the dataset in the Power BI service
- CA Power Automate desktop recorder that replays clicks on a schedule
- DA printed copy of the report dataset delivered by courier each morning
Show answer and explanationHide answer
Correct answer: BScheduled refresh in the Power BI service updates the dataset automatically at chosen times. Manual desktop refreshes need someone to act, desktop recorders automate screens, and printed copies do not refresh data.
Describe Power Platform capabilities (5 questions)
Question 26
A company wants a website for customers, built with Power Platform and connected to Dataverse data, that allows external visitors to sign in and view their records. Which product should be used?
- APower Pages
- BPower Automate desktop
- CPower BI Desktop
- DMicrosoft Forms only
Show answer and explanationHide answer
Correct answer: APower Pages builds secure external websites that can use Dataverse data and authenticate external users. Power BI Desktop builds reports, desktop flows automate local UI actions, and Forms only collects answers.
Question 27
A business wants a conversational assistant that answers customers' questions using its knowledge sources, built by makers without deep coding skills. Which product fits best?
- AMicrosoft Visio Plan 2
- BMicrosoft Planner v2
- CMicrosoft Copilot Studio
- DMicrosoft Project Plan
Show answer and explanationHide answer
Correct answer: CCopilot Studio lets makers build conversational agents that use knowledge sources and connect to actions. Visio draws diagrams, and Project and Planner manage tasks and plans.
Question 28
A maker wants to add AI-generated text to a Power Apps app, such as a summary of a record's notes. Which Power Platform capability supports this?
- AA static image of the screen captured as a bitmap for review
- BA scheduled backup of the app to a file share
- CAI Builder and AI features built into Power Platform
- DDisabling connectors across the tenant nightly
Show answer and explanationHide answer
Correct answer: CAI Builder and built-in AI features let makers add AI capabilities such as summarization and prediction to apps and flows. Disabling connectors, backups and static images do not add AI functions.
Question 29
A company wants to answer customer questions with an automated chat experience inside its website, using its product documents as the knowledge source. Which Power Platform product is designed for this?
- APower BI Desktop app
- BPower Automate desktop
- CMicrosoft Copilot Studio
- DMicrosoft SharePoint Lists
Show answer and explanationHide answer
Correct answer: CCopilot Studio builds agents that answer questions from knowledge sources and can be published to websites and channels. Power BI Desktop builds reports, desktop flows automate local tasks, and Lists tracks items.
Question 30
An organization wants to build an application that reads scanned invoices and extracts the amount and vendor name without training a custom model. Which capability fits?
- AAI Builder prebuilt document processing models
- BCanvas app themes for colours and fonts
- CPower BI slicers placed on the report page for filtering
- DA Dataverse relationship between two tables
Show answer and explanationHide answer
Correct answer: AAI Builder provides prebuilt models, including document processing for invoices, which can be used in apps and flows. Slicers, themes and relationships do not extract information from documents.