AWS Cloud Practitioner Study Session Seven

January 01, 2026

I am taking the AWS Cloud Practitioner Exam in approximately three days and want to ensure I am prepared. This series will serve as non-exhaustive note taking for the information that I am internalizing as I go.

ChatGPT Summary

AWS Certified Cloud Practitioner – Database Services & Data Protection Summary

Databases are a major exam topic. AWS expects you to:

Choose the right database type (relational, NoSQL, in-memory, graph)
Understand managed vs fully managed
Match access patterns and scalability needs to the correct service

Big Picture: Choosing the Right Database

🧠 Golden Memory Trick

Tables → RDS / Aurora
Key-value → DynamoDB
Cache → ElastiCache
Documents → DocumentDB
Relationships → Neptune

Relational Databases

Amazon Relational Database Service (RDS)

What It Is

Fully managed relational database service
AWS handles:
- Backups
- Patching
- Hardware provisioning

Supported Engines

Amazon Aurora
MySQL
PostgreSQL
MariaDB
Oracle
Microsoft SQL Server

Common Use Cases

Web applications
Enterprise workloads
E-commerce product catalogs

Key Benefits of Amazon RDS

Cost Optimization

No upfront hardware costs
Reduced operational overhead

Multi-AZ Deployments (Very Testable)

Automatically replicates data to a standby instance in another AZ
Provides high availability, not performance

🧠 Memory Tip:
Multi-AZ = Availability, not speed

Performance Optimization

Automated monitoring
Read replicas for scaling read-heavy workloads

Security Controls

VPC isolation
Encryption at rest and in transit
Automated backups

🧠 Exam Clue

“Managed relational database” → RDS

Amazon Aurora (High-Performance RDS Engine)

What Makes Aurora Special

MySQL and PostgreSQL compatible
Designed for cloud-native workloads
Up to:
- 5× MySQL throughput
- 3× PostgreSQL throughput
~1/10th the cost of commercial databases

Key Aurora Benefits

High Availability

6 copies of data across 3 AZs
Automatic failover

Storage & Backup

Auto-scales from 10 GB to 128 TB
Continuous backups to Amazon S3

🧠 Memory Tip:
Aurora = “Auto-scaling, auto-healing RDS”

Common Use Cases

Gaming platforms
Media & content management
Real-time analytics

📝 Exam Clue

“High performance relational”
“MySQL/PostgreSQL compatible” → Aurora

NoSQL Databases

Amazon DynamoDB

What It Is

Fully managed NoSQL key-value and document database
Serverless and massively scalable

Use Cases

Gaming platforms
Financial applications
Mobile apps with global users

Key DynamoDB Benefits

Scalability

Auto scales with provisioned capacity
Handles millions of requests per second

Performance

Single-digit millisecond latency
SSD-backed

Availability & Durability

Replicated across multiple facilities per Region

Security

Encryption at rest and in transit

🧠 Memory Tip:
DynamoDB = “Fast, serverless, global scale”

In-Memory Databases (Caching Layer)

Amazon ElastiCache

What It Is

Fully managed in-memory data store
Supports:
- Redis / Valkey
- Memcached

Use Cases

Session storage
Gaming leaderboards
Database query caching

Key Benefits

High Performance

Microsecond latency

High Availability

Automatic failover
Multi-AZ replication

Security

Encryption at rest and in transit

🧠 Memory Tip:
ElastiCache = “Database turbocharger”

📝 Exam Clue

“Reduce database load”
“Cache frequently accessed data” → ElastiCache

Additional Database Services

Amazon DocumentDB

What It Is

Fully managed document database
MongoDB-compatible

Use Cases

Content management
Product catalogs
User profiles

Benefits

Minimal code changes from MongoDB
Auto-scaling storage up to 64 TB
Up to 15 read replicas

🧠 Memory Tip:
DocumentDB = “MongoDB on AWS”

Amazon Neptune (Graph Database)

What It Is

Fully managed graph database
Optimized for connected data

Use Cases

Social networks
Fraud detection
Recommendation engines

Benefits

Low-latency graph queries
Scales to billions of relationships
High availability with backups

🧠 Memory Tip:
Neptune = “Relationships over rows”

Backup & Migration Services

AWS Backup

What It Is

Centralized backup management
Supports:
- EBS
- EFS
- RDS
- DynamoDB
- On-prem resources

Use Cases

Compliance
Centralized DR
Organization-wide backup policies

Benefits

Single dashboard
Automated schedules
Cross-region backups
Audit logs for compliance

🧠 Memory Tip:
AWS Backup = “One place for all backups”

AWS Database Migration Service (DMS)

What It Is

Migrates databases to AWS
Source database remains online

Key Benefit

Minimal downtime during migration

🧠 Memory Tip:
DMS = “Move databases without stopping them”

Final Exam Takeaways

RDS = Managed relational databases
Aurora = High-performance RDS
DynamoDB = Serverless NoSQL
ElastiCache = In-memory caching
DocumentDB = MongoDB-compatible documents
Neptune = Graph relationships
AWS Backup = Centralized backups
DMS = Low-downtime migrations

One-Glance Decision Table

Need	Service
Relational tables	RDS / Aurora
Massive scale, low latency	DynamoDB
Reduce DB load	ElastiCache
JSON / documents	DocumentDB
Relationship queries	Neptune
Centralized backups	AWS Backup
Minimal downtime migration	DMS

Study materials:

Raw Input Notes:

Relational Databases:

Amazon Relational Database Service (Amazon RDS): Managed relational database service that handles routine database tasks (backups, patching, hardware provisioning)

Supported Database Engines Amazon RDS supports different database engines including Amazon Aurora, MySQL, PostgreSQL, Microsoft SQL Server, MariaDB, Oracle Database

