mediumMultiple Choice
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 Microsoft's own data store, so it cannot query the ERP tables held in Azure SQL Database without replication or virtual tables. It is tempting as Power Platform's native database, and would be correct for storing new app data rather than integrating an external SQL source.
- ✗
Power BI
Why it's wrong here
Power BI visualises and reports on data; it performs no write-back or transactional integration with Azure SQL Database, so invoice processing cannot be automated through it. It is tempting because it connects to Azure SQL for analytics, which is the right choice for dashboards, not for moving invoice records.
- ✓
Power Automate
Why this is correct
Power Automate provides built-in connectors and the Azure SQL Database connector, enabling automated invoice workflows to read and write ERP data without custom code. This satisfies the integration requirement by orchestrating triggers and actions between Power Platform and the Azure-hosted ERP.
- ✗
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 — 701 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.