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

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

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

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

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

An application running on AWS uses an Amazon Aurora Multi-AZ deployment for its database. When evaluating performance metrics, a solutions architect discovered that the database reads are causing high I/O and adding latency to the write requests against the database.
What should the solutions architect do to separate the read requests from the write requests?

  • A. Enable read-through caching on the Amazon Aurora database.
  • B. Update the application to read from the Multi-AZ standby instance.
  • C. Create a read replica and modify the application to use the appropriate endpoint.
  • D. Create a second Amazon Aurora database and link it to the primary database as a read replica.
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by Sapens at Aug. 9, 2020, 2:05 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
Adamlin
Highly Voted 3 years, 9 months ago
B. It's a trap trying to make you choose C, remember aurora is DIFFERENT from RDS. ref: https://www.youtube.com/watch?v=QSPIQmsvuTE
upvoted 58 times
Jonycici
3 years, 8 months ago
Aurora standby simply don't exist.
upvoted 5 times
lehoang15tuoi
3 years, 8 months ago
Yep very strange wording instead. It should have been “replica” instead of standby in there. Other options are incorrect too
upvoted 1 times
...
...
Alcpt
3 years, 6 months ago
There is no such thing a "standby instance" in native Aurora flavour. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html Answer is C.
upvoted 3 times
...
TAvenger
3 years, 8 months ago
The answer is "C". Read official FAQs https://aws.amazon.com/rds/faqs/ Q: When running my DB instance as a Multi-AZ deployment, can I use the standby for read or write operations? No, a Multi-AZ standby cannot serve read requests. Multi-AZ deployments are designed to provide enhanced database availability and durability, rather than read scaling benefits. As such, the feature uses synchronous replication between primary and standby. Our implementation makes sure the primary and the standby are constantly in sync, but precludes using the standby for read or write operations. If you are interested in a read scaling solution, please see the FAQs on Read Replicas.
upvoted 21 times
th3cookie
3 years, 8 months ago
You linked to RDS when the question asked about aurora. The correct answer is B
upvoted 2 times
cherry23
3 years, 8 months ago
Arora is RDS
upvoted 3 times
...
...
Nemozini
3 years, 8 months ago
"C" is correct in my opinion. but your reasoning is wrong. A Multi-AZ *stand by* can't service read traffic, that is true. But that doesn't apply to Aurora since Aurora doesn't have a concept of "Multi-AZ stand by". It has Multi-AZ without the "stand by". In Aurora, a read replica can be in a different AZ. And you can fail over to a read replica in a different AZ. Simply having a read replica in another AZ, makes your Aurora cluster "Multi-AZ" but none of your Aurora instances will be "standing by".
upvoted 1 times
...
...
zehnminuten
3 years, 3 months ago
B is correct. See REF: Readable standby instances in Amazon RDS Multi-AZ deployments: A new high availability option https://aws.amazon.com/de/blogs/database/readable-standby-instances-in-amazon-rds-multi-az-deployments-a-new-high-availability-option/
upvoted 2 times
...
Load full discussion...
...
eug45
Highly Voted 3 years, 9 months ago
Answer is B Aurora Replicas are independent endpoints in an Aurora DB cluster, best used for scaling read operations and increasing availability. Up to 15 Aurora Replicas can be distributed across the Availability Zones that a DB cluster spans within an AWS Region. The DB cluster volume is made up of multiple copies of the data for the DB cluster. However, the data in the cluster volume is represented as a single, logical volume to the primary instance and to Aurora Replicas in the DB cluster.
upvoted 27 times
CCNPWILL
3 years, 8 months ago
This question is on NEAL D practice exams. I got everything free cause of work lol. this question Neal has it as answer B. Standby instance!
upvoted 3 times
...
TAvenger
3 years, 8 months ago
The answer is "C". Read official FAQs https://aws.amazon.com/rds/faqs/ Q: When running my DB instance as a Multi-AZ deployment, can I use the standby for read or write operations? No, a Multi-AZ standby cannot serve read requests. Multi-AZ deployments are designed to provide enhanced database availability and durability, rather than read scaling benefits. As such, the feature uses synchronous replication between primary and standby. Our implementation makes sure the primary and the standby are constantly in sync, but precludes using the standby for read or write operations. If you are interested in a read scaling solution, please see the FAQs on Read Replicas.
upvoted 3 times
Kampton
3 years, 8 months ago
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/AuroraUserGuide/aurora-replicas-adding.html
upvoted 2 times
...
Kampton
3 years, 8 months ago
@TAvenger - Good try to mislead people, read below. An Aurora DB cluster with single-master replication has one primary DB instance and up to 15 Aurora Replicas. The primary DB instance supports read and write operations, and performs all data modifications to the cluster volume. Aurora Replicas connect to the same storage volume as the primary DB instance, but support read operations only. You use Aurora Replicas to offload read workloads from the primary DB instance.
upvoted 3 times
...
...
Vidyuth
3 years, 9 months ago
you cannit perform any operations on standby instance as it is meant for backup in case of failover.
upvoted 4 times
LCC92
3 years, 8 months ago
Aurora standby replica is a special one. It can be used to read (just like a read replica of other RDS type), and also can be used for failover when the primary instance is down.
upvoted 3 times
soti84
3 years, 8 months ago
Where did you read about this?
upvoted 2 times
...
...
...
...
NN5
Most Recent 2 weeks, 3 days ago
Selected Answer: C
C is the answer. Why not others: A. Read-through caching: Not a native Aurora feature (you’d use ElastiCache, but this adds complexity). B. Multi-AZ standby: The standby is not for read scaling—it’s for high availability (failover only). D. Second Aurora DB linked as a replica: Overkill; Aurora natively supports read replicas within the same cluster.
upvoted 1 times
...
LEEOscar
1 year, 3 months ago
use read replica as read only
upvoted 1 times
...
parku
2 years, 7 months ago
Selected Answer: C
read replicas are required.
upvoted 1 times
...
Radheysen
2 years, 10 months ago
B Here it's mentioned, that Standby instance can be used when we have multi AZ RDS/Aurora https://aws.amazon.com/rds/features/multi-az/
upvoted 1 times
...
Suya
2 years, 10 months ago
My answer is A
upvoted 1 times
...
Lavvvender
2 years, 10 months ago
Selected Answer: C
about Aurora, the point is its write endpoint and read endpoint.
upvoted 1 times
...
bikshu
2 years, 10 months ago
i will go with C
upvoted 1 times
...
jopeg
2 years, 10 months ago
Selected Answer: B
B for me
upvoted 1 times
...
reve666
3 years ago
Selected Answer: B
The answer is B
upvoted 2 times
...
bighedgedog
3 years ago
Selected Answer: C
I'd go with C because there's no concept of standby instance in Aurora. They are called replicas. Anyway, the question is confusing / wrongly written as we should already have a replica available for reading as it's an Aurora Multi-AZ. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html
upvoted 2 times
...
Robert_B
3 years, 4 months ago
Selected Answer: C
C is correct : "Aurora Replicas have two main purposes. You can issue queries to them to scale the read operations for your application. You typically do so by connecting to the reader endpoint of the cluster. That way, Aurora can spread the load for read-only connections across as many Aurora Replicas as you have in the cluster. Aurora Replicas also help to increase availability." Also, standby instances (B) are not active nodes, so B does not make sense as long as you can use Aurora Replicas to configure reads. (Source: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html#Aurora.Replication.Replicas)
upvoted 2 times
...
FF11
3 years, 6 months ago
Selected Answer: C
C is correct.
upvoted 2 times
...
employee
3 years, 6 months ago
It seems Answer B is more appropriate in terms of Aurora https://1billiontech.com/blog_AWS_Aurora.php
upvoted 1 times
...
Microgen
3 years, 7 months ago
Just realized most people here have no clue about anything. Answer is C. For a cluster using single-master replication, after you create the primary instance, you can create up to 15 read-only Aurora Replicas. The Aurora Replicas are also known as reader instances. During day-to-day operations, you can offload some of the work for read-intensive applications by using the reader instances to process SELECT queries. When a problem affects the primary instance, one of these reader instances takes over as the primary instance. This mechanism is known as failover. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Concepts.AuroraHighAvailability.html
upvoted 4 times
...
cannottellname
3 years, 7 months ago
Other replicas are already present, we just need to point a read instance - Hence, B is correct. Do not over-complicate people.
upvoted 1 times
...
Load full discussion...
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