exam questions

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam

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 Hide Answer
Suggested Answer: D 🗳️
Reference:
https://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-properties-rds-database-instance.html

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
shantest1
Highly Voted 3 years, 7 months ago
D. appears to be correct based on the URL listed.
upvoted 6 times
...
Doox
Most Recent 1 year, 1 month ago
B :: via stack policy
upvoted 1 times
...
novice_expert
3 years 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, 2 months ago
D seems to the right answer
upvoted 1 times
...
TonyGe
3 years, 6 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, 7 months ago
Correct answer is D
upvoted 1 times
...
Aesthet
3 years, 7 months ago
D final answer
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago