Home / SAA-C03 / Objective 4.3

Domain 4: Design Cost-Optimized Architectures · 20% of the exam · Full exam outline

4.3 Design cost-optimized database solutions

What this objective covers · 5% of the exam

AWS cost management service features (for example, cost allocation tags, multi-account billing); AWS cost management tools with appropriate use cases (for example, AWS Cost Explorer, AWS Budgets, AWS Cost and Usage Report); Caching strategies; Data retention policies; Database capacity planning (for example, capacity units); Database connections and proxies; Database engines with appropriate use cases (for example, heterogeneous migrations, homogeneous migrations); Database replication (for example, read replicas); Database types and services (for example, relational compared with non-relational, Amazon Aurora, Amazon DynamoDB); Designing appropriate backup and retention policies (for example, snapshot frequency); Determining an appropriate database engine (for example, MySQL compared with PostgreSQL); Determining cost-effective AWS database services with appropriate use cases (for example, DynamoDB compared with Amazon RDS, serverless); Determining cost-effective AWS database types (for example, time series format, columnar format); Migrating database schemas and data to different locations and/or different database engines

Practice questions

Question 1easy

A concert-ticketing app writes a seat-hold item to DynamoDB each time a buyer starts checkout. The app already ignores holds older than 15 minutes, so expired holds only waste storage. Today a nightly job scans the table and deletes them, consuming write capacity. What is the most cost-effective way to clean up expired holds?

Included in Master: master every domain.See plans
Question 2easy

A logistics firm is choosing an engine for a new order-management system on Amazon RDS. Many users update the same tables concurrently all day, and reporting depends on complex queries that would benefit from materialized views. Which engine fits better?

Included in Master: master every domain.See plans