mediumMultiple ChoiceObjective-mapped
PL-900 Practice Question: A company uses Microsoft Power Platform to…
A company uses Microsoft Power Platform to automate invoice processing. They want to integrate with their existing ERP system hosted on Azure SQL Database. Which Power Platform component is best suited for this integration?
⚠ Common exam trap
A common mix-up: candidates confuse Power Automate with Power Apps, thinking that building an app is necessary for integration, but Power Automate is specifically designed for workflow automation and system-to-system integration without a user interface.
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Power Automate
Power Automate is the correct choice because it provides built-in connectors for Azure SQL Database, enabling seamless integration with the existing ERP system without custom code. It can trigger automated workflows based on invoice events, such as when a new record is created in the SQL database, and orchestrate data processing across multiple systems.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Dataverse
Why it's wrong here
Dataverse is a data platform, not a workflow automation tool.
- ✗
Power BI
Why it's wrong here
Power BI is for data visualization and analytics.
- ✓
Power Automate
Why this is correct
Power Automate creates automated workflows and can connect to Azure SQL Database via connectors.
- ✗
Power Apps
Why it's wrong here
Power Apps is a low-code platform for building custom applications, not a dedicated integration tool for connecting to Azure SQL Database. The scenario requires direct, automated data synchronisation between the ERP system and invoice processing, which Power Automate (or Azure Logic Apps) handles through connectors and triggers. Power Apps would be tempting if the goal were to create a user interface for manually viewing or editing invoice data, but it lacks the background workflow engine to orchestrate the automated integration described.
Go deeper
Related to this question
About these practice questions
Courseiva writes every PL-900 question from scratch — 904 in total, each with an explanation and a wrong-answer breakdown. None are copied from real exams or dumps. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-900 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-900 exam.