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

question 63

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 solution 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:

Writing Time

The period dedicated to the act or process of writing text.

Revising

The process of reviewing and altering content in a document to improve its clarity, coherence, and overall presentation.

Producing

The process of overseeing and managing the creation and development of a product, event, or media content.

Medium

A means or channel through which content or messages are conveyed.