+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

AWS Certified Database Study Guide. Specialty (DBS-C01) Exam. Edition No. 1

  • Book

  • 496 Pages
  • May 2023
  • John Wiley and Sons Ltd
  • ID: 5838393
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.

Table of Contents

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

Authors

Matheus Arrais Rene Martinez Bravet Leonardo Ciccone Angie Nobre Cocharero Erika Kurauchi Hugo Rozestraten