Question 1easymultiple choice
Full question →Question 142 of 315
easymultiple choiceObjective-mapped
SOA-C02 Practice Question: RDS automated backups and the retention period…
This SOA-C02 practice question tests your understanding of rds automated backups and the retention period…. Read the scenario carefully and evaluate each option against the stated constraints before committing to an answer. A key principle to apply: rDS automated backups. 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 production RDS MySQL database stores financial records. The team needs the ability to restore the database to any point within the last 7 days in case of accidental data deletion. Automated backups are currently disabled. What must be configured?
Answer choices
Why each option matters
Good practice is not just finding the correct option. The wrong answers often show the exact trap the exam wants you to fall into.
A
Distractor review
Enable RDS read replicas and promote one if data deletion occurs
Read replicas use asynchronous replication. An accidental DELETE on the primary replicates to all read replicas within seconds. Promoting a replica after the deletion gives you the deleted state, not the pre-deletion state. Read replicas are for read scaling, not PITR.
B
Distractor review
Create a manual DB snapshot every night using the AWS CLI on a schedule
Manual snapshots can restore to the exact moment the snapshot was taken, but they cannot support point-in-time recovery to an arbitrary second between snapshots. Without automated backups, transaction logs are not retained, so restoring to the moment just before an accidental deletion is not possible.
C
Distractor review
Enable Multi-AZ to maintain a synchronous standby replica in a second Availability Zone
Multi-AZ provides high availability by failing over to a synchronous standby if the primary fails. The standby replica mirrors all writes including accidental deletes — it does not enable point-in-time recovery. Multi-AZ is for HA, not for PITR.
D
Best answer
Enable automated backups and set the backup retention period to 7 days
Automated backups with a 7-day retention period keep daily snapshots and transaction logs for 7 days. Any point within the retention window is recoverable. Transaction logs allow recovery to any 5-minute interval within that window. Setting the period to 0 disables automated backups and PITR entirely.
Common exam trap
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.
Technical deep dive
How to think about this question
Treat this as a scenario question. Identify the problem, the constraint, and the best action. Then compare each option against those facts.
KKey Concepts to Remember
- RDS automated backups
- point-in-time recovery
- backup retention period
- transaction logs
TExam Day Tips
- 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
RDS automated backups
Related practice questions
Related SOA-C02 practice-question pages
Use these pages to review the topic behind this question. This is how one missed question becomes focused revision.
More questions from this exam
Keep practising from the same exam bank, or move into a focused topic page if this question exposed a weak area.
Question 1
A company uses Amazon CloudFront to deliver content to a global audience. The origin is an Application Load Balancer in us-east-1. The SysOps administrator wants to reduce costs by minimizing the number of requests that reach the origin server. Which action should the administrator take?
Question 2
A company runs a batch processing application on Amazon EC2 that runs for 2 hours every night. The workload can tolerate interruptions. Which EC2 purchasing option provides the lowest cost for this use case?
Question 3
A SysOps administrator needs to monitor the CPU utilization of an Amazon RDS DB instance and receive an alarm when CPU utilization exceeds 80% for 5 consecutive minutes. Which AWS service should be used to create this alarm?
Question 4
A company runs a critical web application on Amazon EC2 instances in an Auto Scaling group behind an Application Load Balancer (ALB). The application uses session stickiness (sticky sessions) to maintain user sessions. The SysOps administrator notices that when instances are replaced during a scale-in or failure event, users lose their session data. The administrator needs to preserve session data across instance failures without losing stickiness benefits. What should the administrator do?
Question 5
A company runs a production web application on a single Amazon EC2 instance. The application experiences a predictable and steady workload 24/7. The SysOps administrator wants to minimize compute costs for this instance while ensuring it remains available during the expected workload. Which EC2 purchasing option should the administrator use?
Question 6
A company has a VPC with public and private subnets. The private subnets host application servers that need to make outbound HTTPS connections to the internet. The SysOps administrator must implement a solution that provides outbound internet connectivity while preventing inbound connections from the internet. Additionally, the solution must allow the company to control which domains the application servers can access. Which solution should the administrator implement?
Practice this exam
Start a free SOA-C02 practice session
Short sessions build daily habit. Longer sessions build exam-day stamina. Try a timed session to simulate real conditions.
FAQ
Questions learners often ask
What does this SOA-C02 question test?
RDS automated backups
What is the correct answer to this question?
The correct answer is: Enable automated backups and set the backup retention period to 7 days — RDS automated backups enable point-in-time recovery (PITR). When enabled, RDS takes a daily snapshot and continuously uploads transaction logs to S3. A PITR restore recreates the database instance from the snapshot nearest to the target time, then replays transaction logs to recover to the exact second. To cover 7 days, the backup retention period must be set to 7 or more days (maximum 35). Restoring from an automated backup creates a new DB instance — it does not overwrite the existing one.
What should I do if I get this SOA-C02 question wrong?
Review rDS automated backups, then practise related SOA-C02 questions on the same topic to reinforce the concept.
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 →
Discussion
Loading comments…
Sign in to join the discussion.
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.