ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

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

View all questions & answers for the AWS Certified Solutions Architect - Associate SAA-C03 exam
Go to Exam

Exam AWS Certified Solutions Architect - Associate SAA-C03 topic 1 question 946 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Associate SAA-C03
Question #: 946
Topic #: 1
[All AWS Certified Solutions Architect - Associate SAA-C03 Questions]

A company runs its production workload on an Amazon Aurora MySQL DB cluster that includes six Aurora Replicas. The company wants near-real-time 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 Hide Answer
Suggested Answer: A 🗳️
by [deleted] at Aug. 17, 2024, 7:24 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
[Removed]
Highly Voted 8 months, 2 weeks ago
Selected Answer: A
Custom Endpoints: Custom endpoints in Amazon Aurora allow you to group specific replicas together and route traffic only to those replicas. This is particularly useful when you have replicas with different compute and memory specifications and want to direct specific workloads, such as reporting queries, to those replicas. By creating a custom endpoint, you can include the three specific Aurora Replicas that have the required compute and memory configurations, ensuring that your near-real-time reporting queries are automatically distributed among these replicas.
upvoted 6 times
...
FlyingHawk
Most Recent 3 months, 1 week ago
Selected Answer: A
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Endpoints.Custom.html A custom endpoint for an Aurora cluster represents a set of DB instances that you choose. When you connect to the endpoint, Aurora performs connection balancing and chooses one of the instances in the group to handle the connection. You define which instances this endpoint refers to, and you decide what purpose the endpoint serves.
upvoted 1 times
FlyingHawk
3 months, 1 week ago
custom endpoint for an Aurora cluster represents a set of DB instances that you choose. When you connect to the endpoint, Aurora performs connection balancing and chooses one of the instances in the group to handle the connection. You define which instances this endpoint refers to, and you decide what purpose the endpoint serves. An Aurora DB cluster has no custom endpoints until you create one. You can create up to five custom endpoints for each provisioned Aurora cluster or Aurora Serverless v2 cluster. You can't use custom endpoints for Aurora Serverless v1 clusters. The custom endpoint provides balanced database connections based on criteria other than the read-only or read/write capability of the DB instances.
upvoted 1 times
...
...
LeonSauveterre
3 months, 4 weeks ago
Selected Answer: A
A - You can assign the three replicas with different compute and memory specifications to the custom endpoint, ensuring that queries are distributed only among these replicas. B - Expensive, cumbersome, and unnecessary. The clone has separate storage and compute resources. C - You can't target just the three replicas you want. D - The reader endpoint automatically distributes read queries across *ALL* Aurora Replicas in the cluster.
upvoted 2 times
...
JA2018
5 months ago
Selected Answer: A
This is why I choose Option A: Using a Custom endpoint: This allows you to specify a specific set of Aurora replicas be used for the reporting queries, enabling you to target the three replicas with different compute and memory specifications while distributing the workload across them.
upvoted 1 times
JA2018
5 months ago
Why the other options are not ideal: - #B. Create a three-node cluster clone and use the reader endpoint: While you can create a separate cluster, using the "reader endpoint" would distribute queries across all replicas in that cluster, not just the three you want to target with different specs. - #C. Use any of the instance endpoints for the selected three nodes: This approach would require manual connection management to each specific replica, not providing automatic load balancing across the chosen three nodes. - #D. Use the reader endpoint to automatically distribute the read-only workload: The standard "reader endpoint" distributes reads across all Aurora replicas in the cluster, not just the selected three with specific configurations.
upvoted 1 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago