Database Flashcards
Q: Which solution will meet the requirements of migrating an on-premises MySQL database to Amazon RDS for MySQL with high availability and automatic scaling capabilities?
A: Migrate the existing RDS for MySQL database to an Aurora Serverless v2 MySQL database cluster.
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: 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 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.
Q: What should a solutions architect do to improve the performance of an Amazon RDS database that experiences high read and write IOPS during periods of high demand?
A: Replace the Amazon EBS volume with a Provisioned IOPS SSD (io2) volume.