Exam AWS Certified Database - Specialty topic 1 question 15 discussion

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 15
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company has a production Amazon Aurora Db cluster that serves both online transaction processing (OLTP) transactions and compute-intensive reports. The reports run for 10% of the total cluster uptime while the OLTP transactions run all the time. The company has benchmarked its workload and determined that a six- node Aurora DB cluster is appropriate for the peak workload.
The company is now looking at cutting costs for this DB cluster, but needs to have a sufficient number of nodes in the cluster to support the workload at different times. The workload has not changed since the previous benchmarking exercise.
How can a Database Specialist address these requirements with minimal user involvement?

A. Split up the DB cluster into two different clusters: one for OLTP and the other for reporting. Monitor and set up replication between the two clusters to keep data consistent.
B. Review all evaluate the peak combined workload. Ensure that utilization of the DB cluster node is at an acceptable level. Adjust the number of instances, if necessary.
C. Use the stop cluster functionality to stop all the nodes of the DB cluster during times of minimal workload. The cluster can be restarted again depending on the workload at the time.
D. Set up automatic scaling on the DB cluster. This will allow the number of reader nodes to adjust automatically to the reporting workload, when needed.

Show Suggested Answer

Suggested Answer: D 🗳️

by chicagomassageseeker at July 8, 2020, 5:27 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

chicagomassageseeker

Highly Voted 3 years, 9 months ago

Answer D. You dont setup a seperate cluster for reporting. Aurora does OLTP and reporting from same cluster. just use autoscaling.

upvoted 15 times

...

MultiAZ

Most Recent 1 year, 5 months ago

Selected Answer: D

Out of the provided options, D seems to be the best.

upvoted 1 times

...

Pranava_GCP

1 year, 9 months ago

Selected Answer: D

D. Set up Auto Scaling --> minimal user involvement https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html#Aurora.Integrating.AutoScaling.Concepts "Aurora Auto Scaling enables your Aurora DB cluster to handle sudden increases in connectivity or workload. When the connectivity or workload decreases, Aurora Auto Scaling removes unnecessary Aurora Replicas so that you don't pay for unused provisioned DB instances."

upvoted 2 times

...