Microsoft DevOps Engineer Expert AZ-400 Practice Question
You manage a production Azure App Service that is instrumented with Application Insights and sends its telemetry to a Log Analytics workspace. Users report intermittent latency. You must discover which request operations have the highest server-side latency at the 95th percentile during the last hour by running a single Kusto Query Language (KQL) statement. Which KQL statement should you run?
requests | where timestamp > ago(1h) | summarize avg(duration), percentile(duration, 95), count() by operation_Name
dependencies | where timestamp > ago(1h) | summarize percentile(totalDuration, 95), count() by name
traces | where timestamp > ago(1h) | summarize percentile(duration, 95), count() by operation_Name
requests | where timestamp > ago(1h) | extend p95 = percentile(duration, 95) | summarize avg(duration), p95, count() by cloud_RoleName
The requests table records each incoming HTTP request, including its duration and the operation_Name field. Filtering the last hour with ago(1h) keeps only recent data. The summarize operator can calculate multiple aggregates in one step; using percentile(duration, 95) returns the 95th-percentile latency for each group. Grouping by operation_Name surfaces the specific operations that are slow. The other options are incorrect because they either group by the wrong field, use the wrong telemetry table, or omit the requests data needed to measure server response time for operations.
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
What is the percentile function in KQL?
Open an interactive chat with Bash
What is the purpose of the `summarize` operator 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 .