Answer-first summary for fast verification
Answer: Adopt Amazon Aurora MySQL with Multi-AZ and on-demand database cloning for the staging environment.
The correct answer is B. Amazon Aurora MySQL with Multi-AZ Aurora Replicas is designed to handle high-read activity efficiently. Additionally, database cloning allows for quickly creating a copy of the database for the staging environment on-demand, without causing the application latency issues observed with the mysqldump utility. This approach ensures that the development team can access the staging environment without delays, meeting both the performance and operational requirements.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company is migrating a MySQL database-powered application to AWS for improved elasticity and availability. The application experiences high read activity, causing latency during the 4-hourly full database export for the staging environment, which also delays development team access. Recommend an architecture that minimizes latency and enables uninterrupted staging environment use.
A
Implement Amazon Aurora MySQL with Multi-AZ and use mysqldump for staging database backup and restore.
B
Adopt Amazon Aurora MySQL with Multi-AZ and on-demand database cloning for the staging environment.
C
Deploy Amazon RDS MySQL with Multi-AZ and read replicas, utilizing the standby instance for staging.
D
Use Amazon RDS MySQL with Multi-AZ and read replicas, and perform mysqldump-based backup and restore for staging.
No comments yet.