PL-900 Practice Question: Demonstrate the capabilities of Power Automate
A company wants to automate the process of archiving completed sales orders from a SQL Server database to a SharePoint list every night. Which approach should they use?
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
✓
Use a SQL Server connector with a 'Recurrence' trigger to query and move data.
It uses a Recurrence trigger to run the flow on a schedule (every night) to query SQL Server for completed sales orders and archive them to SharePoint. Option A uses an event-driven trigger (when an item is created) which is not suitable for a nightly batch process. Option B is an instant flow triggered manually by a button, not automated. Option C requires an external scheduler to send an HTTP request, but Power Automate's built-in Recurrence trigger is simpler and more appropriate.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Use a 'When an item is created' trigger on the SQL table.
Why it's wrong here
A 'When an item is created' trigger fires on row insertion, not on a nightly schedule, and completed orders are updates rather than new records. It is correct when you must react immediately to each new SQL row.
- ✗
Create an instant flow triggered by a Power Apps button for manual archiving.
Why it's wrong here
An instant flow requires a user to press a Power Apps button, so it cannot run unattended each night; the stem demands scheduled, automated execution. Instant flows suit on-demand user actions, such as archiving a single order from a canvas app, where human initiation is intended rather than nightly batch processing.
- ✗
Use a 'When a HTTP request is received' trigger from an external scheduler.
Why it's wrong here
An HTTP request trigger requires an external scheduler to send a POST request each night, but the scenario demands a scheduled, self-contained automation that runs without external dependencies. This option is tempting because it is commonly used to expose Power Automate flows to external systems, and would be correct if the company already had a scheduler capable of invoking the endpoint reliably.
- ✓
Use a SQL Server connector with a 'Recurrence' trigger to query and move data.
Why this is correct
A scheduled 'Recurrence' trigger in Power Automate fires nightly without manual intervention, satisfying the automation constraint. The SQL Server connector retrieves completed sales orders, and the SharePoint connector writes them to the target list, achieving the required data movement between the two systems.
Go deeper
Related to this question
About these practice questions
This PL-900 question is part of Courseiva's 701-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam 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.