AWS Certified Solutions Architect – Associate (SAA-C03) — Question 479

A company is developing software that uses a PostgreSQL database schema. The company needs to configure multiple development environments and databases for the company's developers. On average, each development environment is used for half of the 8-hour workday.

Which solution will meet these requirements MOST cost-effectively?

Answer options

• A. Configure each development environment with its own Amazon Aurora PostgreSQL database
• B. Configure each development environment with its own Amazon RDS for PostgreSQL Single-AZ DB instances
• C. Configure each development environment with its own Amazon Aurora On-Demand PostgreSQL-Compatible database
• D. Configure each development environment with its own Amazon S3 bucket by using Amazon S3 Object Select

Correct answer: C

Explanation

Amazon Aurora On-Demand (Serverless) is the most cost-effective option because it automatically scales database capacity and shuts down when not in use, which perfectly fits the intermittent 4-hour daily usage pattern. Standard Amazon RDS and provisioned Amazon Aurora instances run continuously and incur charges even when idle unless manually managed. Amazon S3 Object Select is not a relational database service and cannot support a PostgreSQL database schema.