Question 62: You have your data stored in HP Vertica Data warehouse solution, you have to migrate this data to an AWS Based Warehouse solution called AWS Redshift. Which of the following would help in migrating the

data from HP Vertica database to AWS Redshift cluster?

1. You will be using AWS Redshift Bulk Upload tool.

2. You will create EBS volume with the existing data and attach that volume to the Redshift Cluster.

3. You will copy data from HP Vertica to an S3 bucket. And attach that bucket to Redshift cluster.

4. You will be using SCT (Schema Conversion Tool)

5. You will be using AWS SUT (Schema Upload Tool)

Correct Answer : 4 Exp : You can use the AWS Schema Conversion Tool (AWS SCT) to convert your existing database schema from one database engine to another. You can convert relational OLTP schema, or data warehouse

schema. Your converted schema is suitable for an Amazon Relational Database Service (Amazon RDS) MySQL DB instance, an Amazon Aurora DB cluster, an Amazon RDS PostgreSQL DB instance, or an Amazon Redshift cluster. The

converted schema can also be used with a database on an Amazon EC2 instance or stored as data on an Amazon S3 bucket.

AWS SCT supports several industry standards, including Federal Information Processing Standards (FIPS) when connecting to an Amazon S3 bucket or another AWS resource. AWS SCT is also compliant with Federal Risk and

Authorization Management Program (FedRAMP).

AWS SCT supports the following data warehouse solutions to be converted into Redshift Datawarehouse.

Greenplum Database (version 4.3 and later)

Microsoft SQL Server (version 2008 and later)

Netezza (version 7.0.3 and later)

Oracle (version 10 and later)

Teradata (version 13 and later)

Vertica (version 7.2.2 and later)

4