Crucial Exams

Microsoft Azure Developer Associate AZ-204 Practice Question

When examining Application Insights data for an ASP.NET Core API you want to pinpoint operations that generated server errors in the last hour. Specifically, list each operation whose requests returned an HTTP 5xx code more than 50 times and show those operations ordered from slowest to fastest by their average request duration. Which Kusto Query Language (KQL) query meets the requirements?

  • requests
| where timestamp >= ago(1h)
| where toint(resultCode) between (500 .. 599)
| summarize count() > 50, avg(duration) by operation_Name  // invalid summarize syntax
| order by avgDuration asc

  • requests
| where timestamp >= ago(1h)
| where toint(resultCode) between (500 .. 599)
| summarize count_=count(), avgDuration=avg(duration) by operation_Name
| where count_ > 50
| order by avgDuration desc

  • requests
| where timestamp >= ago(1h)
| where resultCode startswith "5"
| summarize avgDuration = avg(duration) by operation_Name
| where count_ > 50  // count_ is not defined here
| order by avgDuration desc

  • traces
| where timestamp >= ago(1h)
| where severityLevel >= 3
| summarize count_=count(), avgDuration=avg(duration) by operation_Name
| where count_ > 50
| order by avgDuration desc
Microsoft Azure Developer Associate AZ-204
Monitor and troubleshoot Azure solutions
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot