Microsoft Power Platform Fundamentals PL-900 3 — Questions and Answers
Question 1: A manager needs a report that automatically refreshes and shows live sales figures from a SQL database. Which Power BI feature enables this?
- Import mode
- DirectQuery mode (Correct answer)
- Composite model
- Paginated reports
Correct answer: DirectQuery mode
DirectQuery mode sends queries directly to the source database at report view time, so data is always current without requiring a scheduled refresh.
Question 2: In Power Virtual Agents, what is a 'topic'?
- A category label applied to bot conversations for reporting
- A conversation path that defines how the bot responds to a specific user intent (Correct answer)
- A plugin that connects the bot to external APIs
- A pre-built bot template provided by Microsoft
Correct answer: A conversation path that defines how the bot responds to a specific user intent
A topic in Power Virtual Agents is a dialog tree that maps a user's intent (triggered by phrases) to a series of bot responses and actions.
Question 3: Which Power Platform environment type is recommended for developing and testing solutions before deploying to production?
- Default environment
- Sandbox environment (Correct answer)
- Trial environment
- Developer environment
Correct answer: Sandbox environment
Sandbox environments are specifically designed for development, testing, and training, and can be reset or copied without affecting production data.
Question 4: What is the maximum number of rows that Power BI's default Import mode can handle per dataset?
- 100,000 rows
- 1 million rows
- 1 billion rows — with no practical limit in Import mode
- 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 5: Which action in Power Automate is used to retrieve multiple records from a Dataverse table based on filter criteria?
- Get a row by ID
- List rows (Correct answer)
- Create a new row
- Relate rows
Correct answer: List rows
The 'List rows' action queries a Dataverse table and returns multiple records, supporting OData filter expressions to narrow results.
Question 6: A Power Apps canvas app needs to display data from an on-premises SQL Server. What component is required to enable this connection?
- Azure Service Bus
- On-premises data gateway (Correct answer)
- Microsoft Dataverse
- Azure API Management
Correct answer: On-premises data gateway
The on-premises data gateway acts as a bridge, allowing cloud services like Power Apps and Power Automate to securely access on-premises data sources.
Question 7: Which Power Platform capability allows organizations to create reusable components that enforce consistent branding across multiple apps?
- Model-driven app forms
- Component libraries in canvas apps (Correct answer)
- Power BI themes
- Dataverse calculated columns
Correct answer: Component libraries in canvas apps
Canvas app component libraries let makers build reusable UI components with consistent styling and logic that can be shared across multiple canvas apps.
Microsoft Power Platform Fundamentals PL-900 3
A manager needs a report that automatically refreshes and shows live sales figures from a SQL database.
Which Power BI feature enables this?