The answer is a scheduled query rule, because it is the only Microsoft Sentinel rule type that supports custom KQL queries with aggregation and threshold-based alerting for time-windowed conditions. This rule allows you to write a query that counts failed Azure AD sign-ins grouped by source IP address over a sliding 5-minute window, then triggers an incident when the count exceeds 10—exactly matching the scenario’s requirement for threshold alerting on failed sign-ins. On the AZ-500 exam, this tests your understanding of how scheduled query rules differ from other rule types like NRT (near-real-time) or anomaly rules, which either lack custom aggregation or rely on machine learning. A common trap is confusing scheduled rules with NRT rules, but remember: NRT rules run every minute on a fixed 1-minute lookback and cannot use sliding windows or custom thresholds. Memory tip: “Schedule your threshold” — scheduled query rules are your go-to for any count-based alert with a custom time window and threshold.
AZ-500 Manage identity and access Practice Question
This AZ-500 practice question tests your understanding of manage identity and access. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. A key principle to apply: scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).. 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.
A security team uses Microsoft Sentinel. They want to create a custom analytic rule that triggers an incident when more than 10 failed Azure Active Directory sign-ins occur from the same source IP address within any 5-minute window. Which type of rule should they use?
Scheduled query rules run on a schedule (e.g., every 5 minutes) and support aggregation over time windows. They are ideal for counting events and setting thresholds.
B
Near-Real-Time (NRT) rule
Why wrong: NRT rules run every minute but have a short lookback (typically 10 minutes) and are designed for single-event detection, not for counting over a fixed window.
C
Fusion rule
Why wrong: Fusion rules use advanced machine learning to correlate multiple alerts into incidents, not for simple threshold-based counting.
D
Anomaly rule
Why wrong: Anomaly rules use machine learning to detect deviations from baseline behavior, not for hard thresholds like a count of 10.
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Scheduled query rule
A scheduled query rule is correct because it allows you to define a KQL query that counts failed Azure AD sign-ins grouped by source IP address within a 5-minute sliding window, and then triggers an incident when the count exceeds 10. This rule type supports custom aggregation and threshold-based alerting, which is exactly what the scenario requires.
Key principle: Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
✓
Scheduled query rule
Why this is correct
Scheduled query rules run on a schedule (e.g., every 5 minutes) and support aggregation over time windows. They are ideal for counting events and setting thresholds.
Related concept
Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).
✗
Near-Real-Time (NRT) rule
Why it's wrong here
NRT rules run every minute but have a short lookback (typically 10 minutes) and are designed for single-event detection, not for counting over a fixed window.
✗
Fusion rule
Why it's wrong here
Fusion rules use advanced machine learning to correlate multiple alerts into incidents, not for simple threshold-based counting.
✗
Anomaly rule
Why it's wrong here
Anomaly rules use machine learning to detect deviations from baseline behavior, not for hard thresholds like a count of 10.
Common exam traps
Common exam trap: answer the scenario, not the keyword
The trap here is that candidates often confuse NRT rules with scheduled queries, assuming NRT rules can handle aggregation over time windows, but NRT rules only evaluate individual events in near real-time and cannot perform the required 5-minute grouping or threshold counting.
Detailed technical explanation
How to think about this question
Under the hood, a scheduled query rule runs a KQL query at a defined interval (e.g., every 5 minutes) against the SigninLogs table, using the `summarize` operator with `bin(TimeGenerated, 5m)` to group events into 5-minute windows. The rule's trigger condition is set to 'Number of results greater than 10', which fires an incident only when the aggregated count exceeds the threshold. A real-world scenario where this matters is detecting brute-force attacks that spread across multiple user accounts but originate from a single IP, which a simple NRT rule would miss.
KKey Concepts to Remember
Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).
They support aggregation functions like `count()` and `bin()` for threshold detection.
Scheduled rules are ideal for custom logic and specific numerical thresholds over time.
They can generate incidents based on query results meeting specified criteria.
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
Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).
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. Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes). Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
Related glossary terms
Concepts from this question explained
These glossary pages explain the core terms tested in this AZ-500 question in full detail.
Review scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes)., then practise related AZ-500 questions on the same topic to reinforce the concept.
Manage identity and access — This question tests Manage identity and access — Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes)..
What is the correct answer to this question?
The correct answer is: Scheduled query rule — A scheduled query rule is correct because it allows you to define a KQL query that counts failed Azure AD sign-ins grouped by source IP address within a 5-minute sliding window, and then triggers an incident when the count exceeds 10. This rule type supports custom aggregation and threshold-based alerting, which is exactly what the scenario requires.
What should I do if I get this AZ-500 question wrong?
Review scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes)., then practise related AZ-500 questions on the same topic to reinforce the concept.
What is the key concept behind this question?
Scheduled query rules run KQL queries on a defined schedule (e.g., every 5 minutes).
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 →
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.
This AZ-500 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 AZ-500 exam.
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.
Sign in to join the discussion.