DBS-C01 practice question 21 of 35

A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process. Recently, a change was made…

Full set: 322 questions
A company is developing a new web application. An AWS CloudFormation template was created as a part of the build process. Recently, a change was made to an AWS::RDS::DBInstance resource in the template. The CharacterSetName property was changed to allow the application to process international text. A change set was generated using the new template, which indicated that the existing DB instance should be replaced during an upgrade. What should a database specialist do to prevent data loss during the stack upgrade?
Answer options
A: Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack.
B: Modify the stack policy using the aws cloudformation update-stack command and the set-stack- policy command, then make the DB resource protected.
C: Create a snapshot of the DB instance. Update the stack. Restore the database to a new instance.
D: Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications. Correct answer
Correct Answer:
D. Deactivate any applications that are using the DB instance. Create a snapshot of the DB instance. Modify the template to add the DBSnapshotIdentifier property with the ID of the DB snapshot. Update the stack and reactivate the applications.
Explanation

To preserve your data, perform the following procedure: 1.Deactivate any applications that are using the DB instance so that there's no activity on the DB instance. 2.Create a snapshot of the DB instance. For more information about creating DB snapshots 3.If you want to restore your instance using a DB snapshot, modify the updated template with your DB instance changes and add the DBSnapshotIdentifier property with the ID of the DB snapshot that you want to use 4.Update the stack.
Reference: https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-propertiesrds- database-instance.html

Scroll to Top