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 to 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?
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
Amazon AWS Certified Database – Specialty (DBS-C01)Free dumps for CLF-C01 in Printable PDF format.High quality PDF and software. VALID exam to help you pass. |
 |
A. It is possible to make DDL operations for the schema changes on the MySQL read replica Set read_only parameter to 0 in DB parameter group for read replica.
By setting read_only parameter to 0 in DB parameter group for read replica.
C
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html
Ans C
How can you make changes to read replica it is for read purpose