Practice Test

True or False: AWS DMS can migrate your data to and from most widely used commercial and open-source databases.

  • True
  • False

Answer: True

Explanation: AWS DMS supports homogenous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora.

AWS Database Migration Service (AWS DMS) only supports migrating databases to AWS Cloud.

  • True
  • False

Answer: False

Explanation: AWS DMS can also be used for migrating databases between on-premises instances or from AWS back to on-premises instances.

True or False: AWS Schema Conversion Tool (AWS SCT) is used to convert the source database schema and a majority of the database code objects to a format compatible with the target database.

  • True
  • False

Answer: True

Explanation: The AWS SCT automates much of the process of converting your online transaction processing (OLTP) schema objects that are part of your data warehouse conversions.

Which AWS tool is an effective way to extract, transform, and load (ETL) data from an on-premises database to an AWS database?

  • A. AWS Glue
  • B. AWS SCT
  • C. AWS DMS
  • D. AWS EBS

Answer: C. AWS DMS

Explanation: AWS Database Migration Service (DMS) helps you migrate on-premises databases to AWS easily and securely.

Can AWS SCT generate a database migration assessment report which can guide you in your heterogeneous migrations?

  • A. Yes
  • B. No

Answer: A. Yes

Explanation: AWS SCT can help you determine the effort involved in your migration projects by generating a database migration assessment report.

True or False: Database migration with AWS DMS requires the source database to be offline.

  • True
  • False

Answer: False

Explanation: With AWS DMS, your source database remains fully operational during the migration, minimizing downtime to applications.

Which of the following is not a potential target for AWS DMS migration?

  • A. DynamoDB
  • B. Oracle
  • C. AWS Glue
  • D. Aurora

Answer: C. AWS Glue

Explanation: AWS DMS is capable of migrating to many AWS services, like DynamoDB, Oracle, and Aurora. However, AWS Glue is not a target database, it’s a fully managed extract, transform, and load (ETL) service.

True or False: The AWS DMS can be used to replicate data for High Availability purposes.

  • True
  • False

Answer: True

Explanation: AWS DMS can also replicate data continuously from your source database to the target, and can be used for High Availability solutions.

What does the AWS Schema Conversion Tool primarily convert in a database migration process?

  • A. Database schema
  • B. Physical storage
  • C. Network topology
  • D. EC2 instances

Answer: A. Database schema

Explanation: The AWS Schema Conversion Tool makes heterogeneous database migrations predictable by automatically converting the source database schema and a majority of the custom code to a format compatible with the target database.

True or False: AWS SCT can help migrate a database from commercial engine like Oracle to an open-source engine like PostgreSQL.

  • True
  • False

Answer: True

Explanation: AWS SCT reduces the complexity of migrating databases from commercial engines like Oracle towards open-source engines like PostgreSQL by converting schema and SQL statements.

Do AWS DMS and AWS SCT support migration of data towards non-AWS databases.

  • A. Yes
  • B. No

Answer: A. Yes

Explanation: Both DMS and SCT support migration of data between on-premise databases, AWS databases, and even some non-AWS cloud databases.

AWS DMS supports ____________ migration such as Oracle to Oracle.

  • A. Homogenous
  • B. Heterogenous

Answer: A. Homogenous

Explanation: Apart from supporting heterogenous migrations (like Oracle to Aurora), DMS also supports homogenous migrations (like Oracle to Oracle).

True or False: AWS SCT can convert embedded SQL in your applications.

  • True
  • False

Answer: True

Explanation: AWS SCT can convert embedded SQL in applications and even the SQL within your stored procedures and functions.

Which of the following is a tool for minimizing downtime during migration, by running source and target database in parallel?

  • A. AWS EC2
  • B. AWS DMS
  • C. AWS SCT
  • D. AWS Lambda

Answer: B. AWS DMS

Explanation: The AWS DMS can keep source and target databases in sync to minimize downtime during migration.

True or False: The AWS DMS and AWS SCT tools are free to use, but you are charged for the resources used during the migration.

  • True
  • False

Answer: True

Explanation: While AWS DMS and AWS SCT are free to use, you need to pay for the resources consumed during the process of migration.

Interview Questions

What is the main purpose of AWS Database Migration Service (AWS DMS)?

AWS DMS is designed to help users migrate databases to AWS quickly and securely. The source database remains fully operational during the migration, reducing downtime to applications that rely on the database.

How does AWS Schema Conversion Tool (AWS SCT) assist in cloud migration?

AWS SCT makes heterogeneous database migrations predictable by automatically converting the source database schema and majority of the database code objects, including views, stored procedures, and functions, to a format compatible with the target database.

Which database types are supported by AWS DMS for migration?

AWS DMS supports a broad range of databases including Oracle, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, SAP ASE, MongoDB, and many more.

Does AWS DMS support migration between different database engines?

Yes, AWS DMS supports homogeneous migrations such as Oracle to Oracle, as well as heterogeneous migrations between different database platforms, such as Oracle to Amazon Aurora or Microsoft SQL Server to MySQL.

Are there any prerequisites for using AWS SCT?

Yes, to use AWS SCT effectively, AWS recommends doing a detailed analysis of your schema conversion project. You need information about the source and target database engines, versions, operating systems and time zones.

When would I use AWS SCT over AWS DMS?

AWS SCT is used when migrating database schemas from one engine to another. AWS DMS is used to migrate the data itself. In many cases, you’d use SCT first to handle schema conversions, then use DMS to migrate the data.

Is it possible to use AWS DMS for ongoing replication?

Yes, AWS DMS supports both one-time migrations and ongoing replications for continuous data replication.

How does AWS SCT handle complex conversions that require refactoring?

When AWS SCT encounters code that cannot be automatically converted, it extracts this code and provides guidance on how to manually convert that code.

How can AWS SCT aid in moving databases to Amazon RDS or Amazon Redshift?

AWS SCT can scan your source database schema and application code, convert the schema, and extract and convert application code into a format compatible with the target database. This helps in moving databases to Amazon RDS or Amazon Redshift.

What is the role of AWS DMS in disaster recovery?

AWS DMS can be used to replicate data from on-premises databases to AWS and create a low-cost hybrid environment for disaster recovery purposes.

Is it possible to pause or resume a migration anytime using AWS DMS?

Yes, AWS DMS allows pausing and resuming the migration anytime which provides great flexibility during the process.

Can AWS SCT convert SQL procedures and views to the target database equivalent?

Yes, AWS SCT not only converts the database schema but also migrates procedural code, user-defined functions, and views to the target database.

Does AWS DMS support encrypted connections for data migration?

Yes, AWS DMS supports SSL-enabled connections to many source and target endpoints to ensure secure data migration.

Which AWS service is primarily used for comparison of source and target databases during migration?

AWS DMS can be used to compare the migration with the source to ensure an accurate migration.

How does AWS handle data consistency during migrations using AWS DMS?

AWS DMS uses a multi-step process to ensure that all changes to the source database that occur during the migration are automatically replicated to the target.

Leave a Reply

Your email address will not be published. Required fields are marked *