SAA-C03 Question 295
Select 3A company is planning to migrate its on-premises relational database to Amazon RDS for PostgreSQL. The database is expected to handle high read and write traffic with a requirement for low latency. The database size is 3TB, and the company expects a steady growth rate of 500GB per year. Which combination of actions should the company take to ensure optimal performance and scalability?
- A
Choose an Amazon RDS instance type with sufficient memory and compute capacity, such as db.r6g.large or higher, based on usage patterns.
- B
Enable Multi-AZ deployment for Amazon RDS to improve read performance and fault tolerance.
- C
Use Amazon RDS Provisioned IOPS storage to handle high input/output operations and maintain low latency.
- D
Implement read replicas to scale read operations and offload read traffic from the primary database.
- E
Enable automatic scaling for the RDS instance to dynamically adjust instance type based on traffic.
Show answer and explanation
Correct answers: A, C, D
Explanation
To ensure optimal performance and scalability, the company must choose an appropriately sized RDS instance, use Provisioned IOPS for high I/O performance, and implement read replicas to scale read operations. Multi-AZ deployment, while useful for fault tolerance, does not address the performance or capacity planning requirements for high traffic. Additionally, RDS does not support automatic scaling of instance types, so this is not a valid action.
- A. Correct.
Choosing an RDS instance type with sufficient memory and compute capacity is essential to handle high traffic and ensure optimal database performance.
- B. Incorrect.
Multi-AZ deployment improves database availability and fault tolerance but does not improve read performance. It is not directly related to handling high traffic or optimizing capacity planning.
- C. Correct.
Using Provisioned IOPS storage is critical for applications that require consistent performance for high input/output workloads with low latency.
- D. Correct.
Read replicas help distribute read traffic and reduce the load on the primary database, making them a crucial component for scaling read-heavy workloads.
- E. Incorrect.
RDS does not support automatic scaling of instance types. Scaling instance types requires manual intervention or automation through external scripts or AWS services like Lambda.