Microsoft DevOps Engineer Expert AZ-400 Practice Question
Your organization uses Azure DevOps for work tracking. You need to build a shared dashboard that helps portfolio managers monitor flow efficiency. The dashboard must display (1) the average cycle time for user stories completed during the current sprint and (2) the average lead time for user stories over the last three sprints. The data must refresh automatically and allow managers to drill down to the underlying work items without requiring additional licenses or external services. Which solution should you recommend?
Build a Power BI report that queries the Azure DevOps REST APIs and pin the report to the dashboard.
Add the Cycle Time and Lead Time Analytics widgets to an Azure DevOps dashboard and scope them by team iteration dates.
Create a query-based chart widget that groups user stories by Completed Date and averages effort.
Schedule a nightly export of work items to CSV using the Azure DevOps CLI and visualize the data in Excel Online.
The Cycle Time and Lead Time widgets that are part of the Azure DevOps Analytics extension read data directly from the Analytics service, refresh automatically each time the dashboard loads, and provide built-in drill-through to the individual work items that compose the metric. Because the Analytics extension is included with Azure DevOps and does not depend on third-party tools, it satisfies the licensing and maintenance constraints. Power BI can meet the metric requirements but adds an external service and licensing overhead. Exporting to Excel or using a basic query-based chart requires manual refresh and lacks true cycle-time calculations, making them unsuitable for an automated management dashboard.
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 are Cycle Time and Lead Time in Azure DevOps?
Open an interactive chat with Bash
What is the Azure DevOps Analytics extension?
Open an interactive chat with Bash
Why is Power BI not suitable for this solution?
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 .