Aurora Custom Endpoint for Selective Replica Routing

SAA-C03 By islever Editorial Last updated

Determine high-performing database solutions.

Short answer

A Create and use a custom endpoint for the workload to route queries specifically to the designated high-spec replicas.

Question

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?
  1. Create and use a custom endpoint for the workload Correct Answer
  2. Create a three-node cluster clone and use the reader endpoint
  3. Use any of the instance endpoints for the selected three nodes
  4. Use the reader endpoint to automatically distribute the read-only workload

Key Takeaways

The question tests the ability to target specific instances within an Aurora cluster; the trap is assuming standard endpoints provide granular control over replica selection.

Learn how to use Amazon Aurora Custom Endpoints to route read-only workloads to specific replicas with different specifications, ensuring optimal performance for reporting queries.

Common mistake: Candidates often choose Option D (Reader Endpoint) because it handles read distribution, but they fail to realize it balances across all available readers, not just the specific high-spec nodes required by the scenario.

Expert Analysis

Why the Answer Is Correct

Option A is correct because Amazon Aurora Custom Endpoints allow you to group specific DB instances and direct traffic only to those members. This feature enables precise workload isolation, which is essential when you need to route reporting queries to a subset of replicas that have different compute or memory capacities compared to the rest of the cluster.

Why the Other Options Are Wrong

Option B is incorrect because creating a clone is a separate resource creation process, not a routing configuration for existing replicas. Option C is invalid because instance endpoints connect directly to a single node, preventing load distribution across multiple replicas. Option D is wrong because the Reader Endpoint automatically distributes connections across ALL available reader instances in the cluster, ignoring your requirement to target only the three specific high-spec replicas.

Community Comment Notes

The community consensus strongly supports Option A, citing AWS documentation that confirms custom endpoints let you define which instances handle traffic. As one commenter noted, this is "particularly useful when you have replicas with different compute and memory specifications," aligning perfectly with the exam scenario's constraints.

Official Reference

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Endpoints.Custom.html

This link opens the official vendor documentation in a new tab.

Exam Strategy

Always look for keywords like 'specific set', 'group', or 'different specifications' when dealing with Aurora endpoints. If the requirement involves targeting a subset of nodes rather than all of them, Custom Endpoint is almost always the answer.

Frequently Asked Questions

Can I use the Reader Endpoint to exclude low-spec replicas?

No. The Reader Endpoint balances traffic across ALL available reader instances in the cluster and does not support filtering or excluding specific nodes.

What happens if a custom endpoint member fails?

Aurora automatically removes the failed instance from the custom endpoint and routes traffic to the remaining healthy members in that specific group.

More SAA-C03 FAQ →

Community Votes

A
100%

100% of anonymous learners picked answer A. Votes are pick records left by other test-takers — they are not the verified answer.

Discussion 4 contributions

Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded, and comments reflect the views of individual contributors.

From public community threads 4

  1. [Removed] 👍 6 Answered A
    Custom Endpoints: Custom endpoints in Amazon Aurora allow you to group specific replicas together and route traffic only to those replicas. This is particularly useful when you have replicas with different compute and memory specifications and want to direct specific workloads, such as reporting queries, to those replicas. By creating a custom endpoint, you can include the three specific Aurora Replicas that have the required compute and memory configurations, ensuring that your near-real-time reporting queries are automatically distributed among these replicas.
  2. LeonSauveterre 👍 2 Answered A
    A - You can assign the three replicas with different compute and memory specifications to the custom endpoint, ensuring that queries are distributed only among these replicas. B - Expensive, cumbersome, and unnecessary. The clone has separate storage and compute resources. C - You can't target just the three replicas you want. D - The reader endpoint automatically distributes read queries across ALL Aurora Replicas in the cluster.
  3. FlyingHawk 👍 1 Answered A
    https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Endpoints.Custom.html A custom endpoint for an Aurora cluster represents a set of DB instances that you choose. When you connect to the endpoint, Aurora performs connection balancing and chooses one of the instances in the group to handle the connection. You define which instances this endpoint refers to, and you decide what purpose the endpoint serves.
  4. JA2018 👍 1 Answered A
    This is why I choose Option A: Using a Custom endpoint: This allows you to specify a specific set of Aurora replicas be used for the reporting queries, enabling you to target the three replicas with different compute and memory specifications while distributing the workload across them.

Reader comments & corrections

No reader corrections yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

S3 Multi-Region Access Point and Replication Strategy

S-grade

Securing NLB with Security Groups for Minimal Change

S-grade

Most Cost-Effective 7-Year Retention for EBS Snapshots?

S-grade

AWS Forecast vs SageMaker for Time-Series Prediction

S-grade

Practice All SAA-C03 Questions

Access 120 questions with complete answers and detailed explanations.

View Full SAA-C03 Practice Test →

← Back to SAA-C03 Study Guide