Microsoft DevOps Engineer Expert AZ-400 Practice Question
Your team needs an operations dashboard that shows the monthly availability of a mission-critical API that is monitored by an Application Insights availability test named "Ping-API". The requirement is to display a single percentage value that represents the ratio of successful test executions to total executions during the last 30 days.
Which Kusto query should you use in an Azure Monitor workbook so the dashboard continuously reflects the correct value?
performanceCounters | where counterName == "Requests/Sec" and timestamp > ago(30d) | summarize availability = 100 * avg(counterValue) | render card
availabilityResults | where name == "Ping-API" and timestamp > ago(30d) | summarize successRate = 100 * sum(toint(success)) / count() by bin(timestamp, 1h) | render timechart
availabilityResults | where name == "Ping-API" | where timestamp > ago(30d) | summarize availability = 100 * sum(toint(success)) / count() | project availability | render card
The availabilityResults table stores one record for every execution of an Application Insights availability test. The column success is a boolean indicating whether the test run passed. Summing the successes and dividing by the total count over the desired time window yields the availability ratio. Multiplying by 100 converts the ratio to a percentage. Using the summarize operator with bin_auto() or a fixed bin groups records; however, because a single value for the whole period is required, summarize without a bin is appropriate. Rendering as a scalar card displays the single percentage value in the workbook. The other queries are incorrect because:
The query that filters on performanceCounters looks at server metrics, not availability tests.
The query that bins data by 1 hour would return a time series, not a single monthly value.
The query that uses request table measures application requests, which can include load balancer health probes and does not directly express test pass/fail status.
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 the Kusto Query Language (KQL) used for?
Open an interactive chat with Bash
What does the 'summarize' operator do in KQL?
Open an interactive chat with Bash
What is the purpose of the 'render card' directive in KQL?
Open an interactive chat with Bash
Microsoft DevOps Engineer Expert AZ-400
Design and implement processes and communications
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 .