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

Exam AWS Certified Database - Specialty All Questions

View all questions & answers for the AWS Certified Database - Specialty exam
Go to Exam

Exam AWS Certified Database - Specialty topic 1 question 47 discussion

Exam question from Amazon's AWS Certified Database - Specialty
Question #: 47
Topic #: 1
[All AWS Certified Database - Specialty Questions]

A company is closing one of its remote data centers. This site runs a 100 TB on-premises data warehouse solution. The company plans to use the AWS Schema
Conversion Tool (AWS SCT) and AWS DMS for the migration to AWS. The site network bandwidth is 500 Mbps. A Database Specialist wants to migrate the on- premises data using Amazon S3 as the data lake and Amazon Redshift as the data warehouse. This move must take place during a 2-week period when source systems are shut down for maintenance. The data should stay encrypted at rest and in transit.
Which approach has the least risk and the highest likelihood of a successful data transfer?

  • A. Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, start an AWS DMS task to move the data from the source to Amazon S3. Use AWS Glue to load the data from Amazon S3 to Amazon Redshift.
  • B. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Start an AWS DMS task with two AWS Snowball Edge devices to copy data from on-premises to Amazon S3 with AWS KMS encryption. Use AWS DMS to finish copying data to Amazon Redshift.
  • C. Leverage AWS SCT and apply the converted schema to Amazon Redshift. Once complete, use a fleet of 10 TB dedicated encrypted drives using the AWS Import/Export feature to copy data from on-premises to Amazon S3 with AWS KMS encryption. Use AWS Glue to load the data to Amazon redshift.
  • D. Set up a VPN tunnel for encrypting data over the network from the data center to AWS. Leverage a native database export feature to export the data and compress the files. Use the aws S3 cp multi-port upload command to upload these files to Amazon S3 with AWS KMS encryption. Once complete, load the data to Amazon Redshift using AWS Glue.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️
by learnaws at July 18, 2020, 6:55 a.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
pan24
Highly Voted 3 years, 8 months ago
Ans: B https://aws.amazon.com/blogs/database/new-aws-dms-and-aws-snowball-integration-enables-mass-database-migrations-and-migrations-of-large-databases/
upvoted 19 times
BillyMadison
3 years, 8 months ago
Going with B as well due to your compelling link.
upvoted 2 times
BillyMadison
3 years, 7 months ago
Found this link that agrees with B https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/agents.dw.html "Large-scale data migrations can include many terabytes of information, and can be slowed by network performance and by the sheer amount of data that has to be moved. AWS Snowball Edge is an AWS service you can use to transfer data to the cloud at faster-than-network speeds using an AWS-owned appliance." "When you use AWS SCT and an AWS Snowball Edge device, you migrate your data in two stages. First, you use the AWS SCT to process the data locally and then move that data to the AWS Snowball Edge device. You then send the device to AWS using the AWS Snowball Edge process, and then AWS automatically loads the data into an Amazon S3 bucket. Next, when the data is available on Amazon S3, you use AWS SCT to migrate the data to Amazon Redshift."
upvoted 4 times
...
...
szmulder
3 years, 7 months ago
B is incorrect. 1. You just need one snowball edge device because one device can hold up to 80 TB of data. 2. The lastest step for B is "Use AWS DMS to finish copying data to Amazon Redshift." but from the AWS docs need "use AWS SCT to migrate the data to Amazon Redshift."
upvoted 2 times
BillyMadison
3 years, 7 months ago
There is 100 TB of data that needs to be transferred. Since a snowball can only hold 80, it makes sense that there would be a need for 2 of them. Hence B.
upvoted 9 times
...
RotterDam
3 years, 2 months ago
Wrong. you need TWO snowball edge devices since out of 100TB only 80TB is usable. This is a standard question in tutotrialsdojo as well - very respectable site.
upvoted 2 times
...
...
...
Exia
Highly Voted 3 years, 6 months ago
Although snowball is a petabyte-scale data transport solution, 100TB database migration through a 500 Mbps network is impossible in 2 weeks. bandwidth: 500 Mbps = 62.5 MB/s capacity: 100 TB = 100 * 10**6 = 100000000 MB time consume: 100000000 / 62.5 MB/s = 1600000.0 s = 1600000 / 60 / 60 / 24 = 18.5 days
upvoted 5 times
58a2d17
1 year, 1 month ago
That is why you need snowball. Network speed won't do it .
upvoted 1 times
...
jitesh_k
1 year, 5 months ago
How is 500MBPS equal to 62.5 MB/sec?
upvoted 1 times
jitesh_k
1 year, 5 months ago
Got it. Lowercase "b" is bits while uppercase "B" is bytes. 500 mbps is 500/8 MB/s.
upvoted 1 times
...
...
...
KaranGandhi30
Most Recent 3 years ago
Selected Answer: B
With the given bandwidth any other option will be completed in more than 20 days.
upvoted 4 times
...
novice_expert
3 years ago
Selected Answer: B
https://aws.amazon.com/blogs/database/new-aws-dms-and-aws-snowball-integration-enables-mass-database-migrations-and-migrations-of-large-databases/
upvoted 1 times
...
jove
3 years, 4 months ago
Option B.. With SCT data extraction agent you can extract the data as well as the schema. Snowball Edge devices are safe.
upvoted 1 times
...
LMax
3 years, 6 months ago
Agree with B
upvoted 1 times
...
myutran
3 years, 6 months ago
Ans: B
upvoted 1 times
...
JobinAkaJoe
3 years, 6 months ago
B is the right choice here
upvoted 1 times
...
Ashoks
3 years, 6 months ago
B. Snow ball will be the solution to transfer 100TB, since existing 500Mbps bandwidth is not enough
upvoted 2 times
...
AWSCert2020
3 years, 6 months ago
For me B here
upvoted 1 times
...
szmulder
3 years, 7 months ago
A. Answer: It's possible but copy 100TB via internet is not reliable B. Answer: "Use AWS DMS to finish copying data to Amazon Redshift." but from the AWS docs need "use AWS SCT to migrate the data to Amazon Redshift." C. Answer: Correct D. Answer: It's possible but it's missing the step AWS SCT and apply the converted schema to Amazon Redshift.
upvoted 1 times
[Removed]
3 years, 7 months ago
didn't know you can ship fleets of drives to AWS.
upvoted 2 times
...
szmulder
3 years, 6 months ago
sorry, change my mind, B is correct.
upvoted 1 times
...
...
badrik
3 years, 7 months ago
B is right option
upvoted 1 times
...
BillyC
3 years, 7 months ago
B is correct for me
upvoted 1 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
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago