Microsoft DevOps Engineer Expert AZ-400 Practice Question
Your team uses Azure Boards with the Analytics extension enabled. You are building a Power BI report that shows the average cycle time for user stories, tasks, and bugs over the past six months. The calculation requires daily snapshots of each work item's state so you can determine the elapsed time between the first "Active" date and the first "Closed" date. Which Analytics view or table should you query to obtain the required data?
The WorkItemSnapshot table in the Azure DevOps Analytics model stores a daily snapshot of every work item, including its state on that day and key date fields. This fine-grained history lets you calculate cycle-time and lead-time metrics by determining when each work item first entered the Active and Closed states. WorkItemLinks contains relationship data but not state history, BuildRuns stores pipeline execution information, and SprintBurndown is a derived view that aggregates remaining work rather than providing per-item daily state snapshots. Therefore, querying WorkItemSnapshot is necessary for an accurate cycle-time 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.
Why does the WorkItemSnapshot table provide daily snapshots of work item states?
Open an interactive chat with Bash
What is the difference between WorkItemSnapshot and SprintBurndown?
Open an interactive chat with Bash
How does daily history in the WorkItemSnapshot table improve Power BI reporting for cycle-time analysis?
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 .