A company hosts an on-premises Microsoft SQL Server Enterprise edition database with Transparent Data Encryption (TDE) enabled.The database is 20 TB in size and includes sparse tables.The company needs to migrate the database to Amazon RDS for SQL Server during a maintenance window that is scheduled for an upcoming weekend.Data-at-rest encryption must be enabled for the target DB instance.
Which combination of steps should the company take to migrate the database to AWS in the MOST operationally efficient manner?
(Choose two.)
Use AWS Database Migration Service (AWS DMS) to migrate from the on-premises source database to the RDS for SQL Server target database.
Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
Restore the backup to the RDS for SQL Server DB instance. Enable TDE for the RDS for SQL Server DB instance.
Set up an AWS Snowball Edge device. Copy the database backup to the device. Send the device to AWS. Restore the database from Amazon S3.
Encrypt the data with client-side encryption before transferring the data to Amazon RDS.
I rank that the answer is:
Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.
I believe the answer is:
Disable TDE. Create a database backup without encryption. Copy the backup to Amazon S3.