AWS Certified Database – Specialty — Question 31

A company is using Amazon with Aurora Replicas for read-only workload scaling. A Database Specialist needs to split up two read-only applications so each application always connects to a dedicated replica. The Database Specialist wants to implement load balancing and high availability for the read-only applications.
Which solution meets these requirements?

Answer options

• A. Use a specific instance endpoint for each replica and add the instance endpoint to each read-only application connection string.
• B. Use reader endpoints for both the read-only workload applications.
• C. Use a reader endpoint for one read-only application and use an instance endpoint for the other read-only application.
• D. Use custom endpoints for the two read-only applications.

Correct answer: D

Explanation

The correct answer is D because custom endpoints allow for dedicated connections to specific replicas, ensuring that each application connects to its own dedicated replica, thus facilitating load balancing and high availability. Options A, B, and C do not provide the same level of dedicated access and may lead to shared load across replicas, which does not meet the requirement of separating the applications.