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

A: Made for high levels of I/O opps for consistent, predictable performance. B: Can improve performance of insert opps, but it's a storage performance rather than processing power problem C: for moderate CPU usage D: for scale read-only replicas and doesn't improve performance of insert opps on the primary DB instance

Option B (changing the DB instance to a memory optimized instance class) focuses on improving memory capacity but may not directly address the storage performance issue. Option C (changing the DB instance to a burstable performance instance class) is suitable for workloads with varying usage patterns and burstable performance needs, but it may not provide consistent and predictable performance for heavy write workloads. Option D (enabling Multi-AZ RDS read replicas with MySQL native asynchronous replication) is a solution for high availability and read scaling but does not directly address the storage performance issue. Therefore, option A is the most appropriate solution to address the performance issue by leveraging Provisioned IOPS SSD storage type, which provides consistent and predictable I/O performance for the Amazon RDS for MySQL database.

Upgrade your RDS MySQL storage from General Purpose SSD (gp2) to Provisioned IOPS SSD (io1/io2) to achieve consistent, high-performance write throughput — the best solution for addressing your current insert performance issue.

Hint in the stem: DB insert operations taking 10 seconds or longer => current General Purpose SSD storage cannot providing sufficient IOPS required for the workload. Provisioned IOPS SSD can significantly improve storage performance and reduce latency for DB operations. Provisioned IOPS SSD: Designed to deliver fast, predictable, and consistent I/O performance. This type of performance is very crucial for databases with high transaction rates and frequent updates. It allows users to provision a specific level of IOPS to meet the performance requirements of their specific workload.

Ans A, as per stephyfresh13: "Provisioned IOPS SSD: This storage type is designed to deliver fast, predictable, and consistent I/O performance, which is crucial for databases with high transaction rates and frequent updates. It allows you to provision a specific level of IOPS to meet the performance requirements of your workload."

A. Change the storage type to Provisioned IOPS SSD. Here's why: Provisioned IOPS SSD: This storage type is designed to deliver fast, predictable, and consistent I/O performance, which is crucial for databases with high transaction rates and frequent updates. It allows you to provision a specific level of IOPS to meet the performance requirements of your workload. Current Issue: The problem with insert operations taking 10 seconds or longer indicates that the current General Purpose SSD storage is not providing sufficient IOPS for the workload. Provisioned IOPS SSD can significantly improve storage performance and reduce latency for database operations.

B is the answer, if the company decided that storage is the problem then an IOPS SSD (storage) is the solution and not a memory optimiser.

A. IOPS is about increasing the number of input connections so you can handle more requests. Which may not be the issue. B. Having a memory optimized class provides more RAM to execute the queries which take upto 10 secs to complete. More RAM means they can execute faster. C and D are distractors. They deal with high availability and timely scalability which are not issues here.

Database storage is issue so BD is irrelevant C is for performance boost (CPU) which won't help with storage issues A Fix the storage issue

Answer-A

Do not misconsider "database storage performance is the problem". I beleive the correct asnwer is B Due too the fact that Mmemory Optimized EC2 instance family is designed for DB servers perf.

A is correct answer because it is talking about storage and transaction speed is slow due to it, should change to iops storage instead.

A: Made for high levels of I/O opps for consistent, predictable performance. B: Can improve performance of insert opps, but it's a storage performance rather than processing power problem C: for moderate CPU usage D: for scale read-only replicas and doesn't improve performance of insert opps on the primary DB instance

I go with option A. Using Amazon Provisioned IOPS (PIOPS) SSD storage is the best way to solve the performance issue of insert operations taking 10 seconds or longer on an Amazon RDS for MySQL database table with more than 10 million rows and 2 TB of General Purpose SSD storage. A high-performance storage solution with reliable throughput and minimal latency is PIOPS SSD storage. Workloads like insert operations, which demand high I/O performance, are ideally suited for it.

Key: database storage performance is the problem.

Option A is answer - A. Change the storage type to Provisioned IOPS SSD. The company's issue is related to storage performance, specifically with insert operations. This suggests that the I/O operations are the bottleneck. Provisioned IOPS SSD storage type is designed to handle the kind of workload the company is experiencing and should help improve the performance of insert operations.

"The company has determined that the database storage performance is the problem." This is the key statement in the question. Otherwise I would have selected B but this statement here makes A correct.