Transfer Data to Redshift from On-Premise Warehouse
Question
A company currently has a large data warehouse hosted in their On-premise Oracle database engine.
They need to migrate the data warehouse over to AWS Redshift.
Which of the following can be used to transfer the data from the on-premise warehouse over to Redshift?
Answers
Explanations
Click on the arrows to vote for the correct answer
A. B. C. D.Answer - B.
The AWS Documentation mentions the following.
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.
Option A is incorrect since for this you need to have the data already available for copying into the Redshift cluster.
Option C is incorrect since this is used to migrate Virtual Machines.
Option D is incorrect since this is used for creating templates for Infrastructure deployment.
For more information on the schema conversion tool, please refer to the below URL.
https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.htmlThe correct answer for the given question is: A. AWS Redshift Copy command.
AWS Redshift Copy command is an efficient and easy-to-use tool that enables data transfer from various sources, including on-premise data warehouses, to Amazon Redshift. It supports various data formats like CSV, JSON, Avro, Parquet, etc. and can handle large data volumes.
AWS Schema Conversion Tool (B) is a tool that helps convert database schemas from one format to another. It is useful in migrating database engines from on-premises to AWS but does not handle data transfer.
AWS VM Migration (C) is a tool used to migrate virtual machines from on-premises data centers to AWS.
AWS CloudFormation (D) is a service used to automate infrastructure deployment in AWS. It is not used for data migration.
In summary, the most appropriate tool for transferring data from an on-premise Oracle data warehouse to Amazon Redshift is the AWS Redshift Copy command.
