Question 9 of 10Pro Only

Design a comprehensive backup strategy for a company with a 500 GB production database that requires an RPO of 15 minutes and an RTO of 1 hour.

Sample answer preview

Designing a backup strategy for a 500 GB database with a 15-minute RPO and 1-hour RTO requires careful selection of backup tools, scheduling, storage, and testing procedures that work together to meet these requirements. Start with the backup tool selection.

pgBackRestincremental backupWAL archivingparallel restorethree-two-one ruleencryption

Unlock the full answer

Get the complete model answer, key points, common pitfalls, and access to 9+ more Database Administrator interview questions.

Upgrade to Pro

Starting at $19/month • Cancel anytime