Use Cases Web apps, enterprise workloads, product inventories for e-commerce applications

Benefits

Cost Optimization: Eliminates the high upfront costs of purchasing / maintainig database hardware infrastructure, and, as a managed service, it reduces OPEX by automating time consuming admin tasks (backups, patching, etc)
Multi-AZ: Improves DB reliability. Automatically replicates data to standby instance in different AZ.
Performance Optimization: Enhances DB performance through automated management of resource allocation, monitoring, optimization tasks. Includes features like automated backups and read replicas.
Security Controls: Enhances DB security thtough multiple layers of protection; VPC isolation as well as encryption at rest and in-transit. Automated backups, offers Multi-AZ deployments for resiliency against potential system failures.

Amazon Aurora: Managed relational database designed to help reduce unnecessary I/O ops, compatible with MySQL and PostgreSQL, provides high performance and availability, automatically scales alongside workloads. (Provides comparable performance to high-end commercial databases but at one-tenth the cost)

Use Cases: Gaming applications, media and content management, real-time analytics

Benefits:

High Performance and Availability: 5x throughput of standard MySQL and 3x throughput of PostgresSQL. Uses distributed storage system across multiple nodes to provide high performance and availability.
Automated Storage and Backup Management: Automatically grows storage from 10 GB to 128 TB based on actual data usage. Eliminates guesswork in capacity planning. Continuously backs up database to Amazon S3 for point-in-time recovery.
Advanced Replication and Fault Tolerance: Replicates six copies of data across 3 AZs. Automatically detect DB failures and redirects traffic to healthy replicas without data loss.

NoSQL Databases:

Amazon DynamoDB: Fully managed NoSQL database service, provides fast and predictable performance for document and key-val data structures. Ideal for apps that require high performance and seamless scaling. Use Cases: Gaming platforms, financial service applications, mobile applications with global user bases.

Benefits:

Scalability with Provisioned Capacity: Can specify target utilization levels and DynamoDB automatically provisions capacity to maintain those targets.
Consistent High Performance: Ideal for high-performance applications. Maintains consistent performance by distributing data across servers and SSD.
High Availability and Durability: Replicates data across three distinct facilities within each AWS Region.
Data Encryption: Comprehensive encryption capabilities to protect information at rest and in-transit.

In-Memory Caches

High-speed storage layer, temporarily stores frequently accessed data in comp’s main memory (RAM).

Amazon ElastiCache

Fully managed in-memory caching service. Detects and replaces failed nodes, which make it ideal for applications that need consistent high performance.

Use Cases

Session data management, database query enhancement, gaming leaderboards.

Benefits

High Performance for Redis, Valkey, or Memcached instances: Streamlines the deployment and maintenace of in-memory caching environments by automatically handling hardware provisioning, software patching, and monitoring.
High Availability: Can promote a replica node to become a new primary without manual intervention, with an entire recovery process finishing within minutes.
Replication Across Multiple Availability Zones: Protects against infra failures. Can configure primary and replica nodes across different AZs.
Data Encryption: Supports data encryption mechanisms to safeguard sensitive info throughout lifecycle. At-rest protects data stored in disk storage, automated backups. In-transit secures data traveling between clients and cache nodes by employing transport layer security, or TLS.

Additional Database Services

Amazon DocumentDB

Fully managed service designed to handle semistructured data, which is information that doesn’t conform to rigid relational schemas. Use Cases: Content Management systems, catalog and inventory management, user profile and personalization systems

Benefits:

MongoDB Compatibility: Can use existing MongoDB code without modification and migrate MongoDB apps to Amazon DocumentDB with minimal changes to their application role.
Performance and Scalability: Automatically scales storage up to 64 TB in 10 GB increments, can handle millions of request / second.
Increased Read Throughput Improves read throughput for high-volume applications by creating up to 15 replica instances that share underlying storage.

AWS Backup

Streamlines data protection across various AWS resources and on-prem deployments by providing a single dashboard for monitoring and managing backups.
Eliminates complexity of managing multiple backup strategies by supporting multiple storage types (Amazon EBS volumes, Amazon EFS, and various databases)
Centralizes and automates data protection processes, improving consistency and reducing admin overhead. Offers flexible scheduling options, encryption capabilities, and cross-region backup support for enhanced DR Use Cases: Centralized DR, consistent backup policies for compliance requirements, consolidating multiple backup processes through single interface.

Benefits:

Centralized Backup Management: Single dashboard to manage backups across multiple AWS services and accounts. Can create automated backup schedules that align with business requirements and compliance needs. Can set up backup policies that automatically protect new resources as they’re created.
Cross-Region Backup Redundancy: Automatic backup data across different AWS Regions for disaster recovery purposes.
Streamlined-regulatory Compliance: Detailed audit logs and reports to demonstrate compliance with regulatory requirements. Can use it to enforce backup policies across organization and track backup activities for security and compliance.

Amazon Neptune:

Fully managed graph database service, manages highly connected data sets like those used in social networking applications, excels at understanding complex relationships that are difficult to identify in relational databases, like user connections, friend networks, interaction patterns. Can maintain high performance even as data complexity grows, and offers high availability with automatic failover and backups. Use Cases: Social network user connection mapping, fraud detection systems, search and recommendation systems

Benefits: Purpose-built for Complex Relationships: Excels at storing and querying highly connected data using graph models. (Low-latency queries on highly connected data) High performance and Scalability: Delivers consistent performance at scale, processing billions of relationships in a millisecond. Automatically grows storage up to 64 TB based on application needs.

AWS Database Migration Service (DMS): Source database remains fully operational during migration, which minimizes downtime to applications.