AWS Certified Database - Specialty Exam: Steps for Migrating On-Premises Cassandra to DynamoDB

Steps to Enable On-Premises Cassandra to DynamoDB Migration using AWS SCT

Question

A company is planning to migrate its on-premises Cassandra cluster to DynamoDB.

They intend to take advantage of AWS SCT.

What steps must the database specialists perform to enable this migration (select THREE)

Answers

Explanations

Click on the arrows to vote for the correct answer

A. B. C. D. E. F.

Answer: B, C, E.

Option A is incorrect because the data extraction agents should NOT be connected to the production Cassandra cluster.

The extraction process performed by the data extraction agents imposes an additional overhead load on the Cassandra database.

To avoid a negative impact on the operation and performance of the source production cluster, a clone datacenter containing a copy of the production data should be created.

SCT should be configured to connect to this clone cluster.

Option B is CORRECT because SCT data extraction agents are required when the source and target databases are significantly different and require complex data transformations.

This is the case for migrating data from Cassandra to DynamoDB.

Data Extraction Agents come as part of the SCT installation.

Option C is CORRECT because the extraction process performed by the data extraction agents imposes an additional overhead load on the Cassandra database.

To avoid a negative impact on the operation and performance of the source production cluster, a clone datacenter containing a copy of the production data should be created.

SCT should be configured to connect to this clone cluster.

Option D is incorrect because Kerberos is not required for connecting and authenticating to a Cassandra cluster using SCT.

Option E is CORRECT because the S3 bucket is required to store the output of the data extraction agent conversion and migration process.

Option F is incorrect because SCT uses AWS access key and secret key for AWS authentication.

Reference:

https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/agents.cassandra.html

The correct answers for this question are A, B, and E.

A. Connect SCT to the production Cassandra cluster: AWS Schema Conversion Tool (SCT) needs to be connected to the production Cassandra cluster to migrate the data from Cassandra to DynamoDB.

B. Install Data Extraction Agent: AWS SCT uses the Data Extraction Agent to extract data from the source Cassandra cluster. The agent is installed on a server in the same network as the Cassandra cluster.

C. Create a Clone Datacenter: This option is not relevant to the migration process from Cassandra to DynamoDB.

D. Configure Kerberos authentication for Cassandra cluster: This option is not relevant to the migration process from Cassandra to DynamoDB.

E. Create an S3 bucket: An S3 bucket is needed to store the output files generated by SCT during the migration process.

F. Configure SCT to connect to DynamoDB using IAM user and password: This option is not relevant to the migration process from Cassandra to DynamoDB.

To summarize, to enable migration from an on-premises Cassandra cluster to DynamoDB using AWS SCT, specialists need to connect SCT to the production Cassandra cluster, install the Data Extraction Agent, and create an S3 bucket to store output files generated by SCT during the migration process.