Microsoft DevOps Engineer Expert AZ-400 Practice Question
You are troubleshooting performance issues in a web application instrumented with Application Insights. You must write a Kusto Query Language (KQL) statement that lists, for the last 30 minutes, the number of server requests that returned HTTP status codes between 500 and 599, grouped by operation_Name, and shows the operations that failed most often first. Which query meets the requirement?
requests
| where timestamp <= ago(30m) and resultCode >= 500
| summarize count() by bin(timestamp, 5m)
| order by timestamp asc
requests
| where timestamp >= ago(30m) and toint(resultCode) between (500 .. 599)
| summarize Failed=count() by operation_Name
| order by Failed desc
requests
| where timestamp >= ago(30m) and toint(resultCode) >= 500
| summarize Failed=count() by operation_Name
| order by Failed asc
requests
| where timestamp between (now() .. ago(30m)) and resultCode in (500,501,502,503,504,505)
| summarize count() by operation_Name
| sort asc by count_
The correct query filters the Requests table to the last 30 minutes and converts resultCode to an integer so that the numeric range 500-599 can be evaluated. It then uses summarize to count failures per operation_Name and orders the result in descending order, so operations with the highest number of failures appear first. The other queries are incorrect because they either use the wrong time filter, do not group by operation_Name, reverse the time range, or sort the results in ascending order.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Kusto Query Language (KQL)?
Open an interactive chat with Bash
Why is the `toint()` function used in the correct KQL query?
Open an interactive chat with Bash
What does the `summarize` and `order by` functions do in KQL?
Open an interactive chat with Bash
Microsoft DevOps Engineer Expert AZ-400
Implement an instrumentation strategy
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .