A company runs an Amazon Aurora MySQL database for a development environment that is used only a few hours per day. The workload is intermittent and does not require consistent performance. Which Aurora configuration would be most cost-effective?

Aurora Provisioned with a small instance type

Aurora Provisioned with a large instance type

Aurora Provisioned with Multi-AZ deployment

A company runs an Amazon RDS for Oracle database with Provisioned IOPS storage. The database has a predictable workload that requires a consistent 5,000 IOPS. The team notices that the current storage configuration is over-provisioned and wants to reduce costs. What is the most cost-effective way to maintain the required IOPS?

Use Magnetic storage to reduce costs

Switch to General Purpose SSD (gp2) without changing IOPS

Keep the current IOPS to avoid any risk of throttling

Reduce the provisioned IOPS to the actual requirement of 5,000

A team is migrating an on-premises MySQL database to Amazon RDS. The database currently uses 8 vCPUs and 32 GB of memory, but monitoring shows average CPU utilization is only 10% and memory usage is 40%. The workload is steady and does not have large spikes. What is the most cost-effective approach for selecting the RDS instance?

Provision the same instance size to avoid any risk of performance degradation

Use a larger instance size to ensure headroom for future growth

Use a Multi-AZ deployment with the same instance size

Provision a smaller instance size that meets the actual performance requirements

A startup wants to run a PostgreSQL database but has a small team and cannot afford to hire a dedicated database administrator. They need automated backups, software patching, and high availability. Which AWS service would best meet these needs while minimizing operational overhead?

PostgreSQL on Amazon EC2 with a custom AMI

A company runs a business intelligence (BI) application that generates daily reports from a 10 TB relational dataset. The reports are generated once per day and take about 30 minutes to run. The company wants to minimize database costs while keeping the reporting workload performant. The data is stored in a relational schema with complex joins. Which solution should the solutions architect recommend?

Use Amazon DynamoDB with on-demand capacity

Use Amazon Redshift and pause the cluster when not in use

Use Amazon RDS for MySQL on a db.r5.2xlarge instance

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

AWSCertified Solutions Architect - Associate

Domain 4Objective 3

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

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 6–10

6foundation · easy
A company runs an Amazon Aurora MySQL database for a development environment that is used only a few hours per day. The workload is intermittent and does not require consistent performance. Which Aurora configuration would be most cost-effective?
Select an answer first
7foundation · easy
A company runs an Amazon RDS for Oracle database with Provisioned IOPS storage. The database has a predictable workload that requires a consistent 5,000 IOPS. The team notices that the current storage configuration is over-provisioned and wants to reduce costs. What is the most cost-effective way to maintain the required IOPS?
Select an answer first
8foundation · easy
A team is migrating an on-premises MySQL database to Amazon RDS. The database currently uses 8 vCPUs and 32 GB of memory, but monitoring shows average CPU utilization is only 10% and memory usage is 40%. The workload is steady and does not have large spikes. What is the most cost-effective approach for selecting the RDS instance?
Select an answer first
9foundation · easy
A startup wants to run a PostgreSQL database but has a small team and cannot afford to hire a dedicated database administrator. They need automated backups, software patching, and high availability. Which AWS service would best meet these needs while minimizing operational overhead?
Select an answer first
10application · medium
A company runs a business intelligence (BI) application that generates daily reports from a 10 TB relational dataset. The reports are generated once per day and take about 30 minutes to run. The company wants to minimize database costs while keeping the reporting workload performant. The data is stored in a relational schema with complex joins. Which solution 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 2)

Questions 6–10

A company runs an Amazon Aurora MySQL database for a development environment that is used only a few hours per day. The workload is intermittent and does not require consistent performance. Which Aurora configuration would be most cost-effective?

A startup wants to run a PostgreSQL database but has a small team and cannot afford to hire a dedicated database administrator. They need automated backups, software patching, and high availability. Which AWS service would best meet these needs while minimizing operational overhead?

Keep studying — Design Cost-Optimized Architectures