DBS-C01 · Question #55
DBS-C01 Question #55: Real Exam Question with Answer & Explanation
Sign in or unlock DBS-C01 to reveal the answer and full explanation for question #55. The question stem and answer options stay visible for context.
Question
The Development team recently executed a database script containing several data definition language (DDL) and data manipulation language (DML) statements on an Amazon Aurora MySQL DB cluster. The release accidentally deleted thousands of rows from an important table and broke some application functionality. This was discovered 4 hours after the release. Upon investigation, a Database Specialist tracked the issue to a DELETE command in the script with an incorrect WHERE clause filtering the wrong set of rows. The Aurora DB cluster has Backtrack enabled with an 8-hour backtrack window. The Database Administrator also took a manual snapshot of the DB cluster before the release started. The database needs to be returned to the correct state as quickly as possible to resume full application functionality. Data loss must be minimal. How can the Database Specialist accomplish this?
Options
- AQuickly rewind the DB cluster to a point in time before the release using Backtrack.
- BPerform a point-in-time recovery (PITR) of the DB cluster to a time before the release and copy
- CRestore the DB cluster using the manual backup snapshot created before the release and change
- DCreate a clone of the DB cluster with Backtrack enabled. Rewind the cloned cluster to a point in
Unlock DBS-C01 to see the answer
You've previewed enough free DBS-C01 questions. Unlock DBS-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.