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

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

Question #: 185
Topic #: 1

[All AWS Certified SysOps Administrator - Associate Questions]

A company plans to deploy a database on an Amazon Aurora MySQL DB cluster. The database will store data for a demonstration environment. The data must be reset on a daily basis.

What is the MOST operationally efficient solution that meets these requirements?

A. Create a manual snapshot of the DB cluster after the data has been populated. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to restore the snapshot and then delete the previous DB cluster.
B. Enable the Backtrack feature during the creation of the DB cluster. Specify a target backtrack window of 48 hours. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to perform a backtrack operation.
C. Export a manual snapshot of the DB cluster to an Amazon S3 bucket after the data has been populated. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to restore the snapshot from Amazon S3.
D. Set the DB cluster backup retention period to 2 days. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to restore the DB cluster to a point in time and then delete the previous DB cluster.

Show Suggested Answer

Suggested Answer: B 🗳️

by Liongeek at Nov. 16, 2022, 10:42 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

r2c3po

1 year, 1 month ago

Selected Answer: B

Option B provides an operationally efficient solution for resetting the data in an Amazon Aurora MySQL DB cluster on a daily basis: B. Enable the Backtrack feature during the creation of the DB cluster. Specify a target backtrack window of 48 hours. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to perform a backtrack operation.

upvoted 1 times

...

Christina666

1 year, 6 months ago

Selected Answer: B

The correct answer is B. Enable the Backtrack feature during the creation of the DB cluster. Specify a target backtrack window of 48 hours. Create an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis. Configure the function to perform a backtrack operation. Enabling the Backtrack feature in Amazon Aurora MySQL allows you to rewind the database cluster to a specific point in time without the need for manual snapshots. This feature is specifically designed for scenarios where you want to reset the data to a previous state, such as in a demonstration environment. By specifying a target backtrack window of 48 hours, you ensure that you have the ability to backtrack to a recent state.

upvoted 3 times

Christina666

1 year, 6 months ago

Using an Amazon EventBridge (Amazon CloudWatch Events) rule to invoke an AWS Lambda function on a daily basis provides an automated and scheduled approach to resetting the data. The Lambda function can then perform the backtrack operation, making the process operationally efficient and requiring minimal manual intervention.

upvoted 2 times

...

Deeezz

2 years ago

The question says " The data must be reset on a daily basis." How can B be the answer when it states "Specify a target backtrack window of 48 hours.". When did daily become 48 hours? is that a typo?

upvoted 2 times

Grodgar

7 months, 4 weeks ago

MOST operationally optimal solution... A and C out (because manual never optimal.) D is not remembering the beginning state of the cluster. Only B left

upvoted 2 times

...

joanneli77

2 years ago

You can backtrack to any point in the last 48 hours, but will backtrack 24 hours. The extra day is arguable margin. (Actual Backtrack vs Target Backtrack)

upvoted 5 times

...