How would you set up backups for a production database, and how would you prove they actually restore?

What the interviewer is looking for

• This question tests reliability & disaster recovery. Sets recovery targets, designs backups and multi-zone or multi-region setups, and actually tests restores.
• Strong answers: Automated snapshots and point-in-time recovery, copies in another account or region, retention policies, and scheduled restore tests.
• Likely follow-up: How would you protect the backups themselves from being deleted by an attacker?

Another way it may be asked: If the main database got deleted tonight, how would you make sure you could get it back?

A structure to follow: Answer, explain, example, limits

1. Step 1

   Answer

   Give your direct answer in the first sentence so the interviewer knows where you are going.

2. Step 2

   Explain

   Say how it works or why you would do it that way, in plain words before jargon.

3. Step 3

   Example

   Anchor it in something you have actually done or seen, with the detail that shows hands-on experience.

4. Step 4

   Limits

   Say when your approach would not be the right one. It shows judgement.

This is guidance on shape, not a script. Use your own real experience and facts; never invent details to fill a gap. See the STAR guide and answer frameworks.

Common slips

• Reciting a definition without showing you have applied it.
• Using terms you cannot explain if asked a level deeper.
• Claiming experience beyond what you can discuss in detail.

How to practise it

Say the answer in 90 seconds, then answer the follow-up as if it were a new question.

Related questions

• Leadership asks for a disaster recovery plan for a critical system. How do you decide recovery time and data loss targets, and what design follows?
• If you had to host a simple web app with a database in the cloud, which services would you pick, and why?
• What does least privilege mean in cloud access management, and how would you apply it to a new developer joining the team?
• Explain the difference between a public and a private subnet, and what kinds of resources you would put in each.
• An app server in a private subnet cannot reach an external payment service. How do you troubleshoot that connection?

Browse all questions