exam questions

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 951 discussion

A company is migrating an on-premises application and a MySQL database to AWS. The application processes highly sensitive data, and new data is constantly updated in the database. The data must not be transferred over the internet. The company also must encrypt the data in transit and at rest.

The database is 5 TB in size. The company already has created the database schema in an Amazon RDS for MySQL DB instance. The company has set up a 1 Gbps AWS Direct Connect connection to AWS. The company also has set up a public VIF and a private VIF. A solutions architect needs to design a solution that will migrate the data to AWS with the least possible downtime.

Which solution will meet these requirements?

  • A. Perform a database backup. Copy the backup files to an AWS Snowball Edge Storage Optimized device. Import the backup to Amazon S3. Use server-side encryption with Amazon S3 managed encryption keys (SSE-S3) for encryption at rest. Use TLS for encryption in transit. Import the data from Amazon S3 to the DB instance.
  • B. Use AWS Database Migration Service (AWS DMS) to migrate the data to AWS. Create a DMS replication instance in a private subnet. Create VPC endpoints for AWS DMS. Configure a DMS task to copy data from the on-premises database to the DB instance by using full load plus change data capture (CDC). Use the AWS Key Management Service (AWS KMS) default key for encryption at rest. Use TLS for encryption in transit.
  • C. Perform a database backup. Use AWS DataSync to transfer the backup files to Amazon S3. Use server-side encryption with Amazon S3 managed encryption keys (SSE-S3) for encryption at rest. Use TLS for encryption in transit. Import the data from Amazon S3 to the DB instance.
  • D. Use Amazon S3 File Gateway. Set up a private connection to Amazon S3 by using AWS PrivateLink. Perform a database backup. Copy the backup files to Amazon S3. Use server-side encryption with Amazon S3 managed encryption keys (SSE-S3) for encryption at rest. Use TLS for encryption in transit. Import the data from Amazon S3 to the DB instance.
Show Suggested Answer Hide Answer
Suggested Answer: B 🗳️

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
phattran
1 year, 11 months ago
Selected Answer: D
Why not option D? It suit for the requirement
upvoted 1 times
vn_thanhtung
1 year, 8 months ago
1. The company already has created the database schema in an Amazon RDS for MySQL DB instance. 2. A solutions architect needs to design a solution that will migrate the data to AWS with the least possible downtime And you are going to choose D. Stupid!
upvoted 1 times
...
...
TajSidKazi
2 years, 2 months ago
B AWS Database Migration Service (DMS), which is designed to migrate databases to AWS with minimal downtime. It can use change data capture (CDC) to continuously replicate changes made to the on-premises database to the Amazon RDS for MySQL DB instance. VPC endpoints for AWS DMS ensure that the data is not transferred over the internet. Encryption at rest is provided by using the AWS KMS default key, and encryption in transit is provided by using TLS.
upvoted 2 times
...
syaldram
2 years, 4 months ago
Selected Answer: B
B makes more sense to me!
upvoted 2 times
...
Kende
2 years, 4 months ago
Selected Answer: B
B is the one.
upvoted 2 times
...
ggrodskiy
2 years, 5 months ago
Correct B. new data is constantly updated in the database
upvoted 3 times
...
masetromain
2 years, 5 months ago
Selected Answer: B
B is correct https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Security.html https://aws.amazon.com/dms/ https://aws.amazon.com/fr/blogs/big-data/near-zero-downtime-migration-from-mysql-to-dynamodb/
upvoted 3 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago