Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 389 discussion

reporting queries to run without impacting the write operations -> read replicas

A) Deploy RDS read replicas to process the business reporting queries. The key points are: RDS read replicas allow read-only copies of the production DB instance to be created Queries to the read replica don't affect the source DB instance performance This isolates reporting queries from production traffic and write operations So using RDS read replicas is the best way to meet the requirements of running reporting queries without impacting production write operations.

"single AZ", "large dataset", "Amazon RDS for MySQL database". Want "business report queries". --> Solution "Read replicas", choose A.

No doubt A.

Load balance read operations = read replicas

Option "A" is the right answer . Read replica use cases - You have a production database that is taking on normal load & You want to run a reporting application to run some analytics • You create a Read Replica to run the new workload there • The production application is unaffected • Read replicas are used for SELECT (=read) only kind of statements (not INSERT, UPDATE, DELETE)

option A is the best solution for ensuring that business reporting queries can run without impacting write operations to the production DB instance.