Deployment Failure Impact

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

After a string of rollbacks, leadership asked how much deployment capacity each service loses to failures. For each service, show what percentage of its deployments failed and what percentage of its total deployment time was consumed by those failures.

Summary

When deploys fail, how bad is the blast radius?

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.