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. What is Power BI Embedded used for? → Embedding Power BI reports into custom applications or websites for external users
3. What templating language does Power Pages use for advanced page customization? → Liquid
4. What is the default data access level for anonymous (unauthenticated) visitors in Power Pages? → No access to Dataverse data unless explicitly granted
5. What is a Power BI dataset? → A curated connection to one or more data sources with a defined data model
6. 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)
7. In Copilot Studio, what is a 'topic' used for? → Defining a conversational flow that is triggered when a user asks about a specific subject
8. Which Power Platform component provides AI model capabilities that can be integrated into Power Pages? → AI Builder
9. Which section of the Power Pages design studio allows makers to apply visual themes, colors, and font styles across the entire site? → Styling
10. 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
11. What does the Dataverse Web API allow developers to do? → Interact with Dataverse data and metadata using RESTful HTTP requests from any platform
12. Which Microsoft product was Power Pages formerly known as before its rebranding? → Power Apps Portals
13. What does CSAT stand for in the context of Copilot Studio analytics? → Customer Satisfaction
14. Which Power Apps feature allows a maker to run an app in a browser without publishing it? → Power Apps Preview (Play mode in Studio)
15. 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.
16. Which of the following is a valid use case for Power BI Dataflows? → Reusing ETL logic across multiple Power BI datasets
17. Which Power BI license allows a user to publish and share content within an organization? → Power BI Pro
18. In Power Apps canvas apps, which language is used to write formulas and expressions? → Power Fx
19. Which of the following best describes the target audience for websites built with Power Pages? → External users such as customers and business partners
20. Which node type in a Copilot Studio topic allows the bot to ask the user a question and store their response? → Ask a question node
21. Which control in Power Apps allows users to capture a handwritten signature? → Pen input control
22. What is the role of solutions in Power Apps ALM (Application Lifecycle Management)? → Packaging app components for transport between environments (dev → test → production)
23. In model-driven apps, what is a 'form' used for? → Displaying and editing the details of a single record
24. What is the purpose of the 'Apply to each' action in Power Automate? → Iterating over each item in an array and performing actions on each one
25. What is a Power BI workspace? → A collaborative area in the Power BI Service for teams to manage and share content
26. What was Microsoft Copilot Studio previously called? → Power Virtual Agents
27. What is the purpose of a 'relationship' in Dataverse? → Linking records across two tables so related data can be accessed together
28. Which Dataverse security concept restricts which records a user can see based on their position in an organization hierarchy? → Row-level security via owner/team/business unit hierarchy
29. What type of Power Automate flow runs automatically based on a trigger event? → Automated flow
30. In Power Apps, what is a 'gallery' control used for? → Showing a scrollable list of records from a data source