A Company Running an On-Premises Application Is Migrating the Application

question 86

Multiple Choice

A company running an on-premises application is migrating the application to AWS to increase its elasticity and availability. The current architecture uses a Microsoft SQL Server database with heavy read activity. The company wants to explore alternate database options and migrate database engines, if needed. Every 4 hours, the development team does a full copy of the production database to populate a test database. During this period, users experience latency. What should a solutions architect recommend as replacement database?

• A) Use Amazon Aurora with Multi-AZ Aurora Replicas and restore from mysqldump for the test database.
• B) Use Amazon Aurora with Multi-AZ Aurora Replicas and restore snapshots from Amazon RDS for the test database.
• C) Use Amazon RDS for MySQL with a Multi-AZ deployment and read replicas, and use the standby instance for the test database.
• D) Use Amazon RDS for SQL Server with a Multi-AZ deployment and read replicas, and restore snapshots from RDS for the test database.

---

Definitions:

Strain

An injury to a muscle or tendon resulting from overstretching or tearing.

Tear

A drop of clear salty liquid secreted by glands in your eyes, often resulting from emotion or irritation.

Perfectly Horizontal

A line on a graph that shows a constant value, indicating no change in the variable it represents across different situations.

Perfectly Vertical

A line on a graph that shows an infinite response in the variable measured on the y-axis for any change in the variable on the x-axis, indicating no change regardless of input.