SAP-C02 Question 411

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose A2

  The other options have limitations or do not address the root cause of the issue: Option B (Increasing max_connections): While increasing the maximum number of connections allowed on the DB cluster may provide a temporary solution, it does not address the underlying issue of inefficient connection management, and it may lead to increased resource consumption and potential performance degradation. Option C (Instance scaling): While instance scaling can help increase the overall capacity of the DB cluster, it does not directly address the issue of too many connections being established. Additionally, it may not be effective if the high-traffic periods are unpredictable and short-lived. Option D (RDS Proxy with Aurora Data API): The Aurora Data API is designed for serverless applications to interact with Aurora Serverless databases using a web services model, not for traditional database connections. It does not address the issue of connection management for the existing application architecture.

• 1

  Option A allows the application to connect to the replica instances without directly accessing them. This approach helps to: 1) Reduce the number of connections to the primary instance 2) Increase performance by offloading read operations to the replica instances 3) Improve reliability by reducing the load on the primary instance during periods of high traffic

• Chose A1

  Option A