SC-900 Practice Question: Describe the concepts of security, compliance, and identity
Exhibit
Refer to the exhibit. ```kusto // KQL query in Microsoft Sentinel SecurityAlert | where TimeGenerated > ago(7d) | where AlertName has "MFA" | summarize Count = count() by AlertName, bin(TimeGenerated, 1d) | render timechart ```
You are a security analyst using Microsoft Sentinel. You run the following Kusto query:
SecurityAlert | where TimeGenerated > ago(7d) | where AlertName contains "MFA" | summarize Count = count() by bin(TimeGenerated, 1d) | render timechart
What does this query do?
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
✓
Counts security alerts containing 'MFA' per day for the last 7 days
The Kusto query filters security alerts containing 'MFA' in the alert name over the last 7 days, counts the number of alerts per day, and renders a timechart. Option B is incorrect because the query counts alerts, not identities. Option C is incorrect because it counts alerts, not distinct users. Option D is incorrect because the query does not filter by severity.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Counts security alerts containing 'MFA' per day for the last 7 days
Why this is correct
Summarize count() by AlertName and time creates a daily count.
- ✗
Lists all identities that triggered MFA alerts
Why it's wrong here
It does not list identities; it aggregates counts.
- ✗
Counts distinct users with MFA alerts per day
Why it's wrong here
It counts alerts, not distinct users.
- ✗
Counts alerts by severity over the last week
Why it's wrong here
There is no severity filter or grouping.
Go deeper
Related to this question
Learn chapter
Core Security Concepts
Key term
Alert
An alert is a notification that something unusual or potentially harmful has happened in a computer system or network.
Key term
MFA
Multi-Factor Authentication (MFA) is a security method that requires a user to verify their identity using two or more different types of evidence, such as a password plus a code from a phone, before they can access an account or system.
About these practice questions
This SC-900 question is part of Courseiva's 1,250-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 SC-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 SC-900 exam.