SAP-C02 · Question #833
A company needs to migrate a 50 TB Oracle data warehouse from on premises to Amazon Redshift. Major updates to the data warehouse occur on the final calendar day of each month. The data warehouse…
The correct answer is B. Create an AWS Snowball Edge import job into Amazon S3. Copy data to the Snowball Edge D. Configure a server in the company's VPC with a data extraction agent. Use AWS SCT to manage F. Create a new project in AWS SCT by using the registered agent. Create a local task and an AWS. AWS Snowball Edge import job allows you to transfer large amounts of data from on-premises to Amazon S3. You can load the 50 TB of Oracle data warehouse to Amazon S3 using Snowball Edge, and then use AWS Database Migration Service (DMS) to copy the data from Amazon S3 to Amazon…
Question
A company needs to migrate a 50 TB Oracle data warehouse from on premises to Amazon Redshift. Major updates to the data warehouse occur on the final calendar day of each month. The data warehouse receives only minor daily updates and is primarily used for reading and reporting for the other days of the month. The company needs to synchronize minor daily changes to the data warehouse with the migration to Amazon Redshift. The company will cut over to strictly using Amazon Redshift after completing the data migration. Which combination of steps will meet these requirements? (Choose three.)
Options
- ACreate an AWS Snowball Edge export job into Amazon S3. Copy data to the Snowball Edge
- BCreate an AWS Snowball Edge import job into Amazon S3. Copy data to the Snowball Edge
- CConfigure a server in the company's data center with a data extraction agent. Use AWS SCT to
- DConfigure a server in the company's VPC with a data extraction agent. Use AWS SCT to manage
- ECreate a new project in AWS SCT by using the registered agent. Create a local task and an AWS
- FCreate a new project in AWS SCT by using the registered agent. Create a local task and an AWS
How the community answered
(37 responses)- A5% (2)
- B59% (22)
- C14% (5)
- E22% (8)
Explanation
AWS Snowball Edge import job allows you to transfer large amounts of data from on-premises to Amazon S3. You can load the 50 TB of Oracle data warehouse to Amazon S3 using Snowball Edge, and then use AWS Database Migration Service (DMS) to copy the data from Amazon S3 to Amazon Redshift. This method is efficient for large initial data transfers and ensures that you can start the migration process with minimal downtime. Setting up a server in the company’s VPC with a data extraction agent is a valid approach to manage the migration. The AWS Schema Conversion Tool (AWS SCT) can be used to convert the Oracle schema to an Amazon Redshift-compatible schema. This allows for seamless migration of the database structure while also managing data extraction in a cloud-native After configuring the AWS SCT project and registering the agent, you can set up both a local task for the initial data migration and an AWS DMS task to use Change Data Capture (CDC). CDC allows for synchronization of minor daily changes after the initial data migration is completed, ensuring that the migration is kept up to date with ongoing changes until the cutover to Amazon Redshift.
Community Discussion
No community discussion yet for this question.