What should a solutions architect do to reduce the impact on the database with the LEAST amount of effort?

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?
A . Create a read replica and direct reporting traffic to the replica.
B . Create a Multi-AZ database and direct reporting traffic to the standby.
C . Create a cross-Region read replica and direct reporting traffic to the replica.
D . Create an Amazon Redshift database and direct reporting traffic to the Amazon Redshift database.

View Answer

Answer: A

Explanation:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html

Amazon RDS uses the MariaDB, MySQL, Oracle, PostgreSQL, and Microsoft SQL Server DB engines’ built-in replication functionality to create a special type of DB instance called a read replica from a source DB instance. Updates made to the source DB instance are asynchronously copied to the read replica. You can reduce the load on your source DB instance by routing read queries from your applications to the read replica.

When you create a read replica, you first specify an existing DB instance as the source. Then Amazon RDS takes a snapshot of the source instance and creates a read-only instance from the snapshot. Amazon RDS then uses the asynchronous replication method for the DB engine to update the read replica whenever there is a change to the source DB instance. The read replica operates as a DB instance that allows only read-only connections. Applications connect to a read replica the same way they do to any DB instance. Amazon RDS replicates all databases in the source DB instance.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_ReadRepl.html