exam questions

Exam AWS Certified Developer - Associate DVA-C02 All Questions

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

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

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 🗳️

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
Devon_Fazekas
Highly Voted 1 year, 11 months ago
Selected Answer: C
Multi-AZ is for disaster recovery, not read scalability or performance.
upvoted 7 times
...
sumanshu
Most Recent 4 months, 1 week ago
Selected Answer: C
A) & B) - Eliminated - Multi-AZ deployments are designed for high availability and failover, not for scaling read performance. D) Eliminated - significant operational overhead to set up and maintain replication between the primary database and the EC2 instance
upvoted 2 times
...
trieudo
4 months, 2 weeks ago
Selected Answer: C
keyword: read-heavy workloads, LEAST current and future effort ==> discard A, B: multiAZ, just only make high availibity, option A: it make you can handler bigger cocurency request, option B you can access to secondary RDS in normal case by modifying code. Both are not help for 'read-heavy workloads' ==> discard D: take time to execute, maintain, ... when use not-intergated source, violate 'LEAST current and future effort' C is best choice
upvoted 3 times
...
Piku2
4 months, 2 weeks 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
9 months, 3 weeks 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
9 months, 3 weeks 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
5 months, 2 weeks ago
No, multi AZ is vor desaster recovery.
upvoted 1 times
...
...
65703c1
11 months, 1 week ago
Selected Answer: C
C is the correct answer.
upvoted 1 times
...
Vaibs099
1 year 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
1 year ago
C it is as it clearly mentions they want to achieve optimum read performance
upvoted 2 times
...
dan_bj
1 year ago
Selected Answer: C
C forever
upvoted 1 times
...
badsati
1 year ago
Selected Answer: C
C... No Question
upvoted 1 times
...
vinfo
1 year ago
Selected Answer: C
C. El uso de replicas de lectura, aliviana las consultas intensivas sobre la BD principal
upvoted 1 times
...
xdkonorek2
1 year, 4 months 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
1 year, 1 month ago
ni mada ra
upvoted 1 times
...
...
Skywalker23
1 year, 7 months ago
Selected Answer: C
Read heavy access need read replicas as the right solution.
upvoted 4 times
...
Tony88
1 year, 7 months ago
Selected Answer: C
Keyword: heavy read
upvoted 3 times
...
Akash619
1 year, 8 months ago
Selected Answer: C
Read Replicas for high performance read operations
upvoted 2 times
...
jayvarma
1 year, 8 months ago
Keyword: Achieve Optimum read performance for queries. Answer: Use Read Replicas and use that specific URL for read queries.
upvoted 2 times
...
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago