ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 311 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 311
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A database administrator needs to save a particular automated database snapshot from an Amazon RDS for Microsoft SQL Server DB instance for longer than the maximum number of days.

Which solution will meet these requirements in the MOST operationally efficient way?

  • A. Create a manual copy of the snapshot.
  • B. Export the contents of the snapshot to an Amazon S3 bucket.
  • C. Change the retention period of the snapshot to 45 days.
  • D. Create a native SQL Server backup. Save the backup to an Amazon S3 bucket.
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
by TQM__9MD at July 14, 2023, 12:56 a.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

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
Submit Cancel
Ashy1313
1 year, 7 months ago
Selected Answer: D
most operationally efficient solution for saving a particular automated database snapshot for longer than the maximum retention period. not A since it will take more time and additional resources.
upvoted 1 times
...
Sathish_dbs
1 year, 9 months ago
Selected Answer: A
operationally efficient = manual snapshot, that's it , no additional procedures or moving to S3 needed.
upvoted 2 times
...
DrCloud
1 year, 10 months ago
Selected Answer: A
Ans: A https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_CopySnapshot.html Copying the automated backup - To retain a particular automated snapshot for longer than 35 days, you can copy the snapshot. - The copy is stored as a manual snapshot. - You can retain this manual snapshot for as long as you need. - Unlike automated backups, manual snapshots aren't subject to the backup retention period. - Manual snapshots don't expire.
upvoted 2 times
...
zanhsieh
1 year, 11 months ago
Selected Answer: A
A. Manual snapshots can be retained indefinitely, allowing you to keep the snapshot for as long as you need. Same apply to MS SQL Server RDS.
upvoted 3 times
...
hecong
1 year, 11 months ago
Selected Answer: A
A. Create a manual copy of the snapshot. Manual snapshots can be retained indefinitely, allowing you to keep the snapshot for as long as you need.
upvoted 3 times
...
Monknil
2 years ago
Not sure on this one, but looks like D maybe.
upvoted 1 times
...
rn30
2 years ago
B https://repost.aws/knowledge-center/rds-automated-snapshot-retain-longer
upvoted 1 times
Windy
2 years ago
Per the link you provided above, the answer should be A. "To retain a particular automated snapshot for longer than 35 days, you can copy the snapshot. ".
upvoted 1 times
...
...
Windy
2 years ago
I think it is A.
upvoted 2 times
...
TQM__9MD
2 years ago
Selected Answer: D
D is answer https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html
upvoted 1 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