Q39 — AWS SAA-C03 Ch.10

Question 39 of 100 | ← Chapter 10

Q639. An ecommerce company runs a PostgreSQL database on premises. The database stores data by using high IOPS Amazon Elastic Block Store (Amazon EBS) block storage.The daily peak I/O transactions per second do not exceed 15,000 IOPS. The company wants to migrate the database to Amazon RDS for PostgreSQL and provision disk IOPS performance independent of disk storage capacity. Which solution will meet these requirements MOST cost_effectively?

Correct Answer: C. Configure the General Purpose SSD (gp3) EBS volume storage type and provision 15,000 IOPS

Explanation

To meet the requirements of migrating the PostgreSQL database to Amazon RDS for PostgreSQL and provisioning disk IOPS performance independent of disk storage capacity in a cost-effective manner, the solution that would be most suitable is: C. Configure the General Purpose SSD (gp3) EBS volume storage type and provision 15,000 IOPS.Option C, configuring the General Purpose SSD (gp3) EBS volume storage type and provisioning 15,000 IOPS, is the most cost-effective solution for this scenario. The gp3 volume type is designed to provide a balance of price and performance for a wide variety of workloads. It offers the ability to independently configure both throughput and IOPS, allowing you to provision the required performance while keeping the costs optimized. By provisioning 15,000 IOPS with the gp3 volume type, you can meet the peak I/O transaction requirements of the database without incurring unnecessary costs for higher IOPS levels. Option A, configuring the General Purpose SSD (gp2) EBS volume storage type and provisioning 15,000 IOPS, is not the most cost-effective solution. While gp2 volumes can provide burstable performance, the maximum provisioned IOPS for gp2 volumes is limited to 16,000 IOPS. Provisioning the maximum IOPS with gp2 volumes would exceed the requirements of the database and result in higher costs without significant performance benefits. Option B, configuring the Provisioned IOPS SSD (io1) EBS volume storage type and provisioning 15,000 IOPS, is a viable solution. However, io1 volumes are typically more expensive compared to the gp3 volume type. Unless specific performance characteristics of io1 volumes are required, such as higher durability or lower latency, using gp3 volumes with the appropriate provisioning can provide a more cost-effective solution. Option D, configuring the EBS magnetic volume type to achieve maximum IOPS, is not recommended for this scenario. EBS magnetic volumes are the legacy magnetic storage option and do not provide the necessary performance and reliability for running a high-IOPS database workload. Therefore, the most cost-effective solution to meet the requirements of migrating the PostgreSQL database to Amazon RDS for PostgreSQL and provisioning disk IOPS performance independent of disk storage capacity is C: Configure the General Purpose SSD (gp3) EBS volume storage type and provision 15,000 IOPS.