AWS Certified Database Study Guide
Specialty (DBS-C01) Exam
1. Edition May 2023
496 Pages, Softcover
Textbook
ISBN:
978-1-119-77895-0
John Wiley & Sons
Validate your AWS Cloud database skills!
AWS Certified Database Study Guide: Specialty (DBS-C01) Exam focuses on helping you to understand the basic job role of a database administrator / architect and to prepare for taking the certification exam. This is your opportunity to take the next step in your career by expanding and validating your skills on the AWS Cloud, and performing a database-focused role. AWS is the frontrunner in cloud computing products and services, and this study guide will help you to gain an understanding of core AWS services, uses, and basic AWS database design and deployment best practices. AWS offers more than relational and nonrelation databases, they offer purpose built databases, which allow you to utilize database services prebuilt to meet your business requirements. If you are looking to take the Specialty (DBS-C01) exam, this Study Guide is what you need for comprehensive content and robust study tools that will help you gain the edge on exam day and throughout your career.
AWS Certified Database certification offers a great way for IT professionals to achieve industry recognition as cloud experts. This new study guide is perfect for you if you perform a database-focused role and want to pass the DBS-C01 exam to prove your knowledge of how to design and deploy secure and robust database applications on AWS technologies. IT cloud professionals who hold AWS certifications are in great demand, and this certification could take your career to the next level!
* Master all the key concepts you need to pass the AWS Certified Database Specialty (DBS-C01) Exam
* Further your career by demonstrating your cloud computing expertise and your knowledge of databases and database services
* Understand the concept of purpose built databases, allowing you to pick the right tool for the right job.
* Review deployment and migration, management and operations, monitoring and troubleshooting, database security, and more
* Access the Sybex online learning environment and test bank for interactive study aids and practice questions
Readers will also get one year of FREE access after activation to Sybex's superior online interactive learning environment and test bank, including hundreds of questions, a practice exam, electronic flashcards, and a glossary of key terms.
Introduction xxv
Assessment Test xxxv
Part I Workload- Specific Database Design 1
Chapter 1 Databases-- from Your Server to AWS Cloud 3
Databases from the Beginning 4
1960s 5
1970s 5
1980s 6
1990s 7
2000-2010 7
2010-Today 8
Databases on Premises 9
Basic Infrastructure 9
Complex Infrastructure and Resiliency 9
Management 10
Databases in the Cloud 10
Data Remains Data 11
DBAs Are the Initial DevOps 11
DBA Career-- Now What? 11
Summary 12
Chapter 2 Basic AWS Concepts 13
AWS Global Infrastructure 14
AWS Regions 14
AWS Availability Zones 14
AWS Local Zones 15
AWS Wavelength Zones 15
Points of Prescence 16
Networking 16
IP Addressing 17
Subnets 17
VPC Routing 17
Gateways and Connectivity Options 18
Security 21
Network Security 21
AWS Shared Responsibility Model 22
Identity and Access Management 24
Data Encryption 25
Storage at AWS 26
Amazon Elastic Block Storage 27
Amazon Elastic File System 28
Amazon Simple Storage Service 29
Operations 31
Monitoring and Logging 32
Amazon CloudWatch 32
AWS CloudTrail 33
Summary 34
Chapter 3 Purpose- Built Databases 35
Data store Concepts 36
Data Access Patterns 37
Latency 37
Scaling 37
Transaction Support 38
Consistency 38
Volume 38
Durability 39
Availability 39
Security/Compliance 39
Business Logic 39
Cost 40
Purpose- Built Databases on AWS 40
Relational Databases 40
Nonrelational Databases 42
Summary 46
Exam Essentials 46
Review Questions 48
Part II Management and Operations, Database Security, Monitoring and Troubleshooting Per Workload 51
Chapter 4 Relational Databases on AWS 53
Relational Databases 54
Structured Query Language 55
Install and Manage Databases Yourself 57
I/O Requirement 58
Managing Databases on EC 2 60
Monitoring Databases on EC 2 60
Scaling Databases 61
Upgrading Databases 61
Managed Services for Relational Databases 62
Launching an RDS Instance 63
Managing High Availability and Scalability 72
Configuring RDS Parameter Groups 74
Configuring RDS Option Groups 76
Deletion Protection 78
RDS Pricing Model 79
Amazon Aurora Cloud- Native Relational Database 79
Amazon Aurora Storage 80
Amazon Aurora DB Clusters 81
Amazon Aurora High Availability 82
Amazon Aurora Global Database 82
Amazon Aurora Read Replica Across Regions 84
Amazon Aurora Serverless 84
Amazon Aurora Multi- master 85
Patch Management and Upgrade 86
Monitoring and Performance Management 86
Backup and Restore 90
Backtrack 94
Cloning an Amazon Aurora DB Cluster Volume 94
Auditing 97
Database Activity Stream in Amazon Aurora 98
Security 98
Migrating Databases 101
Summary 101
Exam Essentials 101
Exercises 102
Review Questions 106
Chapter 5 Low- Latency Response Time for Your Apps and APIs 109
Getting Started with Modern Applications and NoSQL Databases 110
Amazon DynamoDB 112
Design Considerations 112
Migrating Your Data into DynamoDB 114
Query Considerations 116
Amazon DynamoDB Index Options 120
DynamoDB Capacity Modes 122
Other Features of DynamoDB 124
Backup/Restore 134
Scalability 136
Security 139
Monitoring 143
Amazon Keyspaces 148
Design Considerations 148
Migrating Your Data into Keyspaces 149
Query Considerations 150
Keyspaces Capacity Modes 151
Consistency Models 152
Uses Cases 153
Best Practices 153
Backups 154
Scalability 155
Security 155
Monitoring 157
Summary 158
Exam Essentials 159
Exercises 159
Review Questions 162
Chapter 6 Document Databases in the Cloud 165
Introducing Document Databases 166
Getting Started with Amazon DocumentDB 170
Creating an Amazon DocumentDB Cluster 174
Amazon DocumentDB Architecture 175
Security 177
Access Control 177
Data Protection 178
Other Features 179
Backup and Restore 180
Performance and Scaling 182
Compatibility between Amazon DocumentDB and MongoDB 182
Migrating from MongoDB to Amazon DocumentDB 183
Amazon DocumentDB Monitoring 184
Developing with Amazon DocumentDB 187
When to Use DynamoDB vs. DocumentDB 187
Amazon DocumentDB Pricing 188
Summary 189
Exam Essentials 189
Exercises 190
Review Questions 192
Chapter 7 Better Places Than Databases to Store Large Objects 195
Databases and Large Objects 196
Introducing Amazon S 3 198
Costs of Amazon S3 vs. Elastic Block Storage 200
Moving LOBs to Amazon S 3 204
Creating an S3 Bucket 204
Putting or Uploading Objects 206
Indexing LOBs in Amazon S 3 208
Additional S3 Features 211
Backup and Dump Files 211
Other Use Cases 211
Pay per Usage and Scalability 212
Availability and Durability 213
Security 214
Access Control 214
Data Encryption 215
Summary 216
Exam Essentials 216
Exercises 217
Review Questions 219
Chapter 8 Deliver Valuable Information at the Speed Your Business Needs 225
Information Latency 226
Data Warehouses 229
Database Engines for Data Warehouses 231
Migrating Data Warehouses to Amazon Redshift Using Aws Sct 233
Amazon Redshift 235
Redshift Cluster Architecture 235
Table Design in Redshift 235
Loading Data into Redshift 240
Data Lakes in AWS 241
Redshift Spectrum 242
Redshift Federated Queries 242
Data Lakehouse 242
Redshift Cluster Node Types 243
Redshift Monitoring 244
Redshift Scalability 245
Redshift Security 246
Redshift Data Resilience and Backup 247
Time- Series Databases 249
Amazon Timestream 251
Amazon Timestream Architecture 252
Loading Data into Amazon Timestream 253
Querying Data from Amazon Timestream 254
Amazon Timestream Monitoring 255
Amazon Timestream Scalability 255
Amazon Timestream Security 256
Amazon Timestream Data Resilience and Backup 257
Amazon OpenSearch Service 257
Amazon OpenSearch Service Domain Architecture 257
Loading Data to Amazon OpenSearch Service 257
Searching for Data in Amazon OpenSearch Service 258
Amazon OpenSearch Service Monitoring 259
Amazon OpenSearch Service Scalability 259
Amazon OpenSearch Service Security 259
Amazon OpenSearch Service Data Resilience and Backup 259
Summary 260
Exam Essentials 261
Exercises 261
Review Questions 271
Chapter 9 Discovering Relationships Using Graph Databases 275
Graph Databases 276
When to Use Graph Databases 277
Common Use Cases 278
Amazon Neptune 279
High- Level Architecture 279
Graph Models and Query Languages 280
Using and Extracting Data from Amazon Neptune 282
Storage Architecture 284
Data Resilience 284
Read Replicas 284
Scalability 286
Availability 287
Failover Policy 287
Security 288
Automatic Backup and Restore 289
Monitoring 290
Summary 291
Exam Essentials 291
Review Questions 292
Chapter 10 Immutable Database and Traceable Transactions 295
Amazon Quantum Ledger Database 296
Amazon QLDB Components 297
Working with Amazon QLDB 300
Backup and Durability 303
Performance and Scalability 304
Security 305
Monitoring 306
Best Practices 307
Summary 307
Exam Essentials 308
Exercises 308
Review Questions 311
Chapter 11 Caching Data with In- Memory Databases 313
Built- in Database Cache 314
Local Application Cache 315
In- Memory Databases 315
Caching Use Cases 315
Remote Cache Strategies 316
Caching Data in AWS 317
Caching Data with ElastiCache 319
Memcached or Redis? 319
Memcached Architecture on Amazon ElastiCache Service 320
Redis Architecture on the Amazon ElastiCache Service 321
Backup and Restore 324
Security 324
Monitoring 325
Amazon MemoryDB for Redis 325
Summary 326
Exam Essentials 326
Exercises 327
Review Questions 334
Part III Deployment and Migration 337
Chapter 12 Migrating Your Data to AWS 339
Network Communication and Data Migration 340
Optimizing Bandwidth Usage 343
Database Migration to AWS 343
AWS Schema Conversion Tool 344
AWS Data Migration Service 347
Setting Up AWS DMS 350
AWS DMS Continuous Replication 352
AWS DMS Best Practices 353
AWS DMS Security 356
AWS DMS Resilience 356
Other AWS Services for Data Migration 357
AWS DataSync 357
AWS Snow Family 357
AWS Storage Gateway 358
Choosing the Migration Path 358
One or Many Target Databases 358
Small, Noncritical Databases 359
Very Large Databases 359
Summary 360
Exam Essentials 360
Exercises 361
Review Questions 365
Chapter 13 Disaster Recovery 369
Understanding and Planning Disaster Recovery Requirements 370
Recovery Point Objective and Recovery Time Objective 371
Challenges in Disaster Recovery 371
Managing Disaster Recovery Strategies 373
Backup and Recovery Strategy 373
Database Replication Methods: Multi- AZ and Cross- Region Replication 373
Databases Deployed on EC 2 374
Amazon RDS 375
Amazon Aurora 378
Amazon Neptune 383
Summary 384
Exam Essentials 384
Review Questions 386
Chapter 14 Save Time and Reduce Errors Automating Your Infrastructure 389
AWS CloudFormation 390
Components 393
Important Concepts 400
Updating AWS CloudFormation Stacks 403
Deleting AWS CloudFormation Stacks 408
AWS Systems Manager Parameter Store 409
AWS Secrets Manager 411
Summary 415
Exam Essentials 415
Review Questions 416
Appendix Answers to Review Questions 421
Chapter 3: Purpose- Built Databases 422
Chapter 4: Relational Databases on AWS 422
Chapter 5: Low- Latency Response Time for Your Apps and APIs 424
Chapter 6: Document Databases in the Cloud 425
Chapter 7: Better Places Other Than Databases to Store Large Objects 426
Chapter 8: Deliver Valuable Information at the Speed Your Business Needs 427
Chapter 9: Discovering Relationships Using Graph Databases 429
Chapter 10: Immutable Database and Traceable Transactions 431
Chapter 11: Caching Data with In- Memory Databases 432
Chapter 12: Migrating Your Data to AWS 433
Chapter 13: Disaster Recovery 434
Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure 436
Index 439
Assessment Test xxxv
Part I Workload- Specific Database Design 1
Chapter 1 Databases-- from Your Server to AWS Cloud 3
Databases from the Beginning 4
1960s 5
1970s 5
1980s 6
1990s 7
2000-2010 7
2010-Today 8
Databases on Premises 9
Basic Infrastructure 9
Complex Infrastructure and Resiliency 9
Management 10
Databases in the Cloud 10
Data Remains Data 11
DBAs Are the Initial DevOps 11
DBA Career-- Now What? 11
Summary 12
Chapter 2 Basic AWS Concepts 13
AWS Global Infrastructure 14
AWS Regions 14
AWS Availability Zones 14
AWS Local Zones 15
AWS Wavelength Zones 15
Points of Prescence 16
Networking 16
IP Addressing 17
Subnets 17
VPC Routing 17
Gateways and Connectivity Options 18
Security 21
Network Security 21
AWS Shared Responsibility Model 22
Identity and Access Management 24
Data Encryption 25
Storage at AWS 26
Amazon Elastic Block Storage 27
Amazon Elastic File System 28
Amazon Simple Storage Service 29
Operations 31
Monitoring and Logging 32
Amazon CloudWatch 32
AWS CloudTrail 33
Summary 34
Chapter 3 Purpose- Built Databases 35
Data store Concepts 36
Data Access Patterns 37
Latency 37
Scaling 37
Transaction Support 38
Consistency 38
Volume 38
Durability 39
Availability 39
Security/Compliance 39
Business Logic 39
Cost 40
Purpose- Built Databases on AWS 40
Relational Databases 40
Nonrelational Databases 42
Summary 46
Exam Essentials 46
Review Questions 48
Part II Management and Operations, Database Security, Monitoring and Troubleshooting Per Workload 51
Chapter 4 Relational Databases on AWS 53
Relational Databases 54
Structured Query Language 55
Install and Manage Databases Yourself 57
I/O Requirement 58
Managing Databases on EC 2 60
Monitoring Databases on EC 2 60
Scaling Databases 61
Upgrading Databases 61
Managed Services for Relational Databases 62
Launching an RDS Instance 63
Managing High Availability and Scalability 72
Configuring RDS Parameter Groups 74
Configuring RDS Option Groups 76
Deletion Protection 78
RDS Pricing Model 79
Amazon Aurora Cloud- Native Relational Database 79
Amazon Aurora Storage 80
Amazon Aurora DB Clusters 81
Amazon Aurora High Availability 82
Amazon Aurora Global Database 82
Amazon Aurora Read Replica Across Regions 84
Amazon Aurora Serverless 84
Amazon Aurora Multi- master 85
Patch Management and Upgrade 86
Monitoring and Performance Management 86
Backup and Restore 90
Backtrack 94
Cloning an Amazon Aurora DB Cluster Volume 94
Auditing 97
Database Activity Stream in Amazon Aurora 98
Security 98
Migrating Databases 101
Summary 101
Exam Essentials 101
Exercises 102
Review Questions 106
Chapter 5 Low- Latency Response Time for Your Apps and APIs 109
Getting Started with Modern Applications and NoSQL Databases 110
Amazon DynamoDB 112
Design Considerations 112
Migrating Your Data into DynamoDB 114
Query Considerations 116
Amazon DynamoDB Index Options 120
DynamoDB Capacity Modes 122
Other Features of DynamoDB 124
Backup/Restore 134
Scalability 136
Security 139
Monitoring 143
Amazon Keyspaces 148
Design Considerations 148
Migrating Your Data into Keyspaces 149
Query Considerations 150
Keyspaces Capacity Modes 151
Consistency Models 152
Uses Cases 153
Best Practices 153
Backups 154
Scalability 155
Security 155
Monitoring 157
Summary 158
Exam Essentials 159
Exercises 159
Review Questions 162
Chapter 6 Document Databases in the Cloud 165
Introducing Document Databases 166
Getting Started with Amazon DocumentDB 170
Creating an Amazon DocumentDB Cluster 174
Amazon DocumentDB Architecture 175
Security 177
Access Control 177
Data Protection 178
Other Features 179
Backup and Restore 180
Performance and Scaling 182
Compatibility between Amazon DocumentDB and MongoDB 182
Migrating from MongoDB to Amazon DocumentDB 183
Amazon DocumentDB Monitoring 184
Developing with Amazon DocumentDB 187
When to Use DynamoDB vs. DocumentDB 187
Amazon DocumentDB Pricing 188
Summary 189
Exam Essentials 189
Exercises 190
Review Questions 192
Chapter 7 Better Places Than Databases to Store Large Objects 195
Databases and Large Objects 196
Introducing Amazon S 3 198
Costs of Amazon S3 vs. Elastic Block Storage 200
Moving LOBs to Amazon S 3 204
Creating an S3 Bucket 204
Putting or Uploading Objects 206
Indexing LOBs in Amazon S 3 208
Additional S3 Features 211
Backup and Dump Files 211
Other Use Cases 211
Pay per Usage and Scalability 212
Availability and Durability 213
Security 214
Access Control 214
Data Encryption 215
Summary 216
Exam Essentials 216
Exercises 217
Review Questions 219
Chapter 8 Deliver Valuable Information at the Speed Your Business Needs 225
Information Latency 226
Data Warehouses 229
Database Engines for Data Warehouses 231
Migrating Data Warehouses to Amazon Redshift Using Aws Sct 233
Amazon Redshift 235
Redshift Cluster Architecture 235
Table Design in Redshift 235
Loading Data into Redshift 240
Data Lakes in AWS 241
Redshift Spectrum 242
Redshift Federated Queries 242
Data Lakehouse 242
Redshift Cluster Node Types 243
Redshift Monitoring 244
Redshift Scalability 245
Redshift Security 246
Redshift Data Resilience and Backup 247
Time- Series Databases 249
Amazon Timestream 251
Amazon Timestream Architecture 252
Loading Data into Amazon Timestream 253
Querying Data from Amazon Timestream 254
Amazon Timestream Monitoring 255
Amazon Timestream Scalability 255
Amazon Timestream Security 256
Amazon Timestream Data Resilience and Backup 257
Amazon OpenSearch Service 257
Amazon OpenSearch Service Domain Architecture 257
Loading Data to Amazon OpenSearch Service 257
Searching for Data in Amazon OpenSearch Service 258
Amazon OpenSearch Service Monitoring 259
Amazon OpenSearch Service Scalability 259
Amazon OpenSearch Service Security 259
Amazon OpenSearch Service Data Resilience and Backup 259
Summary 260
Exam Essentials 261
Exercises 261
Review Questions 271
Chapter 9 Discovering Relationships Using Graph Databases 275
Graph Databases 276
When to Use Graph Databases 277
Common Use Cases 278
Amazon Neptune 279
High- Level Architecture 279
Graph Models and Query Languages 280
Using and Extracting Data from Amazon Neptune 282
Storage Architecture 284
Data Resilience 284
Read Replicas 284
Scalability 286
Availability 287
Failover Policy 287
Security 288
Automatic Backup and Restore 289
Monitoring 290
Summary 291
Exam Essentials 291
Review Questions 292
Chapter 10 Immutable Database and Traceable Transactions 295
Amazon Quantum Ledger Database 296
Amazon QLDB Components 297
Working with Amazon QLDB 300
Backup and Durability 303
Performance and Scalability 304
Security 305
Monitoring 306
Best Practices 307
Summary 307
Exam Essentials 308
Exercises 308
Review Questions 311
Chapter 11 Caching Data with In- Memory Databases 313
Built- in Database Cache 314
Local Application Cache 315
In- Memory Databases 315
Caching Use Cases 315
Remote Cache Strategies 316
Caching Data in AWS 317
Caching Data with ElastiCache 319
Memcached or Redis? 319
Memcached Architecture on Amazon ElastiCache Service 320
Redis Architecture on the Amazon ElastiCache Service 321
Backup and Restore 324
Security 324
Monitoring 325
Amazon MemoryDB for Redis 325
Summary 326
Exam Essentials 326
Exercises 327
Review Questions 334
Part III Deployment and Migration 337
Chapter 12 Migrating Your Data to AWS 339
Network Communication and Data Migration 340
Optimizing Bandwidth Usage 343
Database Migration to AWS 343
AWS Schema Conversion Tool 344
AWS Data Migration Service 347
Setting Up AWS DMS 350
AWS DMS Continuous Replication 352
AWS DMS Best Practices 353
AWS DMS Security 356
AWS DMS Resilience 356
Other AWS Services for Data Migration 357
AWS DataSync 357
AWS Snow Family 357
AWS Storage Gateway 358
Choosing the Migration Path 358
One or Many Target Databases 358
Small, Noncritical Databases 359
Very Large Databases 359
Summary 360
Exam Essentials 360
Exercises 361
Review Questions 365
Chapter 13 Disaster Recovery 369
Understanding and Planning Disaster Recovery Requirements 370
Recovery Point Objective and Recovery Time Objective 371
Challenges in Disaster Recovery 371
Managing Disaster Recovery Strategies 373
Backup and Recovery Strategy 373
Database Replication Methods: Multi- AZ and Cross- Region Replication 373
Databases Deployed on EC 2 374
Amazon RDS 375
Amazon Aurora 378
Amazon Neptune 383
Summary 384
Exam Essentials 384
Review Questions 386
Chapter 14 Save Time and Reduce Errors Automating Your Infrastructure 389
AWS CloudFormation 390
Components 393
Important Concepts 400
Updating AWS CloudFormation Stacks 403
Deleting AWS CloudFormation Stacks 408
AWS Systems Manager Parameter Store 409
AWS Secrets Manager 411
Summary 415
Exam Essentials 415
Review Questions 416
Appendix Answers to Review Questions 421
Chapter 3: Purpose- Built Databases 422
Chapter 4: Relational Databases on AWS 422
Chapter 5: Low- Latency Response Time for Your Apps and APIs 424
Chapter 6: Document Databases in the Cloud 425
Chapter 7: Better Places Other Than Databases to Store Large Objects 426
Chapter 8: Deliver Valuable Information at the Speed Your Business Needs 427
Chapter 9: Discovering Relationships Using Graph Databases 429
Chapter 10: Immutable Database and Traceable Transactions 431
Chapter 11: Caching Data with In- Memory Databases 432
Chapter 12: Migrating Your Data to AWS 433
Chapter 13: Disaster Recovery 434
Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure 436
Index 439
ABOUT THE AUTHORS
Matheus Arrais is a Senior Partner Solutions Architect at Amazon Web Services.
Rene Martinez Bravet is a Solutions Architect at AWS focused on enterprise and financial services customers.
Leonardo Ciccone is a Senior Database Migration Specialist at Amazon Web Services, with a focus on database migration and modernization.
Angie Nobre Cocharero is the Database Specialist Solution Architect at Amazon Web Services for Latin America.
Érika Kurauchi is the Specialist Solution Architecture Manager at Amazon Web Services for Latin America.
Hugo Rozestraten is a Principal Data Strategy Solutions Architect and author of several AWS blog posts.
Matheus Arrais is a Senior Partner Solutions Architect at Amazon Web Services.
Rene Martinez Bravet is a Solutions Architect at AWS focused on enterprise and financial services customers.
Leonardo Ciccone is a Senior Database Migration Specialist at Amazon Web Services, with a focus on database migration and modernization.
Angie Nobre Cocharero is the Database Specialist Solution Architect at Amazon Web Services for Latin America.
Érika Kurauchi is the Specialist Solution Architecture Manager at Amazon Web Services for Latin America.
Hugo Rozestraten is a Principal Data Strategy Solutions Architect and author of several AWS blog posts.
