Q48 — AWS SAA-C03 Ch.16

Question 48 of 100 | ← Chapter 16

Q1248. An ecommerce company runs a PostgreSQL database on an Amazon EC2 instance. The database stores data in Amazon Elastic Block Store (Amazon EBS) volumes.The daily peak input/output transactions per second (lOPS) do not exceed 15,000 IOPS. The company wants to migrate the database to Amazon RDS for PostgreSQL and to provision disk IOPS performance that is independent of disk storage capacity.Which solution will meet these requirements MOST cost-effectively?

Correct Answer: C. Configure General Purpose SSD (gp3) EBS volumes. Provision 15,000 IOPS

Explanation

Here's the analysis in English:Most Cost-Effective Solution: C. Configure General Purpose SSD (gp3) EBS volumes. Provision 15,000 IOPSWhy Option C is the Best ChoicePerformance & Cost Balancegp3 volumes allow independent scaling of IOPS and storage capacity, making them ideal for workloads requiring high IOPS without over-provisioning storage.Supports up to 16,000 IOPS (well above the required 15,000) at a lower cost compared to Provisioned IOPS (io1).Cost Efficiency:gp3 charges 975/month + storage costs).Why Other Options FailA (gp2, 5 TiB):Requires 5,000 GiB storage to achieve 15,000 IOPS (3 IOPS/GiB). Wastes storage capacity (paying for 5 TiB when only high IOPS are needed).gp2's burst IOPS are unreliable for sustained workloads.B (io1, 15,000 IOPS):Overkill for this workload--io1 is designed for ultra-high IOPS (>30,000).Expensive (15,000 IOPS on io1 costs ~10x more than gp3).D (Magnetic Volumes):Maximum ~100 IOPS--far below requirements.Only suitable for archival, not databases.RDS & gp3 SynergyAmazon RDS for PostgreSQL fully supports gp3, with automatic performance optimization. No application changes needed--just update the RDS instance's storage type to gp3. Monitor with CloudWatch to ensure IOPS stay within the provisioned limit.ConclusionOption C (gp3 with 15,000 IOPS) is the most cost-effective solution, providing the required performance without unnecessary expenses.Final Answer:C