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

https://docs.aws.amazon.com/prescriptive-guidance/latest/sql-server-ec2-best-practices/striping.html

A - For example, given two io1 volumes, each provisioned with 64,000 IOPS, would provide a combined 128,000 IOPS. B - The maximum IOPS for an io1 volume is capped at 64,000 IOPS when attached to an EC2 instance. C - While increasing the size of the volume increases baseline throughput (3 IOPS per GB), it won’t exceed the 64,000 IOPS limit. D - Storage optimized instances (like i3 or i4i) use instance store volumes, which are ephemeral (non-persistent) and cannot be used as a replacement for durable EBS volumes in this use case. What is the deal with LVM striping? LVM striping allows multiple volumes to be treated as a single logical volume. Reads and writes are distributed across the striped volumes, effectively increasing the available IOPS and throughput beyond the single-volume limits.

why I would choose Option B: - Issue: The problem is that the current IOPS (Input/Output Operations Per Second) provisioned on the EBS volume are not sufficient to meet the database workload demands, leading to slower performance compared to the on-premises setup. - Solution: Since the bottleneck is clearly identified as inadequate IOPS, the most effective solution is to simply increase the provisioned IOPS on the existing EBS volume, allowing for faster data read/write operations.

A

Increase the Provisioned IOPS SSD (io1) EBS volume to more than 64,000 IOPS.

A is correct, The maximum provisioned IOPS for io1 is 64000 and hence you can achieve higher aggregate performance by adding more io1 volumes