AWS Certified Database – Specialty — Question 323

A company has an AWS CloudFormation stack that defines an Amazon RDS DB instance. The company accidentally deletes the stack and loses recent data from the DB instance. A database specialist must change the CloudFormation template for the RDS resource to reduce the chance of accidental data loss from the DB instance in the future.
Which combination of actions should the database specialist take to meet this requirement? (Choose three.)

Answer options

• A. Set the DeletionProtection property to True.
• B. Set the MultiAZ property to True.
• C. Set the TerminationProtection property to True.
• D. Set the DeleteAutomatedBackups property to False.
• E. Set the DeletionPolicy attribute to No.
• F. Set the DeletionPolicy attribute to Retain.

Correct answer: A, D, F

Explanation

Setting DeletionProtection to True prevents the Amazon RDS DB instance from being deleted accidentally even if the stack deletion is initiated. Configuring DeleteAutomatedBackups to False ensures that the automated backups are preserved even after the DB instance is deleted. Finally, setting the CloudFormation DeletionPolicy attribute to Retain keeps the physical RDS resource intact when the CloudFormation stack is deleted.