Microsoft Azure Developer Associate AZ-204 Practice Question
You are troubleshooting slow response times in an Application Insights resource for an ASP.NET Core web API. You must identify the five request URLs with the highest average duration over the last 30 minutes, excluding any requests that failed. Which Kusto Query Language (KQL) statement should you run?
requests
| where success == false and timestamp >= ago(30m)
| summarize maxDuration = max(duration) by url
| top 5 by maxDuration desc
requests
| where success == true and timestamp >= ago(30m)
| summarize avgDuration = avg(duration) by url
| top 5 by avgDuration desc
requests
| where timestamp >= ago(30m)
| summarize avg(duration) by url
| sort by duration desc
| take 5
requests
| where success == true and timestamp >= ago(30m)
| summarize avgDuration = avg(duration) by url
| order by avgDuration asc
| take 5
Limit the dataset to the last 30 minutes with timestamp >= ago(30m).
Exclude failed requests by filtering success == true.
Aggregate the data to compute the average duration per URL by using the summarize operator.
Assign the aggregate to a column (for example avgDuration) so it can be referenced in the next operator.
Return only the five slowest URLs by ordering the averages in descending order and selecting the top five.
The correct query satisfies all of these requirements. Each incorrect query fails for at least one reason: using success == false, computing max instead of avg, omitting the success filter, or sorting in ascending order (returning the fastest URLs).
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 KQL and its role in Azure Application Insights?
Open an interactive chat with Bash
What does the `summarize` operator do in KQL?
Open an interactive chat with Bash
How does the `top` operator function in KQL?
Open an interactive chat with Bash
Microsoft Azure Developer Associate AZ-204
Monitor and troubleshoot Azure solutions
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 .