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

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

A company has an existing system that uses a single-instance Amazon DocumentDB (with MongoDB compatibility) cluster. Read requests account for 75% of the system queries. Write requests are expected to increase by 50% after an upcoming global release. A database specialist needs to design a solution that improves the overall database performance without creating additional application overhead.

Which solution will meet these requirements?

  • A. Recreate the cluster with a shared cluster volume. Add two instances to serve both read requests and write requests.
  • B. Add one read replica instance. Activate a shared cluster volume. Route all read queries to the read replica instance.
  • C. Add one read replica instance. Set the read preference to secondary preferred.
  • D. Add one read replica instance. Update the application to route all read queries to the read replica instance.
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
MultiAZ
1 year, 6 months ago
Selected Answer: C
C B and D would require application change.
upvoted 1 times
...
roymunson
1 year, 9 months ago
Selected Answer: C
https://aws.amazon.com/blogs/database/building-resilient-applications-with-amazon-documentdb-with-mongodb-compatibility-part-2-exception-handling/#:~:text=Amazon%20DocumentDB%20can%20scale%20reads%20by%20adding%20read,primary%20if%20all%20replicas%20are%20unavailable%20Weitere%20Elemente
upvoted 1 times
...
Pranava_GCP
1 year, 10 months ago
Selected Answer: C
C. Add one read replica instance. Set the read preference to secondary preferred. --- below copy / paste from mongodb web link --- By default, an application directs its read operations to the primary member in a replica set (i.e. read preference mode "primary"). But, clients can specify a read preference to send read operations to secondaries. https://www.mongodb.com/docs/manual/core/read-preference/
upvoted 1 times
...
zanhsieh
1 year, 10 months ago
Selected Answer: C
A: No. DDB uses a shared cluster volume by default. Adding 2 instances without setting which one is primary and read replica won't be most efficient for the load. B: No. DDB uses a shared cluster volume by default, no need to activate. Routing all read queries to a read replicas required application logic change, so No. C: Yes. Setting the read preference to "secondary preferred" means that read operations will be routed to read replicas when they're available. If not, they'll go to the primary. This change doesn't require any changes in the application logic, so it doesn't introduce application overhead. D: No. Required application change for read-write operation. https://docs.aws.amazon.com/documentdb/latest/developerguide/storage.html https://docs.aws.amazon.com/documentdb/latest/developerguide/db-cluster-read-preference.html
upvoted 2 times
...
Monknil
1 year, 11 months ago
Amazon DocumentDB already has a cluster volume where data is shared across instances. So Answer is D. Any thoughts on this ?
upvoted 2 times
...
TQM__9MD
1 year, 12 months ago
Selected Answer: B
In this solution, a read replica instance is added and the shared cluster volume is activated. This allows read queries to be distributed to the read replica instance, improving performance. At the same time, write queries are processed on the primary instance. This architecture scales the processing of read requests and can handle the anticipated increase in write requests. Additionally, since there is no need to modify the application, there is no added overhead. Therefore, solution B fulfills the requirements.
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 ...