You receive a frantic call from a new DBA who accidentally dropped a table containing all your customers.
Which Amazon RDS feature will allow you to reliably restore your database to within 5 minutes of when the
mistake was made?
A.
Multi-AZ RDS
B.
RDS snapshots
C.
RDS read replicas
D.
RDS automated backup
Explanation:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Overview.BackingUpAndRestoringAmazonRDSIns
tances.html
I will go with D
https://aws.amazon.com/rds/details/#ha
D
C
C is not correct – Read replicas allow you to scale but is not a solution for database restoration
yes! D is correct
The correct answer is: RDS snapshots
You can easily recover from snapshot
Correct is D. This is a point in time recovery. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html
D is correct.
D
The answer is D , because the automated backup allows you to choose from
many snapshots, including the PITC reflected in the `describe-db-instances` LatestRestorableTime parameter.
D
fun-fact: each restore creates a new RDS instance
D
Automated backups happen once a day only- so cannot meet the ” to within 5 minutes “. So not D
Snapshots are manual – you can somehow script them to run every 5 mins, then you can meet the ” to within 5 minutes ” requirement. So B should work
Answer is D.
Think this explains it:
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_PIT.html
So looks like backups can meet the 5 minute requirement.