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

Exam question from Amazon's AWS Certified Database - Specialty

Question #: 89
Topic #: 1

[All AWS Certified Database - Specialty Questions]

A company has a heterogeneous six-node production Amazon Aurora DB cluster that handles online transaction processing (OLTP) for the core business and
OLAP reports for the human resources department. To match compute resources to the use case, the company has decided to have the reporting workload for the human resources department be directed to two small nodes in the Aurora DB cluster, while every other workload goes to four large nodes in the same DB cluster.
Which option would ensure that the correct nodes are always available for the appropriate workload while meeting these requirements?

A. Use the writer endpoint for OLTP and the reader endpoint for the OLAP reporting workload.
B. Use automatic scaling for the Aurora Replica to have the appropriate number of replicas for the desired workload.
C. Create additional readers to cater to the different scenarios.
D. Use custom endpoints to satisfy the different workloads.

Show Suggested Answer

Suggested Answer: D 🗳️

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

shantest1

Highly Voted 3 years, 9 months ago

D - Custom endpoints

upvoted 8 times

...

MultiAZ

Most Recent 1 year, 6 months ago

Selected Answer: D

D - custom endpoints can provide this flexibility

upvoted 1 times

...

examineme

2 years, 7 months ago

Selected Answer: D

Use custom endpoints

upvoted 1 times

...

novice_expert

3 years, 2 months ago

Selected Answer: D

D. Use custom endpoints to satisfy the different workloads. https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-aurora-simplifies-workload-management-with-custom-endpoints/ you can now create custom endpoints for Amazon Aurora databases. This allows you to distribute and load balance workloads across different sets of database instances in your Aurora cluster.

upvoted 3 times

...

RotterDam

3 years, 4 months ago

What does " heterogeneous six-node production Amazon Aurora DB cluster " even mean? I've never heard of any Aurora infrastructure described this way!!

upvoted 1 times

khchan123

3 years, 1 month ago

heterogeneous means the six nodes are of different size.

upvoted 3 times

...

guru_ji

3 years, 8 months ago

Correct Answer: D

upvoted 1 times

...

damaldon

3 years, 8 months ago

D is correct as per link: https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-aurora-simplifies-workload-management-with-custom-endpoints/ ou can now create custom endpoints for Amazon Aurora databases. This allows you to distribute and load balance workloads across different sets of database instances in your Aurora cluster. For example, you may provision a set of Aurora Replicas to use an instance type with higher memory capacity in order to run an analytics workload. A custom endpoint can then help you route the analytics workload to these appropriately-configured instances, while keeping other instances in your cluster isolated from this workload. As you add or remove instances from the custom endpoint to match your workload, the endpoint helps spread the load around.

upvoted 1 times

...

Hits_23

3 years, 8 months ago

D is right choice. Custom endpoints. OLTP can only work with master instance endpoint. OLAP reports could work with either master instance/any combination of reader endpoints

upvoted 1 times

...

Aesthet

3 years, 8 months ago

D final answer

upvoted 3 times

...

std2021

3 years, 9 months ago

Answer D

upvoted 3 times

...