Exam AWS Certified Database - Specialty topic 1 question 185 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 185
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A database specialist is designing an application to answer one-time queries. The application will query complex customer data and provide reports to end users.
These reports can include many fields. The database specialist wants to give users the ability to query the database by using any of the provided fields.
The database's traffic volume will be high but variable during peak times. However, the database will not have much traffic at other times during the day.
Which solution will meet these requirements MOST cost-effectively?

A. Amazon DynamoDB with provisioned capacity mode and auto scaling
B. Amazon DynamoDB with on-demand capacity mode
C. Amazon Aurora with auto scaling enabled
D. Amazon Aurora in a serverless mode

Show Suggested Answer

Suggested Answer: D 🗳️

by leunamE at Nov. 15, 2021, 10:45 a.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

Justu

Highly Voted 3 years, 6 months ago

Hard question. As "database specialist want to enable users to query the database using any of the fields offered" I think DynamoDB is out of the question. So it leave C and D. As max load is not known in the peak hours, (variables), then then D is the only option. In C, with autoscaling, you would need to define min and max ACUs for the autoscaling.

upvoted 11 times

lollyj

2 years, 5 months ago

DynamoDB out of question? I thought it would qualigy because GSIs are predetermined and flexible. I'm confused....

upvoted 1 times

...

RotterDam

Highly Voted 3 years, 3 months ago

Guys - I see this constant confusion about when to use On Demand vs Provisioned w/ Autoscaling. There's a HUGE HUGE difference in cost when it comes to On Demand especially for large applications (typically AWS asks about large applications). It can be SEVEN times higher. Autoscaling can adjust to almost negligible capacity during off peak hours to large capacity during peak . Usually the winner here is autoscaling with Provisioned!! While on-demand delivers the best fit for scalability, the cost is approximately seven times higher than provisioned capacity. In addition, provisioned capacity offers the option to purchase reserved capacity, which can save between 40% and 80% compared to non-reserved provisioned capacity. This means on-demand could cost between 15 times and 20 times more than reserved provisioned capacity for some configurations. For small applications, the flexibility of on-demand may be worth the extra cost, but for large applications, it can mean spending hundreds or thousands of dollars more per month

upvoted 5 times

...

Pranava_GCP

Most Recent 1 year, 9 months ago

Selected Answer: D

D. Amazon Aurora in a serverless mode

upvoted 1 times

...

Dantas

3 years ago

Selected Answer: D

Large amounts of client data would require large amounts of RCUs. Query the database using any of the fields offered ins't a good match for key/value storage.

upvoted 1 times

...