Exam AWS Certified Solutions Architect - Professional All Questions

View all questions & answers for the AWS Certified Solutions Architect - Professional exam

Exam AWS Certified Solutions Architect - Professional topic 1 question 677 discussion

Exam question from Amazon's AWS Certified Solutions Architect - Professional

Question #: 677
Topic #: 1

[All AWS Certified Solutions Architect - Professional Questions]

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?

A. Install Oracle database software on an Amazon EC2 instance. Configure VPN connectivity between AWS and the company's data center. Configure the Oracle database running on Amazon EC2 to join the Oracle Real Application Clusters (RAC). When the Oracle database on Amazon EC2 finishes synchronizing, create an AWS DMS ongoing replication task to migrate the data from the Oracle database on Amazon EC2 to Amazon Redshift. Verify the data migration is complete and perform the cut over to Amazon Redshift.
B. Create an AWS Snowball import job. Export a backup of the Oracle data warehouse. Copy the exported data to the Snowball device. Return the Snowball device to AWS. Create an Amazon RDS for Oracle database and restore the backup file to that RDS instance. Create an AWS DMS task to migrate the data from the RDS for Oracle database to Amazon Redshift. Copy daily incremental backups from Oracle in the data center to the RDS for Oracle database over the internet. Verify the data migration is complete and perform the cut over to Amazon Redshift.
C. Install Oracle database software on an Amazon EC2 instance. To minimize the migration time, configure VPN connectivity between AWS and the company's data center by provisioning a 1 Gbps AWS Direct Connect connection. Configure the Oracle database running on Amazon EC2 to be a read replica of the data center Oracle database. Start the synchronization process between the company's on-premises data center and the Oracle database on Amazon EC2. When the Oracle database on Amazon EC2 is synchronized with the on-premises database, create an AWS DMS ongoing replication task to migrate the data from the Oracle database read replica that is running on Amazon EC2 to Amazon Redshift. Verify the data migration is complete and perform the cut over to Amazon Redshift.
D. Create an AWS Snowball import job. Configure a server in the company's 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.

Show Suggested Answer

Suggested Answer: D 🗳️

by liono at Nov. 7, 2020, 12:47 p.m.

Disclaimers:

- ExamTopics website is not related to, affiliated with, endorsed or authorized by Amazon.
- Trademarks, certification & product names are used for reference only and belong to Amazon.

Comments

Submit Cancel

liono

Highly Voted 3 years, 11 months ago

D is correct, you need Snowball for the size of the DB, SCT for converting from oracle to redshift and DMS for migration job https://aws.amazon.com/getting-started/hands-on/migrate-oracle-to-amazon-redshift/

upvoted 27 times

kirrim

3 years, 9 months ago

50TB to transfer - Transmitting over 50Mbps VPN ~ 90 days, not going to work - Transmitting over 1Gbps DX ~ 4.3 days, but ~ 60 days to provision circuit, not going to work A and C are automatically ruled out - Transmitting via Snowball (Edge) ~ 3-5 days, can hold up to 80TB usable disk, feasible Between B and D, difference is around whether to use SCT and DMS to Snowball in your datacenter, then move to AWS. Or, copy to Snowball in data center, move to AWS, then do DMS WITHOUT SCT within AWS. Clearly, you need SCT to go from Oracle to Redshift, so it has to be D https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/agents.dw.html

upvoted 8 times

sangkhuu

2 years, 10 months ago

great explain!

upvoted 1 times

...

hkwong

Highly Voted 3 years, 10 months ago

D. SCT is a must for converting Oracle DATA WAREHOUSE to Redshift

upvoted 5 times

...

sumaju

Most Recent 1 year, 8 months ago

None of the options are correct here. It should be 1. Ship the 1st full backup using snowball. 2. Incremental backup using internet as data volume will be small. Need SCT to move from Oracle to Redshift. So D is closer, but missed the incremental backup transportation.

upvoted 1 times

...

Anhdd

3 years, 2 months ago

Selected Answer: A

I wonder that if we choose Snow Ball as the solution. It's perfect, but the time when we ship back to AWS (1 week maybe), on-premis data are not being synced. While the question requires that "guarantee that small daily updates are synced with the Amazon Redshift data warehouse" ? How this can be complete?

upvoted 1 times

...

leoluo2020

3 years, 5 months ago

Selected Answer: D

mark D

upvoted 3 times

...

palace

3 years, 8 months ago

For a Oracle database running in the AWS Cloud on "Target architecture" SCT is not printed. https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/migrate-an-oracle-database-to-amazon-redshift-using-aws-dms-and-aws-sct.html With D the changes of the month will be lost.

upvoted 1 times

...

cldy

3 years, 8 months ago

D. Create an AWS Snowball import job. Configure a server in the companyג€™s 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.

upvoted 2 times

...

backfringe

3 years, 8 months ago

I go with D

upvoted 1 times

...

AzureDP900

3 years, 8 months ago

I just thought about D and all the candidates mentioned same. I am getting ready for exam :)

upvoted 1 times

...

acloudguru

3 years, 9 months ago

Selected Answer: D

since it is Oracle to Redshit, it needs SCT. scan for the key word SCT and answer is D. 50T through network is impossible for A to finish in 30days, snowball is a must.

upvoted 1 times

...

moon2351

3 years, 9 months ago

Answer is D

upvoted 1 times

...

andylogan

3 years, 9 months ago

It's D - for Oracle to Redshit, it needs SCT

upvoted 2 times

...

DerekKey

3 years, 9 months ago

Requirements: 1. "the data warehouse only receives minor daily updates and is primarily used for reading and reporting" 2. "ensure that the minor daily changes have been synchronized with the Amazon Redshift data warehouse" D - how would you make it working if Snowball will travel to AWS for 3-4 days and 1 day more will be spent on restoring database?

upvoted 1 times

...