Free Microsoft Power Platform Fundamentals Practice Test

A retail company wants to empower citizen developers to create custom business applications without extensive coding knowledge. The applications need to connect to existing data sources like SharePoint and SQL Server. Which Power Platform component should they primarily use?

Your organization needs to analyze sales data from multiple sources and create interactive dashboards that automatically refresh. Business users should be able to explore the data and share insights with stakeholders. Which Power Platform service is most appropriate?

A company wants to automate the approval process for expense reports. When an employee submits an expense report in SharePoint, it should automatically send an approval request to their manager via email and update the status based on the manager's response. Which Power Platform component provides this capability?

What type of Power Apps application should you create if you need to build a mobile-optimized app with a portrait orientation that users can run on their smartphones and tablets?

A customer service department wants to create an automated conversational bot to answer frequently asked questions on their website without requiring users to contact human agents. Which Power Platform tool should they use?

Your organization has built several Power Apps and Power Automate flows in a development environment. You need to move these solutions to the production environment while maintaining relationships and dependencies. What should you use?

A company needs to create a data-driven application where the user interface is automatically generated based on the underlying data model in Microsoft Dataverse. The app requires complex business logic, security roles, and process flows. Which type of app should they build?

You need to create a Power Automate flow that runs once every weekday at 9:00 AM to generate a report and send it via email. Which type of trigger should you use?

In Power BI, you have a dataset that needs to display the most current data from your SQL database. The data updates every hour, and reports must reflect these changes. What refresh option should you configure?

A Power Virtual Agents bot needs to perform a complex calculation or call an external API that is not available through standard actions. What feature should you use to extend the bot's capabilities?

Your organization wants to ensure that sensitive customer data in Dataverse is only accessible to specific security roles. Users in the Sales role should only see records they own, while managers should see all records in their business unit. What Dataverse security feature addresses this requirement?

A company needs to create a flow that monitors a shared mailbox and automatically creates tasks in Microsoft Planner when emails with specific keywords arrive. Which type of Power Automate flow is most appropriate?

In Power BI, you need to combine data from an Excel file and a SQL database, perform transformations like removing duplicates and changing data types, before loading it into your report. Which Power BI component should you use?

Your organization wants to reduce the Total Cost of Ownership (TCO) by replacing multiple custom-coded applications with low-code solutions. Which business value does this scenario primarily represent for Power Platform adoption?

A canvas app uses a collection to store temporary data during the user session. After filtering and manipulating the data, you need to display it in a gallery control. Which function category would you primarily use to work with this collection?

A multinational company needs to create Power Automate flows that handle errors gracefully. When a flow fails to update a record in Dataverse due to a network issue, it should retry the operation three times with delays, and if still unsuccessful, send a notification to IT support. What flow features should be implemented?

You are designing a Power BI solution where different departments need to see the same reports but filtered to show only their department's data. Security must be enforced at the data level. What Power BI feature should you implement?

A company is building a model-driven app with Dataverse. They need to ensure data consistency by automatically calculating the total order amount whenever order line items are added, updated, or deleted. The calculation must happen immediately and reliably. What Dataverse feature should they use?

An organization needs to automate a legacy desktop application that has no API and requires mouse clicks and keyboard inputs to process invoices. The application runs on Windows desktops. Which Power Platform capability should they use?

A Power BI developer needs to create a measure that calculates year-over-year sales growth percentage, comparing current year sales to previous year sales. The calculation must work correctly regardless of how the report is filtered. What approach should they use?