An RDS for MySQL database serves orders and reporting queries. Long-running reports consume resources needed by writes. Reports can tolerate replication lag of several seconds. The company wants to keep the current database engine. Which change best isolates the reporting workload?

  1. Create an RDS Proxy endpoint and assume it executes reports on a separate database copy.
  2. Route reports to the standby of a classic Multi-AZ DB instance deployment.
  3. Create a read replica and update reporting connections to use the replica's endpoint.
  4. Add more application servers while keeping every report on the same database endpoint.
Sign in to start exam

Exam