Database Flashcards

1
Q

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

A: Migrate the existing RDS for MySQL database to an Aurora Serverless v2 MySQL database cluster.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
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
3
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
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
6
Q

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

A: Replace the Amazon EBS volume with a Provisioned IOPS SSD (io2) volume.

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