SAA-C03 Exam - Question 39

Question

A company maintains a searchable repository of items on its website. The data is stored in an Amazon RDS for MySQL database table that contains more than 10 million rows. The database has 2 TB of General Purpose SSD storage. There are millions of updates against this data every day through the company's website.

The company has noticed that some insert operations are taking 10 seconds or longer. The company has determined that the database storage performance is the problem.

Which solution addresses this performance issue?

Examice · Accepted Answer

The company is facing performance issues with insert operations in their Amazon RDS for MySQL database due to storage performance limitations. Changing the storage type to Provisioned IOPS SSD is the most suitable solution. Provisioned IOPS SSD is designed to provide fast and consistent I/O performance, which is crucial for databases with high transaction rates and frequent updates. It allows for a specific level of IOPS to be provisioned to meet the performance requirements, thereby addressing the identified storage performance bottleneck.

pazabal · Answer

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

cookieMr · Answer

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.

Guru4Cloud · Answer

The best solution would be to change the storage type to Provisioned IOPS SSD. This allows you to specify a higher level of IOPS provisioned for your workload's needs.Therefore, switching to Provisioned IOPS SSD storage is the most direct way to resolve the storage performance bottleneck causing the slow insert times. The ability to provision high IOPS makes it the best solution for high throughput transactional workloads like this one.

awsleffe · Answer

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.

AWSStudyBuddy · Answer

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.

TariqKipkemei · Answer

Provisioned IOPS SSD it is.

David_Ang · Answer

yeah "A" is correct is the most suitable option for this scenario, because you need to improve the speed of the reading and writing of the storage system.

awashenko · Answer

"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.

tom_cruise · Answer

Key: database storage performance is the problem.

Ruffyit · Answer

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

aptx4869 · Answer

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

bujuman · Answer

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_jaa · Answer

Answer-A

awsgeek75 · Answer

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

TilTil · Answer

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.

sudohogan · Answer

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.

stephyfresh13 · Answer

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.

SAA-C03 Exam - Question 39

Discussion