mediummulti selectObjective-mapped

An Aurora PostgreSQL application has an OLTP writer and a reporting dashboard that issues many read-only queries. The writer is healthy, but read latency rises noticeably during reporting windows. Which two changes should you make? Select two.

Question 1mediummulti select
Full question →

An Aurora PostgreSQL application has an OLTP writer and a reporting dashboard that issues many read-only queries. The writer is healthy, but read latency rises noticeably during reporting windows. Which two changes should you make? Select two.

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 Replicas to scale out the read workload.

Aurora Replicas provide additional read capacity, which lets you spread read-only traffic away from the writer instance.

B

Best answer

Send read-only application traffic to the reader endpoint.

The reader endpoint automatically distributes reads across available replicas, reducing load on the writer and improving throughput.

C

Distractor review

Scale up only the writer instance and keep all queries on it.

A larger writer may help briefly, but it does not address the core issue of separating read-heavy traffic from writes.

D

Distractor review

Replace the cluster with a single-AZ RDS instance to reduce replication overhead.

A single instance removes read scaling options and usually makes availability and read performance worse, not better.

E

Distractor review

Move the dashboard to DynamoDB without changing the query model.

This is not a direct fix for an Aurora read bottleneck and would require a major application redesign.

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 Replicas to scale out the read workload. — Aurora Replicas are designed for read scaling, so they absorb reporting traffic that would otherwise compete with the writer. Using the reader endpoint directs read-only requests to those replicas automatically, which is the simplest way to separate read load from writes. This combination improves performance without changing the transactional write path or introducing unnecessary architectural complexity. Why others are wrong: Scaling only the writer does not separate reads from writes, so the reporting workload still competes with OLTP traffic. A single-AZ RDS instance removes the very feature that helps here: read scaling. Moving the dashboard to DynamoDB is a redesign, not a targeted performance fix for the Aurora bottleneck.

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.