AWS Certified Database Study Guide: Specialty (DBS-C01) Exam

Title Page....16 Copyright....18 Dedication....19 Acknowledgments....20 About the Authors....21 About the Technical Editor....23 Table of Exercises....24 Introduction....26 What Does This Book Cover?....28 Interactive Online Learning Environment and Test Bank....31 AWS Certified Database Study Guide – Specialty (DBS-C01) Exam Objectives....33 Objective Map....34 How to Contact the Publisher....39 Assessment Test....39 Answers to Assessment Test....47 PART I: Workload-Specific Database Design....54 Chapter 1: Databases—from Your Server to AWS Cloud....55 Databases from the Beginning....55 Databases on Premises....62 Databases in the Cloud....64 Summary....66 Chapter 2: Basic AWS Concepts....67 AWS Global Infrastructure....67 Networking....70 Security....78 Storage at AWS....86 Operations....92 Monitoring and Logging....93 Summary....96 Chapter 3: Purpose-Built Databases....98 Data store Concepts....98 Purpose-Built Databases on AWS....101 Summary....108 Exam Essentials....108 Review Questions....109 PART II: Management and Operations, Database Security, Monitoring and Troubleshooting per Workload....112 Chapter 4: Relational Databases on AWS....113 Relational Databases....115 Structured Query Language....116 Install and Manage Databases Yourself....119 Managed Services for Relational Databases....126 Amazon Aurora Cloud-Native Relational Database....149 Summary....178 Exam Essentials....179 Exercises....180 Review Questions....185 Chapter 5: Low-Latency Response Time for Your Apps and APIs....190 Getting Started with Modern Applications and NoSQL Databases....192 Amazon DynamoDB....194 Amazon Keyspaces....243 Summary....258 Exam Essentials....258 Exercises....259 Review Questions....263 Chapter 6: Document Databases in the Cloud....268 Introducing Document Databases....270 Getting Started with Amazon DocumentDB....276 Creating an Amazon DocumentDB Cluster....281 Amazon DocumentDB Architecture....283 Security....286 Backup and Restore....290 Performance and Scaling....293 Compatibility between Amazon DocumentDB and MongoDB....294 Migrating from MongoDB to Amazon DocumentDB....294 Amazon DocumentDB Monitoring....296 Developing with Amazon DocumentDB....300 When to Use DynamoDB vs. DocumentDB....301 Amazon DocumentDB Pricing....302 Summary....303 Exam Essentials....303 Exercises....304 Review Questions....306 Chapter 7: Better Places Than Databases to Store Large Objects....310 Databases and Large Objects....311 Introducing Amazon S3....312 Costs of Amazon S3 vs. Elastic Block Storage....315 Moving LOBs to Amazon S3....319 Indexing LOBs in Amazon S3....324 Additional S3 Features....327 Security....330 Summary....333 Exam Essentials....333 Exercises....334 Review Questions....336 Chapter 8: Deliver Valuable Information at the Speed Your Business Needs....342 Information Latency....343 Data Warehouses....347 Amazon Redshift....356 Time-Series Databases....376 Amazon Timestream....378 Amazon OpenSearch Service....386 Summary....389 Exam Essentials....390 Exercises....391 Review Questions....404 Chapter 9: Discovering Relationships Using Graph Databases....411 Graph Databases....412 Amazon Neptune....416 Summary....431 Exam Essentials....432 Review Questions....433 Chapter 10: Immutable Database and Traceable Transactions....437 Amazon Quantum Ledger Database....438 Summary....453 Exam Essentials....453 Exercises....454 Review Questions....457 Chapter 11: Caching Data with In-Memory Databases....461 Built-in Database Cache....462 Local Application Cache....462 In-Memory Databases....463 Caching Use Cases....463 Remote Cache Strategies....464 Caching Data in AWS....466 Caching Data with ElastiCache....467 Amazon MemoryDB for Redis....477 Summary....478 Exam Essentials....478 Exercises....479 Review Questions....488 PART III: Deployment and Migration....492 Chapter 12: Migrating Your Data to AWS....493 Network Communication and Data Migration....493 Database Migration to AWS....497 AWS Schema Conversion Tool....498 AWS Data Migration Service....502 Other AWS Services for Data Migration....516 Choosing the Migration Path....518 Summary....520 Exam Essentials....521 Exercises....522 Review Questions....528 Chapter 13: Disaster Recovery....534 Understanding and Planning Disaster Recovery Requirements....534 Recovery Point Objective and Recovery Time Objective....535 Challenges in Disaster Recovery....536 Managing Disaster Recovery Strategies....538 Summary....553 Exam Essentials....553 Review Questions....554 Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure....559 AWS CloudFormation....560 AWS Systems Manager Parameter Store....583 AWS Secrets Manager....586 Summary....590 Exam Essentials....591 Review Questions....592 Appendix: Answers to Review Questions....598 Chapter 3: Purpose-Built Databases....599 Chapter 4: Relational Databases on AWS....601 Chapter 5: Low-Latency Response Time for Your Apps and APIs....604 Chapter 6: Document Databases in the Cloud....606 Chapter 7: Better Places Other Than Databases to Store Large Objects....608 Chapter 8: Deliver Valuable Information at the Speed Your Business Needs....610 Chapter 9: Discovering Relationships Using Graph Databases....613 Chapter 10: Immutable Database and Traceable Transactions....616 Chapter 11: Caching Data with In-Memory Databases....618 Chapter 12: Migrating Your Data to AWS....620 Chapter 13: Disaster Recovery....623 Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure....625 Index....628 End User License Agreement....682