Your company has 5 TB of testing data stored in the production database of a testing tool name Quality Center. The data is being used to create a real-time analytics system which is causing the slow r

Multi-AZ (Multi-Availability Zone) provides high availability and disaster recovery, but it does not directly offload read workloads from the primary database to improve performance under heavy read traffic.

Setting up a read replica allows the real-time analytics system to query the replica instead of the primary production database, thereby offloading the read workload and improving response times for testers using the main application.

Scaling the database instance might offer some relief but is often a more expensive solution and may not fully separate the analytics workload from the transactional workload, making a read replica a more targeted approach.

Running analytics queries only on weekends would prevent the 'real-time analytics system' requirement and only postpones the problem without solving the concurrent load issue during business hours.