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

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

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

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

Question #: 353
Topic #: 1

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

A company has multiple applications that use Amazon RDS for MySQL as is database. The company recently discovered that a new custom reporting application has increased the number of Queries on the database. This is slowing down performance.
How should a solutions architect resolve this issue with the LEAST amount of application changes?

A. Add a secondary DB instance using Multi-AZ.
B. Set up a road replica and Multi-AZ on Amazon RDS.
C. Set up a standby replica and Multi-AZ on Amazon RDS.
D. Use caching on Amazon RDS to improve the overall performance.

Show Suggested Answer

Suggested Answer: B 🗳️

by dmscountera at March 11, 2021, 5:21 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

dmscountera

Highly Voted 3 years, 8 months ago

B. Set up a road replica and Multi-AZ on Amazon RDS.

upvoted 54 times

wanglei3607

3 years, 7 months ago

should be a typo road->read

upvoted 19 times

...

EarlBrillantes061816

Highly Voted 3 years, 8 months ago

I dont understand why D? not sure if caching would help the problem. Caching is for frequently requested data. We are complicating things and confusing people

upvoted 14 times

patriktre

3 years, 7 months ago

https://aws.amazon.com/blogs/database/automating-sql-caching-for-amazon-elasticache-and-amazon-rds/ - leveraging Amazon ElastiCache’s performance and scalability requires the developer to know how to best use the cache. This requires manual application code changes. the requirement is not to change application code

upvoted 6 times

francisco_guerra

3 years, 7 months ago

If the question says common queryies or common reports it would be needed cache but if say custom shows that cache it is not needed

upvoted 5 times

...

gnaw

Most Recent 1 year, 9 months ago

Answer Option C, setting up a standby replica and Multi-AZ, can help distribute the read and write load across multiple instances and provide high availability. While it does require some configuration changes in the database, it generally requires fewer application changes compared to implementing caching or other solutions. This can be an effective way to address the performance issue without significant application modifications.

upvoted 1 times

...

BECAUSE

2 years ago

Selected Answer: B

B is the answer

upvoted 1 times

...

Uzi_m

2 years, 4 months ago

Correct Answer: D

upvoted 1 times

Uzi_m

2 years, 4 months ago

Sorry it's a typo. Correct Option is B.

upvoted 1 times

...

sassy2023

2 years, 4 months ago

Road replica? Oo

upvoted 1 times

...

msyusa

2 years, 10 months ago

road replica ne abi biraz ozenin aq xd

upvoted 2 times

...

slcheng

2 years, 10 months ago

Selected Answer: D

go for D as B involve fix performance and create Availability. question just ask solve performance. D just to fix performance.

upvoted 1 times

...

cloud_collector

2 years, 10 months ago

B is better. A cache can only return results for queries it has already seen. So if you run the same queries over and over again, it's a good match If you have many different, frequently changing, or dynamic queries, a read replica will be a better match.

upvoted 1 times

...

naveenagurjara

2 years, 11 months ago

Selected Answer: B

Read Replica

upvoted 2 times

...

future77

2 years, 11 months ago

3 types of caching, 1-Aurora cache, which does not require code change 2-App internal caching, requires code change 3-Redis based cache, no development required. I would say D is wrong, because RDS is not offering a cache like Aurora. Only option is B here. A,C are distractives and could be ignored. https://aws.amazon.com/caching/database-caching/

upvoted 3 times

...

albert_kuo

3 years, 2 months ago

Selected Answer: B

Amazon RDS Read Replicas provide enhanced performance and durability for RDS database (DB) instances. They make it easy to elastically scale out beyond the capacity constraints of a single DB instance for read-heavy database workloads. https://aws.amazon.com/rds/features/read-replicas/?nc1=h_ls

upvoted 3 times

...

Venki_dev

3 years, 2 months ago

Selected Answer: B

its a custom reporting application so it query not neccesarly be the same content , so caching is not better option here.

upvoted 2 times

...

ramyargp5

3 years, 3 months ago

Selected Answer: B

Answer is B because caching needs major code modifications

upvoted 2 times

...

SmartDude

3 years, 3 months ago

Selected Answer: B

Read Replica, as its with minimum effort. For Cache we have to change the app to read from cache and then a logic to update/flush the cache.

upvoted 2 times

cutecolt

3 years, 1 month ago

Read replica also need to change the end point from where the application has to read.

upvoted 1 times

...

SuhasH

3 years, 4 months ago

Selected Answer: B

Typo Answer is B Read Replica Reporting is a Read Operation, Caching is not of much use

upvoted 2 times

...

Javatar

3 years, 4 months ago

answer is B, (assuming it's read , not road). because fewest number of application modifications is required, with read replica we only need to change db ip. also no mention repeated query or something so using cache is not option.

upvoted 1 times

...

Load full discussion...