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

question 111

Multiple Choice

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.

---

Definitions:

P < .01

Indicates that the probability of the observed data (or more extreme) given that the null hypothesis is true is less than 1%, suggesting strong evidence against the null hypothesis.

Null Hypothesis

A presumption in statistical inference that indicates no significant variance between groups or no significant relationship between variables.

Statistic

Numeric characteristic of a sample.

Region

An area or division, especially part of a country or the world having definable characteristics but not always fixed boundaries.