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

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

A database is on an Amazon RDS MySQL 5.6 Multi-AZ DB instance that experiences highly dynamic reads. Application developers notice a significant slowdown when testing read performance from a secondary AWS Region. The developers want a solution that provides less than 1 second of read replication latency.
What should the solutions architect recommend?

  • A. Install MySQL on Amazon EC2 in the secondary Region.
  • B. Migrate the database to Amazon Aurora with cross-Region replicas.
  • C. Create another RDS for MySQL read replica in the secondary Region.
  • D. Implement Amazon ElastiCache to improve database query performance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
Cloudtraining
Highly Voted 3 years, 6 months ago
Why not "C" ? create a MySQL read replica on the secondary region
upvoted 19 times
forExamCert2023
2 years, 8 months ago
Because it is all about Aurora at the end. If you find yourself in a position to choose AWS brand tool/service vs. other non-Aws original services and tools, pick AWS in any AWS exams.
upvoted 4 times
...
jayvarma
1 year, 7 months ago
Because Aurora is the fastest and has minimal latency when it comes to replicating data to another AWS region compared to MySQL read replicas.
upvoted 1 times
...
boriscasoy
3 years, 5 months ago
simple, the question states "what solution the architect should recommend?". AWS wants you to offer the best solution available (also for then). Why shouldn't you offer Aurora as a Certified AWS Solution Architect?
upvoted 5 times
zxing233
3 years, 5 months ago
because you should stand align with Client's benefit not AWS's lol....
upvoted 4 times
zxing233
3 years, 5 months ago
However I will go with Aurora bcuz less than 1 second latency
upvoted 3 times
...
...
GameLift
3 years, 5 months ago
Why shouldn't you offer Aurora as a Certified AWS Solution Architect? imao
upvoted 4 times
andwill1001
3 years, 5 months ago
His point is you dont offer things just because they're "the best"... what these questions seem to never take into account is what the customer wants to pay. There's so many solutions that would work perfectly fine... but the questions leave out many other reasons why a customer would pick something else. As a SA you shouldn't just pick the best most expensive option.
upvoted 2 times
...
...
...
lehoang15tuoi
3 years, 5 months ago
Because MySQL Read Replica has rather high replication lag. Aurora can support less than 1 second, RDS MySQL cannot
upvoted 4 times
...
...
Cloudy_Guy
Highly Voted 3 years, 6 months ago
While you can do a simple RDS MySQL read replica to improve the performance whats the need for AWS Aroura cross replication? Hence "C" is the write answer
upvoted 10 times
lehoang15tuoi
3 years, 5 months ago
Yes it can improve the performance, but replication lag for RDS is high and will not meet the requirement
upvoted 2 times
...
swadeey
3 years, 5 months ago
They already have read replica. "Application developers notice a significant slowdown when testing read performance from a secondary AWS Region" Also the problem you are solving is "a solution that provides less than 1 second of read replication latency."
upvoted 2 times
...
Respuct
3 years, 5 months ago
If C is the write answer, what is the right answer?
upvoted 15 times
Shane_theNetworkGuy
2 years, 7 months ago
C is the read answer. B is the right answer.
upvoted 2 times
...
...
...
BECAUSE
Most Recent 1 year, 10 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
Sachin032
2 years, 1 month ago
Migrating database is costlier compare to creating replica .. so C is right answer
upvoted 1 times
...
queen101
2 years, 7 months ago
bbbbbbbbbbbb
upvoted 1 times
...
Alfene
2 years, 8 months ago
B is a correct answer
upvoted 1 times
...
cloud_collector
2 years, 8 months ago
B . Replication from the primary DB cluster to all secondaries is handled by the Aurora storage layer rather than by the database engine, so lag time for replicating changes is minimal—typically, less than 1 second. Keeping the database engine out of the replication process means that the database engine is dedicated to processing workloads. It also means that you don't need to configure or manage Aurora MySQL's binlog (binary logging) replication. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Replication.CrossRegion.html
upvoted 1 times
...
Janan
2 years, 8 months ago
IF the Answer B, it must hve mention Aurora Global DB not cross-region replicas. In Aurora there is nothing like cross region replicas. So my Answer is C, to create a RR of RDS in 2nd region. Question no where mentions there is already a RR in 2nd region. They only find latency when apps read from 2ns region
upvoted 1 times
...
marklovesaws143
2 years, 8 months ago
Selected Answer: B
BBBBBBBBBBBBBB
upvoted 1 times
...
bora4motion
2 years, 8 months ago
Initially I went for C. It was the better answer in my mind as you avoid a migration. Because lag time for replication must be under 1 second the correct answer is B.
upvoted 1 times
...
slcheng
2 years, 8 months ago
Selected Answer: C
question asking about fix Read issues. Read replica able fix, no need migrate. Unless the version not able create Read Replica.
upvoted 1 times
...
etheng1970
2 years, 9 months ago
Selected Answer: B
https://aws.amazon.com/rds/aurora/faqs/#High_Availability_and_Replication, MySQL Replica not only have longer replication (1sec), BUT it have high impact on Primary DB.. Therefore B is a better answer.
upvoted 2 times
...
done7
3 years, 1 month ago
Selected Answer: B
Because MySQL Read Replica has rather high replication lag. Aurora can support less than 1 second, RDS MySQL cannot
upvoted 4 times
...
drimdrim2002
3 years, 1 month ago
Selected Answer: B
https://aws.amazon.com/ko/rds/aurora/faqs/
upvoted 2 times
...
Robert_B
3 years, 2 months ago
Selected Answer: B
B - Aurora is the solution as Amazon RDS for MySQL uses asynchronous replication which does not the lag requirement (invalidating C as an answer).
upvoted 4 times
...
Siddhartham
3 years, 3 months ago
Selected Answer: C
https://aws.amazon.com/blogs/aws/cross-region-read-replicas-for-amazon-rds-for-mysql/
upvoted 3 times
...
Hira101
3 years, 3 months ago
Ans should be C, As AWS documentation,This feature builds upon our existing support for read replicas that reside within the same region as the source database instance. You can now create up to five in-region and cross-region replicas per source with a single API call or a couple of clicks in the AWS Management Console. We are launching with support for version 5.6 of MySQL
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