AWS Certified Database – Specialty — Question 12

A Database Specialist needs to speed up any failover that might occur on an Amazon Aurora PostgreSQL DB cluster. The Aurora DB cluster currently includes the primary instance and three Aurora Replicas.
How can the Database Specialist ensure that failovers occur with the least amount of downtime for the application?

Answer options

• A. Set the TCP keepalive parameters low
• B. Call the AWS CLI failover-db-cluster command
• C. Enable Enhanced Monitoring on the DB cluster
• D. Start a database activity stream on the DB cluster

Correct answer: A

Explanation

Setting the TCP keepalive parameters low helps maintain a constant connection and can reduce the time it takes to detect a failure, leading to quicker failovers. The AWS CLI failover-db-cluster command can initiate a failover but does not inherently speed up the process. Enabling Enhanced Monitoring and starting a database activity stream are useful for monitoring but do not directly impact the failover speed.