Exam AWS Certified Solutions Architect - Associate SAA-C03 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam

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

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03

Question #: 394
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company is running a multi-tier ecommerce web application in the AWS Cloud. The application runs on Amazon EC2 instances with an Amazon RDS for MySQL Multi-AZ DB instance. Amazon RDS is configured with the latest generation DB instance with 2,000 GB of storage in a General Purpose SSD (gp3) Amazon Elastic Block Store (Amazon EBS) volume. The database performance affects the application during periods of high demand.

A database administrator analyzes the logs in Amazon CloudWatch Logs and discovers that the application performance always degrades when the number of read and write IOPS is higher than 20,000.

What should a solutions architect do to improve the application performance?

A. Replace the volume with a magnetic volume.
B. Increase the number of IOPS on the gp3 volume.
C. Replace the volume with a Provisioned IOPS SSD (io2) volume.
D. Replace the 2,000 GB gp3 volume with two 1,000 GB gp3 volumes.

Show Suggested Answer

Suggested Answer: C 🗳️

by [deleted] at March 10, 2023, 4:29 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

Bezha

Highly Voted 2 years, 3 months ago

Selected Answer: D

A - Magnetic Max IOPS 200 - Wrong B - gp3 Max IOPS 16000 per volume - Wrong C - RDS not supported io2 - Wrong D - Correct; 2 gp3 volume with 16 000 each 2*16000 = 32 000 IOPS

upvoted 37 times

FlyingHawk

6 months, 2 weeks ago

gp3 Max IOPS 16000 per volume is for SQL server, for MySQL server it is 64000 per volume, so B should work. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

upvoted 1 times

...

dkw2342

1 year, 3 months ago

I really wonder how this answer can be the top answer. How would it even be possible to provision multiple gp3 volumes for RDS? RDS manages the storage, we have no influence on the number of volumes. *Striping* is something that RDS does automatically depending on storage class and volume size: "When you select General Purpose SSD or Provisioned IOPS SSD, depending on the engine selected and the amount of storage requested, Amazon RDS automatically stripes across multiple volumes to enhance performance (...)" For MariaDB with 400 to 64,000 GiB of gp3 storage, RDS automatically provisions 4 volumes. This gives us 12,000 IOPS *baseline* and can be increased up to 64,000 *provisioned* IOPS. RDS does not support io2. Therefore: Option B

upvoted 6 times

dkw2342

1 year, 3 months ago

PS: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

upvoted 2 times

zits88

1 year, 2 months ago

It must be that io2 was originally not supported by RDS, because I see this untruth reposted everywhere. It totally is.

upvoted 4 times

...

joechen2023

2 years ago

https://repost.aws/knowledge-center/ebs-volume-type-differences RDS does support io2

upvoted 3 times

wRhlH

1 year, 12 months ago

that Link is to EBS instead of RDS

upvoted 6 times

...

baba365

1 year, 9 months ago

‘the application performance always degrades when the number of read and write IOPS is higher than 20,000’ … question didn’t say read and write IOPs can’t be higher than 32,000. Answer: C if it’s based on performance and not cost related. ‘Amazon RDS provides three storage types: General Purpose SSD (also known as gp2 and gp3), Provisioned IOPS SSD (also known as io1), and magnetic (also known as standard). They differ in performance characteristics and price, which means that you can tailor your storage performance and cost to the needs of your database workload.’ https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

upvoted 1 times

...

Michal_L_95

Highly Voted 2 years, 3 months ago

Selected Answer: B

It can not be option C as RDS does not support io2 storage type (only io1). Here is a link to the RDS storage documentation: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html Also it is not the best option to take Magnetic storage as it supports max 1000 IOPS. I vote for option B as gp3 storage type supports up to 64 000 IOPS where question mentioned with problem at level of 20 000.

upvoted 15 times

joechen2023

2 years ago

check the link below https://repost.aws/knowledge-center/ebs-volume-type-differences it states: General Purpose SSD volumes are good for a wide variety of transactional workloads that require less than the following: 16,000 IOPS 1,000 MiB/s of throughput 160-TiB volume size

upvoted 2 times

...

GalileoEC2

2 years, 2 months ago

is this true? Amazon RDS (Relational Database Service) supports the Provisioned IOPS SSD (io2) storage type for its database instances. The io2 storage type is designed to deliver predictable performance for critical and highly demanding database workloads. It provides higher durability, higher IOPS, and lower latency compared to other Amazon EBS (Elastic Block Store) storage types. RDS offers the option to choose between the General Purpose SSD (gp3) and Provisioned IOPS SSD (io2) storage types for database instances.

