SAP-C02 · Question #194
SAP-C02 Question #194: Real Exam Question with Answer & Explanation
The correct answer is D: Create an AWS Snowball import job. Configure a server in the company's data center with an. Create an AWS Snowball import job. Configure a server in the company TMs data center with an extraction agent. Use AWS SCT to manage the extraction agent and convert the Oracle schema to an Amazon Redshift schema. Create a new project in AWS SCT using the registered data extracti
Question
A solutions architect has been assigned to migrate a 50 TB Oracle data warehouse that contains sales data from on-premises to Amazon Redshift. Major updates to the sales data occur on the final calendar day of the month. For the remainder of the month, the data warehouse only receives minor daily updates and is primarily used for reading and reporting. Because of this, the migration process must start on the first day of the month and must be complete before the next set of updates occur. This provides approximately 30 days to complete the migration and ensure that the minor daily changes have been synchronized with the Amazon Redshift data warehouse. Because the migration cannot impact normal business network operations, the bandwidth allocated to the migration for moving data over the internet is 50 Mbps. The company wants to keep data migration costs low. Which steps will allow the solutions architect to perform the migration within the specified timeline?
Options
- AInstall Oracle database software on an Amazon EC2 instance.
- BCreate an AWS Snowball import job. Export a backup of the Oracle data warehouse.
- CInstall Oracle database software on an Amazon EC2 instance.
- DCreate an AWS Snowball import job. Configure a server in the company's data center with an
Explanation
Create an AWS Snowball import job. Configure a server in the company TMs data center with an extraction agent. Use AWS SCT to manage the extraction agent and convert the Oracle schema to an Amazon Redshift schema. Create a new project in AWS SCT using the registered data extraction agent. Create a local task and an AWS DMS task in AWS SCT with replication of ongoing changes. Copy data to the Snowball device and return the Snowball device to AWS. Allow AWS DMS to copy data from Amazon S3 to Amazon Redshift. Verify that the data migration is complete and perform the cut over to Amazon Redshift. https://aws.amazon.com/getting-started/hands-on/migrate-oracle-to-amazon-redshift/
Community Discussion
No community discussion yet for this question.