Home / SAA-C03 / Objective 3.3

Domain 3: Design High-Performing Architectures · 24% of the exam · Full exam outline

3.3 Determine high-performing database solutions

What this objective covers · 5% of the exam

AWS global infrastructure (for example, Availability Zones, AWS Regions); Caching strategies and services (for example, Amazon ElastiCache); Data access patterns (for example, read-intensive compared with write-intensive); Database capacity planning (for example, capacity units, instance types, Provisioned IOPS); 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, serverless, relational compared with non-relational, in-memory); Configuring read replicas to meet business requirements; Designing database architectures; Determining an appropriate database engine (for example, MySQL compared with PostgreSQL); Determining an appropriate database type (for example, Amazon Aurora, Amazon DynamoDB); Integrating caching to meet business requirements

Practice questions

Question 1easy

Month-end reporting queries are slowing a production RDS for MySQL database that runs as a Multi-AZ DB instance deployment. A colleague suggests pointing the reports at the existing standby, since it already holds a synchronous copy. The standby cannot take that role. What should the architect do instead?

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

A logistics company is building an order-routing system on Amazon RDS. It must handle frequent concurrent writes from many users, run complex queries, and rely on materialized views. Which engine fits best?

Included in Master: master every domain.See plans