SAA-C03 Q502 · Database

Question

A company runs its production workload on an Amazon Aurora MySQL DB cluster that includes six Aurora Replicas. The company wants near-realtime 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 speciifcation from the rest of the DB cluster. Which solution meets these requirements?

Accepted Answer

**Option A: Create and use a custom endpoint for the workload.**

Let's break down each requirement and how custom endpoints satisfy them:

1. **Distribute queries across exactly 3 specific replicas**: Aurora **custom endpoints** let you define a group of specific DB instances within a cluster. You pick exactly which instances belong to the endpoint — in this case, the three replicas with different compute/memory specs.

2. **Automatic distribution**: A custom endpoint performs load balancing across the instances in its defined group automatically. The reporting department simply connects to one DNS endpoint and Aurora handles distributing connections across the three selected replicas.

3. **Different compute and memory specifications**: This is the key signal. When you have heterogeneous

📖 Explanation

✅ Correct Answer

❌ Wrong Answers

📘 Key Concepts

🏗️ Architecture

⚙️ Operations

💰 Cost

🎯 Exam Tips