Exam AWS Certified DevOps Engineer - Professional DOP-C02 All Questions

View all questions & answers for the AWS Certified DevOps Engineer - Professional DOP-C02 exam

Exam AWS Certified DevOps Engineer - Professional DOP-C02 topic 1 question 44 discussion

Exam question from Amazon's AWS Certified DevOps Engineer - Professional DOP-C02

Question #: 44
Topic #: 1

[All AWS Certified DevOps Engineer - Professional DOP-C02 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 invoke an AWS Lambda function that will promote the replica instance as the primary.
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 CloudFormation 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 invoke this Lambda function after the failure event occurs.
D. Store the Aurora endpoint in AWS Systems Manager Parameter Store. Create an Amazon EventBridge event that detects 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

Suggested Answer: D 🗳️

by alce2020 at April 15, 2023, 6:31 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

haazybanj

Highly Voted 2 years, 1 month ago

Selected Answer: D

D is the correct answer. Explanation: To automate the promotion of a read replica to the primary instance in the event of a failure, we need to detect the failure and then invoke an AWS Lambda function to promote the replica instance. This can be achieved using Amazon EventBridge. Option A is incorrect because using a CNAME with health checks doesn't provide an automated way to promote the read replica. Additionally, subscribing an Amazon SNS topic to Amazon RDS failure notifications from AWS CloudTrail doesn't help to promote the replica. Option B is incorrect because a custom endpoint is not required to promote the read replica. Additionally, using AWS CloudTrail to run an AWS Lambda function to promote the replica instance doesn't provide an automated way to update the application endpoint to point to the newly promoted instance.

upvoted 8 times

...

nlw

Highly Voted 1 year, 8 months ago

doesnt failover happen automatically in aurora?

upvoted 7 times

VrilianVirgil

1 year, 4 months ago

Aurora supports automated failover for a single cluster. [Be it a global Aurora cluster or a multi AZ/region deployment] In this case it's implied that the read-replica is not part of the cluster. that's my best guess.

upvoted 2 times

...

GripZA

Most Recent 2 months, 1 week ago

Selected Answer: D

eventbridge detects failure events from RDS. It triggers a almbda function to: Promote the cross-region read replica. Update the endpoint in parameter store. the app is designed to reload the DB endpoint from parameter store if it detects a connection issues this supports automated failover with minimal downtime and makes the endpoint configurable rather than hardcoded

upvoted 1 times

...

jamesf

11 months, 1 week ago

Selected Answer: D

D is correct. Option B is wrong as AWS CloudTrail to run an AWS Lambda function to promote the replica instance doesn't provide an automated way.

upvoted 1 times

jamesf

11 months ago

Option B is wrong also due to: - Custom Endpoint Management: Extra complexity in managing and updating endpoints dynamically. - Lag in Promotion: Possible delays due to CloudTrail event delivery and Lambda invocation. - Reliance on CloudTrail: Lag in event processing can cause potential downtime or data inconsistency.

upvoted 1 times

...

hkh2

11 months, 3 weeks ago

Correct answer is B Here is why. Previously, you might have used the CNAMES mechanism to set up Domain Name Service (DNS) aliases from your own domain to achieve similar results. By using custom endpoints, you can avoid updating CNAME records when your cluster grows or shrinks. Custom endpoints also mean that you can use encrypted Transport Layer Security/Secure Sockets Layer (TLS/SSL) connections. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Endpoints.Custom

upvoted 1 times

...

thanhnv142

1 year, 5 months ago

A is correct: Using Amazon Route 53 CNAME with health checks is the way for failover recommended by AWS: https://aws.amazon.com/blogs/database/cross-region-disaster-recovery-using-amazon-aurora-global-database-for-amazon-aurora-postgresql/

upvoted 1 times

...

Ffida

1 year, 9 months ago

option D is not either providing seemless solution, in option D application needed to be reload and that will cause downtime.

upvoted 1 times

...

madperro

2 years ago

Selected Answer: D

D make most sense.

upvoted 2 times

...

haazybanj

2 years, 1 month ago

Selected Answer: D

Option D is the correct solution Option C is incorrect because modifying the AWS CloudFormation template requires manual intervention and cannot be automated. Additionally, creating an Amazon CloudWatch alarm to invoke the Lambda function after the failure event occurs doesn't provide an automated way to promote the replica instance. Therefore, Option D is the correct solution.

upvoted 3 times

...