Answer-first summary for fast verification
Answer: Switch to Provisioned IOPS SSD storage type.
Changing the storage type to Provisioned IOPS SSD (Option A) is the best solution because it provides high and consistent input/output performance, which is essential when dealing with high write and read operations, like those described in the scenario. General Purpose SSD storage may not handle the high I/O demand effectively, leading to performance issues such as the slow insert operations the company is experiencing. Provisioned IOPS SSD is specifically designed to support applications with high I/O workloads and offers faster and more reliable performance compared to General Purpose SSD.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
A company's website hosts a large searchable repository with over 10 million rows in an Amazon RDS MySQL database, utilizing 2 TB of General Purpose SSD storage. Despite this, the company experiences performance issues with insert operations taking up to 10 seconds, identifying storage performance as the bottleneck. What is the recommended solution to address this?
A
Switch to Provisioned IOPS SSD storage type.
B
Upgrade the DB instance to a memory-optimized class.
C
Adopt a burstable performance DB instance class.
D
Implement Multi-AZ RDS read replicas with MySQL's asynchronous replication.
No comments yet.