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

For me it is C. From AWS Aurora Serverless: "It enables you to run your database in the cloud without managing any database instances. It's a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads." https://aws.amazon.com/rds/aurora/serverless/ The question clearly states that it is sporadic. Indeed, it is predictable because we do know when the traffic is low and when it increases. However, I think a serverless solution will better work for this kind of workload as it scales out and in only when it needs --> costs savings.

The key words are ; Cost effective - Aurora cost is high. Unpredictable usage - Aurora is the best option However company’s requirement is “needs to select a cost effective database” which implies that; B is the right answer

C is the answer

RDS is cheaper than aurora. However, the question is about unpredictable load, which is where aurora serverless really shines.

My review of this points to B as the answer as the question says "need to choose an affordable database platform", it is not asking about the whole application. The best database platform for this is RDS MySQL. C would be the response about the Web front end/processing Application component, C is not a database platform in itself.

C for me. - "does not need database adjustments."

only because of unexpected spike, I choose serverless.

Answer C. https://aws.amazon.com/about-aws/whats-new/2020/06/announcing-aurora-serverless-with-mysql-5-7-compatibility/

C is the most appropriate answer.

Ans: C. Aurora is better than RDS MySQL but, the question says the cost-effective solution. Aurora instances will cost you ~20% more than RDS MySQL. So, it will be RDS MySQL

i go with (c) (a) is not the answer becasue that would require a change to the code (nosql vs relational database) (b) could be cheaper, but heavy usage at the start of the month means you'd need a big instance to handle it which would remain underutilized for the rest of the time (c) you are only paying for it when you're using it and scales automatically and is good for unpredictable workloads (d) never choose something you have to manage manually when there are services you can use

"C" is correct. Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora (MySQL-compatible and PostgreSQL-compatible editions), where the database will automatically start up, shut down, and scale capacity up or down based on your application's needs. It's a simple, cost-effective option for infrequent, intermittent, or unpredictable workloads

C Reference: https://aws.amazon.com/about-aws/whats-new/2020/06/announcing-aurora-serverless-with-mysql-5-7-compatibility/

The answer is C. Amazon Aurora Serverless is an on-demand, auto-scaling configuration for Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down based on your application's needs. It enables you to run your database in the cloud without managing any database capacity. Second point is "a cost-effective database platform that will not require database modifications" https://aws.amazon.com/rds/aurora/serverless/

Aws : C. MySQL-compatible Amazon Aurora Serverless.

C: cost effective in terms of DynamoDB

Aurora Serverless • Automated database Client instantiation and autoscaling based on actual usage • Good for infrequent, intermittent or unpredictable workloads • No capacity planning needed • Pay per second, can be more cost-effective