A company migrated a MySQL database from the company's on-premises data center to an Amazon RDS for MySQL DB instance. The company sized the RDS DB instance to meet the company's average daily workload. Once a month, the database performs slowly when the company runs queries for a report. The company wants to have the ability to run reports and maintain the performance of the daily workloads. Which solution will meet these requirements?

Creating a read replica is the most effective solution because it offloads read-heavy reporting queries from the primary database instance. This ensures that the primary instance maintains optimal performance for the daily operational workload, as the reporting queries run independently on the replica. Restoring a backup to another DB instance is inefficient and time-consuming for a recurring monthly task. Exporting data to Amazon S3 and using Athena is a viable option for analytics but adds complexity and latency for direct database reporting. Resizing the DB instance would increase costs unnecessarily for a once-a-month spike and might still impact daily operations during the reporting period.