mediummultiple choiceObjective-mapped

An e-commerce application uses Aurora MySQL. Writes are modest, but the product-detail page generates many read-only queries and the writer instance CPU is high. The application can tolerate a small amount of replication lag on those reads. What should the team do?

Question 1mediummultiple choice
Full question →

An e-commerce application uses Aurora MySQL. Writes are modest, but the product-detail page generates many read-only queries and the writer instance CPU is high. The application can tolerate a small amount of replication lag on those reads. What should the team do?

Answer choices

Why each option matters

Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.

A

Best answer

Add Aurora read replicas and send read-only traffic to the reader endpoint.

Aurora read replicas are the right way to scale read-heavy workloads and reduce pressure on the writer instance. By directing read-only traffic to the reader endpoint, the application can offload product-page queries while keeping writes on the primary instance. Because a small amount of replication lag is acceptable, this approach aligns well with the workload's consistency and performance needs.

B

Distractor review

Increase the writer instance size and keep all traffic on the primary.

A larger writer may temporarily relieve CPU pressure, but it does not solve the architectural issue of read traffic competing with writes. The application would still send every query to the primary instance, limiting future scalability. Since the reads can tolerate a bit of lag, offloading them to replicas is a better design.

C

Distractor review

Replace Aurora with DynamoDB to eliminate replication lag.

Switching database engines would require major application redesign and is not the simplest answer to a read-scaling problem in Aurora. DynamoDB has different query patterns, data modeling rules, and consistency behavior. The question asks how to improve the current Aurora architecture, so a full migration is unnecessary and too disruptive.

D

Distractor review

Enable Multi-AZ failover only, because it increases read throughput automatically.

Multi-AZ improves availability and failover behavior, but it is not a read-scaling feature. It ensures that the database can recover quickly if the primary fails, yet it does not automatically redirect large volumes of read traffic away from the writer for performance purposes. The problem here is read load, not just availability.

Common exam trap

Common exam trap: NAT rules depend on direction and matching traffic

NAT is not only about the public address. The inside/outside interface roles and the ACL or rule that matches traffic are just as important.

Technical deep dive

How to think about this question

NAT questions usually test address translation, overload/PAT behaviour, static mappings and whether the right traffic is being translated. Read the interface direction and address terms carefully.

KKey Concepts to Remember

  • Static NAT maps one inside address to one outside address.
  • PAT allows many inside hosts to share one public address using ports.
  • Inside local and inside global describe the private and translated addresses.
  • NAT ACLs identify traffic for translation, not always security filtering.

TExam Day Tips

  • Identify inside and outside interfaces first.
  • Check whether the scenario needs static NAT, dynamic NAT or PAT.
  • Do not confuse NAT matching ACLs with normal packet-filtering intent.

Related practice questions

Related SAA-C03 practice-question pages

Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.

More questions from this exam

Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.

FAQ

Questions learners often ask

What does this SAA-C03 question test?

Static NAT maps one inside address to one outside address.

What is the correct answer to this question?

The correct answer is: Add Aurora read replicas and send read-only traffic to the reader endpoint. — Aurora read replicas and the reader endpoint are the best fit because the workload is read-heavy and the application can tolerate a small amount of lag. This allows the team to keep writes on the primary while sending product-detail reads to replicas, reducing writer CPU and improving overall throughput. It is a standard, low-risk scaling pattern for Aurora when read performance is the main bottleneck. Why others are wrong: Increasing the writer size only postpones the bottleneck and keeps read pressure on the primary. Migrating to another database is too disruptive for a problem that can be solved within Aurora. Multi-AZ is about availability and failover, not read scaling. Because the scenario explicitly allows slight lag, read replicas are the most appropriate solution.

What should I do if I get this SAA-C03 question wrong?

Then try more questions from the same exam bank and focus on understanding why the wrong options are tempting.

Discussion

Loading comments…

Sign in to join the discussion.