nerdexam
Amazon

SAP-C02 · Question #658

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…

The correct answer is B. Use AWS Database Migration Service (AWS DMS) to migrate the data to AWS. Create a DMS. The company needs to migrate a 5TB MySQL database with highly sensitive, constantly updated data to AWS RDS with minimal downtime, encryption in transit and at rest, and no public internet transfer, leveraging an existing Direct Connect private VIF.

Submitted by andres_qro· Mar 6, 2026Migrate Workloads and Modernize Solutions

Question

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?

Options

  • APerform a database backup. Copy the backup files to an AWS Snowball Edge Storage Optimized
  • BUse AWS Database Migration Service (AWS DMS) to migrate the data to AWS. Create a DMS
  • CPerform a database backup. Use AWS DataSync to transfer the backup files to Amazon S3. Use
  • DUse Amazon S3 File Gateway. Set up a private connection to Amazon S3 by using AWS

How the community answered

(56 responses)
  • A
    32% (18)
  • B
    43% (24)
  • C
    16% (9)
  • D
    9% (5)

Why each option

The company needs to migrate a 5TB MySQL database with highly sensitive, constantly updated data to AWS RDS with minimal downtime, encryption in transit and at rest, and no public internet transfer, leveraging an existing Direct Connect private VIF.

APerform a database backup. Copy the backup files to an AWS Snowball Edge Storage Optimized

AWS Snowball Edge is suitable for large initial data transfers but does not support continuous replication for frequently updated databases and would incur significant downtime during the migration.

BUse AWS Database Migration Service (AWS DMS) to migrate the data to AWS. Create a DMSCorrect

AWS Database Migration Service (DMS) supports continuous replication (Change Data Capture) from on-premises MySQL to Amazon RDS, minimizing downtime for a 5TB database with ongoing updates. Creating a DMS replication instance and endpoints within a private VPC, routing traffic over a Direct Connect private VIF, ensures data remains private and encrypted in transit, while RDS handles data at rest encryption.

CPerform a database backup. Use AWS DataSync to transfer the backup files to Amazon S3. Use

Performing a database backup and transferring it with AWS DataSync would involve significant downtime during the backup and transfer process, and DataSync is primarily for file or object storage, not continuous database migration.

DUse Amazon S3 File Gateway. Set up a private connection to Amazon S3 by using AWS

Amazon S3 File Gateway is designed for hybrid cloud storage integration with S3, not for migrating an entire relational database with continuous replication and minimal downtime requirements.

Concept tested: AWS DMS for continuous database migration

Source: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Welcome.html

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full SAP-C02 Practice