Q41 — AWS SAA-C03 Ch.13

Question 41 of 100 | ← Chapter 13

Q941. 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?

• 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. Create and use a custom endpoint for the workload.

Explanation

The solution that meets the requirements is:A. Create and use a custom endpoint for the workload.Here's why:Custom Endpoint: Creating a custom endpoint allows you to specify a specific set of Aurora Replicas for read-only queries. This enables you to direct the reporting workload to the three replicas with different compute and memory specifications.Targeted Distribution: You can configure the custom endpoint to distribute read-only queries across the selected three replicas, ensuring that the reporting workload is handled efficiently.Isolation: The custom endpoint isolates the reporting workload from the main database cluster, preventing performance impacts on the primary database.Why other options are less suitable:B. Create a three-node cluster clone and use the reader endpoint. While creating a clone provides a separate cluster, it doesn't allow you to distribute the workload across specific replicas within the main cluster.C. Use any of the instance endpoints for the selected three nodes. This approach doesn't provide automatic distribution of the workload across the chosen replicas. It requires manual routing and doesn't guarantee even distribution.D. Use the reader endpoint to automatically distribute the read-only workload. The reader endpoint distributes read-only queries across all available Aurora Replicas, not just the specific three with different specifications.In summary:Option A provides the most efficient and flexible solution for distributing reporting queries across specific Aurora Replicas with different configurations. Creating a custom endpoint allows for targeted distribution and isolation of the workload, ensuring optimal performance and resource utilization.