Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 568 discussion

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

Question #: 568
Topic #: 1

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

A company wants to relocate its on-premises MySQL database to AWS. The database accepts regular imports from a client-facing application, which causes a high volume of write operations. The company is concerned that the amount of traffic might be causing performance issues within the application.
How should a solutions architect design the architecture on AWS?

A. Provision an Amazon RDS for MySQL DB instance with Provisioned IOPS SSD storage. Monitor write operation metrics by using Amazon CloudWatch. Adjust the provisioned IOPS if necessary.
B. Provision an Amazon RDS for MySQL DB instance with General Purpose SSD storage. Place an Amazon ElastiCache cluster in front of the DB instance. Configure the application to query ElastiCache instead.
C. Provision an Amazon DocumentDB (with MongoDB compatibility) instance with a memory optimized instance type. Monitor Amazon CloudWatch for performance-related issues. Change the instance class if necessary.
D. Provision an Amazon Elastic File System (Amazon EFS) file system in General Purpose performance mode. Monitor Amazon CloudWatch for IOPS bottlenecks. Change to Provisioned Throughput performance mode if necessary.

Show Suggested Answer

Suggested Answer: A 🗳️

by hmc929 at Dec. 29, 2021, 10: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

Venki_dev

Highly Voted 3 years, 2 months ago

Selected Answer: A

"Regular imports from a client-facing application result in a huge amount of write operations in the database" statement is very tricky here , there is huge amount of write operations what is happening because of regular import, which means you need something that provides better I/O ops which essentially is Provisioned IOPS Hence A is the answer

upvoted 8 times

...

peterabe

Most Recent 2 years, 10 months ago

Selected Answer: B

When it comes to A and B, Provisioned IOPS SSD vs General Purpose SSD, I think the question deliberately points you to A as Provisioned IOPS SSD is better. But according to below link: https://aws.amazon.com/getting-started/hands-on/boosting-mysql-database-performance-with-amazon-elasticache-for-redis/?refid=ada1d5c2-3aa7-4147-9b89-f4569bb84598 "Even if you add replicas to scale reads, there’s a physical limit imposed by disk based storage. The most effective strategy for coping with that limit is to supplement disk-based databases with in-memory caching." And ElastiCache is in-memory caching So B is a solution. During the process of creating a RDS SQL instance, it is mandatory to choose a storage type (Provisioned IOPS SSD or General Purpose SSD). It doesn't matter what you choose here, because finally you will query ElastiCache instead of SSD.

upvoted 2 times

balmo

2 years, 9 months ago

And nobody is talking about querying (reading), but about writing.

upvoted 3 times

...

Siraf

3 years, 3 months ago

Answer is A

upvoted 3 times

...

adsdadasdad

3 years, 4 months ago

Its a 1000000%

upvoted 2 times

...

xDANGEROUSx

3 years, 4 months ago

Why not B Can someone explain plz.

upvoted 1 times

Rob_q

3 years, 4 months ago

i think that as the problem looks for a robust write capability and does not mention reading as a problem, there is no need for caching, but there is a need for IOPS. Therefore answer = A

upvoted 9 times

...