AWS Certified Database – Specialty – Question195

An application reads and writes data to an Amazon RDS for MySQL DB instance. A new reporting dashboard needs read-only access to the database. When the application and reports are both under heavy load, the database experiences performance degradation. A database specialist needs to improve the database performance.
What should the database specialist do to meet these requirements?

A.
Create a read replica of the DB instance. Configure the reports to connect to the replication instance endpoint.
B. Create a read replica of the DB instance. Configure the application and reports to connect to the cluster endpoint.
C. Enable Multi-AZ deployment. Configure the reports to connect to the standby replica.
D. Enable Multi-AZ deployment. Configure the application and reports to connect to the cluster endpoint.

Correct Answer: C

Explanation: