AWS Certified SysOps Administrator – Associate (legacy) — Question 511

A company has an application database on Amazon RDS that runs a resource-intensive reporting job. This is causing other applications using the database to run slowly.
What should the SysOps Administrator do to resolve this issue?

Answer options

• A. Create Amazon RDS backups
• B. Create Amazon RDS read replicas to run the report
• C. Enable Multi-AZ mode on Amazon RDS
• D. Use Amazon RDS automatic host replacement

Correct answer: B

Explanation

Creating an Amazon RDS read replica allows read-heavy workloads, such as resource-intensive reporting jobs, to be offloaded from the primary database instance. This prevents performance degradation for other applications interacting with the primary database. Multi-AZ deployments are meant for high availability and disaster recovery, not for scaling read traffic, while backups and host replacement do not address query-driven resource contention.