AWS Certified Data Engineer - Associate
Get started today
Ultimate access to all questions.
Your company is planning to migrate its existing on-premises data warehouse to AWS. The data warehouse contains a large volume of structured data that needs to be ingested into AWS. Which AWS service would you recommend for this migration, and how would you design the data ingestion pipeline to ensure minimal downtime and data consistency?
Your company is planning to migrate its existing on-premises data warehouse to AWS. The data warehouse contains a large volume of structured data that needs to be ingested into AWS. Which AWS service would you recommend for this migration, and how would you design the data ingestion pipeline to ensure minimal downtime and data consistency?
Explanation:
In this scenario, using Amazon Redshift for data storage and AWS Database Migration Service (DMS) for data migration would be the most appropriate choice. Amazon Redshift is a fully managed data warehouse service that can handle large volumes of structured data. AWS DMS can help you migrate the data from your on-premises data warehouse to Amazon Redshift with minimal downtime and ensure data consistency. This combination of services provides a seamless migration process for the data warehouse.