Question 536 of 976

Quick Answer

The answer is that the flow misses records because it runs on a recurring schedule rather than triggering instantly on record creation. When a scheduled flow runs hourly, it uses a polling mechanism that checks for new records based on a timestamp filter, but records created at the exact hour boundary can fall into a gap between the end of one run and the start of the next, especially if the flow’s query excludes the boundary moment. This question tests your understanding of the critical difference between scheduled and event-driven triggers in Power Automate, a common trap on the PL-900 exam where candidates overlook that scheduled flows are not real-time. The key insight is that a scheduled flow is a batch process, not a live listener, so it cannot capture records created between polling intervals. Remember the memory tip: “Scheduled polls, triggers catch”—if you need zero-miss accuracy, use a Dataverse row trigger instead of a recurring schedule.

PL-900 Practice Question: Describe the business value of Microsoft Power Platform

This PL-900 practice question tests your understanding of describe the business value of microsoft power platform. This is a configuration task: choose the command set that satisfies every stated requirement. Small differences — like 'secret' vs 'password' or 'transport input ssh' vs 'all' — change whether the answer is correct. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.

Exhibit

{
  "triggers": [
    {
      "type": "Schedule",
      "recurrence": {
        "frequency": "Hour",
        "interval": 1
      }
    }
  ],
  "actions": [
    {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataservice"
        },
        "parameters": {
          "tableName": "accounts",
          "filterQuery": "createdon ge @{addHours(utcNow(), -1)}"
        }
      }
    }
  ]
}

Refer to the exhibit. A Power Automate flow runs hourly to retrieve new accounts from Dataverse. However, it sometimes misses records created at the exact hour boundary. What is the most likely reason?

Clue words in this question

Noticing these words before you look at the options changes how you read each choice.

  • Clue: "most likely"

    Why it matters: Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.

Question 1hardmultiple choice
Full question →

Exhibit

{
  "triggers": [
    {
      "type": "Schedule",
      "recurrence": {
        "frequency": "Hour",
        "interval": 1
      }
    }
  ],
  "actions": [
    {
      "type": "ApiConnection",
      "inputs": {
        "host": {
          "apiId": "/providers/Microsoft.PowerApps/apis/shared_commondataservice"
        },
        "parameters": {
          "tableName": "accounts",
          "filterQuery": "createdon ge @{addHours(utcNow(), -1)}"
        }
      }
    }
  ]
}

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

The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs.

Option A is correct because the flow is configured to run on a recurring schedule (e.g., every hour), not as an instant trigger on record creation. When a record is created at the exact boundary between two scheduled runs, it may not be captured by the previous run (which already completed) and may not yet exist when the next run begins, especially if the flow uses a filter query based on a timestamp. This is a classic limitation of scheduled polling compared to event-driven triggers like 'When a row is added, modified, or deleted' in Dataverse.

Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs.

    Why this is correct

    A scheduled flow may miss records due to clock skew or processing delays; a trigger-based flow would be more reliable.

    Clue confirmation

    The clue word "most likely" in the question point toward this answer.

    Related concept

    Read the scenario before looking for a memorised answer.

  • The accounts table has a security filter that hides records from the flow owner.

    Why it's wrong here

    If the flow owner has appropriate permissions, security filters should not cause intermittent issues.

  • The API connection to Dataverse is not authenticated properly.

    Why it's wrong here

    Authentication issues would cause consistent failures, not intermittent misses.

  • The filter query uses utcNow() which may not be precise across time zones.

    Why it's wrong here

    utcNow() is UTC, but the issue is timing, not time zone.

Common exam traps

Common exam trap: answer the scenario, not the keyword

The trap here is that candidates often assume utcNow() is the cause of the issue, but the real problem is the fundamental difference between scheduled polling and event-driven triggers in Power Automate.

Detailed technical explanation

How to think about this question

Under the hood, scheduled flows use a polling mechanism that queries Dataverse at fixed intervals. If the flow's filter query uses a condition like `createdon ge @{utcNow()}` to fetch records created since the last run, any record created after the query executes but before the next scheduled run will be missed. This is a common challenge in ETL patterns where event-driven triggers (e.g., webhooks or change tracking) are preferred for near-real-time data capture. In real-world scenarios, this can lead to data loss in time-sensitive integrations like CRM-to-ERP syncs.

KKey Concepts to Remember

  • Read the scenario before looking for a memorised answer.
  • Find the constraint that changes the correct option.
  • Eliminate answers that are true in general but not in this case.

TExam Day Tips

  • Watch for words such as best, first, most likely and least administrative effort.
  • Review why wrong options are wrong, not only why the correct option is correct.

Key takeaway

Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.

Real-world example

How this comes up in practice

A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.

What to study next

Got this wrong? Here's your next step.

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Related practice questions

Related PL-900 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

Identify foundational components of Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Power Platform.

Demonstrate capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate capabilities of Power BI.

Describe complementary Microsoft Power Platform solutions practice questions

Practise PL-900 questions linked to Describe complementary Microsoft Power Platform solutions.

Demonstrate the capabilities of Power Automate practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Automate.

Describe the business value of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Describe the business value of Microsoft Power Platform.

Manage the Microsoft Power Platform environment practice questions

Practise PL-900 questions linked to Manage the Microsoft Power Platform environment.

Identify foundational components of Microsoft Power Platform practice questions

Practise PL-900 questions linked to Identify foundational components of Microsoft Power Platform.

Demonstrate the capabilities of Power BI practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power BI.

Demonstrate the capabilities of Power Apps practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Apps.

Demonstrate the capabilities of Microsoft Copilot Studio practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Microsoft Copilot Studio.

Demonstrate the capabilities of Power Pages practice questions

Practise PL-900 questions linked to Demonstrate the capabilities of Power Pages.

PL-900 fundamentals practice questions

Practise PL-900 questions linked to PL-900 fundamentals.

Practice this exam

Start a free PL-900 practice session

Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.

FAQ

Questions learners often ask

What does this PL-900 question test?

Describe the business value of Microsoft Power Platform — This question tests Describe the business value of Microsoft Power Platform — Read the scenario before looking for a memorised answer..

What is the correct answer to this question?

The correct answer is: The flow runs on a schedule, not triggered by record creation, so it may miss records created between runs. — Option A is correct because the flow is configured to run on a recurring schedule (e.g., every hour), not as an instant trigger on record creation. When a record is created at the exact boundary between two scheduled runs, it may not be captured by the previous run (which already completed) and may not yet exist when the next run begins, especially if the flow uses a filter query based on a timestamp. This is a classic limitation of scheduled polling compared to event-driven triggers like 'When a row is added, modified, or deleted' in Dataverse.

What should I do if I get this PL-900 question wrong?

Identify which exam domain this question belongs to, review the core concept, then practise similar questions from the same domain.

Are there clue words in this question I should notice?

Yes — watch for: "most likely". Probability qualifier — the question wants the most probable cause or outcome, not a guaranteed one. Eliminate low-probability options.

What is the key concept behind this question?

Read the scenario before looking for a memorised answer.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

Last reviewed: Jun 24, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

Sign in to join the discussion.

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.