DBS-C01 Management and Operations Practice Question

A company is using Amazon RDS for SQL Server with Always On Availability Groups. The primary DB instance is in us-east-1, and the secondary is in us-west-2. The application writes to the primary and reads from the secondary. The secondary instance becomes unreachable due to a network issue. What happens to the primary instance?

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

✓

The primary continues to accept read and write operations.

When the secondary DB instance (read replica) becomes unreachable, the primary continues to accept read and write operations normally. The secondary is an asynchronous replica, so its failure does not affect the primary. Option B is wrong because the primary does not stop accepting writes; write operations continue. Option C is wrong because failover is not automatic for asynchronous replicas; manual intervention would be required to promote the secondary. Option D is wrong because the primary remains fully available and does not become read-only.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

✓
The primary continues to accept read and write operations.
Why this is correct
The primary continues to accept read and write operations normally because the failure of the secondary does not impact primary operations in an Always On Availability Group setup.
✗
The primary stops accepting write operations.
Why it's wrong here
The primary does not become read-only; it continues to accept both read and write operations. This option is incorrect.
✗
The primary automatically fails over to the secondary.
Why it's wrong here
Failover is not automatic in this scenario. Always On Availability Groups require manual failover or a separate Multi-AZ configuration for automatic failover. This option is incorrect.
✗
The primary becomes read-only until the secondary is restored.
Why it's wrong here
The primary continues to accept write operations; it does not become read-only. This option is incorrect.

About these practice questions

Courseiva creates original exam-style practice questions with explanations and wrong-answer analysis. It does not publish real exam questions, exam dumps, or protected exam content. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

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. Refer to the exhibit. A database administrator runs the AWS CLI command shown. The output is: ["available", false]. What does this output indicate about the DB instance?

easy

A.The DB instance is in the process of being modified to enable Multi-AZ.
B.The DB instance is in a Multi-AZ deployment and is available.
C.The DB instance is stopped and is not in a Multi-AZ configuration.
✓ D.The DB instance is available and is not configured for Multi-AZ.

Why D: The output shows the DBInstanceStatus is 'available' and MultiAZ is false. Option A is incorrect because MultiAZ false indicates it is not in the process of being modified to enable Multi-AZ. Option B is incorrect because MultiAZ is false, meaning it is not in a Multi-AZ deployment. Option C is incorrect because the status is 'available', not 'stopped'.

Last reviewed: Jun 20, 2026

Question Discussion

Share a tip, memory trick, or ask about the reasoning behind this question. Do not post real exam questions, leaked content, braindumps, or copyrighted exam material. Comments are moderated and may be removed without notice.

Loading comments…

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.