A Database Specialist migrated an existing production MySQL database from on-premises to an Amazon RDS for MySQL DB instance. However, after the migration, the database needed to be encrypted at rest using AWS KMS. Due to the size of the database, reloading, the data into an encrypted database would be too time-consuming, so it is not an option. How should the Database Specialist satisfy this new requirement?
A) Create a snapshot of the unencrypted RDS DB instance. Create an encrypted copy of the unencrypted snapshot. Restore the encrypted snapshot copy.
B) Modify the RDS DB instance. Enable the AWS KMS encryption option that leverages the AWS CLI.
C) Restore an unencrypted snapshot into a MySQL RDS DB instance that is encrypted.
D) Create an encrypted read replica of the RDS DB instance. Promote it the master.

Question

Quizplus · Accepted Answer

Creating a snapshot of the unencrypted RDS DB instance and then creating an encrypted copy of that snapshot allows you to restore the database with encryption without needing to reload the data manually.

A Database Specialist Migrated an Existing Production MySQL Database from On-Premises