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

Running a DMS task via SCT

SCT and DMS can work together to handle both schema conversion and data migration. Using a data extraction agent, SCT allows you to monitor and control DMS jobs via the SCT interface. To do this, you must configure an AWS service profile to use, which requires an AWS Access Key and an AWS Secret Key for a user who has permissions to create DMS tasks. Once that profile has been added, SCT will be able to create DMS tasks for you. The SCT DMS interface can only work with tasks and cannot create endpoints or replication instances, so these will need to be configured before you try to migrate. The following screenshot shows the Global settings view, which appears when you have correctly configured an AWS Access Key and profile:

Figure 10.11 – AWS Global settings for AWS service profiles

To use DMS within SCT, you need to install a data extraction agent. This agent can also be used for complex SCT migrations, such as from Apache...