A Company Has Migrated a Single MySQL Database to Amazon

question 119

Multiple Choice

A company has migrated a single MySQL database to Amazon Aurora. The production data is hosted in a DB cluster in VPC_PROD, and 12 testing environments are hosted in VPC_TEST using the same AWS account. Testing results in minimal changes to the test data. The Development team wants each environment refreshed nightly so each test database contains fresh production data every day. Which migration approach will be the fastest and most cost-effective to implement?

• A) Run the master in Amazon Aurora MySQL. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.
• B) Run the master in Amazon Aurora MySQL. Take a nightly snapshot, and restore it into 12 databases in VPC_TEST using Aurora Serverless.
• C) Run the master in Amazon Aurora MySQL. Create 12 Aurora Replicas in VPC_TEST, and script the replicas to be deleted and re-created nightly.
• D) Run the master in Amazon Aurora MySQL using Aurora Serverless. Create 12 clones in VPC_TEST, and script the clones to be deleted and re-created nightly.

---

Definitions:

Loss-Minimizing

A strategy or condition in which a firm seeks to minimize its losses by operating at a production level where marginal cost equals marginal revenue.

Total Revenue

The total amount of money received by a company for goods sold or services provided during a certain period.

Total Cost

The total expenses involved in creating goods or services, encompassing both constant and fluctuating costs.

Perfectly Competitive Firm

A business that operates in a perfectly competitive market, where it is a price taker due to the presence of many sellers offering homogeneous products.