Construct an Azure Log Analytics query that finds failed user sign-in attempts from the last several days and returns only users with more than five failed attempts. Which elements should be included in the query?
Choose an answer
Tap an option to check your answer.
Correct answer: EventID and Count().
Why this is the answer
The correct option is EventID and Count() because EventID is a common field in Azure AD sign-in logs that identifies specific events, such as failed sign-in attempts. The Count() aggregation function is used to tally the number of occurrences of these events, which is necessary to identify users with more than five failed attempts. CountIf() is not a standard KQL aggregation function; Count() is used with a where clause for conditional counting. ActivityID is a unique identifier for a single activity or operation, not an event type, making it unsuitable for filtering failed sign-in events across multiple attempts.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed