Q18Design Resilient ArchitecturesMultiple answers
A company uses a 100 GB Amazon RDS for Microsoft SQL Server Single-AZ DB instance in the `us-east-1` Region to store customer transactions. The company requires high availability and automatic recovery for the DB instance. The company must also run reports on the RDS database several times each year. The reporting process causes transactions to take longer than normal to post to customers’ accounts. The company needs a solution that will improve the performance of the reporting process. Which combination of steps will meet these requirements? *(Choose two.)*
Select 2 answers.
← → navigate · a answer
Community votes
Discussion · 9
9
A and C are the right choices.
B. It will not help with improving the performance of the report process.
D. Migrating to RDS Custom does not solve the issue of high availability and automatic recovery.
E. RDS Proxy can help with scalability and high availability, but it does not solve the issue of performance for the report process. Limiting the reporting requests to the maintenance window will not give the required availability and recovery for the DB instance.
A, C 4
The correct answers are A and C.
A. Modify the DB instance from a Single-AZ DB instance to a Multi-AZ deployment. This will provide high availability and automatic recovery for the DB instance. If the primary DB instance fails, the standby DB instance will automatically become the primary DB instance. This will ensure that the database is always available.
C. Create a read replica of the DB instance in a different Availability Zone. Point all requests for reports to the read replica. This will improve the performance of the report process by offloading the read traffic from the primary DB instance to the read replica. The read replica is a fully synchronized copy of the primary DB instance, so the reports will be accurate.
A, C 4
Create a Multi-AZ deployment, create a read replica of the DB instance in the second Availability Zone, point all requests for reports to the read replica
A, C 4
Options A & C...
4
ANSWER - A & C
A, C 4
https://medium.com/awesome-cloud/aws-difference-between-multi-az-and-read-replicas-in-amazon-rds-60fe848ef53a
3
Options A+C
A, C 3
A and C.
2
A and C