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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 3 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 3
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A Database Specialist is troubleshooting an application connection failure on an Amazon Aurora DB cluster with multiple Aurora Replicas that had been running with no issues for the past 2 months. The connection failure lasted for 5 minutes and corrected itself after that. The Database Specialist reviewed the Amazon
RDS events and determined a failover event occurred at that time. The failover process took around 15 seconds to complete.
What is the MOST likely cause of the 5-minute connection outage?

  • A. After a database crash, Aurora needed to replay the redo log from the last database checkpoint
  • B. The client-side application is caching the DNS data and its TTL is set too high
  • C. After failover, the Aurora DB cluster needs time to warm up before accepting client connections
  • D. There were no active Aurora Replicas in the Aurora DB cluster
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by chicagomassageseeker at July 7, 2020, 3:11 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
jnassp1
Highly Voted 3 years, 9 months ago
Answer: B The question indicates failover has already taken place. The TTL is set too high.
upvoted 17 times
LMax
3 years, 8 months ago
Agree, B. TTL.
upvoted 3 times
...
...
58a2d17
Most Recent 1 year, 3 months ago
examtopics.com : please explain your answers C.
upvoted 1 times
...
Pranava_GCP
1 year, 9 months ago
Selected Answer: B
B. The client-side application is caching the DNS data and its TTL is set too high
upvoted 1 times
...
renfdo
2 years, 5 months ago
Selected Answer: B
Answer: B https://aws.amazon.com/premiumsupport/knowledge-center/aurora-mysql-redirected-endpoint-writer/
upvoted 1 times
...
SteveMartin9
2 years, 5 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
SachinGoel
2 years, 5 months ago
Selected Answer: B
B is the answer
upvoted 1 times
...
ftrimmer
2 years, 8 months ago
B is corret
upvoted 1 times
...
sirfans
2 years, 8 months ago
Selected Answer: B
B is the right one.
upvoted 1 times
...
niteshdba
2 years, 9 months ago
B is correct
upvoted 1 times
...
novice_expert
3 years, 2 months ago
Selected Answer: B
B. The client-side application is caching the DNS data and its TTL is set too high If your client application is caching the Domain Name Service (DNS) data of your DB instances, set a time-to-live (TTL) value of less than 30 seconds. Because the underlying IP address of a DB instance can change after a failover, caching the DNS data for an extended time can lead to connection failures if your application tries to connect to an IP address that no longer is in service.
upvoted 2 times
...
RotterDam
3 years, 4 months ago
Got this question in my exam. (i cleared it). B is correct
upvoted 2 times
Zdujgfr567783ff
2 years, 2 months ago
how would you know that? in the result there is passed / not passed and a section %%
upvoted 1 times
...
...
kped21
3 years, 4 months ago
B If your client application is caching the Domain Name Service (DNS) data of your DB instances, set a time-to-live (TTL) value of less than 30 seconds. Because the underlying IP address of a DB instance can change after a failover, caching the DNS data for an extended time can lead to connection failures if your application tries to connect to an IP address that no longer is in service.
upvoted 2 times
...
aws4myself
3 years, 8 months ago
B is the correct answer, cache needs to be set for the lowest possible time.
upvoted 1 times
...
guru_ji
3 years, 8 months ago
B ==>> Correct Answer
upvoted 1 times
...
Dr_Kiko
3 years, 8 months ago
B; in Stephane's course he talks about Aurora-Postgres settings to keep client caching at minimum. Since there were Read Replicas in place, Aurora-side failover is <1 min
upvoted 1 times
...
Dip11
3 years, 8 months ago
Why "Reveal Solution" answer is mostly wrong ? When i come to discussion i see the answers given by others which look correct/logical. Is "Reveal solution" not reliable ?
upvoted 2 times
jove
3 years, 6 months ago
"Reveal solution" is not reliable. Always read the discussion.
upvoted 2 times
...
...
myutran
3 years, 8 months ago
Ans: B
upvoted 1 times
...
Load full discussion...
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