Q53 — AWS SAA-C03 Ch.12

Question 53 of 100 | ← Chapter 12

Q853. A company is planning to deploy its application on an Amazon Aurora PostgreSQL Serverless v2 cluster. The application will receive large amounts of traffic. The company wants to optimize the storage performance of the cluster as the load on the application increases.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: D. Configure the cluster to use the Aurora I/O-Optimized storage configuration.

Explanation

To optimize the storage performance of an Amazon Aurora PostgreSQL Serverless v2 cluster while considering cost-effectiveness, the recommended solution is:D. Configure the cluster to use the Aurora I/O-Optimized storage configuration.Here's why:Option D suggests configuring the cluster to use the Aurora I/O-Optimized storage configuration. This configuration is specifically designed to provide high performance for database workloads. It utilizes a striped storage architecture that can scale to handle high levels of I/O activity, making it suitable for applications that receive large amounts of traffic.By choosing the Aurora I/O-Optimized storage configuration, the company can achieve improved storage performance for their application as the load increases. The I/O-optimized storage configuration is designed to handle high throughput and low latency for database operations, which is beneficial for applications with heavy traffic.Options A, B, and C do not specifically address the need to optimize storage performance for a high-traffic application.Option A suggests configuring the cluster to use the Aurora Standard storage configuration. While this configuration provides good performance for typical workloads, it may not be optimized for handling large amounts of traffic.Option B suggests configuring the cluster storage type as Provisioned IOPS. This option allows you to provision a specific number of IOPS for your storage, but it may result in higher costs if the provisioned IOPS exceed the actual workload requirements.Option C suggests configuring the cluster storage type as General Purpose. This option provides a balance of performance and cost-effectiveness for moderate workloads but may not deliver optimal performance for applications with heavy traffic.In summary, the recommended solution is to configure the Amazon Aurora PostgreSQL Serverless v2 cluster to use the Aurora I/O-Optimized storage configuration. This configuration is designed to provide high storage performance and is well-suited for applications with large amounts of traffic, optimizing both performance and cost-effectiveness.