Optimize Aurora PostgreSQL Storage for High Traffic

SAA-C03 By islever Editorial Last updated

Determine appropriate data security controls.

Short answer

D Configure the cluster to use the Aurora I/O-Optimized storage configuration to eliminate per-request I/O charges for high-traffic workloads.

Question

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?
  1. Configure the cluster to use the Aurora Standard storage configuration.
  2. Configure the cluster storage type as Provisioned IOPS.
  3. Configure the cluster storage type as General Purpose.
  4. Configure the cluster to use the Aurora I/O-Optimized storage configuration. Correct Answer

Key Takeaways

The core concept tested is understanding the pricing model and performance characteristics of Aurora storage types, specifically distinguishing between Standard and I/O-Optimized configurations to avoid unexpected I/O charges.

This question addresses how to select the most cost-effective storage configuration for an Amazon Aurora PostgreSQL Serverless v2 cluster under high traffic loads. The analysis confirms that Aurora I/O-Optimized is the correct choice for I/O-intensive workloads.

Common mistake: Many candidates incorrectly choose General Purpose or Provisioned IOPS because they are familiar with standard RDS storage options. They fail to recognize that Aurora has specific storage configurations (Standard vs. I/O-Optimized) designed to optimize costs for different workload patterns.

Expert Analysis

Why the Answer Is Correct

Aurora I/O-Optimized is specifically designed for I/O-intensive applications where I/O charges can exceed 25% of the total database spend. By switching to this configuration, you pay only for storage usage without additional per-request I/O charges, which significantly reduces costs for high-traffic applications as described in the scenario.

Why the Other Options Are Wrong

Aurora Standard storage includes free I/O allowances but charges extra for operations beyond that limit, making it expensive for high traffic. General Purpose (SSD) and Provisioned IOPS are storage types available for non-Aurora RDS instances or specific Aurora setups, but they do not offer the same I/O cost structure benefits as Aurora I/O-Optimized for this specific high-volume use case. Option A would lead to high variable costs due to excessive I/O requests.

Community Comment Notes

The community consensus strongly supports option D, with many users highlighting the cost savings for I/O-intensive apps. As one user noted, "Aurora I/O-Optimized offers up to 40% cost savings for I/O-intensive applications." Another comment emphasized that you "pay only for the usage and storage... with no additional charges for read and write I/O operations," which directly addresses the requirement to optimize performance and cost under large traffic loads.

Official Reference

https://aws.amazon.com/rds/aurora/pricing/

This link opens the official vendor documentation in a new tab.

Exam Strategy

When analyzing Aurora storage questions, always look for keywords like 'I/O-intensive', 'high traffic', or 'cost-effective' regarding I/O operations. Remember that Aurora has two main storage configurations: Standard and I/O-Optimized. Choose I/O-Optimized when I/O costs are a significant portion of the budget.

Frequently Asked Questions

Why is Aurora Standard storage not cost-effective here?

Aurora Standard charges extra for I/O operations after a free tier. For high-traffic apps, these fees accumulate quickly, making I/O-Optimized cheaper.

Is Provisioned IOPS better for performance?

Provisioned IOPS guarantees latency but doesn't solve the I/O cost issue. Aurora I/O-Optimized provides high performance without per-request fees, fitting the 'cost-effective' requirement.

More SAA-C03 FAQ →

Community Votes

D
83%
C
17%

83% of anonymous learners picked answer D. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 12 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 12

  1. Scheldon 👍 5 Answered D
    AnswerD For Aurora we have 2 storage type/options: A - Standard B -- I/O-Optimized hence answers B and C options are incorrect. Because customer inform us that there will be a big amount of traffic for their application I would go with I/O-Optimized. Maybe we are giving more $$ per GB-month but we are not paing for I/O operations/request. https://aws.amazon.com/rds/aurora/pricing/ In general question is not precise and it is hard to say which option will be more beneficial (cost effective)
  2. joseantoniopolo 👍 4 Answered D
    Aurora I/O-Optimized – Improved price performance and predictability for I/O-intensive applications. You pay only for the usage and storage of your DB clusters, with no additional charges for read and write I/O operations.
  3. xBUGx 👍 3 Answered D
    https://aws.amazon.com/about-aws/whats-new/2023/05/amazon-aurora-i-o-optimized/ Aurora I/O-Optimized offers up to 40% cost savings for I/O-intensive applications where I/O charges exceed 25% of the total Aurora database spend.
  4. haci 👍 2 Answered C
    The traffic load is not defined well enough to decide which storage type to use. General Purpose (SSD) storage suits many workloads, including small to medium-sized databases and it is cost-effective. Provisioned IOPS (PIOPS) storage is the highest-performing option available for RDS instances. With Provisioned IOPS storage, you can provision a specific amount of IOPS (input/output operations per second) based on your application’s needs. But here we don't know the amount of requests. So since the question is asking for cost-effective I'll go with C
  5. osmk 👍 2 Answered D
    https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html#aurora-storage-type
Show 7 more comments
  1. mk168898 👍 2 Answered D
    Aurora only have: -> Standard -> I/O-Optimized (need optimise storage thats why i chose this)
  2. GOTJ 👍 1 Answered A
    In my opinion, when the company "wants to optimize the storage performance of the cluster AS the load on the application increases" they mean that they EXPECT that the load increases somewhere in the future. If so, what's the point of paying more for the I/O optimised storage configuration from the very beginning? You can switch to this more expensive configuration AS the load increased, saving money before this increment occurs
  3. TruthWS 👍 2
    I think A is true answer
  4. JCAWS 👍 2 Answered D
    D is more suitable
  5. camps 👍 2
    I would choose D
  6. Kaula 👍 2 Answered C
    Agree with haci
  7. Johnoppong101 👍 2 Answered D
    Answer is D

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

S3 Multi-Region Access Point and Replication Strategy

S-grade

Securing NLB with Security Groups for Minimal Change

S-grade

Most Cost-Effective 7-Year Retention for EBS Snapshots?

S-grade

AWS Forecast vs SageMaker for Time-Series Prediction

S-grade

Practice All SAA-C03 Questions

Access 120 questions with complete answers and detailed explanations.

View Full SAA-C03 Practice Test →

← Back to SAA-C03 Study Guide