AWS Certified Database – Specialty — Question 67

A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and
OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.
Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

Answer options

• A. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
• B. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.
• C. Create additional readers to cater to the different scenarios.
• D. Use custom endpoints to satisfy the different workloads.

Correct answer: D

Explanation

The correct answer is D because custom endpoints allow for specific routing of traffic to designated nodes, ensuring that OLTP and OLAP workloads are effectively managed on the right resources. Option A does not provide sufficient control over workload distribution, while options B and C do not address the requirement for dedicated resources for each workload effectively.