Q39 — AWS SAA-C03 Ch.16

Question 39 of 100 | ← Chapter 16

Q1239. A company uses Amazon RDS for PostgreSQL to run its applications in the us-east-1 Region.The company also uses machine learning (ML)models to forecast annual revenue based on near real-time reports. The reports are generated by using the same RDS for PostgreSQL database.The database performance slows during business hours. The company needs to improve database performance.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: D. Create a read replica in us-east-1. Configure the reports to be generated from the read replica.

Explanation

Let's analyze each option to determine the most cost-effective solution for improving database performance during business hours while supporting near real-time reporting for ML models:Option A: Create a cross-Region read replica. Configure the reports to be generated from the read replica.Pros: Offloads read traffic from the primary database.Cons:Cross-Region data transfer incurs additional costs (data transfer out of the Region). Higher latency for read operations compared to a same-Region read replica.Not cost-effective due to cross-Region charges.Conclusion: Not the most cost-effective solution.Option B: Activate Multi-AZ DB instance deployment for RDS for PostgreSQL. Configure the reports to be generated from the standby database.Pros: Provides high availability and failover support.Cons:The standby database in a Multi-AZ deployment is not accessible for read operations. It is only used for failover.Cannot be used to offload reporting workloads.Conclusion: Does not meet the requirement of generating reports from the standby database. Option C: Use AWS Data Migration Service (AWS DMS) to logically replicate data to a new database. Configure the reports to be generated from the new database. Pros: Can replicate data to another database (e.g., Amazon Aurora PostgreSQL or another RDS instance).Cons:AWS DMS incurs additional costs (task setup, ongoing replication, and potential target database costs). More complex to set up and manage compared to read replicas.Not as cost-effective as read replicas for this use case.Conclusion: Overkill and more expensive than necessary.Option D: Create a read replica in us-east-1. Configure the reports to be generated from the read replica.Pros:Offloads read traffic (reporting workloads) from the primary database, improving performance during business hours.Read replicas are in the same Region (us-east-1), so no cross-Region data transfer costs.Low latency for read operations.Cost-effective because read replicas are priced similarly to the primary database (no additional AWS DMS or cross-Region fees).Easy to set up and manage.Cons: None significant for this use case.Conclusion: The most cost-effective and practical solution.Final Answer:D. Create a read replica in us-east-1. Configure the reports to be generated from the read replica.This solution offloads reporting workloads to a read replica in the same Region, improving primary database performance without incurring additional cross-Region or complex replication costs.