upvoted 3 times

1rob

1 year, 5 months ago

Please add a reference where it states that io2 is supported by RDS.

upvoted 1 times

zits88

1 year, 2 months ago

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html - Right there in the first paragraph: "Amazon RDS provides three storage types: General Purpose SSD (also known as gp2 and gp3), Provisioned IOPS SSD (also known as io1 and io2 Block Express), and magnetic (also known as standard). They differ in performance characteristics and price, which means that you can tailor your storage performance and cost to the needs of your database workload. You can create Db2, MySQL, MariaDB, Oracle, and PostgreSQL RDS DB instances with up to 64 tebibytes (TiB) of storage. "

upvoted 7 times

...

zdi561

Most Recent 4 months, 2 weeks ago

Selected Answer: C

RDS now support io2

upvoted 2 times

...

EllenLiu

6 months ago

Selected Answer: C

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html#Concepts.Storage.GeneralSSD

upvoted 1 times

...

FlyingHawk

6 months, 2 weeks ago

Selected Answer: B

I selected C initially, but after read the doc https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html, noticed maximum IOPS for gp3 volume is 64K (16K for SQL server), For an RDS for MySQL workload, increasing the provisioned IOPS on the gp3 volume to exceed the application's peak demand (e.g., 30,000 IOPS) is a cost-effective and scalable solution.

upvoted 1 times

...

LeonSauveterre

6 months, 3 weeks ago

Selected Answer: C

How on earth would the answer be D? Splitting the gp3 volume into two does not solve the IOPS limitation because each volume would still be subject to the gp3 performance cap. The core of the crux is still there! C - io2 volumes are exactly designed for workloads requiring consistent, high-performance storage.

upvoted 1 times

...

Mish

7 months, 1 week ago

Selected Answer: C

Provisioned IOPS SSDs (io2) are specifically designed to deliver sustained high performance and low latency (RDS is supported in IO2). They can handle more than 20,000 IOPS.

upvoted 2 times

...

studydue

7 months, 2 weeks ago

Updated 2024 Answer: C

upvoted 4 times

...

ashishs174

9 months ago

Answer is C, io2 volumes are supported https://aws.amazon.com/blogs/aws/amazon-rds-now-supports-io2-block-express-volumes-for-mission-critical-database-workloads/

upvoted 2 times

...

MatAlves

9 months, 1 week ago

Nice to see that everyone just picked a different answer...

upvoted 3 times

...

ChymKuBoy

10 months, 1 week ago

Selected Answer: B

B for sure

upvoted 1 times

...

example_

10 months, 3 weeks ago

Selected Answer: C

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

upvoted 5 times

...

FrozenCarrot

11 months, 2 weeks ago

Selected Answer: C

Now EBS support io2.

upvoted 6 times

...

theamachine

12 months ago

Selected Answer: C

Provisioned IOPS SSDs (io2) are specifically designed to deliver sustained high performance and low latency (RDS is supported in IO2). They can handle more than 20,000 IOPS.

upvoted 7 times

FlyingHawk

6 months, 2 weeks ago

C is more expensive and overkill.

upvoted 1 times

...

Lin878

1 year ago

Selected Answer: C

It should be "C" right, now. https://aws.amazon.com/blogs/aws/amazon-rds-now-supports-io2-block-express-volumes-for-mission-critical-database-workloads/

upvoted 5 times

...

[Removed]

1 year ago

C is the correct one EBS Volume Types Use cases Provisioned IOPS (PIOPS) SSD • Critical business applications with sustained IOPS performance • Or applications that need more than 16,000 IOPS • Great for databases workloads (sensitive to storage perf and consistency) • io1/io2 (4 GiB - 16 TiB): • Max PIOPS: 64,000 for Nitro EC2 instances & 32,000 for other • Can increase PIOPS independently from storage size • io2 have more durability and more IOPS per GiB (at the same price as io1) • io2 Block Express (4 GiB – 64 TiB): • Sub-millisecond latency • Max PIOPS: 256,000 with an IOPS:GiB ratio of 1,000:1

upvoted 3 times

...

Scheldon

1 year ago

Selected Answer: C

Per the newest info it should be C right now https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Storage.html

upvoted 4 times

...

Load full discussion...