easymultiple choiceObjective-mapped

A support engineer needs to search a Log Analytics workspace for only failed sign-in records. Which KQL query should they use?

Question 1easymultiple choice
Full question →

A support engineer needs to search a Log Analytics workspace for only failed sign-in records. Which KQL query should they use?

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Distractor review

SigninLogs | where ResultType == 0

ResultType 0 typically indicates success, so this query would not return failed sign-ins.

B

Best answer

SigninLogs | where ResultType != 0

Filtering for values other than zero is a common way to return failed sign-in records in SigninLogs.

C

Distractor review

SigninLogs | summarize count()

This counts all records but does not filter for failed sign-ins.

D

Distractor review

SigninLogs | project UserPrincipalName

Projecting a column changes the displayed fields, but it does not identify failed events.

Common exam trap

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Technical deep dive

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

  • Static NAT maps one inside address to one outside address.
  • PAT allows many inside hosts to share one public address using ports.
  • Inside local and inside global describe the private and translated addresses.
  • NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

  • Identify inside and outside interfaces first.
  • Check whether the scenario needs static NAT, dynamic NAT or PAT.
  • Do not confuse NAT matching ACLs with normal packet-filtering intent.

Related practice questions

Related AZ-104 practice-question pages

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

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

FAQ

Questions learners often ask

What does this AZ-104 question test?

Static NAT maps one inside address to one outside address.

What is the correct answer to this question?

The correct answer is: SigninLogs | where ResultType != 0 — The query that filters on `ResultType != 0` is correct because failed sign-ins in the SigninLogs table are typically represented by nonzero result values. This is a simple and practical KQL pattern for narrowing results to failures so the support engineer can investigate what went wrong. The other queries either count everything, display one column, or filter for success. Why others are wrong: Filtering for `ResultType == 0` returns successful sign-ins rather than failed ones. `summarize count()` gives a total count but not the failure records themselves. `project UserPrincipalName` only changes the output columns and does not perform the needed troubleshooting filter.

What should I do if I get this AZ-104 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.