A company's web application uses an Amazon RDS PostgreSQL DB instance to store its application data. During the financial closing period at the start of every month, Accountants run large queries that impact the database's performance due to high usage. The company wants to minimize the impact that the reporting activity has on the web application. What should a solutions architect do to reduce the impact on the database with the LEAST amount of effort?

Question

Quizplus · Accepted Answer

Creating a read replica allows the company to offload read-heavy operations, such as reporting, from the primary database, thus reducing the impact on the web application with minimal effort.

A Company's Web Application Uses an Amazon RDS PostgreSQL DB