Q2 — AWS SAP-C02 Ch.1

Question 2 of 75 | ← Chapter 1

Q77. A retail company is hosting an ecommerce website on AWS across multiple AWS Regions. The company wants the website to be operational at all times for online purchases The website stores data in an Amazon RDS for MySQL DB instance.Which solution will provide the HIGHEST availability for the database?

Correct Answer: D. Configure read replicas on Amazon RDS In the case of disruption, promote a cross-Region read replica to be a standalone DB instance Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source

Explanation

To provide the highest availability for the database in a multi-region setup, the recommended solution is: D. Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region read replica to be a standalone DB instance. Direct database traffic to the promoted DB instance. Create a replacement read replica that has the promoted DB instance as its source. Explanation: Option D provides a solution that maximizes database availability by leveraging read replicas and promoting them in case of disruption: 1. Read replicas: By configuring read replicas on Amazon RDS, you can offload read traffic from the primary database instance and improve overall performance. Read replicas can be created in separate AWS Regions to provide redundancy and failover capability. 2. Promoting a cross-Region read replica: In the event of a disruption in the primary region, you can promote a cross-Region read replica to become a standalone DB instance. This promotion process allows the replica to take over as the primary database, ensuring continued availability. 3. Direct database traffic to the promoted instance: Once the cross-Region read replica is promoted to a standalone DB instance, you can direct the database traffic to this instance to ensure uninterrupted access to the data. 4. Create a replacement read replica: After promoting a read replica to be a standalone DB instance, it's important to create a new read replica that has the promoted DB instance as its source. This ensures that the read replica is continuously updated with the latest data and can serve as a failover target in case of future disruptions. By following this approach, the database can maintain high availability across multiple regions, allowing the ecommerce website to operate at all times for online purchases. Option A is incorrect because promoting an automated backup to a standalone DB instance and creating a replacement read replica would introduce downtime during the failover process, affecting database availability. Option B is incorrect because although global tables and read replicas provide availability benefits, the solution does not include the process of promoting read replicas in case of disruption, which is necessary for achieving the highest availability. Option C is incorrect because using AWS Lambda to copy read replicas from one region to another in the event of a disruption does not include the promotion of a read replica to a standalone DB instance, which is necessary for maintaining high availability. Therefore, option D is the recommended solution for achieving the highest availability for the database in a multi-region setup. Not BC, DynamoDB has the technology of global table, while RDS does not Global tables build on the global Amazon DynamoDB footprint to provide you with a fully managed, multi-Region, and multi-active database that delivers fast, local, read and write performance for massively scaled, global applications. Global tables replicate your DynamoDB tables automatically across your choice of AWS Regions.Amazon Aurora global databases span multiple AWS Regions, enabling low latency global reads and providing fast recovery from the rare outage that might affect an entire AWS Region. An Aurora global database has a primary DB cluster in one Region, and up to five secondary DB clusters in different Regions.