Amazon Exam DBS-C01 Topic 6 Question 1 Discussion

Actual exam question for Amazon's DBS-C01 exam

Question #: 1
Topic #: 6

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?

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 the deleted rows from the restored database to the original database.

CRestore the DB cluster using the manual backup snapshot created before the release and change the

DCreate a clone of the DB cluster with Backtrack enabled. Rewind the cloned cluster to a point in time

Show Suggested Answer

Suggested Answer: D

by Vallie at May 10, 2022, 01:23 AM

Limited Time Offer

25%

Off

Get Premium DBS-C01 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!