Courseiva
Design for New SolutionsmediumDrag & DropObjective-mapped

SAP-C02 Design for New Solutions Practice Question

Drag and drop the steps to recover an Amazon RDS Multi-AZ DB instance after a primary instance failure in the correct order.

Drag steps to the numbered slots on the right, or tap a step then tap a slot.

Steps
Order
1Step 1
2Step 2
3Step 3
4Step 4
5Step 5

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

1) Detect failure, 2) Wait for automatic failover to complete, 3) Verify that the standby instance is promoted to primary, 4) Update application endpoints to point to the new primary, 5) Investigate the root cause of the failure.

First identify failure, wait for failover, verify promotion, update endpoints, then investigate.

Answer analysis

Option-by-option breakdown

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

  • 1) Detect failure, 2) Wait for automatic failover to complete, 3) Verify that the standby instance is promoted to primary, 4) Update application endpoints to point to the new primary, 5) Investigate the root cause of the failure.

    Why this is correct

    This is the correct order because after detecting the failure, you must wait for the automatic failover to finish, then verify the promotion, update endpoints, and finally investigate the cause.

  • 1) Detect failure, 2) Immediately update application endpoints, 3) Verify promotion, 4) Wait for failover to complete, 5) Investigate the cause.

    Why it's wrong here

    This is incorrect because updating endpoints before the failover completes can cause application downtime or errors; you must wait for the failover to finish first.

  • 1) Investigate the root cause of the failure, 2) Detect failure, 3) Wait for automatic failover, 4) Verify promotion, 5) Update endpoints.

    Why it's wrong here

    This is incorrect because investigation should occur after recovery, not before detection; you must first detect the failure before taking any recovery steps.

  • 1) Detect failure, 2) Verify promotion, 3) Update endpoints, 4) Wait for failover, 5) Investigate.

    Why it's wrong here

    This is incorrect because you cannot verify promotion or update endpoints before the failover has completed; waiting for failover must come before verification.

About these practice questions

This SAP-C02 question is part of Courseiva's 1,660-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 →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This SAP-C02 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 SAP-C02 exam.