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

Exam AWS Certified SysOps Administrator - Associate All Questions

View all questions & answers for the AWS Certified SysOps Administrator - Associate exam
Go to Exam

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 Hide 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

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
r2c3po
10 months 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, 3 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, 3 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
1 year, 9 months 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
4 months, 1 week 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 1 times
...
joanneli77
1 year, 8 months 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
...
...
michaldavid
1 year, 10 months ago
Selected Answer: B
bbbbbbb
upvoted 2 times
...
tyfta6
1 year, 10 months ago
Selected Answer: B
Vote for B
upvoted 1 times
...
Liongeek
1 year, 11 months ago
Ans: B Ref: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.Managing.Backtrack.html
upvoted 3 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago