AWS Certified Solutions Architect – Associate (SAA-C03) — Question 925

A company runs its production workload on an Amazon Aurora MySQL DB cluster that includes six Aurora Replicas. The company wants near-real-time 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

Creating a custom endpoint allows you to define a specific group of DB instances within an Amazon Aurora cluster and load-balance read-only connections exclusively among them. The default reader endpoint would distribute connections across all six replicas, which is undesirable since only three have the required hardware specifications. Utilizing individual instance endpoints fails to provide automatic load balancing, and cloning the cluster introduces unnecessary overhead, cost, and data latency.