A company runs an Amazon Aurora PostgreSQL database for a production application. The workload is predictable and runs 24/7. The company plans to use the database for at least 3 years. The company wants to minimize database costs. What should the solutions architect recommend?

Use Aurora Serverless v2 with a minimum capacity of 0.5 ACUs

Use Aurora Serverless v2 with a minimum capacity of 2 ACUs

Purchase a 1-year No Upfront Aurora Reserved Instance

Purchase a 3-year All Upfront Aurora Reserved Instance

A company uses Amazon RDS for MySQL for its production application. The database contains a table of user activity data that is only relevant for the current fiscal year. The company wants to reduce storage costs while retaining the data for potential audits. Which approach is most cost-effective?

Export the old data to Amazon S3 and remove it from the RDS database

Increase the RDS storage to accommodate the data growth

Keep all data in RDS and use compression to reduce storage size

Delete the old data permanently to save storage costs

A company runs a web application that stores session data. The application experiences highly variable traffic: near-zero usage at night, moderate usage during the day, and occasional spikes to 10x normal traffic during marketing campaigns. The session data is accessed by primary key and does not require relational queries. The company wants to minimize database costs while ensuring the application can handle the spikes. Which solution should the solutions architect recommend?

Use Amazon Aurora Serverless v2 with a minimum capacity of 2 ACUs

Use Amazon RDS for MySQL with a db.t3.small instance and Storage Autoscaling

Use Amazon DynamoDB with on-demand capacity mode

Use Amazon ElastiCache for Redis with a single cache node

A company stores historical application logs in an Amazon RDS for PostgreSQL database. The logs are rarely accessed after 90 days, but they must be retained for compliance for 7 years. Which strategy would most effectively reduce database storage costs?

Archive the logs to Amazon S3 with a lifecycle policy that transitions them to S3 Glacier Deep Archive after 90 days

Delete the logs after 90 days to save storage costs

Compress the logs and store them in the same RDS instance

Keep the logs in the RDS database and increase the allocated storage

A company has a production Amazon Aurora database that runs continuously and has a predictable workload. The team wants to reduce database costs without changing the instance configuration. Which option would provide the most cost savings?

Use Spot Instances for the Aurora database

Purchase an Aurora Savings Plan or Reserved Instance

Switch to a smaller instance type and enable Auto Scaling

Use On-Demand pricing and rely on Auto Scaling to adjust capacity

AWSCertified Solutions Architect - Associate

Domain 4Objective 3

Task 4.3: Design Cost-Optimized Database Solutions SAA-C03 Practice Questions (Page 4)

Part of the Design Cost-Optimized Architectures domain, which makes up ~31% of our current practice bank. AWS does not publish an official question count, but from its 130-minute exam (~50–85 total, ~16–26 in this domain), expect 4–7 from this objective — we provide 26 practice questions to prepare you well beyond it. (estimate)

26questions here

6free pages

8concepts

Questions 16–20

16application · medium
A company runs an Amazon Aurora PostgreSQL database for a production application. The workload is predictable and runs 24/7. The company plans to use the database for at least 3 years. The company wants to minimize database costs. What should the solutions architect recommend?
Select an answer first
17foundation · easy
A company uses Amazon RDS for MySQL for its production application. The database contains a table of user activity data that is only relevant for the current fiscal year. The company wants to reduce storage costs while retaining the data for potential audits. Which approach is most cost-effective?
Select an answer first
18application · medium
A company runs a web application that stores session data. The application experiences highly variable traffic: near-zero usage at night, moderate usage during the day, and occasional spikes to 10x normal traffic during marketing campaigns. The session data is accessed by primary key and does not require relational queries. The company wants to minimize database costs while ensuring the application can handle the spikes. Which solution should the solutions architect recommend?
Select an answer first
19foundation · easy
A company stores historical application logs in an Amazon RDS for PostgreSQL database. The logs are rarely accessed after 90 days, but they must be retained for compliance for 7 years. Which strategy would most effectively reduce database storage costs?
Select an answer first
20foundation · easy
A company has a production Amazon Aurora database that runs continuously and has a predictable workload. The team wants to reduce database costs without changing the instance configuration. Which option would provide the most cost savings?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to SAA-C03

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by AWS. “SAA-C03” is a trademark of its owner, used for identification only.