Cover
Title Page
Copyright Page
Contents at a Glance
Contents
Table of Exercises
Introduction
What Does This Book Cover?
Interactive Online Learning Environment and Test Bank
AWS Certified Database Study Guide – Specialty (DBS-C01) Exam Objectives
Objective Map
Part I Workload-Specific Database Design
Chapter 1 Databases—from Your Server to AWS Cloud
Databases from the Beginning
1960s
1970s
1980s
1990s
2000–2010
2010–Today
Databases on Premises
Basic Infrastructure
Complex Infrastructure and Resiliency
Management
Databases in the Cloud
Data Remains Data
DBAs Are the Initial DevOps
DBA Career—Now What?
Summary
Chapter 2 Basic AWS Concepts
AWS Global Infrastructure
AWS Regions
AWS Availability Zones
AWS Local Zones
AWS Wavelength Zones
Points of Prescence
Networking
IP Addressing
Subnets
VPC Routing
Gateways and Connectivity Options
Security
Network Security
AWS Shared Responsibility Model
Identity and Access Management
Data Encryption
Storage at AWS
Amazon Elastic Block Storage
Amazon Elastic File System
Amazon Simple Storage Service
Operations
Monitoring and Logging
Amazon CloudWatch
AWS CloudTrail
Summary
Chapter 3 Purpose-Built Databases
Data store Concepts
Data Access Patterns
Latency
Scaling
Transaction Support
Consistency
Volume
Durability
Availability
Security/Compliance
Business Logic
Cost
Purpose-Built Databases on AWS
Relational Databases
Nonrelational Databases
Summary
Exam Essentials
Review Questions
Part II Management and Operations, Database Security, Monitoring and Troubleshooting per Workload
Chapter 4 Relational Databases on AWS
Relational Databases
Structured Query Language
Install and Manage Databases Yourself
I/O Requirement
Managing Databases on EC2
Monitoring Databases on EC2
Scaling Databases
Upgrading Databases
Managed Services for Relational Databases
Launching an RDS Instance
Managing High Availability and Scalability
Configuring RDS Parameter Groups
Configuring RDS Option Groups
Deletion Protection
RDS Pricing Model
Amazon Aurora Cloud-Native Relational Database
Amazon Aurora Storage
Amazon Aurora DB Clusters
Amazon Aurora High Availability
Amazon Aurora Global Database
Amazon Aurora Read Replica Across Regions
Amazon Aurora Serverless
Amazon Aurora Multi-master
Patch Management and Upgrade
Monitoring and Performance Management
Backup and Restore
Backtrack
Cloning an Amazon Aurora DB Cluster Volume
Auditing
Database Activity Stream in Amazon Aurora
Security
Migrating Databases
Summary
Exam Essentials
Exercises
Review Questions
Chapter 5 Low-Latency Response Time for Your Apps and APIs
Getting Started with Modern Applications and NoSQL Databases
Amazon DynamoDB
Design Considerations
Migrating Your Data into DynamoDB
Query Considerations
Amazon DynamoDB Index Options
DynamoDB Capacity Modes
Other Features of DynamoDB
Backup/Restore
Scalability
Security
Monitoring
Amazon Keyspaces
Design Considerations
Migrating Your Data into Keyspaces
Query Considerations
Keyspaces Capacity Modes
Consistency Models
Use Cases
Best Practices
Backups
Scalability
Security
Monitoring
Summary
Exam Essentials
Exercises
Review Questions
Chapter 6 Document Databases in the Cloud
Introducing Document Databases
Getting Started with Amazon DocumentDB
Creating an Amazon DocumentDB Cluster
Amazon DocumentDB Architecture
Security
Access Control
Data Protection
Other Features
Backup and Restore
Performance and Scaling
Compatibility between Amazon DocumentDB and MongoDB
Migrating from MongoDB to Amazon DocumentDB
Amazon DocumentDB Monitoring
Developing with Amazon DocumentDB
When to Use DynamoDB vs. DocumentDB
Amazon DocumentDB Pricing
Summary
Exam Essentials
Exercises
Review Questions
Chapter 7 Better Places Than Databases to Store Large Objects
Databases and Large Objects
Introducing Amazon S3
Costs of Amazon S3 vs. Elastic Block Storage
Moving LOBs to Amazon S3
Creating an S3 Bucket
Putting or Uploading Objects
Indexing LOBs in Amazon S3
Additional S3 Features
Backup and Dump Files
Other Use Cases
Pay per Usage and Scalability
Availability and Durability
Security
Access Control
Data Encryption
Summary
Exam Essentials
Exercises
Review Questions
Chapter 8 Deliver Valuable Information at the Speed Your Business Needs
Information Latency
Data Warehouses
Database Engines for Data Warehouses
Migrating Data Warehouses to Amazon Redshift Using AWS SCT
Amazon Redshift
Redshift Cluster Architecture
Table Design in Redshift
Loading Data into Redshift
Data Lakes in AWS
Redshift Spectrum
Redshift Federated Queries
Data Lakehouse
Redshift Cluster Node Types
Redshift Monitoring
Redshift Scalability
Redshift Security
Redshift Data Resilience and Backup
Time-Series Databases
Amazon Timestream
Amazon Timestream Architecture
Loading Data into Amazon Timestream
Querying Data from Amazon Timestream
Amazon Timestream Monitoring
Amazon Timestream Scalability
Amazon Timestream Security
Amazon Timestream Data Resilience and Backup
Amazon OpenSearch Service
Amazon OpenSearch Service Domain Architecture
Loading Data to Amazon OpenSearch Service
Searching for Data in Amazon OpenSearch Service
Amazon OpenSearch Service Monitoring
Amazon OpenSearch Service Scalability
Amazon OpenSearch Service Security
Amazon OpenSearch Service Data Resilience and Backup
Summary
Exam Essentials
Exercises
Review Questions
Chapter 9 Discovering Relationships Using Graph Databases
Graph Databases
When to Use Graph Databases
Common Use Cases
Amazon Neptune
High-Level Architecture
Graph Models and Query Languages
Using and Extracting Data from Amazon Neptune
Storage Architecture
Data Resilience
Read Replicas
Scalability
Availability
Failover Policy
Security
Automatic Backup and Restore
Monitoring
Summary
Exam Essentials
Review Questions
Chapter 10 Immutable Database and Traceable Transactions
Amazon Quantum Ledger Database
Amazon QLDB Components
Working with Amazon QLDB
Backup and Durability
Performance and Scalability
Security
Monitoring
Best Practices
Summary
Exam Essentials
Exercises
Review Questions
Chapter 11 Caching Data with In-Memory Databases
Built-in Database Cache
Local Application Cache
In-Memory Databases
Caching Use Cases
Remote Cache Strategies
Caching Data in AWS
Caching Data with ElastiCache
Memcached or Redis?
Memcached Architecture on Amazon ElastiCache Service
Redis Architecture on the Amazon ElastiCache Service
Backup and Restore
Security
Monitoring
Amazon MemoryDB for Redis
Summary
Exam Essentials
Exercises
Review Questions
Part III Deployment and Migration
Chapter 12 Migrating Your Data to AWS
Network Communication and Data Migration
Optimizing Bandwidth Usage
Database Migration to AWS
AWS Schema Conversion Tool
AWS Data Migration Service
Setting Up AWS DMS
AWS DMS Continuous Replication
AWS DMS Best Practices
AWS DMS Security
AWS DMS Resilience
Other AWS Services for Data Migration
AWS DataSync
AWS Snow Family
AWS Storage Gateway
Choosing the Migration Path
One or Many Target Databases
Small, Noncritical Databases
Very Large Databases
Summary
Exam Essentials
Exercises
Review Questions
Chapter 13 Disaster Recovery
Understanding and Planning Disaster Recovery Requirements
Recovery Point Objective and Recovery Time Objective
Challenges in Disaster Recovery
Managing Disaster Recovery Strategies
Backup and Recovery Strategy
Database Replication Methods: Multi-AZ and Cross-Region Replication
Databases Deployed on EC2
Amazon RDS
Amazon Aurora
Amazon Neptune
Summary
Exam Essentials
Review Questions
Chapter 14 Save Time and Reduce Errors Automating Your Infrastructure
AWS CloudFormation
Components
Important Concepts
Updating AWS CloudFormation Stacks
Deleting AWS CloudFormation Stacks
AWS Systems Manager Parameter Store
AWS Secrets Manager
Summary
Exam Essentials
Review Questions
Appendix: Answers to Review Questions
Chapter 3: Purpose-Built Databases
Chapter 4: Relational Databases on AWS
Chapter 5: Low-Latency Response Time for Your Apps and APIs
Chapter 6: Document Databases in the Cloud
Chapter 7: Better Places Other Than Databases to Store Large Objects
Chapter 8: Deliver Valuable Information at the Speed Your Business Needs
Chapter 9: Discovering Relationships Using Graph Databases
Chapter 10: Immutable Database and Traceable Transactions
Chapter 11: Caching Data with In-Memory Databases
Chapter 12: Migrating Your Data to AWS
Chapter 13: Disaster Recovery
Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure
Index
EULA