AWS : Database Specialty Exam — Part 2
A Quick Review for Deployment and Migration
Part 2: Deployment and Migration (20% of exam)
- Choose appropriate deployment tools and services
- Determine data preparation and data migration strategies
1 — A Database Specialist want to migrate database using the AWS Database Migration Service (DMS). Half of the tables inside the database contained columns of LOB data types.
How should the Database Specialist do to achieve fast LOB data migration ?
- Configure an AWS DMS task to migrate the tables without LOBs.
- Configure another AWS DMS task using limited LOB mode with LobMaxSize setting.
https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.LOBSupport.html
2— A Database Specialist is planning to migrate its existing on-premises to Amazon RDS by AWS Database Migration Service. The validation of data from the source to the target is needed to ensure that migration was successful.
What actions are required to meet these requirements ?
Create the AWS DMS task with Enable validation.
Note — During data validation, AWS DMS queries each row in the source with its corresponding row at the target and verifies that those rows contain the same data. These queries will consume additional resources at both the source and the target.
https://aws.amazon.com/premiumsupport/knowledge-center/validation-feature-dms/
3 — A company want to migrate from an on-premises database to an Amazon Aurora. The Database Specialist was asked for assessment report to understand the complexity of migration, for example, license requirements, current hardware configurations, and estimation of effort that it will take to write the equivalent code for your target DB instance that can’t be converted automatically.
What should the database specialist do to meet these requirement ?
Use AWS Schema Conversion Tool (AWS SCT)
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_AssessmentReport.html
4— A Database Specialist is migrating a heterogeneous database migration where an on-premises Oracle database needs to be migrated and transformed into an Amazon RDS for MySQL database.
What is the suitable approach to this migration ?
- Convert the source schema using the AWS Schema Conversion Tool (SCT) to match the target database.
- Migrate the data from the source database to the target database using the AWS Database Migration Service (DMS) with the change data capture (CDC) option enabled for continuous data replication.
5 — How does Database Specialist set up an Amazon Aurora PostgreSQL DB cluster to have a minimal application downtime during a failover ?
Enable Aurora DB cluster cache management in the associated parameter group.
Note — In a typical failover situation, you might see a temporary but large performance degradation after failover. This degradation occurs because when the failover DB instance starts, the buffer cache is empty. An empty cache is also known as a cold cache.
Cluster cache management ensures that the data in the designated reader’s cache is kept synchronized with the data in the writer DB instance’s cache. If a failover occurs, the designated reader uses values in its warm cache immediately when it’s promoted to the new writer DB instance. This approach provides your application with better recovery performance.
6 — A Database Specialist was assigned to migrate an Amazon RDS DB Instance for MySQL to Amazon Aurora.
What is the most cost-effective solution to migrate with near-zero downtime ?
Create an Aurora MySQL Read Replica of the Amazon RDS DB instance and promote it once the replication lag drops to 0
7 — What should the Database Specialist implement to integrate an on-premises Active Directory (AD) to an Amazon RDS for SQL Server DB instance ?
- Launch an AWS Managed Microsoft AD and set up Windows Authentication by establishing a trust relationship with the on-premises Active Directory.
- Configure the security group of the domain controllers to restrict unauthorized access.
Note —The DB instance works with AWS Directory Service for Microsoft AD, also called AWS Managed Microsoft AD, to enable Windows Authentication.
When users authenticate with a SQL Server DB instance joined to the trusting domain, authentication requests are forwarded to the domain directory that you create with AWS Directory Service.
8 — A company has a suite of AWS services that are deployed to different environments. The Application team needs an automated deployment that will minimize rework due to manual configuration errors.
What is the most suitable solution that the Database Specialist should implement ?
- Store the environment-specific parameters in the AWS Systems Manager Parameter Store.
- Design the AWS CloudFormation template to reference the values from the Parameter Store dynamically.
Related Articles
- AWS Database Specialty Exam — Part 1
- AWS Database Specialty Exam — Part 2
- AWS Database Specialty Exam — Part 3
- AWS Database Specialty Exam — Part 4
- AWS Database Specialty Exam — Part 5
