A company runs a production Amazon RDS for PostgreSQL database on a db.r5.2xlarge instance. The workload is steady and predictable, with no plans to change instance size in the next 12 months. The company wants to reduce database costs without changing performance. What should the solutions architect recommend?

Downsize the instance to db.r5.xlarge and enable Performance Insights

Enable RDS Storage Autoscaling with a maximum storage limit

Purchase a Compute Savings Plan covering the instance family and region

Switch the database to Amazon Aurora PostgreSQL with the same instance class

A company runs an Amazon RDS for MySQL database with Provisioned IOPS (io1) storage. The database is used for a production application with steady, predictable IOPS requirements of 5,000 IOPS. The company wants to reduce storage costs without impacting performance. What should the solutions architect recommend?

Enable RDS Storage Autoscaling with a maximum of 5,000 IOPS

Migrate to gp3 storage and provision 5,000 IOPS

Keep io1 storage but reduce the provisioned IOPS to 3,000

Migrate to gp2 storage with 5,000 IOPS

A company has multiple Amazon RDS databases across different AWS accounts and regions. The finance team wants to identify which databases are underutilized and could be downsized or have reserved capacity purchased. The team needs a centralized view of database usage and costs. What should the solutions architect recommend?

Use AWS Budgets to set a cost budget for each RDS instance

Use AWS Config to track RDS instance configuration changes

Use Amazon CloudWatch to monitor CPU utilization of each RDS instance individually

Use AWS Cost Explorer to view RDS usage and costs, and use AWS Trusted Advisor to identify underutilized RDS instances

A company runs an Amazon RDS for MySQL instance that is used 24/7 for a production application. The workload is stable and predictable. Which purchasing option would provide the most significant cost savings for this database?

Purchase a Reserved Instance for a 1-year or 3-year term

Use On-Demand pricing with no commitment

Use Spot Instances for the RDS instance

Use a Savings Plan but only for the storage component

A company runs an Amazon RDS for Oracle database on a db.r5.4xlarge instance. The database has been running for 6 months, and CloudWatch metrics show that CPU utilization averages 15% and memory utilization averages 40%. The company wants to reduce costs. What should the solutions architect recommend?

Enable RDS Storage Autoscaling to reduce storage costs

Purchase a Reserved Instance for the current db.r5.4xlarge instance

Downsize the instance to db.r5.xlarge and monitor performance for 2 weeks

Switch to Amazon Aurora PostgreSQL with the same instance class

AWSCertified Solutions Architect - Associate

Domain 4Objective 3

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

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 11–15

11application · medium
A company runs a production Amazon RDS for PostgreSQL database on a db.r5.2xlarge instance. The workload is steady and predictable, with no plans to change instance size in the next 12 months. The company wants to reduce database costs without changing performance. What should the solutions architect recommend?
Select an answer first
12application · medium
A company runs an Amazon RDS for MySQL database with Provisioned IOPS (io1) storage. The database is used for a production application with steady, predictable IOPS requirements of 5,000 IOPS. The company wants to reduce storage costs without impacting performance. What should the solutions architect recommend?
Select an answer first
13application · medium
A company has multiple Amazon RDS databases across different AWS accounts and regions. The finance team wants to identify which databases are underutilized and could be downsized or have reserved capacity purchased. The team needs a centralized view of database usage and costs. What should the solutions architect recommend?
Select an answer first
14foundation · easy
A company runs an Amazon RDS for MySQL instance that is used 24/7 for a production application. The workload is stable and predictable. Which purchasing option would provide the most significant cost savings for this database?
Select an answer first
15application · medium
A company runs an Amazon RDS for Oracle database on a db.r5.4xlarge instance. The database has been running for 6 months, and CloudWatch metrics show that CPU utilization averages 15% and memory utilization averages 40%. The company wants to reduce costs. What should the solutions architect recommend?
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.

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

Questions 11–15

A company runs an Amazon RDS for MySQL instance that is used 24/7 for a production application. The workload is stable and predictable. Which purchasing option would provide the most significant cost savings for this database?

Keep studying — Design Cost-Optimized Architectures