Minimizing RDS Multi-AZ Failover Downtime
A company is running an Amazon RDS for SQL Server instance with Multi-AZ deployment. The database is used by a critical application. During a recent failover test, the application experienced a 2-minute downtime. The application's connection string uses the DB instance endpoint, not the cluster endpoint. Which change would minimize downtime during future failovers?
Quick Answer
The answer is to modify the application to use the cluster endpoint instead of the instance endpoint. This is correct because the cluster endpoint is a CNAME that always points to the current primary instance, so when a Multi-AZ failover occurs, DNS updates automatically and the application reconnects with minimal interruption. In contrast, the instance endpoint is tied to a specific database server, forcing the application to wait for a new TCP connection and DNS resolution, which causes the full two-minute downtime. On the AWS Certified Database Specialty DBS-C01 exam, this question tests your understanding of how RDS Multi-AZ failover downtime is minimized through connection management, not through scaling or additional replicas. A common trap is assuming that increasing instance size or adding read replicas reduces failover time, but the real bottleneck is often the application’s connection logic. Remember the mnemonic: “Cluster for failover, instance for direct.”
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Modify the application to use the cluster endpoint instead of the instance endpoint
Using the cluster endpoint (the DNS name that automatically points to the current primary after failover) allows the application to reconnect to the new primary without waiting for DNS propagation, thus minimizing downtime. Option B is incorrect because increasing the DB instance class size does not reduce failover time. Option C is incorrect because read replicas are used for read scaling, not for reducing failover downtime. Option D is incorrect because Multi-AZ is already enabled, so enabling it again would have no effect.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✓
Modify the application to use the cluster endpoint instead of the instance endpoint
Why this is correct
The cluster endpoint points to the current primary and updates automatically after failover, reducing downtime.
- ✗
Increase the DB instance class size
Why it's wrong here
Instance size affects performance, not failover downtime.
- ✗
Create a read replica in a different Availability Zone
Why it's wrong here
Read replicas are for read offloading, not automatic failover.
- ✗
Enable Multi-AZ on the DB instance
Why it's wrong here
Multi-AZ is already enabled.
Go deeper
Related to this question
About these practice questions
This DBS-C01 question is part of Courseiva's 1,663-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →
Same concept, more angles
1 more way this is tested on DBS-C01
These questions test the same concept from different angles. Work through them to make sure you can recognise it however the exam phrases it.
Variation 1. A company runs an Amazon RDS for PostgreSQL instance with Multi-AZ deployment. The primary DB instance fails unexpectedly and a failover occurs. Which action should be taken to minimize downtime during future failovers?
medium- ✓ A.Configure an Amazon RDS Proxy to reduce failover time.
- B.Increase the DB instance size to reduce failover time.
- C.Create a read replica in the same region and promote it during failover.
- D.Enable Multi-AZ deployment to automatically failover to the standby.
Why A: Amazon RDS Proxy helps minimize downtime during failovers by maintaining database connections, reducing connection disruption and allowing applications to recover faster. The instance already has Multi-AZ enabled, so simply enabling it again is not a valid action. RDS Proxy provides connection pooling and seamless failover handling. Increasing instance size does not reduce failover time. Read replicas require manual promotion and are not used for automatic failover in RDS for PostgreSQL. Multi-AZ is already enabled, so there is no need to enable it again.
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This DBS-C01 practice question is part of Courseiva's free Amazon Web Services certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the DBS-C01 exam.