Microsoft DevOps Engineer Expert AZ-400 Practice Question
Your team stores production incident records in an Azure Log Analytics workspace. The workspace contains a custom table named Incident_CL with these columns:
IncidentId_g (string)
State_s (string)
CreatedTime_t (datetime)
ResolvedTime_t (datetime)
You need to add a metric tile to an Azure dashboard that shows the average mean time to recovery (MTTR) for the last 30 days. Incidents that are still open must be excluded. Which Kusto Query Language (KQL) statement should you use?
Incident_CL | where CreatedTime_t > ago(30d) and State_s == "Resolved" | summarize avg(CreatedTime_t - ResolvedTime_t)
Incident_CL | where CreatedTime_t > ago(30d) and isnotnull(ResolvedTime_t) | extend TTR = ResolvedTime_t - CreatedTime_t | summarize avg(TTR)
The query must calculate the difference between the resolution and creation timestamps, skip rows that do not yet have a ResolvedTime_t value, and average the resulting timespans over the last 30 days. Extending with a TTR column makes the calculation explicit, and summarize avg(TTR) returns a single timespan representing MTTR. Options that do not filter NULL resolution dates risk dividing by zero or skewing results, and queries that subtract in the wrong order produce negative durations.
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 Azure Log Analytics, and why is it used?
Open an interactive chat with Bash
What is Kusto Query Language (KQL)?
Open an interactive chat with Bash
Can you explain the purpose of the `extend` and `summarize` commands 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 .