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

B read replica read offload

Answer is B. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Replication.html#Aurora.Replication.Replicas 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. If the writer instance in a cluster becomes unavailable, Aurora automatically promotes one of the reader instances to take its place as the new writer.

D. Increase the Provisioned IOPS on the Aurora instance is the most cost-effective solution. By increasing the Provisioned IOPS, the Aurora instance can handle the increased read I/O requirements during the monthly reports. This will help to reduce the spiking of the ReadIOPS and CPUUtilization metrics, improving the performance of the ecommerce application during these reports. Migrating the monthly reporting to Amazon Redshift or an Aurora Replica may also improve performance, but it could result in additional costs. Migrating the Aurora database to a larger instance class would also require additional resources, leading to an increase in cost.

Option B (Migrating the monthly reporting to an Aurora Replica) may not be the most cost-effective solution as it requires adding another Aurora instance, which would increase the cost of running the database. Additionally, it may not resolve the root cause of the issue (i.e., high ReadIOPS and CPUUtilization), as the replica instance would still need to process the same volume of data as the primary instance during monthly reports. It would also add additional operational overhead in terms of managing and maintaining the replica instance. D is correct

It is C. https://aws.amazon.com/blogs/database/making-better-decisions-about-amazon-rds-with-amazon-cloudwatch-metrics/ If you see that ReadIOPS are contributing more toward total IOPS consumption, you should move to a higher instance class with more RAM. If a bad or unexpected query, or unusually high workload, causes a high value of CPUUtilization, you might move to a larger instance class.

D => possible..... however the cost of increasing instance should be lesser than Read Replica. So for the sake of exmaple i will choose text book answer B.

IMO: B is correct, since increase of Aurora IOPS means changing instance type: https://www.percona.com/blog/2018/07/17/when-should-i-use-amazon-aurora-and-when-should-i-use-rds-mysql/

B => ReadIOPS and CPUUtilization metrics are spiking when monthly reports run => mean we have issues with reading so increase read replica

B .Aurora Replicas can also offload read workloads from the primary DB instance. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html

B looks right

ans should be B

B is correct

No need to get confused. The answer is B!

Aurora Storage is not EBS based like other RDS DBs. It's SSD cluster, replicated automatically in 3 AZs. You dont pay for provisioned storage, only for used storage. There is no option to configure storage in Aurora. https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.StorageReliability.html https://aws.amazon.com/blogs/database/introducing-the-aurora-storage-engine/

D or not?

I think it would be D ...even thought you add a replica it will use the common/same cluster volume that will be shared commonly by the primaryDB and replicas https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Overview.html It would be D ..to increase the iops

omg different answer so many