AWS Certified Database – Specialty — Question 35

A manufacturing company's website uses an Amazon Aurora PostgreSQL DB cluster.
Which configurations will result in the LEAST application downtime during a failover? (Choose three.)

Answer options

• A. Use the provided read and write Aurora endpoints to establish a connection to the Aurora DB cluster.
• B. Create an Amazon CloudWatch alert triggering a restore in another Availability Zone when the primary Aurora DB cluster is unreachable.
• C. Edit and enable Aurora DB cluster cache management in parameter groups.
• D. Set TCP keepalive parameters to a high value.
• E. Set JDBC connection string timeout variables to a low value.
• F. Set Java DNS caching timeouts to a high value.

Correct answer: A, C, E

Explanation

Using the read and write Aurora endpoints (A) ensures seamless connectivity during failover. Editing cache management settings (C) optimizes performance and reduces downtime, while setting low timeout for JDBC connections (E) allows for quicker detection of failures. The other options either do not directly affect downtime during failover or could potentially lead to increased latency.