A solutions architect is designing a database architecture for an application that has unpredictable traffic and needs to minimize costs. Which database service is designed to scale automatically and charge based on usage?

Amazon RDS with Provisioned IOPS

A company runs a multi-tier web application on AWS. The application uses Amazon RDS for MySQL for its transactional data and Amazon ElastiCache for Redis for caching. The team has noticed that the cache hit ratio is low, and the database is experiencing high read load. The cache is populated using a cache-aside pattern. What should a solutions architect do to improve the cache hit ratio?

Pre-warm the cache with frequently accessed data during off-peak hours.

Increase the TTL of the cached items to reduce the frequency of cache misses.

Use a write-through caching strategy to populate the cache on every write.

Analyze the application's access patterns and adjust the cache key design to improve data locality.

A company runs a reporting application that queries an Amazon Aurora PostgreSQL database. The reporting queries are complex and run for a long time, causing performance degradation for the primary application. The company wants to isolate the reporting workload from the primary application without changing the reporting queries. What should a solutions architect do?

Increase the instance class of the Aurora primary instance to handle the additional load.

Use Amazon RDS Proxy to route the reporting queries to a different database.

Create an Aurora Replica and configure the reporting application to connect to the replica's endpoint.

Enable Multi-AZ on the Aurora cluster to provide a standby for failover.

AWSCertified Solutions Architect - Associate

Domain 3Objective 3

Task 3.3: Determine High-Performing Database Solutions SAA-C03 Practice Questions (Page 4)

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

37questions here

8free pages

13concepts

13 Concepts in This Objective

AWS Global Infrastructure
Caching Strategies and Services
Data Access Patterns
Database Capacity Planning
Database Connections and Proxies
Database Engines and Use Cases
Database Replication
Database Types and Services
Configuring Read Replicas
Designing Database Architectures
Choosing Database Engine
Choosing Database Type
Integrating Caching

Questions 16–20

16foundation · easy
A solutions architect is designing a database architecture for an application that has unpredictable traffic and needs to minimize costs. Which database service is designed to scale automatically and charge based on usage?
Select an answer first
17foundation · easy
A company wants to migrate an on-premises Oracle database to AWS with minimal changes to the application. Which AWS database service is most appropriate for this migration?
Select an answer first
18foundation · easy
An application performs a high volume of INSERT and UPDATE operations. Which type of workload does this represent?
Select an answer first
19expert · hard
A company runs a multi-tier web application on AWS. The application uses Amazon RDS for MySQL for its transactional data and Amazon ElastiCache for Redis for caching. The team has noticed that the cache hit ratio is low, and the database is experiencing high read load. The cache is populated using a cache-aside pattern. What should a solutions architect do to improve the cache hit ratio?
Select an answer first
20application · medium
A company runs a reporting application that queries an Amazon Aurora PostgreSQL database. The reporting queries are complex and run for a long time, causing performance degradation for the primary application. The company wants to isolate the reporting workload from the primary application without changing the reporting queries. What should a solutions architect do?
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 3.3: Determine High-Performing Database Solutions SAA-C03 Practice Questions (Page 4)

Questions 16–20

A solutions architect is designing a database architecture for an application that has unpredictable traffic and needs to minimize costs. Which database service is designed to scale automatically and charge based on usage?

A company wants to migrate an on-premises Oracle database to AWS with minimal changes to the application. Which AWS database service is most appropriate for this migration?

An application performs a high volume of INSERT and UPDATE operations. Which type of workload does this represent?

Keep studying — Design High-Performing Architectures