AWS Certified Database – Specialty – Question089

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?

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: B