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 248 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 248
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A pharmaceutical company's drug search API is using an Amazon Neptune DB cluster. A bulk uploader process automatically updates the information in the database a few times each week. A few weeks ago during a bulk upload, a database specialist noticed that the database started to respond frequently with a
ThrottlingException error. The problem also occurred with subsequent uploads.
The database specialist must create a solution to prevent ThrottlingException errors for the database. The solution must minimize the downtime of the cluster.
Which solution meets these requirements?

A. Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica.
B. Add a read replica to each Availability Zone. Use an instance for the read replica that is the same size as the primary DB instance. Keep the traffic between the API and the database within the Availability Zone.
C. Create a read replica that uses a larger instance size than the primary DB instance. Offload the reads from the primary DB instance.
D. Take the latest backup, and restore it in a DB cluster of a larger size. Point the application to the newly created DB cluster.

Show Suggested Answer

Suggested Answer: A 🗳️

by mbar94 at Sept. 7, 2022, 12:44 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

Pranava_GCP

1 year, 9 months ago

Selected Answer: A

A. Create a read replica that uses a larger instance size than the primary DB instance. Fail over the primary DB instance to the read replica. A. should resolve the error with bulk upload because of promoting the replica to full writer instance with larger instance size.

upvoted 1 times

...

aviathor

2 years ago

Selected Answer: A

The throttling occurs during data upload. Adding read replicas won't solve the problem.

upvoted 3 times

...

Sathish_dbs

2 years, 5 months ago

Selected Answer: A

C is wrong. this is not about read, it is about write. so primary is getting throttled so move to bigger one...

upvoted 3 times

...

lollyj

2 years, 5 months ago

Selected Answer: C

C is correct to me. Why are failing over to another instance as described in A. Does this solve this problem?

upvoted 1 times

lehoang15tuoi

2 years ago

because it's to solve a problem with a "bulk upload", ie with a write not a read. Failing to a read replica means that the read replica is now the main instance

upvoted 1 times

...

khun

2 years, 5 months ago

Selected Answer: C

C is correct. You can achieve read scaling for your Neptune DB cluster by creating up to 15 Neptune replicas in the DB cluster. Each Neptune replica returns the same data from the cluster volume with minimal replica lag (often considerably less than 100 milliseconds after the primary instance has written an update). As your read traffic increases, you can create additional Neptune replicas and connect to them directly to distribute the read load for your DB cluster. Neptune replicas don't have to be of the same DB instance class as the primary instance.

upvoted 1 times

Germaneli

1 year, 8 months ago

But the question is about writing (updating), not reading. Nothing to separate in traffic. Hence, I'd choose A which is the most straightforward way to increase the capacity of the database.

upvoted 1 times

...

Stteve

2 years, 8 months ago

C is correct answer. there is no down-time compare to other options https://docs.aws.amazon.com/neptune/latest/userguide/manage-console-add-replicas.html Neptune replicas connect to the same storage volume as the primary DB instance and support only read operations. Neptune replicas can offload read workloads from the primary DB instance.

upvoted 1 times

...

JeanGat

2 years, 8 months ago

Selected Answer: A

A - Readers do not need to be of the same size. Create a larger sized reader, and failover. Not D. How is backup and recover "no downtime". Dude, you just lost data potentially using last nights backup. https://docs.aws.amazon.com/neptune/latest/userguide/neptune-gdb-disaster-recovery.html#neptune-gdb-managed-failover

upvoted 2 times

...