DBS-C01 Monitoring and Troubleshooting Practice Question
A developer executed a DELETE statement without a WHERE clause on an Amazon RDS for PostgreSQL instance. The transaction is still open. Which action should the developer take to undo the DELETE without affecting other operations?
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
✓
Execute ROLLBACK in the same session.
The correct action is to execute ROLLBACK in the same session. Since the transaction is still open, issuing ROLLBACK will undo the DELETE statement without affecting other operations. Option A is incorrect because COMMIT would make the DELETE permanent. Option B is incorrect because Point-in-Time Recovery restores the entire DB instance to a past state, which is unnecessary and affects other data. Option D is incorrect because stopping and restoring from a snapshot would also affect other data and is not the simplest solution.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
Execute COMMIT and then run a recovery script.
Why it's wrong here
COMMIT would finalize the DELETE, and recovery would be needed.
- ✗
Use the Point-in-Time Recovery feature to restore the database to a time before the DELETE.
Why it's wrong here
This is a more drastic measure and unnecessary if the transaction is still open.
- ✓
Execute ROLLBACK in the same session.
Why this is correct
ROLLBACK undoes all changes made in the current transaction.
- ✗
Stop the DB instance and restore from the latest snapshot.
Why it's wrong here
This is overly aggressive and would cause downtime.
Go deeper
Related to this question
About these practice questions
One of 1,663 original DBS-C01 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
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.