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

Exam AWS Certified Developer - Associate DVA-C02 All Questions

View all questions & answers for the AWS Certified Developer - Associate DVA-C02 exam
Go to Exam

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: C 🗳️
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 (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Devon_Fazekas
Highly Voted 1 year, 7 months ago
Selected Answer: C
Multi-AZ is for disaster recovery, not read scalability or performance.
upvoted 6 times
...
Piku2
Most Recent 1 day, 20 hours ago
Selected Answer: C
It should be C as we need to update the URL of the rds endpoint as it is needed to connect the application to use the read replicas for read queries.
upvoted 1 times
...
tomchandler077
5 months, 1 week 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 3 times
...
nkroker
5 months, 1 week 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
JonasKahnwald
1 month ago
No, multi AZ is vor desaster recovery.
upvoted 1 times
...
...
65703c1
6 months, 3 weeks ago
Selected Answer: C
C is the correct answer.
upvoted 1 times
...
Vaibs099
7 months, 3 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
7 months, 4 weeks ago
C it is as it clearly mentions they want to achieve optimum read performance
upvoted 2 times
...
dan_bj
8 months, 1 week ago
Selected Answer: C
C forever
upvoted 1 times
...
badsati
8 months, 1 week ago
Selected Answer: C
C... No Question
upvoted 1 times
...
vinfo
8 months, 1 week ago
Selected Answer: C
C. El uso de replicas de lectura, aliviana las consultas intensivas sobre la BD principal
upvoted 1 times
...
xdkonorek2
11 months, 4 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 2 times
mghectorenjoyer69
8 months, 3 weeks ago
ni mada ra
upvoted 1 times
...
...
Skywalker23
1 year, 2 months ago
Selected Answer: C
Read heavy access need read replicas as the right solution.
upvoted 4 times
...
Tony88
1 year, 3 months ago
Selected Answer: C
Keyword: heavy read
upvoted 2 times
...
Akash619
1 year, 3 months ago
Selected Answer: C
Read Replicas for high performance read operations
upvoted 2 times
...
jayvarma
1 year, 4 months ago
Keyword: Achieve Optimum read performance for queries. Answer: Use Read Replicas and use that specific URL for read queries.
upvoted 1 times
...
Malkia
1 year, 7 months ago
Selected Answer: C
C answer
upvoted 1 times
...
Rpod
1 year, 7 months ago
Selected Answer: C
C answer
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago