Exam AWS Certified Database - Specialty topic 1 question 121 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 121
Topic #: 1

[All AWS Certified Database - Specialty 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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️
Reference:
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html

by shantest1 at April 8, 2021, 2:54 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

shantest1

Highly Voted 3 years, 9 months ago

D. appears to be correct based on the URL listed.

upvoted 6 times

...

Doox

Most Recent 1 year, 3 months ago

B :: via stack policy

upvoted 1 times

...

novice_expert

3 years, 2 months ago

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

upvoted 2 times

...

RotterDam

3 years, 4 months ago

D seems to the right answer

upvoted 1 times

...

TonyGe

3 years, 8 months ago

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

upvoted 3 times

...

Hits_23

3 years, 8 months ago

Correct answer is D

upvoted 1 times

...

Aesthet

3 years, 8 months ago

D final answer

upvoted 2 times

...