Book Image

AWS Certified Database – Specialty (DBS-C01) Certification Guide

By : Kate Gawron
5 (1)
Book Image

AWS Certified Database – Specialty (DBS-C01) Certification Guide

5 (1)
By: Kate Gawron

Overview of this book

The AWS Certified Database – Specialty certification is one of the most challenging AWS certifications. It validates your comprehensive understanding of databases, including the concepts of design, migration, deployment, access, maintenance, automation, monitoring, security, and troubleshooting. With this guide, you'll understand how to use various AWS databases, such as Aurora Serverless and Global Database, and even services such as Redshift and Neptune. You’ll start with an introduction to the AWS databases, and then delve into workload-specific database design. As you advance through the chapters, you'll learn about migrating and deploying the databases, along with database security techniques such as encryption, auditing, and access controls. This AWS book will also cover monitoring, troubleshooting, and disaster recovery techniques, before testing all the knowledge you've gained throughout the book with the help of mock tests. By the end of this book, you'll have covered everything you need to pass the DBS-C01 AWS certification exam and have a handy, on-the-job desk reference guide.
Table of Contents (24 chapters)
1
Part 1: Introduction to Databases on AWS
Free Chapter
2
Chapter 1: AWS Certified Database – Specialty Overview
5
Part 2: Workload-Specific Database Design
12
Part 3: Deployment and Migration and Database Security
16
Part 4: Monitoring and Optimization
20
Part 5: Assessment
21
Chapter 16: Exam Practice

Review

Let's test our knowledge of the contents of this chapter with some example exam questions:

  1. You have been hired to migrate an Amazon EC2 instance that's running Oracle Database Standard Edition to an RDS for Oracle DB instance. The database is used for critical production services and the business can only provide a 5-minute outage window. How can you achieve this?
    1. Configure Oracle Real Application Clusters on the EC2 instance with the RDS DB instance as one of the nodes. Once the EC2 and RDS DB instances are in sync, switch over from Amazon EC2 to Amazon RDS and update the application connection string.
    2. Export the Oracle database from the EC2 instance using Oracle Data Pump to an S3 bucket and import it into Amazon RDS. Shut down the application until the restore is complete. Change the database connection string and then restart the application.
    3. Create an AWS DMS task with the EC2 instance as the source and the RDS DB instance as the destination. Stop the application...