Which solution will provide the MOST cost savings without impacting the performance of the database?
Convert the data volume to the Cloud HDD (sc1) type. Leave the volume as 512 GB. Set the volume IOPS to 1,500.
Convert the data volume to the Provisioned IOPS SSD (io2) type. Resize the volume to 256 GB. Set the volume IOPS to 1,500.
Convert the data volume to the Provisioned IOPS SSD (io2) Block Express type. Leave the volume as 512 GB. Set the volume IOPS to 1,500.
Convert the data volume to the General Purpose SSD (gp3) type. Resize the volume to 256 GB. Set the volume IOPS to 1,500.
Explanations:
The Cold HDD (sc1) volume type is unsuitable for consistently high IOPS workloads like a database, as it is designed for infrequent access and low-cost storage, and it does not support setting specific IOPS.
Although Provisioned IOPS SSD (io2) supports high and consistent IOPS, it is more expensive than General Purpose SSD (gp3), making it less cost-effective for this use case.
Provisioned IOPS SSD (io2) Block Express is a premium offering for high-performance workloads, which is unnecessary for a workload with 1,500 IOPS and results in higher costs.
General Purpose SSD (gp3) is cost-effective and allows for separate scaling of IOPS and storage size. Reducing the volume to 256 GB and setting IOPS to 1,500 will meet performance needs while reducing costs.