AWS Certified Database – Specialty — Question 18

A company is using Amazon RDS for MySQL to redesign its business application. A Database Specialist has noticed that the Development team is restoring their
MySQL database multiple times a day when Developers make mistakes in their schema updates. The Developers sometimes need to wait hours for the restores to complete.
Multiple team members are working on the project, making it difficult to find the correct restore point for each mistake.
Which approach should the Database Specialist take to reduce downtime?

Answer options

• A. Deploy multiple read replicas and have the team members make changes to separate replica instances
• B. Migrate to Amazon RDS for SQL Server, take a snapshot, and restore from the snapshot
• C. Migrate to Amazon Aurora MySQL and enable the Aurora Backtrack feature
• D. Enable the Amazon RDS for MySQL Backtrack feature

Correct answer: C

Explanation

The correct answer is C, as migrating to Amazon Aurora MySQL and enabling the Aurora Backtrack feature allows developers to revert the database to a specific point in time without the lengthy restore process. The other options either involve unnecessary migrations or do not provide the same level of flexibility and speed for schema changes.