ExamTopics Logo
Mail Us[email protected]
Menu
Amazon Discussions
exam questions

Exam AWS Certified Solutions Architect - Professional All Questions

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

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

Exam question from Amazon's AWS Certified Solutions Architect - Professional
Question #: 728
Topic #: 1
[All AWS Certified Solutions Architect - Professional Questions]

A company wants to migrate a 30 TB Oracle data warehouse from on premises to Amazon Redshift. The company used the AWS Schema Conversion Tool (AWS
SCT) to convert the schema of the existing data warehouse to an Amazon Redshift schema. The company also used a migration assessment report to identify manual tasks to complete.
The company needs to migrate the data to the new Amazon Redshift cluster during an upcoming data freeze period of 2 weeks. The only network connection between the on-premises data warehouse and AWS is a 50 Mbps internet connection.
Which migration strategy meets these requirements?

  • A. Create an AWS Database Migration Service (AWS DMS) replication instance. Authorize the public IP address of the replication instance to reach the data warehouse through the corporate firewall. Create a migration task to run at the beginning of the fata freeze period.
  • B. Install the AWS SCT extraction agents on the on-premises servers. Define the extract, upload, and copy tasks to send the data to an Amazon S3 bucket. Copy the data into the Amazon Redshift cluster. Run the tasks at the beginning of the data freeze period.
  • C. Install the AWS SCT extraction agents on the on-premises servers. Create a Site-to-Site VPN connection. Create an AWS Database Migration Service (AWS DMS) replication instance that is the appropriate size. Authorize the IP address of the replication instance to be able to access the on-premises data warehouse through the VPN connection.
  • D. Create a job in AWS Snowball Edge to import data into Amazon S3. Install AWS SCT extraction agents on the on-premises servers. Define the local and AWS Database Migration Service (AWS DMS) tasks to send the data to the Snowball Edge device. When the Snowball Edge device is returned to AWS and the data is available in Amazon S3, run the AWS DMS subtask to copy the data to Amazon Redshift.
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
by gsw at April 30, 2021, 12:51 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
gsw
Highly Voted 3 years, 2 months ago
D seems correct
upvoted 12 times
StelSen
3 years, 1 month ago
Adding one more link for architecture: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.Process.html
upvoted 1 times
...
ExtHo
3 years, 2 months ago
Yes its D :) Transfer 30TB over 50Mbps will take around 53Days that ruled out ABC https://www.calctool.org/CALC/prof/computing/transfer_time
upvoted 9 times
...
...
SkyZeroZx
Most Recent 1 year, 5 months ago
Selected Answer: D
50Mbps = 6.25 MBPS = 22GB per hour = 540 (.5TB) per day. 30TB / .5 = 60 days... Snowball is the only option here
upvoted 1 times
...
[Removed]
1 year, 9 months ago
Selected Answer: D
50Mbps = 6.25 MBPS = 22GB per hour = 540 (.5TB) per day. 30TB / .5 = 60 days... Snowball is the only option here
upvoted 1 times
...
cldy
2 years, 12 months ago
D. Create a job in AWS Snowball Edge to import data into Amazon S3. Install AWS SCT extraction agents on the on-premises servers. Define the local and AWS Database Migration Service (AWS DMS) tasks to send the data to the Snowball Edge device. When the Snowball Edge device is returned to AWS and the data is available in Amazon S3, run the AWS DMS subtask to copy the data to Amazon Redshift.
upvoted 1 times
...
backfringe
3 years ago
I go with D
upvoted 1 times
...
AzureDP900
3 years ago
D is best option, data transfer using corporate internet takes around 58 days!
upvoted 1 times
...
andylogan
3 years, 1 month ago
It's D
upvoted 1 times
...
tgv
3 years, 1 month ago
DDD --- You cannot migrate 20 TB over 50 Mbps in 2 weeks without Snowball
upvoted 3 times
...
WhyIronMan
3 years, 1 month ago
I'll go with D for data > 20TB use Snowball
upvoted 2 times
...
vimgoru24
3 years, 1 month ago
D. This is the way.
upvoted 1 times
...
hk436
3 years, 1 month ago
D is my answer!!
upvoted 1 times
...
Waiweng
3 years, 1 month ago
it's D
upvoted 2 times
...
tvs
3 years, 1 month ago
it is D . Since there is no online data to sync , snowball is best option. Also with 50Mbs you can able to transfer 7Tb only in 14 days.
upvoted 3 times
...
beebatov
3 years, 2 months ago
Answer: D AWS Database Migration Service (AWS DMS) can use Snowball Edge and Amazon S3 to migrate large databases more quickly than by other methods https://docs.aws.amazon.com/dms/latest/userguide/CHAP_LargeDBs.html
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel