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

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

Question #: 864
Topic #: 1

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

A company that runs its application on AWS uses an Amazon Aurora DB cluster as its database. During peak usage hours when multiple users access and read the data, the monitoring system shows degradation of database performance for the write queries. The company wants to increase the scalability of the application to meet peak usage demands.

Which solution will meet these requirements MOST cost-effectively?

A. Create a second Aurora DB cluster. Configure a copy job to replicate the users’ data to the new database. Update the application to use the second database to read the data.
B. Create an Amazon DynamoDB Accelerator (DAX) cluster in front of the existing Aurora DB cluster. Update the application to use the DAX cluster for read-only queries. Write data directly to the Aurora DB cluster.
C. Create an Aurora read replica in the existing Aurora DB cluster. Update the application to use the replica endpoint for read-only queries and to use the cluster endpoint for write queries.
D. Create an Amazon Redshift cluster. Copy the users' data to the Redshift cluster. Update the application to connect to the Redshift cluster and to perform read-only queries on the Redshift cluster.

Show Suggested Answer

Suggested Answer: C 🗳️

by Scheldon at May 31, 2024, 1:38 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

mk168898

8 months ago

I was thinking between B and C. Saw that DAX is for Dynamo DB which is different from the question Aurora DB. So i picked C

upvoted 2 times

...

KennethNg923

1 year ago

Selected Answer: C

Read Replica for multiple users access and read the data

upvoted 4 times

...

ug56c

1 year ago

Answer C, wording is that read queries are slowing down write queries -> we need to optimize for read queries -> we need to add read replicas. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Performance.html#Aurora.Managing.Performance.ReadScaling

upvoted 4 times

...

sheilawu

1 year ago

Selected Answer: B

write queries=>High performance of read & Write Dynamo, I think DAX is a better solution.

upvoted 1 times

Rhydian25

11 months, 3 weeks ago

Dynamo is NoSQL...

upvoted 2 times

...

Scheldon

1 year ago

Selected Answer: C

AnswerC A - We can create only RO replica of DB hence this is not possible. D - Redshift is not for a DB from my understanding but more like analitics tools B - Could be a thinkg but there is no point of Read-Only from DAX and write to DB cluster. beside it is hard to say if it would be cost effective as we are paying per hour not R/W requests as it is with replica. Hence I would go with C

upvoted 2 times

...