RDS Flashcards

1
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Q: How should a solutions architect design a highly available and scalable database solution for an application that experiences variable and unpredictable workloads?

A

A: Migrate the database to Amazon Aurora Serverless v2.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Q: What solution will meet the requirements of offloading read-heavy workloads from an Amazon RDS database without impacting the primary database?

A

A: Create a read replica of the RDS database and direct the read-heavy workloads to the read replica.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

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

A: Use Amazon Aurora with a Multi-AZ deployment and configure Aurora Auto Scaling.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly