Question

Your team runs an Application Insights-instrumented web API. Product management wants a weekly report showing the 99th percentile server response time grouped by each API operation (URL path), covering the last 7 days. You need to write a KQL query against the requests table that returns one row per operation with its p99 duration. Which query satisfies this requirement?

Accepted Answer

requests | where timestamp > ago(7d) | summarize percentile(duration, 99) by operation_Name

Answer

requests | where timestamp > ago(7d) | summarize avg(duration) by bin(timestamp, 1d)

Answer

requests | where timestamp > ago(7d) | top 99 by duration desc by operation_Name

Answer

requests | where timestamp > ago(7d) | project duration, operation_Name | render timechart