AWS Certified Solutions Architect – Associate (SAA-C02) — Question 78

A solutions architect is helping a developer design a new ecommerce shopping cart application using AWS services. The developer is unsure of the current database schema and expects to make changes as the ecommerce site grows. The solution needs to be highly resilient and capable of automatically scaling read and write capacity.
Which database solution meets these requirements?

Answer options

• A. Amazon Aurora PostgreSQL
• B. Amazon DynamoDB with on-demand enabled
• C. Amazon DynamoDB with DynamoDB Streams enabled
• D. Amazon SQS and Amazon Aurora PostgreSQL

Correct answer: B

Explanation

The correct answer is B, Amazon DynamoDB with on-demand enabled, because it provides automatic scaling of read and write capacity to handle varying workloads, which is essential for an ecommerce site. Option A, Amazon Aurora PostgreSQL, while resilient, requires more manual intervention for scaling. Option C, Amazon DynamoDB with DynamoDB Streams enabled, focuses on data processing rather than scaling. Option D combines SQS and Aurora, which does not directly address the scaling needs of the database.