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

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.