SAA-C03 Question 500
Select 4An e-commerce company is planning to migrate its on-premises relational database to Amazon Aurora. The database will handle high read and write traffic during peak shopping seasons. To prepare for the migration, you need to determine the appropriate database instance class and storage capacity. Which factors should you consider to ensure optimal performance and scalability?
- A
The number of read replicas required to handle read traffic
- B
The expected size of the database, including current and future growth
- C
The maximum number of concurrent connections the database will need to support
- D
The type of storage used for the database, such as General Purpose (SSD) or Provisioned IOPS (SSD)
- E
The number of availability zones where the database will be deployed
Show answer and explanation
Correct answers: A, B, C, D
Explanation
Database capacity planning involves evaluating key factors like read and write traffic, expected storage size, and concurrent connections to ensure the database can handle the workload. Additionally, selecting the appropriate storage type (e.g., Provisioned IOPS for high I/O performance) is crucial for optimal database performance. Considerations like availability zones are important for durability and availability but do not directly impact capacity planning.
- A. Correct.
Correct. The number of read replicas affects the database's ability to handle high read traffic and distribute the load across multiple replicas.
- B. Correct.
Correct. Understanding the current and future database size is essential for provisioning sufficient storage capacity.
- C. Correct.
Correct. Knowing the maximum number of concurrent connections helps in selecting an instance class that can handle the workload.
- D. Correct.
Correct. The type of storage impacts performance, especially for write-intensive workloads where Provisioned IOPS may be required.
- E. Incorrect.
Incorrect. While deploying across multiple availability zones is important for high availability and disaster recovery, it is not directly related to database capacity planning.