ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

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

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

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02
Question #: 38
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company's website is using an Amazon RDS MySQL Multi-AZ DB instance for its transactional data storage. There are other internal systems that query this DB instance to fetch data for internal batch processing. The RDS DB instance slows down significantly when the internal systems fetch data. This impacts the website's read and write performance, and the users experience slow response times.
Which solution will improve the website's performance?

  • A. Use an RDS PostgreSQL DB instance instead of a MySQL database.
  • B. Use Amazon ElastiCache to cache the query responses for the website.
  • C. Add an additional Availability Zone to the current RDS MySQL Multi-AZ DB instance.
  • D. Add a read replica to the RDS DB instance and configure the internal systems to query the read replica.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by frizzo at June 3, 2020, 1:06 a.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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
frizzo
Highly Voted 3 years, 8 months ago
D is correct
upvoted 62 times
aguy9
3 years, 7 months ago
Yep D is correct
upvoted 4 times
...
...
dkcloudguru
Highly Voted 3 years, 8 months ago
D is correct option. Here the internal system fetch the data that mean it is performing only SELECT statement, Read replicas are used for SELECT (=read) only kind of statements (not INSERT, UPDATE, DELETE)
upvoted 22 times
...
jopeg
Most Recent 2 years, 9 months ago
Selected Answer: D
DDD for me
upvoted 1 times
...
queen101
2 years, 10 months ago
Select statement being done by the internal system and READ REPLICA is only for this. So answer is DDDDD
upvoted 1 times
...
marklovesaws143
2 years, 10 months ago
Selected Answer: D
DDDDDDDDDDDDDD
upvoted 1 times
...
slcheng
2 years, 11 months ago
Selected Answer: D
Vote for D
upvoted 1 times
...
achrafsky
3 years ago
Selected Answer: D
D is correct
upvoted 1 times
...
sailarg
3 years, 1 month ago
Selected Answer: D
I choose D
upvoted 1 times
...
mona667
3 years, 2 months ago
Performance = Read Replicas MultiAZ= Disaster Recovery (DR)
upvoted 3 times
...
joe2211
3 years, 5 months ago
Selected Answer: D
vote D
upvoted 2 times
...
sandeep138
3 years, 7 months ago
Why not B? "Use Amazon ElastiCache to cache the query responses for the website." I am sure C is correct but looks like B too should be correct. Any reason for eliminating B?
upvoted 2 times
derekurizar
3 years ago
C is not correct, that is for DRP purposes not for improve the performance
upvoted 1 times
...
LETSGETIT
3 years, 4 months ago
A read replica will continuously sync from the master. So your results will probably lag 0 - 3s (depending on the load) behind the master. A cache takes the query result at a specific point in time and stores it for a certain amount of time. The longer your queries are being cached, the more lag you'll have; but your master database will experience less load. It's a trade-off you'll need to choose wisely depending on your application.
upvoted 3 times
...
...
Vibes
3 years, 7 months ago
D is right
upvoted 2 times
...
Akbar_aws
3 years, 7 months ago
D is correct. "Read Replica"
upvoted 3 times
...
woke
3 years, 7 months ago
D is correct
upvoted 3 times
...
Maddy_aws2020
3 years, 7 months ago
Passed the exam on 19th June 2021. This question appeared in my exam. Marking it for future help.
upvoted 9 times
TG080
3 years, 7 months ago
Maddy how many questions u got out of examtopics and any other dumps u have used ?
upvoted 4 times
...
...
Flass
3 years, 7 months ago
Everytime there's a question on Db slowness, you can bet the answer will be "Read Replica", whether the Db is MySQL, PostGres, Aurora, RDS... READ REPLICA
upvoted 12 times
...
KK_uniq
3 years, 7 months ago
D for sure Easy question
upvoted 2 times
...
Load full discussion...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel