Which solution meets these requirements?

By:
In: SAA-C02
Tagged:
With: 1 Comment
A company runs an on-premises application that is powered by a MySQL database.The company is migrating the application to AWS to increase the application’s elasticity and availability.The current architecture shows heavy read activity on the database during times of normal operation.Every 4 hours, the company’s development team pulls a full export of the production database to populate a database in the staging environment.During this period, users experience unacceptable application latency.The development team is unable to use the staging environment until the procedure completes.A solutions architect must recommend replacement architecture that alleviates the application latency issue.The replacement architecture also must give the development team the ability to continue using the staging environment without delay.

Which solution meets these requirements?

Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Populate the staging database by implementing a backup and restore process that uses the mysqldump utility.

Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Use database cloning to create the staging database on-demand.

Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas for production. Use the standby instance for the staging database.

Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas for production. Populate the staging database by implementing a backup and restore process that uses the mysqldump utility.

Explanations:

While Amazon Aurora MySQL with Multi-AZ Aurora Replicas would improve availability, using the mysqldump utility for backup and restore would still cause delays and high latency, as it is a time-consuming process.

Amazon Aurora MySQL with Multi-AZ Aurora Replicas provides high availability, and using database cloning allows the development team to create a staging database quickly and without impacting the production workload.

Although Amazon RDS for MySQL with Multi-AZ and read replicas would improve availability, using the standby instance for staging is not feasible since the standby instance is not accessible and is meant for failover only.

Amazon RDS for MySQL with Multi-AZ and read replicas would improve availability, but using mysqldump for backup and restore would still cause delays and high latency, affecting the production environment.

2025-10-19

1 Comment

  1. Brenda
    Author

    I reckon the answer is:
    Use Amazon Aurora MySQL with Multi-AZ Aurora Replicas for production. Use database cloning to create the staging database on-demand.

Leave a Reply

Your email address will not be published. Required fields are marked *

2 × 1 =