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:

Expense Account

An account used to record the consumption of assets, including costs incurred in the operation of a business, contributing to a reduction in equity.

Merchandise Inventory

Goods a company intends to sell to customers, typically in a retail or wholesale setting.

Replacement Price

The current cost of replacing an asset or inventory with a similar item.

Income-Sharing Ratio

The predetermined formula used among business partners or within an organization to divide profits or losses among stakeholders.