AWS Certified Database – Specialty — Question 232

A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.

Which solution will meet these requirements in the MOST operationally efficient way?

Answer options

• A. Create a manual copy of the snapshot.
• B. Export the contents of the snapshot to an Amazon S3 bucket.
• C. Change the retention period of the snapshot to 45 days.
• D. Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.

Correct answer: A

Explanation

Creating a manual copy of the snapshot is the most efficient method to retain it beyond the standard retention limit set by Amazon RDS. The other options either do not extend the retention of the automated snapshot or involve additional steps that may complicate the process.