Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 827 discussion

Answer is 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)

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.

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html#aurora-storage-type

D is more suitable

I would choose D

I think A is true answer

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.

Agree with haci

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