exam questions

Exam AWS Certified Database - Specialty All Questions

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

Exam AWS Certified Database - Specialty topic 1 question 22 discussion

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

A Database Specialist is setting up a new Amazon Aurora DB cluster with one primary instance and three Aurora Replicas for a highly intensive, business-critical application. The Aurora DB cluster has one medium-sized primary instance, one large-sized replica, and two medium sized replicas. The Database Specialist did not assign a promotion tier to the replicas.
In the event of a primary failure, what will occur?

  • A. Aurora will promote an Aurora Replica that is of the same size as the primary instance
  • B. Aurora will promote an arbitrary Aurora Replica
  • C. Aurora will promote the largest-sized Aurora Replica
  • D. Aurora will not promote an Aurora Replica
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️

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
pan24
Highly Voted 3 years, 9 months ago
ANS: C Priority: If you don't select a value, the default is tier-1. This priority determines the order in which Aurora https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Backups.html#Aurora.Managing.FaultTolerance
upvoted 17 times
...
dougporto1988
Most Recent 2 years ago
C: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier.
upvoted 1 times
...
f___16
2 years, 3 months ago
Selected Answer: C
1. Highest priority will be promoted. 2. Largest size will be promoted. 3. Random replica will be promoted. Since they are the same priority, it will go to (2) Largest size will be promoted. If all replicas were the same size, a random replica will be promoted.
upvoted 3 times
sguinales
1 year, 7 months ago
but he trick here is: The larger instances are reserved for specialized kinds of reporting queries. To make it unlikely for them to be promoted to the primary instance, the following example changes their promotion tier to the lowest priority.
upvoted 1 times
...
...
novice_expert
3 years, 1 month ago
Selected Answer: C
default tier = -1 More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size.
upvoted 3 times
...
kret
3 years, 2 months ago
Selected Answer: C
C "If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier."
upvoted 2 times
...
jnassp1
3 years, 7 months ago
C If two replicas have the same priority, then the replica that is largest in size gets promoted
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Correct Answer ==>> C
upvoted 1 times
...
guru_ji
3 years, 7 months ago
Correct Answer ==>> C
upvoted 1 times
...
LMax
3 years, 8 months ago
Answer C
upvoted 2 times
...
myutran
3 years, 8 months ago
Ans: C
upvoted 1 times
...
Exia
3 years, 8 months ago
C. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html
upvoted 4 times
...
JobinAkaJoe
3 years, 8 months ago
C is the right choice. Since all replicas have same default priority the largest among them will be considered for failover.
upvoted 2 times
...
Billhardy
3 years, 8 months ago
Since priority isn't assigned, aurora will promote the largest sized replica.
upvoted 1 times
...
Ashoks
3 years, 8 months ago
Ans is C
upvoted 1 times
...
Manmohan
3 years, 8 months ago
Answer: C, If you don't have priority, Aurora will pick the biggest size by default
upvoted 2 times
...
Rahu
3 years, 8 months ago
C is right!
upvoted 4 times
...
BillyMadison
3 years, 9 months ago
https://aws.amazon.com/blogs/aws/additional-failover-control-for-amazon-aurora/ A "In the event of a failover, Amazon RDS will promote the read replica that has the highest priority (the lowest numbered tier). If two or more replicas have the same priority, RDS will promote the one that is the same size as the previous primary instance."
upvoted 2 times
BillyMadison
3 years, 8 months ago
Switching to C. AWS has made this question way to hard as their own documentation isn't consistent with their priority levels. I'm going with largest first priority due to https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-ug.pdf More than one Aurora Replica can share the same priority, resulting in promotion tiers. If two or more Aurora Replicas share the same priority, then Amazon RDS promotes the replica that is largest in size. If two or more Aurora Replicas share the same priority and size, then Amazon RDS promotes an arbitrary replica in the same promotion tier."
upvoted 12 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 ...