Learn the most cost-effective solution to improve Amazon RDS for PostgreSQL database performance for generating real-time reports and machine learning models during peak business hours.
Table of Contents
Question
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?
A. Create a cross-Region read replica. Configure the reports to be generated from the read replica.
B. Activate Multi-AZ DB instance deployment for RDS for PostgreSQL. Configure the reports to be generated from the standby database.
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.
D. Create a read replica in us-east-1. Configure the reports to be generated from the read replica.
Answer
The most cost-effective solution to improve database performance for the given scenario is:
D. Create a read replica in us-east-1. Configure the reports to be generated from the read replica.
Explanation
Creating a read replica of the RDS for PostgreSQL database within the same us-east-1 region is the best approach here. Read replicas allow you to create a read-only copy of your database that can be used to offload read queries and analytics workloads from the primary database. This frees up resources on the primary database to handle the main transactional workload.
The key benefits of using a read replica in this case are:
- Improved performance: By routing the report generation queries to the read replica, you reduce the load on the primary database during business hours. This allows the primary to dedicate resources to handling the main application workload.
- Cost-effective: Creating a read replica is more cost-effective than the other options presented. It doesn’t require setting up cross-region infrastructure (option A) or doubling database costs with Multi-AZ (option B). Logically replicating to a new database with DMS (option C) would also be more complex and costly than using a read replica.
- Easy to implement: Setting up a read replica is straightforward through the RDS console or API. You just need to select the source database instance and choose to create a read replica in the same region. AWS handles the replication process.
- Near real-time data: Read replicas are updated asynchronously, typically within milliseconds of updates to the primary. This is sufficient for the near real-time reporting requirements stated.
So in summary, creating an us-east-1 read replica and generating the reports from it will provide the most cost-effective and efficient solution to improve database performance for this use case. The read replica offloads queries from the primary, allowing it to focus on core workloads during peak hours.
Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification exam assessment practice question and answer (Q&A) dump including multiple choice questions (MCQ) and objective type questions, with detail explanation and reference available free, helpful to pass the Amazon AWS Certified Solutions Architect – Associate SAA-C03 exam and earn Amazon AWS Certified Solutions Architect – Associate SAA-C03 certification.