Amazon SAA-C03 Exam - Topic 3 Question 50 Discussion

Actual exam question for Amazon's SAA-C03 exam

Question #: 50
Topic #: 3

A company is developing a new application that uses a relational database to store user data and application configurations. The company expects the application to have steady user growth. The company expects the database usage to be variable and read-heavy, with occasional writes.

The company wants to cost-optimize the database solution. The company wants to use an AWS managed database solution that will provide the necessary performance.

Which solution will meet these requirements MOST cost-effectively?

ADeploy the database on Amazon RDS. Use Provisioned IOPS SSD storage to ensure consistent performance for read and write operations.

BDeploy the database on Amazon Aurora Serveriess to automatically scale the database capacity based on actual usage to accommodate the workload.

CDeploy the database on Amazon DynamoDB. Use on-demand capacity mode to automatically scale throughput to accommodate the workload.

DDeploy the database on Amazon RDS Use magnetic storage and use read replicas to accommodate the workload

Show Suggested Answer

Suggested Answer: B

Amazon Aurora Serverless is a cost-effective, on-demand, autoscaling configuration for Amazon Aurora. It automatically adjusts the database's capacity based on the current demand, which is ideal for workloads with variable and unpredictable usage patterns. Since the application is expected to be read-heavy with occasional writes and steady growth, Aurora Serverless can provide the necessary performance without requiring the management of database instances.

Cost-Optimization: Aurora Serverless only charges for the database capacity you use, making it a more cost-effective solution compared to always running provisioned database instances, especially for workloads with fluctuating demand.

Scalability: It automatically scales database capacity up or down based on actual usage, ensuring that you always have the right amount of resources available.

Performance: Aurora Serverless is built on the same underlying storage as Amazon Aurora, providing high performance and availability.

Why Not Other Options?:

Option A (RDS with Provisioned IOPS SSD): While Provisioned IOPS SSD ensures consistent performance, it is generally more expensive and less flexible compared to the autoscaling nature of Aurora Serverless.

Option C (DynamoDB with On-Demand Capacity): DynamoDB is a NoSQL database and may not be the best fit for applications requiring relational database features.

Option D (RDS with Magnetic Storage and Read Replicas): Magnetic storage is outdated and generally slower. While read replicas help with read-heavy workloads, the overall performance might not be optimal, and magnetic storage doesn't provide the necessary performance.

AWS Reference:

Amazon Aurora Serverless - Information on how Aurora Serverless works and its use cases.

Amazon Aurora Pricing - Details on the cost-effectiveness of Aurora Serverless.

by Derick at Oct 18, 2024, 08:43 PM

Limited Time Offer

25%

Off

Get Premium SAA-C03 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

Submit Cancel

Elizabeth

3 months ago

I’d go with DynamoDB (C) for cost-effectiveness and scalability!

upvoted 0 times

...

Sarah

3 months ago

RDS with Provisioned IOPS (A) is solid, but might be overkill for this use case.

upvoted 0 times

...

Annamae

3 months ago

Wait, can magnetic storage really handle read-heavy loads? Sounds risky.

upvoted 0 times

...

Aleta

4 months ago

Definitely agree with B! It scales automatically, which is a huge plus.

upvoted 0 times

...

Eden

4 months ago

I think Amazon Aurora Serverless (B) is the best choice for variable workloads.

upvoted 0 times

...

Madonna

4 months ago

Using magnetic storage with RDS and read replicas sounds like it could save costs, but I feel like it might not handle the variable load as well as the other options.

upvoted 0 times

...

Brinda

4 months ago

I practiced a similar question where DynamoDB was mentioned, and it seems like a solid choice for variable workloads, but I’m not sure about the relational aspect here.

upvoted 0 times

...

Brock

4 months ago

I think Amazon Aurora Serverless could be a good fit since it scales automatically, but I wonder if it really is the most cost-effective option.

upvoted 0 times

...

Dick

5 months ago

I remember studying about Amazon RDS and its Provisioned IOPS, but I'm not sure if that's the best choice for a read-heavy workload.

upvoted 0 times

...

Katheryn

5 months ago

I'm a bit confused by the options here. Provisioned IOPS SSD on RDS seems like it could work, but I'm not sure if that's the most cost-effective approach. Maybe I should look into the pricing models for each service more closely.

upvoted 0 times

...

Dominic

5 months ago

Okay, I think I've got a good handle on this. Based on the read-heavy, variable usage pattern, I'm leaning towards Aurora Serverless. The automatic scaling should help keep costs down while still providing the performance needed.

upvoted 0 times

...

Virgie

5 months ago

Hmm, this is a tricky one. I'm not sure if I fully understand the requirements yet. I'll need to review the details on each of the AWS database services to see which one aligns best with the usage patterns described.

upvoted 0 times

...

Josephine

5 months ago

This question is asking me to choose the most cost-effective AWS database solution for a variable, read-heavy workload with occasional writes. I'll need to carefully consider the options and their pricing models to determine the best fit.

upvoted 0 times

...

Nieves

1 year ago

Hold up, is anyone else thinking about the fact that the company expects 'steady user growth'? Sounds like they're gonna need to scale no matter what, so Aurora Serverless is the way to go. Easy peasy.

upvoted 0 times

...

Sheridan

1 year ago

Why not just use regular RDS with Provisioned IOPS? Seems like it would give them the consistent performance they're looking for.

upvoted 0 times

...

Lai

1 year ago

I don't know, DynamoDB on-demand mode could be a good option too. It'll scale throughput as needed, and the company said they wanted to cost-optimize.

upvoted 0 times

Sophia

1 year ago

A: True, but using read replicas on Amazon RDS with magnetic storage could also help accommodate the workload.

upvoted 0 times

...

Jacki

1 year ago

C: DynamoDB on-demand mode could be a good choice too, it scales throughput as needed.

upvoted 0 times

...

Tawna

1 year ago

A: I think deploying on Amazon RDS with Provisioned IOPS SSD storage is the best option for consistent performance.

upvoted 0 times

...

Elise

1 year ago

B: I agree, but Amazon Aurora Serverless could be more cost-effective since it automatically scales based on usage.

upvoted 0 times

...

Oliva

1 year ago

I disagree, I believe option B is more cost-effective as it automatically scales based on actual usage.

upvoted 0 times

...

Hoa

1 year ago

Aurora Serverless sounds like the way to go here. It will automatically scale to handle the variable and read-heavy workload, which is exactly what the company needs.

upvoted 0 times