A company uses a 100 GB Amazon RDS for Microsoft SQL Server Single-AZ DB instance in us-east-1 for customer transactions. The company requires high availability and automatic recovery for the DB instance. Reports run several times a year and cause transactions to take longer to post. The company needs to improve report performance. Which combination of steps will meet these requirements? (Choose two.)
Choose an answer
Tap an option to check your answer.
Correct answer: Modify the DB instance from a Single-AZ DB instance to a Multi-AZ deployment., Create a read replica of the DB instance in a different Availability Zone. Point all requests for reports to the read replica..
Why this is the answer
Modifying the DB instance to a Multi-AZ deployment provides high availability and automatic recovery by synchronously replicating data to a standby instance in a different Availability Zone. This ensures continuous operation during outages. Creating a read replica offloads read-heavy workloads, like reports, from the primary DB instance. By directing reports to the read replica, the primary instance's performance for customer transactions improves, addressing the performance requirement. Restoring a snapshot to a new RDS deployment doesn't provide automatic failover for the primary instance. RDS Custom is for applications requiring OS or database customization, not directly for high availability or read scaling. RDS Proxy is for connection management and pooling, not for limiting requests to a maintenance window or improving report performance.
Pass your exam — without the endless answer hunt
Get every verified question and explanation for this exam in one place, and save hours of prep. 1,000+ certifications · 20+ languages · free to start.
Pass your exam faster → No card needed