nerdexam
Amazon

SAP-C02 · Question #278

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 Am

The correct answer is D. Configure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and. This solution will provide the highest availability for the database, as the read replicas will allow the database to be available in multiple Regions, thus reducing the chances of disruption. Additionally, the promotion of the cross-Region read replica to become a standalone DB

Submitted by krish.m· Mar 6, 2026Continuous Improvement for Existing Solutions

Question

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?

Options

  • AConfigure automated backups on Amazon RDS. In the case of disruption, promote an automated
  • BConfigure global tables and read replicas on Amazon RDS. Activate the cross-Region scope. In
  • CConfigure global tables and automated backups on Amazon RDS. In the case of disruption, use
  • DConfigure read replicas on Amazon RDS. In the case of disruption, promote a cross-Region and

How the community answered

(34 responses)
  • A
    18% (6)
  • B
    3% (1)
  • C
    9% (3)
  • D
    71% (24)

Explanation

This solution will provide the highest availability for the database, as the read replicas will allow the database to be available in multiple Regions, thus reducing the chances of disruption. Additionally, the promotion of the cross-Region read replica to become a standalone DB instance will ensure that the database is still available even if one of the Regions experiences disruptions.

Community Discussion

No community discussion yet for this question.

Full SAP-C02 Practice