A company hosts a production MySQL database on an Amazon Aurora single-node DB cluster. The database is queried heavily for reporting purposes. The DB cluster is experiencing periods of performance…

Question

Options

• ACreate an Aurora Replica node. Create an Auto Scaling policy to scale replicas based on CPU
• BCreate a second Aurora MySQL single-node DB cluster in a second Availability Zone. Ensure that
• CCreate an AWS Lambda function that caches reporting requests. Ensure that all reporting
• DCreate a multi-node Amazon ElastiCache cluster. Ensure that all reporting requests use the

• A
  79% (44)
• B
  4% (2)
• C
  5% (3)
• D
  13% (7)

Explanation

Creating an Aurora Replica node will offload the reporting workload from the primary DB instance, reducing the CPU utilization and improving stability. By creating an Auto Scaling policy to scale replicas based on CPU utilization, you can automatically add or remove replicas as needed to handle the reporting workload. Ensuring that all reporting requests use the read-only connection string directs the reporting workload to the replica nodes, further reducing the load on the primary DB instance.

No community discussion yet for this question.