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 questionsReaders 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 xxvAssessment Test xxxvPart I Workload- Specific Database Design 1Chapter 1 Databases-- from Your Server to AWS Cloud 3Databases from the Beginning 41960s 51970s 51980s 61990s 72000-2010 72010-Today 8Databases on Premises 9Basic Infrastructure 9Complex Infrastructure and Resiliency 9Management 10Databases in the Cloud 10Data Remains Data 11DBAs Are the Initial DevOps 11DBA Career-- Now What? 11Summary 12Chapter 2 Basic AWS Concepts 13AWS Global Infrastructure 14AWS Regions 14AWS Availability Zones 14AWS Local Zones 15AWS Wavelength Zones 15Points of Prescence 16Networking 16IP Addressing 17Subnets 17VPC Routing 17Gateways and Connectivity Options 18Security 21Network Security 21AWS Shared Responsibility Model 22Identity and Access Management 24Data Encryption 25Storage at AWS 26Amazon Elastic Block Storage 27Amazon Elastic File System 28Amazon Simple Storage Service 29Operations 31Monitoring and Logging 32Amazon CloudWatch 32AWS CloudTrail 33Summary 34Chapter 3 Purpose- Built Databases 35Data store Concepts 36Data Access Patterns 37Latency 37Scaling 37Transaction Support 38Consistency 38Volume 38Durability 39Availability 39Security/Compliance 39Business Logic 39Cost 40Purpose- Built Databases on AWS 40Relational Databases 40Nonrelational Databases 42Summary 46Exam Essentials 46Review Questions 48Part II Management and Operations, Database Security, Monitoring and Troubleshooting Per Workload 51Chapter 4 Relational Databases on AWS 53Relational Databases 54Structured Query Language 55Install and Manage Databases Yourself 57I/O Requirement 58Managing Databases on EC 2 60Monitoring Databases on EC 2 60Scaling Databases 61Upgrading Databases 61Managed Services for Relational Databases 62Launching an RDS Instance 63Managing High Availability and Scalability 72Configuring RDS Parameter Groups 74Configuring RDS Option Groups 76Deletion Protection 78RDS Pricing Model 79Amazon Aurora Cloud- Native Relational Database 79Amazon Aurora Storage 80Amazon Aurora DB Clusters 81Amazon Aurora High Availability 82Amazon Aurora Global Database 82Amazon Aurora Read Replica Across Regions 84Amazon Aurora Serverless 84Amazon Aurora Multi- master 85Patch Management and Upgrade 86Monitoring and Performance Management 86Backup and Restore 90Backtrack 94Cloning an Amazon Aurora DB Cluster Volume 94Auditing 97Database Activity Stream in Amazon Aurora 98Security 98Migrating Databases 101Summary 101Exam Essentials 101Exercises 102Review Questions 106Chapter 5 Low- Latency Response Time for Your Apps and APIs 109Getting Started with Modern Applications and NoSQL Databases 110Amazon DynamoDB 112Design Considerations 112Migrating Your Data into DynamoDB 114Query Considerations 116Amazon DynamoDB Index Options 120DynamoDB Capacity Modes 122Other Features of DynamoDB 124Backup/Restore 134Scalability 136Security 139Monitoring 143Amazon Keyspaces 148Design Considerations 148Migrating Your Data into Keyspaces 149Query Considerations 150Keyspaces Capacity Modes 151Consistency Models 152Uses Cases 153Best Practices 153Backups 154Scalability 155Security 155Monitoring 157Summary 158Exam Essentials 159Exercises 159Review Questions 162Chapter 6 Document Databases in the Cloud 165Introducing Document Databases 166Getting Started with Amazon DocumentDB 170Creating an Amazon DocumentDB Cluster 174Amazon DocumentDB Architecture 175Security 177Access Control 177Data Protection 178Other Features 179Backup and Restore 180Performance and Scaling 182Compatibility between Amazon DocumentDB and MongoDB 182Migrating from MongoDB to Amazon DocumentDB 183Amazon DocumentDB Monitoring 184Developing with Amazon DocumentDB 187When to Use DynamoDB vs. DocumentDB 187Amazon DocumentDB Pricing 188Summary 189Exam Essentials 189Exercises 190Review Questions 192Chapter 7 Better Places Than Databases to Store Large Objects 195Databases and Large Objects 196Introducing Amazon S 3 198Costs of Amazon S3 vs. Elastic Block Storage 200Moving LOBs to Amazon S 3 204Creating an S3 Bucket 204Putting or Uploading Objects 206Indexing LOBs in Amazon S 3 208Additional S3 Features 211Backup and Dump Files 211Other Use Cases 211Pay per Usage and Scalability 212Availability and Durability 213Security 214Access Control 214Data Encryption 215Summary 216Exam Essentials 216Exercises 217Review Questions 219Chapter 8 Deliver Valuable Information at the Speed Your Business Needs 225Information Latency 226Data Warehouses 229Database Engines for Data Warehouses 231Migrating Data Warehouses to Amazon Redshift Using Aws Sct 233Amazon Redshift 235Redshift Cluster Architecture 235Table Design in Redshift 235Loading Data into Redshift 240Data Lakes in AWS 241Redshift Spectrum 242Redshift Federated Queries 242Data Lakehouse 242Redshift Cluster Node Types 243Redshift Monitoring 244Redshift Scalability 245Redshift Security 246Redshift Data Resilience and Backup 247Time- Series Databases 249Amazon Timestream 251Amazon Timestream Architecture 252Loading Data into Amazon Timestream 253Querying Data from Amazon Timestream 254Amazon Timestream Monitoring 255Amazon Timestream Scalability 255Amazon Timestream Security 256Amazon Timestream Data Resilience and Backup 257Amazon OpenSearch Service 257Amazon OpenSearch Service Domain Architecture 257Loading Data to Amazon OpenSearch Service 257Searching for Data in Amazon OpenSearch Service 258Amazon OpenSearch Service Monitoring 259Amazon OpenSearch Service Scalability 259Amazon OpenSearch Service Security 259Amazon OpenSearch Service Data Resilience and Backup 259Summary 260Exam Essentials 261Exercises 261Review Questions 271Chapter 9 Discovering Relationships Using Graph Databases 275Graph Databases 276When to Use Graph Databases 277Common Use Cases 278Amazon Neptune 279High- Level Architecture 279Graph Models and Query Languages 280Using and Extracting Data from Amazon Neptune 282Storage Architecture 284Data Resilience 284Read Replicas 284Scalability 286Availability 287Failover Policy 287Security 288Automatic Backup and Restore 289Monitoring 290Summary 291Exam Essentials 291Review Questions 292Chapter 10 Immutable Database and Traceable Transactions 295Amazon Quantum Ledger Database 296Amazon QLDB Components 297Working with Amazon QLDB 300Backup and Durability 303Performance and Scalability 304Security 305Monitoring 306Best Practices 307Summary 307Exam Essentials 308Exercises 308Review Questions 311Chapter 11 Caching Data with In- Memory Databases 313Built- in Database Cache 314Local Application Cache 315In- Memory Databases 315Caching Use Cases 315Remote Cache Strategies 316Caching Data in AWS 317Caching Data with ElastiCache 319Memcached or Redis? 319Memcached Architecture on Amazon ElastiCache Service 320Redis Architecture on the Amazon ElastiCache Service 321Backup and Restore 324Security 324Monitoring 325Amazon MemoryDB for Redis 325Summary 326Exam Essentials 326Exercises 327Review Questions 334Part III Deployment and Migration 337Chapter 12 Migrating Your Data to AWS 339Network Communication and Data Migration 340Optimizing Bandwidth Usage 343Database Migration to AWS 343AWS Schema Conversion Tool 344AWS Data Migration Service 347Setting Up AWS DMS 350AWS DMS Continuous Replication 352AWS DMS Best Practices 353AWS DMS Security 356AWS DMS Resilience 356Other AWS Services for Data Migration 357AWS DataSync 357AWS Snow Family 357AWS Storage Gateway 358Choosing the Migration Path 358One or Many Target Databases 358Small, Noncritical Databases 359Very Large Databases 359Summary 360Exam Essentials 360Exercises 361Review Questions 365Chapter 13 Disaster Recovery 369Understanding and Planning Disaster Recovery Requirements 370Recovery Point Objective and Recovery Time Objective 371Challenges in Disaster Recovery 371Managing Disaster Recovery Strategies 373Backup and Recovery Strategy 373Database Replication Methods: Multi- AZ and Cross- Region Replication 373Databases Deployed on EC 2 374Amazon RDS 375Amazon Aurora 378Amazon Neptune 383Summary 384Exam Essentials 384Review Questions 386Chapter 14 Save Time and Reduce Errors Automating Your Infrastructure 389AWS CloudFormation 390Components 393Important Concepts 400Updating AWS CloudFormation Stacks 403Deleting AWS CloudFormation Stacks 408AWS Systems Manager Parameter Store 409AWS Secrets Manager 411Summary 415Exam Essentials 415Review Questions 416Appendix Answers to Review Questions 421Chapter 3: Purpose- Built Databases 422Chapter 4: Relational Databases on AWS 422Chapter 5: Low- Latency Response Time for Your Apps and APIs 424Chapter 6: Document Databases in the Cloud 425Chapter 7: Better Places Other Than Databases to Store Large Objects 426Chapter 8: Deliver Valuable Information at the Speed Your Business Needs 427Chapter 9: Discovering Relationships Using Graph Databases 429Chapter 10: Immutable Database and Traceable Transactions 431Chapter 11: Caching Data with In- Memory Databases 432Chapter 12: Migrating Your Data to AWS 433Chapter 13: Disaster Recovery 434Chapter 14: Save Time and Reduce Errors Automating Your Infrastructure 436Index 439