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

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

A company is running a database on Amazon Aurora. The database is idle every evening. An application that performs extensive reads on the database experiences performance issues during morning hours when user traffic spikes. During these peak periods, the application receives timeout errors when reading from the database. The company does not have a dedicated operations team and needs an automated solution to address the performance issues.
Which actions should a solutions architect take to automatically adjust to the increased read load on the database? (Choose two.)

  • A. Migrate the database to Aurora Serverless.
  • B. Increase the instance size of the Aurora database.
  • C. Configure Aurora Auto Scaling with Aurora Replicas.
  • D. Migrate the database to an Aurora multi-master cluster.
  • E. Migrate the database to an Amazon RDS for MySQL Multi-AZ deployment.
Show Suggested Answer Hide Answer
Suggested Answer: AC 🗳️

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
weilun_tann
Highly Voted 3 years, 6 months ago
Selected Answer: AC
A and C - The problem here is to AUTOMATICALLY SCALE READS during traffic surges A. Migrate the database to Aurora Serverless. Correct. https://aws.amazon.com/rds/aurora/serverless/ B. Increase the instance size of the Aurora database. Wrong. The excess capacity will be unutilized during off-peak periods C. Configure Aurora Auto Scaling with Aurora Replicas. Correct. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Integrating.AutoScaling.html D. Migrate the database to an Aurora multi-master cluster. Wrong. This helps to scale WRITES, not reads - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-multi-master.html E. Migrate the database to an Amazon RDS for MySQL Multi-AZ deployment. Wrong. This is for availability and disaster recovery, NOT read scaling. The standby instance is NOT used to serve reads or writes. Active-passive failover is adopted. https://aws.amazon.com/rds/features/multi-az/
upvoted 37 times
Kings2020
3 years, 4 months ago
Question says that DB is already in Aurora, On Amazon Aurora, a business is operating a database. Do I miss any here ?
upvoted 1 times
Tonero2016
2 years, 11 months ago
Organisation is already using Aurora, so how do you migrate again to Aurora serverless? The best answer is C & D
upvoted 5 times
...
...
DriVen
3 years, 2 months ago
Yes, but 1 - The question does not state whether Aurora is not already serveless and 2 - It doesn't sound logical to MIGRATE to Aurora Serverless, I don't think thats the proper word use of MIGRATION, Confusing question nonetheless, but I'd stay with C +D here
upvoted 3 times
...
...
NVH
Highly Voted 3 years, 5 months ago
This questions was on my test I took today 1-18-22, I went with AC
upvoted 5 times
...
marklovesaws143
Most Recent 2 years, 11 months ago
Selected Answer: AC
ACACACACACAC
upvoted 1 times
...
TecoCloud
2 years, 11 months ago
C and D Aurora Multi-Master enables the Aurora database to maintain read and write availability with zero application downtime
upvoted 3 times
...
slcheng
2 years, 11 months ago
Selected Answer: AC
Vote A and C.
upvoted 1 times
...
BreakoutTrader
2 years, 11 months ago
It can not be d. It improves write only. To manage operation select A and to improve read c. Answer a and c
upvoted 1 times
...
naveenagurjara
2 years, 12 months ago
Selected Answer: AC
Aurora multi-master scales Writes but here use case is for Reads.
upvoted 2 times
...
etheng1970
2 years, 12 months ago
Selected Answer: CD
if the question ask what are the 2 solution to address than i will chose A and C. However, that is not the question is "Which activities should a solutions architect take to ensure that the database automatically adjusts to the increasing read load?" So i chose C and D
upvoted 2 times
ProtonUser
2 years, 11 months ago
By using Multi - master you are not automatically adjusting to increasing loads (r/w). You are paying for the multi - master option even though you not using it. Multi - master is good when you cannot afford any downtime in write operations. Going multi - master for this specific use case means over - provisioning, which is not an AWS best practice.
upvoted 2 times
...
...
Aniketh
3 years ago
Amazon Aurora and Aurora Serverless are two distinct products from AWS. While Amazon's Aurora lets you use cloud-based computing resources to test and run your applications, the Aurora Serverless is a configuration that enables automated capacity scaling and for connecting applications.
upvoted 1 times
...
bangfire
3 years ago
CD. The question already mentioned it is on Aurora, why migrate Aurora to Aurora? Serverless is just a characteristics of Aurora.
upvoted 1 times
f6f7f8
3 years ago
Amazon Aurora and Aurora Serverless are two distinct products from AWS. While Amazon's Aurora lets you use cloud-based computing resources to test and run your applications, the Aurora Serverless is a configuration that enables automated capacity scaling and for connecting applications.
upvoted 4 times
...
...
SZARCHITECT
3 years, 2 months ago
Selected Answer: AC
Question deals with auto adjustment, A and C look fine. Here a use case for Aurora serverless from AWS : "Infrequently-used applications You have an application that is only used for a few minutes several times per day or week, such as a low-volume blog site, and you want a cost-effective database that only requires you to pay when it's active. With Aurora Serverless v1, you only pay for the database resources you consume." Here is a use case for Auto scaling : "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 3 times
...
zik87
3 years, 3 months ago
A is wrong. It doesn't solve anything. C and D
upvoted 2 times
ProtonUser
2 years, 11 months ago
By using Multi - master you are not automatically adjusting to increasing loads (r/w). You are paying for the multi - master option even though you not using it. Multi - master is good when you cannot afford any downtime in write operations. Going multi - master for this specific use case means over - provisioning, which is not an AWS best practice. Aurora serverles allows you to solve unpredictable workloads.
upvoted 2 times
...
...
Parth9
3 years, 4 months ago
Selected Answer: AC
AC is the right answer
upvoted 2 times
...
FF11
3 years, 5 months ago
Selected Answer: AC
A&C are correct.
upvoted 3 times
...
keeplearning_rahul
3 years, 6 months ago
Selected Answer: AC
A and C
upvoted 2 times
SurenDakshin
3 years, 6 months ago
"A. Migrate the database to Aurora Serverless. " Question already mentions Aurora which is serverless; can you ple explain why you would migrate aurora to aurora, if that even makes sense?
upvoted 2 times
kevinhao426
3 years, 5 months ago
Please notice Aurora RDS and Aurora Serverless are two different kinds of products from AWS, and I believe when the questions say Aurora, normally it mean Aurora RDS
upvoted 7 times
...
...
...
LETSGETIT
3 years, 6 months ago
A and C for me. Multi cluster is more for high availability
upvoted 2 times
rukkoth
3 years, 6 months ago
Me too think same. A & C make more sense for me.
upvoted 1 times
...
...
farciarz212
3 years, 6 months ago
You don't get to choose Multi master with Server less Capacity type. Only Provisioned options allows replication features. Server less: You specify the minimum and maximum amount of resources needed, and Aurora scales the capacity based on database load. This is a good option for intermittent or unpredictable workloads.
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
Loading ...