Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us[email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Amazon Discussions

Exam AWS Certified Developer - Associate DVA-C02 topic 1 question 25 discussion

Exam question from Amazon's AWS Certified Developer - Associate DVA-C02
Question #: 25
Topic #: 1
[All AWS Certified Developer - Associate DVA-C02 Questions]

A company is migrating an on-premises database to Amazon RDS for MySQL. The company has read-heavy workloads. The company wants to refactor the code to achieve optimum read performance for queries.
Which solution will meet this requirement with LEAST current and future effort?

  • A. Use a multi-AZ Amazon RDS deployment. Increase the number of connections that the code makes to the database or increase the connection pool size if a connection pool is in use.
  • B. Use a multi-AZ Amazon RDS deployment. Modify the code so that queries access the secondary RDS instance.
  • C. Deploy Amazon RDS with one or more read replicas. Modify the application code so that queries use the URL for the read replicas.
  • D. Use open source replication software to create a copy of the MySQL database on an Amazon EC2 instance. Modify the application code so that queries use the IP address of the EC2 instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by svrnvtr at March 21, 2023, 10:07 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

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
tomchandler077
12 hours, 24 minutes ago
Option C provides the most straightforward and effective solution for improving read performance with minimal changes to the current application code and the least ongoing maintenance effort. Deploying read replicas allows for scaling read capacity and distributing read traffic efficiently.
upvoted 1 times
...
nkroker
3 days, 10 hours ago
Option C is wrong because deploying a read replica will be more effort then just enabling the multi-AZ with RDS and also the multi-AZ is meant for high availability that's why option B is correct.
upvoted 1 times
...
65703c1
1 month, 2 weeks ago
Selected Answer: C
C is the correct answer.
upvoted 1 times
...
Vaibs099
2 months, 2 weeks ago
Option A and B are both talking about Multi AZ RDS instance which gives Primary and Secondary(Non Read Replica). This is good for high availability but will not help in reads. Read replica or Multi AZ Cluster deployment is the only option to achieve high reads.
upvoted 1 times
...
Dikshika
2 months, 2 weeks ago
C it is as it clearly mentions they want to achieve optimum read performance
upvoted 2 times
...
dan_bj
2 months, 4 weeks ago
Selected Answer: C
C forever
upvoted 1 times
...
badsati
3 months ago
Selected Answer: C
C... No Question
upvoted 1 times
...
vinfo
3 months ago
Selected Answer: C
C. El uso de replicas de lectura, aliviana las consultas intensivas sobre la BD principal
upvoted 1 times
...
xdkonorek2
6 months, 2 weeks ago
Selected Answer: B
easiest solution is to use multi-az rds deployment with 2 readable standby instances setting up read replica is more effort than checking a single option
upvoted 1 times
mghectorenjoyer69
3 months, 1 week ago
ni mada ra
upvoted 1 times
...
...
Skywalker23
9 months, 2 weeks ago
Selected Answer: C
Read heavy access need read replicas as the right solution.
upvoted 4 times
...
Tony88
10 months, 1 week ago
Selected Answer: C
Keyword: heavy read
upvoted 2 times
...
Akash619
10 months, 2 weeks ago
Selected Answer: C
Read Replicas for high performance read operations
upvoted 2 times
...
jayvarma
11 months ago
Keyword: Achieve Optimum read performance for queries. Answer: Use Read Replicas and use that specific URL for read queries.
upvoted 1 times
...
Devon_Fazekas
1 year, 2 months ago
Selected Answer: C
Multi-AZ is for disaster recovery, not read scalability or performance.
upvoted 4 times
...
Malkia
1 year, 2 months ago
Selected Answer: C
C answer
upvoted 1 times
...
Rpod
1 year, 2 months ago
Selected Answer: C
C answer
upvoted 3 times
...
Krok
1 year, 3 months ago
Selected Answer: C
It's C.
upvoted 2 times
...
Load full discussion...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
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
ex Want to SAVE BIG on Certification Exam Prep?
close
ex Unlock All Exams with ExamTopics Pro 75% Off
  • arrow Choose From 1000+ Exams
  • arrow Access to 10 Exams per Month
  • arrow PDF Format Available
  • arrow Inline Discussions
  • arrow No Captcha/Robot Checks
Limited Time Offer
Ends in

Claim Offer Now
286 people claimed it in the last 6 hours