Microsoft DevOps Engineer Expert AZ-400 Practice Question
You manage an e-commerce solution instrumented with Application Insights. The custom metric CheckoutTime (milliseconds) is stored in the customMetrics table of a Log Analytics workspace. You must display the daily 95th-percentile CheckoutTime for the last seven days in Azure Monitor Logs. Which Kusto Query Language (KQL) query should you run?
customMetrics | where name == "CheckoutTime" and timestamp > ago(7d) | summarize pct95 = pctile(value, 0.95) by bin(timestamp, 1h)
customMetrics | where name == "CheckoutTime" and timestamp > ago(7d) | summarize pct95 = percentile(value, 95) by bin(timestamp, 1d)
The query must filter the customMetrics table to the CheckoutTime metric for the required time range, then calculate the 95th percentile of the value column and group the result into one-day time buckets. The percentile() aggregation is the correct KQL function; pctile() is not valid syntax. Aggregating by one-hour bins or omitting the initial filter would not satisfy the reporting requirements, and averaging values would not produce a percentile-based metric.
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 a Log Analytics workspace in Azure?
Open an interactive chat with Bash
What is the difference between percentile() and pctile() in KQL?
Open an interactive chat with Bash
How does the bin() function work 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 .