exam questions

Exam AWS DevOps Engineer Professional All Questions

View all questions & answers for the AWS DevOps Engineer Professional exam

Exam AWS DevOps Engineer Professional topic 1 question 27 discussion

Exam question from Amazon's AWS DevOps Engineer Professional
Question #: 27
Topic #: 1
[All AWS DevOps Engineer Professional Questions]

A company has an application that is using a MySQL-compatible Amazon Aurora Multi-AZ DB cluster as the database. A cross-Region read replica has been created for disaster recovery purposes. A DevOps engineer wants to automate the promotion of the replica so it becomes the primary database instance in the event of a failure.
Which solution will accomplish this?

  • A. Configure a latency-based Amazon Route 53 CNAME with health checks so it points to both the primary and replica endpoints. Subscribe an Amazon SNS topic to Amazon RDS failure notifications from AWS CloudTrail and use that topic to trigger an AWS Lambda function that will promote the replica instance as the master.
  • B. Create an Aurora custom endpoint to point to the primary database instance. Configure the application to use this endpoint. Configure AWS CloudTrail to run an AWS Lambda function to promote the replica instance and modify the custom endpoint to point to the newly promoted instance.
  • C. Create an AWS Lambda function to modify the application's AWS Cloud Formation template to promote the replica, apply the template to update the stack, and point the application to the newly promoted instance. Create an Amazon CloudWatch alarm to trigger this Lambda function after the failure event occurs.
  • D. Store the Aurora endpoint in AWS Systems Manager Parameter Store. Create an Amazon EventBridge (Amazon CloudWatch Events) event that defects the database failure and runs an AWS Lambda function to promote the replica instance and update the endpoint URL stored in AWS Systems Manager Parameter Store. Code the application to reload the endpoint from Parameter Store if a database connection fails.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️

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
1234567J
Highly Voted 3 years, 3 months ago
ans: D
upvoted 15 times
...
sb333
Highly Voted 3 years, 3 months ago
The answer is D. EventBridge is needed to detect the database failure. Lambda is needed to promote the replica as it's in another Region (manual promotion, otherwise). Storing and updating the endpoint in Parameter store is important in updating the application. Look at High Availability section of Aurora FAQ: https://aws.amazon.com/rds/aurora/faqs/
upvoted 13 times
...
DevOpsJagadGuru
Most Recent 1 year, 10 months ago
Option D is the correct solution because it uses AWS Systems Manager Parameter Store to store the Aurora endpoint and Amazon EventBridge (Amazon CloudWatch Events) to detect database failures. It runs an AWS Lambda function to promote the read replica and update the endpoint URL stored in Parameter Store, which can be reloaded by the application if a database connection fails.
upvoted 1 times
...
Murimi
1 year, 10 months ago
Selected Answer: D
Correct Answer is D by method of elimination and either way, parameter store can be used to store configuration. Cloudtrail is not applicable to this question
upvoted 2 times
...
Piccaso
1 year, 10 months ago
Selected Answer: B
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Endpoint.Tutorial
upvoted 1 times
vn_thanhtung
7 months, 3 weeks ago
Configure AWS CloudTrail to run an AWS Lambda function. Are you sure ? I don't think so. D is correct answer
upvoted 1 times
...
Piccaso
1 year, 10 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Overview.Endpoints.HA
upvoted 1 times
Piccaso
1 year, 10 months ago
https://docs.aws.amazon.com/lambda/latest/dg/with-cloudtrail.html
upvoted 1 times
...
...
...
Piccaso
1 year, 10 months ago
Selected Answer: A
A looks most automatical.
upvoted 1 times
Piccaso
1 year, 10 months ago
I think A is wrong. As "fartosh 2" said, CloudTrail does not help to detect failures of database. Same reason to exclude B. Do you guys know why B is shown as "Correct Answer" ?
upvoted 2 times
Piccaso
1 year, 10 months ago
CloudTrail can do the job https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/logging-using-cloudtrail.html
upvoted 1 times
acloudguru
1 year, 7 months ago
no, it can't detect failure only API calls
upvoted 1 times
...
...
...
...
Bulti
1 year, 11 months ago
D is the right answer. We need CloudWatch events to detect errors from the Aurora CloudWatch logs and then invoke a Lambda function to promote the Read Replica in another region. The Lambda can run in the primary region and update the Parameter store in the Primary region with the newly promoted cluster address.
upvoted 2 times
...
apcloud
2 years ago
This one is hard to understand, but my bust understanding is: A and b are wrong because they use cloud trail, you would want event bridge or cloud watch events or something else. C is wrong because it’s using lambda to update cloud formation template when you really need to be adjusting the infra in real time not waiting on cloud formation. Knowing that D is the only possible choice that makes sense
upvoted 3 times
...
Arkarter
2 years ago
Selected Answer: A
I think choice D not right REF : https://aws.amazon.com/blogs/architecture/implementing-multi-region-disaster-recovery-using-event-driven-architecture/ -> Parameter Store is hosted in multiple Availability Zones in an AWS Region -> I go with choice A from this link below. https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-using-amazon-aurora-global-database-for-amazon-aurora-postgresql/
upvoted 1 times
apcloud
2 years ago
A talks about RDS, the question is about aurora
upvoted 2 times
Piccaso
1 year, 10 months ago
Aurora is a managed RDS
upvoted 1 times
...
...
...
saeidp
2 years ago
I'll go with D
upvoted 1 times
...
Nickhiahiahia
2 years ago
So why B is wrong?
upvoted 1 times
Piccaso
1 year, 10 months ago
I think B is correct. It uses Aurora endpoint neatly https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Endpoint.Tutorial
upvoted 1 times
...
...
alinato
2 years, 1 month ago
Selected Answer: A
A: Route 53 is the only one which does not go down in case of region going down. D is incorrect because Parameter Store goes down together with region.
upvoted 2 times
fartosh
1 year, 11 months ago
But answer A uses CloudTrail which cannot detect failures of the database. Thus, this cannot be correct.
upvoted 1 times
Piccaso
1 year, 10 months ago
CloudTrail can do the job.
upvoted 1 times
Piccaso
1 year, 10 months ago
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/logging-using-cloudtrail.html
upvoted 1 times
...
...
...
...
MikeyJ
2 years, 3 months ago
For each of these databases, we store all configuration information in AWS Systems Manager Parameter Store, so the failover process can get all the information it needs to carry out the failover steps. We have created a lambda which breaks down the entire failover process into two steps. Step 1 promotes the replica database to be read write, and Step 2 re-establishes resiliency by creating a new replica in the original primary region. https://developer.gs.com/blog/posts/building-multi-region-resiliency-with-amazon-rds-and-amazon-aurora
upvoted 3 times
...
friendofpenguin
2 years, 8 months ago
Selected Answer: D
D - always choose decoupling options for endpoints, urls, passwords etc.
upvoted 4 times
...
jj22222
2 years, 8 months ago
Selected Answer: D
D looks right
upvoted 1 times
...
dzenadcu
2 years, 9 months ago
Correct Answer: D Applicatino can be coded to load endpoint value from AWS Parameter Store. Once the value is changed in the param store, the application can use the new value. Just need a reload. Wrong answer is B, because Cloudtrail is for static content and media stream caching. But not for DB content.
upvoted 2 times
...
szl0144
3 years ago
answer is D
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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago