Microsoft DevOps Engineer Expert AZ-400 Practice Question
You are building a Power BI report by using the Azure DevOps Analytics OData feed. The report must show mean time to recovery (MTTR) for the production environment, defined as the elapsed time between a failed deployment and the next successful deployment to that same environment. Which pair of columns from the Deployments table contains the information you need to calculate this KPI?
MTTR is the interval between the end of an unsuccessful deployment and the end of the next successful deployment. In the Deployments table, the CompletedDate column records the timestamp at which each deployment finished, while the DeploymentStatus column indicates whether the deployment succeeded, partially succeeded, or failed. By filtering rows on DeploymentStatus and comparing their CompletedDate values, you can determine the duration from a failure to the subsequent success. The other answer options omit either the completion timestamp or the outcome flag, preventing an accurate MTTR calculation.
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 Azure DevOps Analytics OData feed?
Open an interactive chat with Bash
How does DeploymentStatus help calculate MTTR in Azure DevOps?
Open an interactive chat with Bash
Why is CompletedDate essential for MTTR calculation?
Open an interactive chat with Bash
What is the Azure DevOps Analytics OData feed?
Open an interactive chat with Bash
How do the CompletedDate and DeploymentStatus columns help calculate MTTR?
Open an interactive chat with Bash
What is Mean Time to Recovery (MTTR), and why is it important in DevOps?
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 .