Answer-first summary for fast verification
Answer: Configure AWS DMS to handle schema differences automatically and set up individual replication tasks for each source.
Option C is correct because it involves setting up individual replication tasks for each source and handling schema differences automatically, which is a practical approach for managing diverse data sources. Using default settings (Option A) does not address potential schema differences. Manually migrating schema (Option B) is time-consuming and error-prone. Using AWS Glue for schema migration (Option D) is not the most efficient method for this specific task.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
Consider a scenario where you need to ingest data from multiple batch sources including Amazon S3, Amazon RDS, and on-premises SQL Server databases into an Amazon Redshift data warehouse. Describe how you would configure AWS DMS to replicate data from these sources to Redshift, including the steps for setting up the replication tasks and handling schema differences.
A
Use AWS DMS with default settings and assume no schema differences.
B
Manually migrate schema from each source to Redshift before setting up DMS.
C
Configure AWS DMS to handle schema differences automatically and set up individual replication tasks for each source.
D
Use AWS Glue to migrate schema and then set up DMS for data replication.
No comments yet.