Microsoft DevOps Engineer Expert AZ-400 Practice Question
You instrument an ASP.NET Core web app with Application Insights. You must discover which API operations are responsible for the worst client-perceived latency over the last 24 hours by calculating the 95th-percentile request duration and listing only the five slowest operations whose 95th percentile is greater than 3 000 ms. Which Kusto Query Language (KQL) statement should you run in Log Analytics to meet the requirement?
requests | where timestamp > ago(1d) | summarize avgduration = avg(duration) by operationName | where avgduration > 3000 | top 5 by avgduration desc
requests | where timestamp > ago(1d) | summarize percentile(duration, 95) by operationName | where duration > 3000 | top 5 by duration desc
requests | where timestamp > ago(1d) | summarize percent_duration = percentile(duration, 95) by operationName | where percent_duration < 3000 | top 5 by percent_duration asc
requests | where timestamp > ago(1d) | summarize P95 = percentile(duration, 95) by operationName | where P95 > 3000 | top 5 by P95 desc
Retrieve request telemetry from the last day (requests table, timestamp filter).
Use the percentile aggregation to compute the 95th-percentile duration for each operationName.
Filter out any operation whose P95 is not above 3 000 ms.
Return only the five operations with the highest P95 values.
The correct query meets every criterion: requests | where timestamp > ago(1d) | summarize P95 = percentile(duration, 95) by operationName | where P95 > 3000 | top 5 by P95 desc
The distractors fail because they either:
Compare the raw duration column instead of the percentile result (making the filter ineffective).
Use average rather than percentile, giving the wrong measure of tail latency.
Keep operations below 3 000 ms or sort ascending, returning the fastest operations instead of the slowest.
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) and where is it used?
Open an interactive chat with Bash
What does the 'percentile' function do in KQL?
Open an interactive chat with Bash
Why is the 95th percentile used for performance analysis instead of average duration?
Open an interactive chat with Bash
What is Kusto Query Language (KQL)?
Open an interactive chat with Bash
What does percentile(duration, 95) mean in the query?
Open an interactive chat with Bash
Why is P95 used instead of average(duration)?
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 .