A company needs to implement a relational database with a multi-Region disaster recovery Recovery Point Objective (RPO) of 1 second and a Recovery Time Objective (RTO) of 1 minute. Which AWS solution can achieve this?
A.
Amazon Aurora Global Database
B.
Amazon DynamoDB global tables
C.
Amazon RDS for MySQL with Multi-AZ enabled
D.
Amazon RDS for MySQL with a cross-Region snapshot copy
Aurora Global Database replicates writes in the primary region with a typical latency of <1 second to secondary regions, for low latency global reads. In disaster recovery situations, you can promote a secondary region to take full read-write responsibilities in under a minute.
Yes, Answer is A
To add to that......
Cross-Region Disaster Recovery - Amazon Aurora Global Database
If your primary region suffers a performance degradation or outage, you can promote one of the secondary regions to take read/write responsibilities. An Aurora cluster can recover in less than 1 minute even in the event of a complete regional outage. This provides your application with an effective Recovery Point Objective (RPO) of 1 second and a Recovery Time Objective (RTO) of less than 1 minute, providing a strong foundation for a global business continuity plan.
https://aws.amazon.com/rds/aurora/global-database/
C is wrong . Question is asking for multi-region DR solution . C says multi AZ , so if that region goes down then there is no DR solution. Multi-AZ solution works in the same region.
B. Is wrong , as the question mentions relational DB and Dynamo db is not a relational DB
D. Cross region snapshot copy takes time and since the expected RPO and RTO mentioned in the question is very less , so this solution won't work.
that leaves with the right answer A
A-Global Aurora
Relational DB->B(Dynamo DB) is out
RDS does not have cross region replication capability.
Aurora has with Global Aurora.
And the replication lag is minimal for Aurora(100 ms for within region and less than 1 second for cross region,which satsifies RPO)
RDS Snapshots would actually involve more time I guess.
=======
RTO=Recovery Time Objective=Amount of time within which services must be restored
ie from start of disaster upto how much time ahead elapsed for services to restore
RPO=Recovery Point Objective= Amount of dataloss (due to disaster ) that can be tolerated. ie from start of disaster upto how much time back (data loss) can be tolerated
========
Answer=A
https://aws.amazon.com/rds/aurora/global-database/:
"Global Database uses storage-based replication with typical latency of less than 1 second, using dedicated infrastructure that leaves your database fully available to serve application workloads. In the unlikely event of a regional degradation or outage, one of the secondary regions can be promoted to read and write capabilities in less than 1 minute."
can someone help with the following question?
A company runs a fleet of web servers using an Amazon RDS for PostgreSQL DB instance. After a routine compliance check, the company sets a standard that requires a recovery point objective (RPO) of less than 1 second for all its production databases.
Which solution meets these requirements?
A. Enable a Multi-AZ deployment for the DB instance.
B. Enable auto scaling for the DB instance in one Availability Zone.
C. Configure the DB instance in one Availability Zone, and create multiple read replicas in a separate
Availability Zone.
D. Configure the DB instance in one Availability Zone, and configure AWS Database Migration Service
(AWS DMS) change data capture (CDC) tasks.
https://aws.amazon.com/rds/aurora/global-database/:
"Global Database uses storage-based replication with typical latency of less than 1 second, using dedicated infrastructure that leaves your database fully available to serve application workloads. In the unlikely event of a regional degradation or outage, one of the secondary regions can be promoted to read and write capabilities in less than 1 minute."
Answer is A
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
dfedeli
Highly Voted 3 years, 8 months agoaguy9
3 years, 7 months agoAjNapa
3 years, 8 months agosqlquaker
3 years, 7 months agoZenRajnish
Highly Voted 3 years, 7 months agobikshu
Most Recent 2 years, 9 months agojanvandermerwer
3 years, 3 months agoSR82
3 years, 5 months agogargaditya
3 years, 6 months agogargaditya
3 years, 6 months agocloudguruguru
3 years, 6 months agoalxkuper
3 years, 6 months agoarulmuruganshanmugam
3 years, 3 months agowoke
3 years, 6 months agonickname20212021
3 years, 6 months agoMaddy_aws2020
3 years, 6 months agoVeny
3 years, 6 months agoMurlidhar
3 years, 6 months agosyu31svc
3 years, 6 months agoKK_uniq
3 years, 6 months agoElshahaly
3 years, 6 months agoYogi
3 years, 7 months agoismai1
3 years, 7 months ago