The correct answer involves enabling Multi-AZ, taking a snapshot, and updating the CloudFormation stack with the new instance class. This combination works because Multi-AZ allows a rolling upgrade: when you modify the instance class, AWS first updates the standby replica, then performs a failover to it, making the new class active with only a brief connection interruption rather than full downtime. On the AWS Certified SysOps Administrator Associate SOA-C02 exam, this scenario tests your understanding of CloudFormation stack updates versus direct RDS modifications—a common trap is thinking you can change the instance class manually in the console, but that causes stack drift and breaks infrastructure-as-code management. The key insight is that CloudFormation orchestrates the change through the stack update, while Multi-AZ handles the minimal-downtime mechanics behind the scenes. Memory tip: think "Stack, Snapshot, Standby" — update the stack, snapshot for safety, and rely on the Multi-AZ standby for the rolling switch.
SOA-C02 Deployment, Provisioning, and Automation Practice Question
This SOA-C02 practice question tests your understanding of deployment, provisioning, and automation. Match the stated requirement to the specific cloud service, access model, or configuration option — many options are valid in isolation but not for this scenario. After answering, compare your reasoning against the explanation and wrong-answer breakdown below. Once you have made your selection, read the full explanation to reinforce the concept and understand why each distractor is designed to mislead on exam day.
A company uses AWS CloudFormation to manage infrastructure. The SysOps administrator wants to update a stack that contains an Amazon RDS DB instance. The update involves changing the DB instance class. Which THREE steps should the administrator take to perform this update with minimal downtime? (Choose three.)
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Update the CloudFormation stack with a new parameter value for the DB instance class.
The correct answers are B, C, and E. Using a snapshot ensures data is backed up (B). Modifying the DB instance class with Multi-AZ enabled allows a rolling update (C). Updating the CloudFormation stack with the new instance class triggers the change (E). Option A is wrong because deleting the stack is not necessary. Option D is wrong because modifying the DB instance directly outside CloudFormation may cause drift.
Key principle: Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
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 RDS instance class directly in the RDS console and then update the CloudFormation template.
Why it's wrong here
Wrong: Direct modification causes drift; should update via CloudFormation.
✓
Update the CloudFormation stack with a new parameter value for the DB instance class.
Why this is correct
Correct: Updating the stack applies the change in a controlled manner.
Related concept
Read the scenario before looking for a memorised answer.
✗
Delete the existing stack and create a new one with the updated instance class.
Why it's wrong here
Wrong: This causes downtime and data loss if no snapshot.
✓
Take a manual snapshot of the RDS instance before making changes.
Why this is correct
Correct: Snapshot provides a backup in case of failure.
Related concept
Read the scenario before looking for a memorised answer.
✓
Enable Multi-AZ on the RDS instance to allow a rolling upgrade.
Why this is correct
Correct: Multi-AZ allows updates to be applied to the standby first.
Related concept
Read the scenario before looking for a memorised answer.
Common exam traps
Common exam trap: answer the scenario, not the keyword
Many certification questions include familiar terms but test a specific constraint. Read the exact wording before choosing an answer that is generally true but wrong for this case.
Detailed technical explanation
How to think about this question
This question should be treated as a scenario, not a definition check. Identify the problem, the constraint and the best action. Then compare each option against those facts.
KKey Concepts to Remember
Read the scenario before looking for a memorised answer.
Find the constraint that changes the correct option.
Eliminate answers that are true in general but not in this case.
Use explanations to understand the rule behind the answer.
TExam Day Tips
→Underline the problem statement mentally.
→Watch for words such as best, first, most likely and least administrative effort.
→Review why wrong options are wrong, not only why the correct option is correct.
Key takeaway
Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option.
Real-world example
How this comes up in practice
A cloud solutions architect for a retail company is evaluating services for a new workload. The correct answer here reflects best practice for the specific scenario described — not a general cloud recommendation. Answer the scenario, not the keyword: identify the specific constraint before choosing the most familiar-sounding option. Cloud exam questions reward reading the constraint carefully: the same technology can be right or wrong depending on the use case.
What to study next
Got this wrong? Here's your next step.
Identify which SOA-C02 exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.
Deployment, Provisioning, and Automation — This question tests Deployment, Provisioning, and Automation — Read the scenario before looking for a memorised answer..
What is the correct answer to this question?
The correct answer is: Update the CloudFormation stack with a new parameter value for the DB instance class. — The correct answers are B, C, and E. Using a snapshot ensures data is backed up (B). Modifying the DB instance class with Multi-AZ enabled allows a rolling update (C). Updating the CloudFormation stack with the new instance class triggers the change (E). Option A is wrong because deleting the stack is not necessary. Option D is wrong because modifying the DB instance directly outside CloudFormation may cause drift.
What should I do if I get this SOA-C02 question wrong?
Identify which SOA-C02 exam domain this question belongs to, then review the specific concept being tested. Practise related questions in that domain and focus on understanding why each wrong answer is tempting — not just why the correct answer is right.
What is the key concept behind this question?
Read the scenario before looking for a memorised answer.
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 →
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 uses AWS CloudFormation to deploy infrastructure. The administrator needs to update a stack that includes an Amazon RDS DB instance. The update requires replacing the DB instance with a new one. What is the most efficient way to achieve this with minimal downtime?
medium
A.Modify the stack template to change the DB instance identifier and update the stack.
B.Use a custom resource to create a new DB instance and delete the old one.
C.Delete the stack and create a new one with the updated DB instance.
✓ D.Use CloudFormation's UpdateReplace policy by modifying a property that requires replacement, such as DBInstanceClass, and take a snapshot before update.
Why D: Option C is correct. Using CloudFormation's UpdateReplace policy with a snapshot creation and then updating the stack with a new DB instance, then updating DNS to point to the new instance, minimizes downtime. Option A would cause downtime during creation. Option B (DeletionPolicy Retain) would not create a new instance. Option D (custom resource) is overly complex.
Variation 2. A company is using AWS CloudFormation to manage its infrastructure. The SysOps administrator wants to update a stack that includes an Amazon RDS database. The administrator needs to modify the DB instance class but wants to avoid downtime. Which TWO options should the administrator consider? (Choose two.)
medium
✓ A.Apply the change during the RDS maintenance window to control when the modification occurs.
✓ B.Deploy the RDS instance as Multi-AZ to allow a failover during the modification.
C.Set the DeletionPolicy attribute to Retain on the RDS instance.
D.Delete the current RDS instance and create a new one with the desired instance class.
E.Take a snapshot of the database and restore it with the new instance class.
Why A: Option A is correct because a Multi-AZ deployment allows modifications with minimal downtime by applying the change to the standby first. Option B is correct because applying the change during a maintenance window can also reduce impact. Option C is wrong because deleting and recreating causes downtime. Option D is wrong because using a snapshot does not help with modifying the instance class. Option E is wrong because setting DeletionPolicy to Retain does not affect updates.
Variation 3. A company uses AWS CloudFormation to manage infrastructure. The administrator wants to update a stack that contains an RDS DB instance. The update requires replacing the DB instance. What should the administrator do to minimize downtime?
easy
A.Delete the stack and create a new one with the updated template
B.Disable deletion protection on the DB instance before the update
C.Modify the DB instance endpoint in the application configuration after update
✓ D.Use a CloudFormation stack update with a Replacement update policy and a snapshot
Why D: Option C is correct because using CloudFormation's update policy with a snapshot and replacement can minimize downtime. Option A is wrong because deletion will cause downtime. Option B is wrong because modifying the endpoint manually is not automated. Option D is wrong because disabling deletion protection is not enough.
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.
This SOA-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 SOA-C02 exam.
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.
Sign in to join the discussion.