SAA-C03 Question 296
Single answerYour company is migrating a high-traffic e-commerce website to AWS. The website's backend uses a relational database that must handle millions of read and write operations per second with low latency. During peak times, the traffic volume spikes significantly. Which configuration is MOST suitable for handling the database workload effectively while ensuring scalability and performance?
- A
Use an RDS instance with a General Purpose (GP2) storage type and enable Multi-AZ for high availability.
- B
Use an RDS instance with Provisioned IOPS storage and choose an instance type optimized for memory and I/O performance.
- C
Use Amazon Aurora with Auto Scaling enabled and General Purpose (GP2) storage.
- D
Deploy an RDS instance with Magnetic storage to minimize costs and configure read replicas for scalability.
Show answer and explanation
Correct answer: B
Explanation
The database workload requires high, consistent, and predictable IOPS to handle millions of operations per second with low latency. Provisioned IOPS storage provides the necessary performance for such demanding workloads, and pairing it with an instance type optimized for memory and I/O ensures that the application can handle expected traffic spikes effectively. While other options provide some benefits, they do not meet the specific performance requirements of the scenario.
- A. Incorrect.
General Purpose (GP2) storage provides baseline performance with burst capabilities but is not suitable for consistently high IOPS requirements. Multi-AZ enhances availability but does not improve the database's ability to handle high traffic spikes.
- B. Correct.
Provisioned IOPS storage is designed for workloads requiring high, consistent, and predictable IOPS, making it ideal for high-traffic relational databases. Pairing this with an instance type optimized for memory and I/O ensures the database can handle millions of operations per second efficiently.
- C. Incorrect.
Amazon Aurora with Auto Scaling is highly scalable, but General Purpose (GP2) storage may not meet the performance needs of a workload requiring millions of read and write operations per second.
- D. Incorrect.
Magnetic storage has the lowest performance characteristics and is not suitable for high-traffic workloads. While read replicas can improve read scalability, they do not address the limitations of the primary instance's performance.