AWS Certified Database – Specialty — Question 80

A company has a 20 TB production Amazon Aurora DB cluster. The company runs a large batch job overnight to load data into the Aurora DB cluster. To ensure the company's development team has the most up-to-date data for testing, a copy of the DB cluster must be available in the shortest possible time after the batch job completes.
How should this be accomplished?

Answer options

• A. Use the AWS CLI to schedule a manual snapshot of the DB cluster. Restore the snapshot to a new DB cluster using the AWS CLI.
• B. Create a dump file from the DB cluster. Load the dump file into a new DB cluster.
• C. Schedule a job to create a clone of the DB cluster at the end of the overnight batch process.
• D. Set up a new daily AWS DMS task that will use cloning and change data capture (CDC) on the DB cluster to copy the data to a new DB cluster. Set up a time for the AWS DMS stream to stop when the new cluster is current.

Correct answer: C

Explanation

The correct answer is C, as creating a clone of the DB cluster immediately after the batch job ensures that the development team has access to the most current data without the delays associated with snapshots or dump file imports. Options A and B involve longer processes that are less efficient for this use case, while option D introduces unnecessary complexity with AWS DMS, which is not needed for a simple cloning task.