RDS Flashcards
Q: What solution will meet the requirements of migrating a MySQL database from on-premises to an Amazon RDS for MySQL DB instance with minimal downtime and data loss?
A: Create an Aurora read replica of the RDS for MySQL DB instance. Promote the Aurora read replicate to a new Aurora PostgreSQL DB cluster.
Q: How should a solutions architect design a highly available and scalable database solution for an application that experiences variable and unpredictable workloads?
A: Migrate the database to Amazon Aurora Serverless v2.
Q: What solution will meet the requirements of offloading read-heavy workloads from an Amazon RDS database without impacting the primary database?
A: Create a read replica of the RDS database and direct the read-heavy workloads to the read replica.
Q: What solution will meet the requirements of ensuring high availability and automatic scaling for an application’s database hosted on Amazon RDS with the least operational overhead?
A: Use Amazon Aurora with a Multi-AZ deployment and configure Aurora Auto Scaling.
Q: How should a solutions architect design a disaster recovery solution for an Amazon RDS database to meet a recovery time objective (RTO) of less than 4 hours?
A: Create Amazon Machine Images (AMIs) to back up the EC2 instances. Copy the AMIs to a secondary AWS Region. Automate infrastructure deployment in the secondary Region by using AWS CloudFormation.