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)

  • Incident_CL | where CreatedTime_t > ago(30d) | summarize avg(ResolvedTime_t - CreatedTime_t)

  • Incident_CL | where CreatedTime_t > ago(30d) and isnotnull(ResolvedTime_t) | summarize avg(datetime_diff('minute', CreatedTime_t, ResolvedTime_t))

Microsoft DevOps Engineer Expert AZ-400
Design and implement processes and communications
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Bash, the Crucial Exams Chat Bot
AI Bot