SAP-C02 · Question #725
A company needs to implement disaster recovery for a critical application that runs in a single AWS Region. The application's users interact with a web frontend that is hosted on Amazon EC2…
The correct answer is C. Create a read replica of the RDS DB instance in a separate Region. Instruct the finance team to. To provide cross-region disaster recovery with minimized data loss and resolve performance issues from finance team queries on an Amazon RDS for MySQL database, the optimal solution involves creating a cross-region RDS Read Replica for both DR and query offloading. The finance…
Question
A company needs to implement disaster recovery for a critical application that runs in a single AWS Region. The application's users interact with a web frontend that is hosted on Amazon EC2 instances behind an Application Load Balancer (ALB). The application writes to an Amazon RDS for MySQL DB instance. The application also outputs processed documents that are stored in an Amazon S3 bucket. The company's finance team directly queries the database to run reports. During busy periods, these queries consume resources and negatively affect application performance. A solutions architect must design a solution that will provide resiliency during a disaster. The solution must minimize data loss and must resolve the performance problems that result from the finance team's queries. Which solution will meet these requirements?
Options
- AMigrate the database to Amazon DynamoDB and use DynamoDB global tables. Instruct the
- BLaunch additional EC2 instances that host the application in a separate Region. Add the
- CCreate a read replica of the RDS DB instance in a separate Region. Instruct the finance team to
- DCreate hourly snapshots of the RDS DB instance. Copy the snapshots to a separate Region. Add
How the community answered
(16 responses)- A13% (2)
- B13% (2)
- C69% (11)
- D6% (1)
Why each option
To provide cross-region disaster recovery with minimized data loss and resolve performance issues from finance team queries on an Amazon RDS for MySQL database, the optimal solution involves creating a cross-region RDS Read Replica for both DR and query offloading. The finance team should be directed to run reports against this read replica, and Amazon S3 Cross-Region Replication (CRR) should be configured for the application's document storage.
Migrating from Amazon RDS for MySQL to Amazon DynamoDB would require significant re-architecture and code changes, which is not implied or suitable for a solution focused on DR and performance tuning of an existing application.
Launching EC2 instances in a separate region addresses the application tier's DR but fails to provide a solution for the database's disaster recovery or the finance team's query performance issue.
Creating an Amazon RDS Read Replica in a separate AWS Region provides a low Recovery Point Objective (RPO) for the database by continuously replicating data, serving as a robust disaster recovery target. Instructing the finance team to run their reports against this read replica offloads read-heavy queries from the primary database, resolving the performance degradation experienced during busy periods. Additionally, configuring Amazon S3 Cross-Region Replication (CRR) ensures the application's processed documents are also replicated for disaster recovery with minimal data loss.
While hourly snapshots copied to another region provide some disaster recovery for RDS, the RPO would be higher than continuous replication, and crucially, this solution does not address the performance problems caused by the finance team's queries on the primary database.
Concept tested: Disaster recovery strategies (RDS, S3), database read replica for performance offloading.
Source: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Replication.html
Community Discussion
No community discussion yet for this question.