Exam AWS Certified SysOps Administrator - Associate topic 1 question 29 discussion

Exam question from Amazon's AWS Certified SysOps Administrator - Associate

Question #: 29
Topic #: 1

[All AWS Certified SysOps Administrator - Associate Questions]

A company is using an Amazon Aurora MySQL DB cluster that has point-in-time recovery, backtracking, and automatic backup enabled. A SysOps administrator needs to be able to roll back the DB cluster to a specific recovery point within the previous 72 hours. Restores must be completed in the same production DB cluster.
Which solution will meet these requirements?

A. Create an Aurora Replica. Promote the replica to replace the primary DB instance.
B. Create an AWS Lambda function to restore an automatic backup to the existing DB cluster.
C. Use backtracking to rewind the existing DB cluster to the desired recovery point.
D. Use point-in-time recovery to restore the existing DB cluster to the desired recovery point.

Show Suggested Answer

Suggested Answer: C 🗳️

by dontcomplain at April 22, 2022, 10:19 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

Submit Cancel

221898

Highly Voted 1 year, 8 months ago

Selected Answer: C

C - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html

upvoted 9 times

...

Finger41

Highly Voted 1 year, 8 months ago

Selected Answer: C

C - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html

upvoted 6 times

...

MrMLB

Most Recent 1 year, 2 months ago

C for the win

upvoted 1 times

...

vjt

1 year, 9 months ago

it is D. it is PITR and not backtracking. also Restored DB clusters are automatically associated with the default DB cluster and DB parameter groups. Please clarify why C is suggested by people here?

upvoted 1 times

vjt

1 year, 9 months ago

it is C. PITR will create a new DB cluster. however i am still confused with below aws info. "You can restore a DB cluster to a specific point in time, creating a new DB cluster. When you restore a DB cluster to a point in time, you can choose the default virtual private cloud (VPC) security group. Or you can apply a custom VPC security group to your DB cluster. Restored DB clusters are automatically associated with the default DB cluster and DB parameter groups."

upvoted 4 times

...