DEA-C01 Question 177
Select 3Your company is planning to migrate its on-premises data warehouse to AWS. The data consists of structured customer records and unstructured log files. The migration team has identified Amazon S3 as the destination for unstructured data and Amazon Redshift as the destination for structured data. What steps should you take to align the storage and migration process with these requirements?
- A
Use AWS DataSync to transfer unstructured log files directly from on-premises to Amazon S3.
- B
Leverage the COPY command in Amazon Redshift to load structured data directly from the on-premises data warehouse.
- C
Use AWS Snowball to migrate large volumes of structured data to S3, then load it into Amazon Redshift.
- D
Enable S3 Transfer Acceleration for faster migration of unstructured data to Amazon S3.
- E
Use Amazon Kinesis Data Firehose to stream structured data directly into Amazon Redshift.
Show answer and explanation
Correct answers: A, C, D
Explanation
To align the storage and migration process with the requirements, AWS DataSync is ideal for automating the transfer of unstructured data to Amazon S3. For structured data, AWS Snowball is a practical solution for large-scale migrations, with Redshift integration occurring afterward. Additionally, enabling S3 Transfer Acceleration can optimize unstructured data transfer speeds. Options like using the COPY command directly from on-premises or Kinesis Data Firehose for bulk migrations do not meet the scenario's needs.
- A. Correct.
AWS DataSync is a fully managed service that simplifies and automates the transfer of unstructured data, such as log files, to Amazon S3. This is an appropriate choice for unstructured data migration.
- B. Incorrect.
The COPY command in Amazon Redshift is used to load data from Amazon S3 or DynamoDB into Redshift, but not directly from an on-premises data warehouse. This option is incorrect in this scenario.
- C. Correct.
AWS Snowball is suitable for migrating large volumes of data efficiently to AWS. Transferring structured data first to S3, then loading it into Redshift, aligns with the migration requirements.
- D. Correct.
S3 Transfer Acceleration speeds up data transfers over long distances to S3, making it a good choice for unstructured data migration.
- E. Incorrect.
Amazon Kinesis Data Firehose streams real-time data into Redshift, but it is not designed for bulk data migration from an on-premises data warehouse. Thus, it is not suitable for this scenario.