RDS backup and snapshots in AWS - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is an RDS automated backup?

An automated backup is a daily backup of your RDS database that AWS performs automatically. It includes the database and transaction logs, allowing point-in-time recovery within the retention period.

beginner

What is the difference between an RDS snapshot and an automated backup?

An RDS snapshot is a manual backup you create anytime and keep until you delete it. Automated backups happen daily and are retained only for a set period.

intermediate

How long can automated backups be retained in RDS?

Automated backups can be retained from 0 (disabled) up to 35 days. After that, backups are deleted automatically.

intermediate

Can you restore an RDS database to a specific point in time?

Yes, using automated backups and transaction logs, you can restore your database to any second within the backup retention period.

intermediate

What happens to snapshots when you delete the original RDS instance?

Manual snapshots remain even after the original RDS instance is deleted. Automated backups are deleted with the instance.

What type of backup in RDS is created automatically every day?

A Incremental snapshot

B Manual snapshot

C Export backup

D Automated backup

Automated backups are created daily by AWS without user intervention.

How long can you keep automated backups in RDS?

A Up to 7 days

B Up to 14 days

C Up to 35 days

D Indefinitely

Automated backups can be retained for up to 35 days.

Which backup type must you create manually in RDS?

A Manual snapshot

B Point-in-time recovery

C Automated backup

D Continuous backup

Manual snapshots are created by the user whenever needed.

What happens to automated backups when you delete an RDS instance?

A They are deleted with the instance

B They are retained indefinitely

C They convert to manual snapshots

D They are archived automatically

Automated backups are deleted when the RDS instance is deleted.

Can you restore an RDS database to a specific second in the past?

A No, only to the last snapshot

B Yes, within the backup retention period

C Only if you have manual snapshots

D Only if you export the data

Point-in-time recovery allows restoring to any second within the retention period using automated backups.

Explain the difference between automated backups and manual snapshots in RDS.

Think about who controls the backup timing and how long backups last.

Describe how you can restore an RDS database to a specific point in time.

Consider what backups and logs are needed for precise recovery.