Goal: Answer 13 questions. Each right answer adds its points.
While the quiz has focus, keys 1 to 4 pick an answer, H opens the hint and N goes to the next question.
Zero-Downtime PostgreSQL Migrations Quiz - Quiz Overview
Test your skills shipping schema changes against a live PostgreSQL database without dropping traffic, breaking deploys, or locking out writers.
Estimated Time
20-25 minutes
Total Points
195
Questions
13
💡 Database Operations Tip
Practice makes perfect! Take your time to understand each question and read the explanations carefully. Real-world scenarios often require combining multiple concepts, so think about how these tools work together in production environments.
Found an issue?
Also worth your time on this topic
Zero-Downtime Database Migrations for PostgreSQL
Practical techniques for changing schemas on busy PostgreSQL databases without taking the app down, including expand-and-contract, online DDL, and safe backfills.
22 minutes
Zero-Downtime PostgreSQL Migrations in Production
How to change a live PostgreSQL schema without taking the app down: the expand-and-contract pattern, online DDL with CONCURRENTLY and NOT VALID, batched backfills, and the lock monitoring that lets you do it with confidence.
2-4 hours