AWS Certified Solutions Architect – Associate (SAA-C02) — Question 311

A company runs its production workload on an Amazon Aurora MySQL DB cluster that includes six Aurora Replicas. The company wants near-real-lime reporting queries from one of its departments to be automatically distributed across three of the Aurora Replicas. Those three replicas have a different compute and memory specification from the rest of the DB cluster.
Which solution meets these requirements?

Answer options

• A. Create and use a custom endpoint for the workload.
• B. Create a three-node cluster clone and use the reader endpoint.
• C. Use any of the instance endpoints for the selected three nodes.
• D. Use the reader endpoint to automatically distribute the read-only workload.

Correct answer: A

Explanation

Amazon Aurora custom endpoints allow you to group a specific subset of DB instances within a cluster, enabling automatic load balancing of read-only workloads across only those selected instances. Using the default reader endpoint would route traffic to all six replicas, which is undesirable since three of them have different performance specifications. Individual instance endpoints do not provide automatic distribution of traffic, and creating a cluster clone introduces unnecessary lag, cost, and management overhead.