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

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 93
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A software development company is using Amazon Aurora MySQL DB clusters for several use cases, including development and reporting. These use cases place unpredictable and varying demands on the Aurora DB clusters, and can cause momentary spikes in latency. System users run ad-hoc queries sporadically throughout the week. Cost is a primary concern for the company, and a solution that does not require significant rework is needed.
Which solution meets these requirements?

A. Create new Aurora Serverless DB clusters for development and reporting, then migrate to these new DB clusters.
B. Upgrade one of the DB clusters to a larger size, and consolidate development and reporting activities on this larger DB cluster.
C. Use existing DB clusters and stop/start the databases on a routine basis using scheduling tools.
D. Change the DB clusters to the burstable instance family.

Show Suggested Answer

Suggested Answer: A 🗳️

by std2021 at April 1, 2021, 8:40 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

Zhongkai

Highly Voted 3 years, 8 months ago

Check https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.DBInstanceClass.html - t2 and t3 (8vCPU 32GB RAM) series are mostly weaker than r4/r5 (96 vCPU 768GB RAM) series. Changing from r to t series is not a good idea. Furthermore, "unpredictable" indicates "Aurora Serverless". Hence I will go with A.

upvoted 15 times

...

novice_expert

Highly Voted 3 years, 1 month ago

Selected Answer: A

"unexpected and variable demands, adhoc searched" => "Aurora Serverless"

upvoted 7 times

...

Germaneli

Most Recent 1 year, 8 months ago

Selected Answer: A

Skipping B+c as distractors. Torn between A+D - D is not applicable as "we recommend using the [burstable] T DB instance classes only for development, test, or other nonproduction servers". Switching to burstable classes is not an option here for PROD reporting. Hence A. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraMySQL.BestPractices.html#AuroraMySQL.BestPractices.T2Medium

upvoted 1 times

...

anantarb

2 years, 4 months ago

Selected Answer: D

Question says without significant rework. Option A would require migration. So option D is correct. https://aws.amazon.com/rds/instance-types/

upvoted 4 times

...

lollyj

2 years, 5 months ago

Selected Answer: D

A - Serverless will require moving existing DB although you are saving on cost. D. Can respond to traffic spikes, requires very little change and the costs for the spikes won't be much because it isn't too frequent. The burst credits can be used.

upvoted 1 times

...

Dantas

3 years, 2 months ago

Selected Answer: A

https://aws.amazon.com/rds/aurora/serverless/ Amazon Aurora Serverless is a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads.

upvoted 4 times

...

tugboat

3 years, 3 months ago

Selected Answer: A

ad-hoc searches = Serverless https://aws.amazon.com/rds/aurora/faqs/?nc=sn&loc=6 Q: Can I migrate an existing Aurora DB cluster to Aurora Serverless? Yes, you can restore a snapshot taken from an existing Aurora provisioned cluster into an Aurora Serverless DB Cluster (and vice versa).

upvoted 1 times

...

user0001

3 years, 3 months ago

D A is good if the cluster experience no activities which is not the case

upvoted 2 times

...

awsmonster

3 years, 4 months ago

Answer: A The company's key concern is cost, and a solution that does not need extensive rework is required. Converting Aurora Cluster to Serverless does not require extensive rework.

upvoted 1 times

...