AWS Certified Solutions Architect – Professional — Question 59

You are running a successful multitier web application on AWS and your marketing department has asked you to add a reporting tier to the application. The reporting tier will aggregate and publish status reports every 30 minutes from user-generated information that is being stored in your web application s database.
You are currently running a Multi-AZ RDS MySQL instance for the database tier. You also have implemented Elasticache as a database caching layer between the application tier and database tier.
Please select the answer that will allow you to successfully implement the reporting tier with as little impact as possible to your database.

Answer options

• A. Continually send transaction logs from your master database to an S3 bucket and generate the reports off the S3 bucket using S3 byte range requests.
• B. Generate the reports by querying the synchronously replicated standby RDS MySQL instance maintained through Multi-AZ.
• C. Launch a RDS Read Replica connected to your Multi AZ master database and generate reports by querying the Read Replica.
• D. Generate the reports by querying the ElastiCache database caching tier.

Correct answer: C

Explanation

The correct answer is C because a RDS Read Replica allows for offloading read operations from the master database, enabling reporting tasks without impacting the performance of the primary database. Options A, B, and D either involve more complexity or do not effectively isolate the reporting functions from the main database workload.