Microsoft DevOps Engineer Expert AZ-400 Practice Question
Your team wants to visualize code churn so that developers can see whether large, risky changes are still entering the main branch late in the iteration. You need a dashboard widget that shows, for the last 30 days, the total number of lines added and deleted per repository. You decide to create an Analytics query in Azure DevOps and pin the result to a dashboard. Which Analytics view or table and measures should you base the query on to obtain the required numbers?
Query the Work Item Snapshot table and sum the Story Points and Effort measures.
Query the Pull Request view and total the ReviewersDurationSeconds measure.
Query the Build table and average the BuildDurationSeconds measure.
Query the Code Churn view and aggregate the LinesAdded and LinesDeleted measures.
The Azure DevOps Analytics Code Churn view (also referred to in OData as the CodeChurn table) records one row per file changed in each commit and exposes the LinesAdded and LinesDeleted measures. By aggregating these two measures over a time range you get total churn (lines added plus lines deleted) per repository. Work Item, Build, and Pull Request tables do not contain line-level code delta information, so they cannot provide churn metrics directly.
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 Code Churn in Azure DevOps?
Open an interactive chat with Bash
How can you aggregate LinesAdded and LinesDeleted in Azure DevOps Analytics?
Open an interactive chat with Bash
Why aren't Work Item, Build, or Pull Request tables suitable for visualizing code churn?
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 .