Exam AWS Certified Solutions Architect - Associate SAA-C02 All Questions

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C02 exam

Exam AWS Certified Solutions Architect - Associate SAA-C02 topic 1 question 352 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C02

Question #: 352
Topic #: 1

[All AWS Certified Solutions Architect - Associate SAA-C02 Questions]

A company runs its production workload on an Amazon Aurora MySQL DB cluster that includes six Aurora Replicas. The company wants near-real-lime reporting queries from one of its departments to be automatically distributed across three of the Aurora Replicas. Those three replicas have a different compute and memory specification from the rest of the DB cluster.
Which solution meets these requirements?

A. Create and use a custom endpoint for the workload.
B. Create a three-node cluster clone and use the reader endpoint.
C. Use any of the instance endpoints for the selected three nodes.
D. Use the reader endpoint to automatically distribute the read-only workload.

Show Suggested Answer

Suggested Answer: A 🗳️

by dmscountera at March 11, 2021, 5:21 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

dmscountera

Highly Voted 3 years, 11 months ago

A custom endpoint https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Endpoints.Custom

upvoted 38 times

may2021_r

3 years, 9 months ago

For clusters with DB instances of different capacities or configurations, you can connect to custom endpoints associated with different subsets of DB instances.

upvoted 2 times

...

manan728

3 years, 9 months ago

This question was on my test that I passed on Nov 20 2021. I picked A custom endpoint. Roughly about half of the questions are from this 500 examtopics dump. But other half were unheard of new and lengthy ones in my test. Some of those questions had similarities but had twisted options. Good luck ya'll.

upvoted 10 times

Konglao

3 years, 8 months ago

you've got to help with whatever made you prepare so well, i agree with this, custom endpoint, Answer is A

upvoted 3 times

...

cvlaje

Highly Voted 3 years, 10 months ago

This feature is intended for advanced users with specialized kinds of workloads where it isn't practical to keep all the Aurora Replicas in the cluster identical. With custom endpoints, you can predict the capacity of the DB instance used for each connection. When you use custom endpoints, you typically don't use the reader endpoint for that cluster. Answer is A.

upvoted 14 times

cvlaje

3 years, 10 months ago

Meanwhile Reader Endpoint also helps the cluster to scale the capacity to handle simultaneous SELECT queries, proportional to the number of Aurora Replicas in the cluster. Each Aurora DB cluster has one reader endpoint. ~Answer could be B

upvoted 2 times

swadeey

3 years, 9 months ago

Once you clone it is separate copy and won't be updated real time, so there won't be near real time reporting queries as the data will become stale and non-relevant

upvoted 2 times

...

BECAUSE

Most Recent 2 years, 2 months ago

Selected Answer: A

A is the answer

upvoted 1 times

...

queen101

3 years ago

AAAAAAAAAAAA

upvoted 1 times

...

Alfene

3 years ago

Answer is A

upvoted 1 times

...

marklovesaws143

3 years ago

Selected Answer: A

AAAAAAAAAA

upvoted 1 times

...

etheng1970

3 years, 1 month ago

Selected Answer: A

A - the custom endpoint, will be able to identify which replica had the highest work load. And with report, the Solution Architect will do the needful to increase the capacity if require. https://aws.amazon.com/about-aws/whats-new/2018/11/amazon-aurora-simplifies-workload-management-with-custom-endpoints/#:~:text=A%20custom%20endpoint%20can%20then,helps%20spread%20the%20load%20around.

upvoted 2 times

...

Rickywsiek

3 years, 7 months ago

Selected Answer: A

Answer is A

upvoted 2 times

...

Siddhartham

3 years, 7 months ago

Selected Answer: A

Custom endpoint for a different set of replica

upvoted 1 times

...

Siddhartham

3 years, 7 months ago

Selected Answer: A

The Reader Endpoint is generally not used after defining Custom Endpoints

upvoted 1 times

...

Dsb86

3 years, 8 months ago

Selected Answer: A

https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.Endpoints.html#Aurora.Endpoints.Custom

upvoted 1 times

...

mankeer

3 years, 8 months ago

Three replicas differ in terms of memory and CPU, this direct us to a custom endpoint, Answer is A.

upvoted 2 times

...

Nitish34

3 years, 8 months ago

Cluster endpoint – Connects you to the primary instance and automatically follows the primary instance in case of failover, that is, when the current primary instance is demoted and one of the Aurora Replicas is promoted in its place. • Reader endpoint – Includes all Aurora Replicas in the DB cluster under a single DNS CNAME. You can use the reader endpoint to implement DNS round robin load balancing for read-only connections. • Instance endpoint – Each instance in the DB cluster has its own individual endpoint. You can use this endpoint to connect directly to a specific instance. • Custom endpoints – User-defined DNS endpoints containing a selected group of instances from a given cluster - (Correct Answer A)

upvoted 8 times

...

gargaditya

3 years, 9 months ago

answer is A. Aurora uses single reader endpoint for all replica nodes. We can create new custom endpoints for our workloads. So, 3 nodes can share the same custom endpoint and serve the reports. B is out because 3' node cluster clone' does not make sense C-this happens in 'RDS 'where instance endpoints exist and application needs to be updated with connection string D-this would effectively mean using the same endpoint shared by all 6 replica nodes

upvoted 5 times

...