AZ-400 Designing and Implementing Microsoft DevOps Solutions Exam

Seeking the thrill of transformative tech? Explore the art of designing and implementing DevOps solutions on Azure. Master the shift towards CI/CD, testing, and delivery, while preparing for the Designing and Implementing Microsoft DevOps Solutions exam!

Intermediate

Gauge your current knowledge

Track Readiness

Set Exam Goal

Intermediate

Gauge your current knowledge

Track Readiness

Set Exam Goal

Design and implement appropriate metrics and queries for projectplanning

Design and implement appropriate metrics and queries for DevOps

Author and Optimize WIQL Queries for Project Planning Metrics

WIQL (Work Item Query Language) is the special query language used in Azure DevOps to find and filter work items, like user stories, bugs, and tasks. To plan a project effectively, teams need to measure their progress using specific data, which requires creating and running good queries.

Define and Configure KPIs

The first step is to decide what to measure by setting up Key Performance Indicators (KPIs). Common KPIs for project planning include Sprint Velocity, which shows how much work a team finishes in a sprint; Cycle Time, which tracks how long a single work item takes from start to finish; and Backlog Health, which gives a snapshot of how many items are waiting and their priority. These metrics help the team understand their pace, identify delays, and manage future workload.

...

A process flow showing how KPIs are defined, WIQL queries are authored and optimized, and results are visualized on Azure DevOps dashboards.

Author and Optimize WIQL Queries

To get the data for these KPIs, you write WIQL queries. Authoring a query means using the WIQL syntax to ask for specific work items, such as all tasks completed in the last sprint to calculate velocity. You filter data using fields like Work Item Type, State, and Changed Date. Optimizing a query makes it run faster and use less resources. This is done by simplifying the query logic, filtering on fields that Azure DevOps has indexed for speed, and only requesting the data columns you actually need for your report or dashboard.

Implement Dashboards or Analytics Views

The final step is to turn the query results into easy-to-understand visuals. You can implement dashboards within Azure DevOps to display charts and graphs for your KPIs. For example, a velocity chart shows trends over multiple sprints, while a cycle time report can highlight bottlenecks. These dashboards pull data from your optimized WIQL queries. They provide a central place for the whole team to see project health, track progress against goals, and support decisions with real data.

...

Design and implement a dashboard, including flow of work, such ascycle times, time to recovery, and lead time Design and implement appropriate metrics and queries for development

AZ-400 Designing and Implementing Microsoft DevOps Solutions Exam

Design and implement appropriate metrics and queries for projectplanning

Author and Optimize WIQL Queries for Project Planning Metrics

Define and Configure KPIs

WIQL Metrics Implementation Pipeline

Author and Optimize WIQL Queries

Implement Dashboards or Analytics Views

Author and Optimize WIQL Queries for Project Planning Metrics

Define and Configure KPIs

Author and Optimize WIQL Queries

Implement Dashboards or Analytics Views