SAA-C03 Question 298
Select 3A company is designing a high-performance application that processes large volumes of financial transactions. The database backend must handle consistent, low-latency read and write operations under heavy load. The company has decided to use Amazon RDS for their database. Which of the following configurations should they choose to meet their requirements?
- A
Select an RDS instance type with sufficient memory and compute capacity, such as db.r5.4xlarge.
- B
Enable Multi-AZ deployment to ensure high availability and automatic failover.
- C
Set up a General Purpose (gp2) storage type for cost efficiency.
- D
Use Provisioned IOPS (io1 or io2) storage to ensure high throughput and low-latency disk performance.
- E
Enable Read Replicas to scale database read operations independently.
Show answer and explanation
Correct answers: A, D, E
Explanation
To meet the performance requirements of a high-load application with consistent, low-latency read and write operations, it is necessary to select an appropriately sized RDS instance type, use Provisioned IOPS storage for high throughput, and enable Read Replicas to offload read operations. Multi-AZ deployment is beneficial for availability but is not directly related to performance, and General Purpose (gp2) storage is not suitable for high-performance workloads.
- A. Correct.
Selecting an appropriate RDS instance type that matches the application's compute and memory requirements is essential for handling high loads and ensuring database performance.
- B. Incorrect.
While Multi-AZ deployment improves availability and failover capabilities, it does not directly optimize database performance under heavy read/write loads.
- C. Incorrect.
General Purpose (gp2) storage is designed for cost efficiency, but it does not provide the high throughput and low-latency performance required for the given scenario.
- D. Correct.
Provisioned IOPS storage is specifically designed for high-performance applications that require consistent, low-latency I/O operations, making it a suitable choice for the given workload.
- E. Correct.
Read Replicas allow scaling of read-intensive operations, reducing the primary database's load and ensuring better performance for read-heavy applications.