DBS-C01 Question #232: Real Exam Question with Answer & Explanation

Question

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.)

Options

• ASet the DeletionProtection property to True.
• BSet the MultiAZ property to True.
• CSet the TerminationProtection property to True.
• DSet the DeleteAutomatedBackups property to False.
• ESet the DeletionPolicy attribute to No.
• FSet the DeletionPolicy attribute to Retain.

Explanation

To prevent accidental data loss from an Amazon RDS DB instance when its AWS CloudFormation stack is deleted, configure the CloudFormation template to set DeletionProtection to True for the RDS resource, set DeleteAutomatedBackups to False, and apply the DeletionPolicy: Retain attribute to the resource.

Common mistakes.

• B. Setting the MultiAZ property to True provides high availability within a region but does not prevent the entire DB instance from being deleted if the CloudFormation stack is removed.
• C. The TerminationProtection property is used for Amazon EC2 instances, not for Amazon RDS DB instances.
• E. The value No is not a valid DeletionPolicy attribute for AWS CloudFormation resources; valid options are Delete, Retain, or Snapshot.

Concept tested. CloudFormation RDS deletion protection and backup retention

Reference. https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-attribute-deletionpolicy.html

No community discussion yet for this question.