Answer-first summary for fast verification
Answer: Upgrade the DB instance to Multi-AZ for enhanced availability., Implement a read replica in another Availability Zone for report processing.
Option A is correct because upgrading the DB instance to a Multi-AZ deployment provides high availability and automatic recovery, which are essential for minimizing downtime and ensuring continuous operation. Option C is also correct because creating a read replica in a different Availability Zone and directing all report queries to the read replica offloads the reporting workload from the primary DB instance, thereby improving the performance without affecting transaction processing. Together, these steps meet the company's needs for high availability, automatic recovery, and enhanced performance during report generation.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company operates a 100 GB Amazon RDS Microsoft SQL Server instance in us-east-1, requiring high availability, automatic recovery, and improved performance for periodic report generation. What steps should be taken to meet these needs?
A
Upgrade the DB instance to Multi-AZ for enhanced availability.
B
Snapshot and restore the instance in a new RDS deployment across an Availability Zone.
C
Implement a read replica in another Availability Zone for report processing.
D
Transition to RDS Custom for database management.
E
Employ RDS Proxy to control report request timing.
No comments yet.