Microsoft Power Platform Fundamentals Cheat Sheet 2026

The 30 highest-yield Microsoft Power Platform Fundamentals facts, distilled from real exam questions. Print it, save it as a PDF, or study it here — free, no sign-up.

1. Which Dataverse feature allows a column to store the sum or count of related child records? → Rollup column
2. In Power Virtual Agents, what is a 'topic'? → A conversation path that defines how the bot responds to a specific user intent
3. Which Power Platform licensing model allows organizations to estimate costs based on the number of individual users who will access apps? → Per-app licensing (per user per app)
4. What is Power BI Embedded used for? → Embedding Power BI reports into custom applications or websites for external users
5. What templating language does Power Pages use for advanced page customization? → Liquid
6. Which Power Apps feature allows makers to test their app on a mobile device before publishing? → Power Apps Mobile app
7. What is the default data access level for anonymous (unauthenticated) visitors in Power Pages? → No access to Dataverse data unless explicitly granted
8. A government agency needs a public-facing portal where citizens can submit permit applications. Which Power Platform component is best suited for this use case? → Power Pages (formerly Power Apps Portals)
9. What is a Power BI dataset? → A curated connection to one or more data sources with a defined data model
10. 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)
11. In Copilot Studio, what is a 'topic' used for? → Defining a conversational flow that is triggered when a user asks about a specific subject
12. What is the maximum number of environments a user can create by default in a Power Platform tenant (excluding the default environment)? → Unlimited, subject to capacity
13. Which Power Platform component provides AI model capabilities that can be integrated into Power Pages? → AI Builder
14. Which Power Virtual Agents feature allows the bot to hand off a conversation to a human agent when it cannot resolve the user's issue? → Transfer to agent
15. Which metric would best demonstrate the ROI (Return on Investment) of a Power Platform deployment to executive leadership? → Hours saved per week through automated processes and self-service apps
16. Which section of the Power Pages design studio allows makers to apply visual themes, colors, and font styles across the entire site? → Styling
17. Which Power Platform tool would you use to analyze adoption metrics such as active makers, flow runs, and app sessions across your tenant? → Power Platform Admin Center analytics
18. 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
19. Which Dataverse security concept grants a user access to records they own or that are shared with them, but not all records in the organization? → User-level access
20. What does the Dataverse Web API allow developers to do? → Interact with Dataverse data and metadata using RESTful HTTP requests from any platform
21. Which Microsoft product was Power Pages formerly known as before its rebranding? → Power Apps Portals
22. Which Power Platform feature helps organizations enforce governance and compliance across all apps and flows created by citizen developers? → Data Loss Prevention (DLP) policies in the Power Platform admin center
23. What does CSAT stand for in the context of Copilot Studio analytics? → Customer Satisfaction
24. Which Power Apps feature allows a maker to run an app in a browser without publishing it? → Power Apps Preview (Play mode in Studio)
25. Which of the following statements best describes how the Common Data Model and Common Data Service work? → They represent a set of services that exposes the data tables.
26. In Power BI, which visual type is best suited for showing the proportion of individual parts to a whole? → Pie or donut chart
27. Which of the following is a valid use case for Power BI Dataflows? → Reusing ETL logic across multiple Power BI datasets
28. Which Power BI license allows a user to publish and share content within an organization? → Power BI Pro
29. In Power Apps canvas apps, which language is used to write formulas and expressions? → Power Fx
30. Which of the following best describes the target audience for websites built with Power Pages? → External users such as customers and business partners